What is DaDaBIK?

Starting from version 4.0 alpha DaDaBIK uses the ADOdb Database Abstraction Library in order to support as many DBMS as possible, at the moment it has been tested on MySQL, PostgreSQL, Oracle and MS SQL Server.

The strength of DaDaBIK lies in its ability to be customized. For each field of a table you can choose:

• if the field should be included or not in the search/insert/update form and results table
• its label (what will appear in the form near the input field)
• its content format (e.g. numeric, alphabetic, e-mail, url......)
• the input type (e.g. select, date, text, rich text editor, password......)
• the possible values, also driven from another table (foreign key support)
• and more...

DaDaBIK also allows you to handle multiple tables. Other features include file uploading, export to CSV, checking for possible duplication during an insert, authentication and authorization restrictions on view/update/delete, e-mail notices, table aliases.

The graphic layout of DaDaBIK is customizable to help you to embed its forms in your own site.

DaDaBIK differs from other applications like PHPMyAdmin since it doesn't enable the complete administration of a database, but rather to easily create a simple and customizable Web application that manages a group of tables by allowing search/insert/update/delete operations. DaDaBIK's target user is not the DB administrator but rather the final user.

DaDaBIK is available in Italian, English, Dutch, German, Spanish, French, Portuguese, Croatian, Polish, Catalan, Estonian, Rumanian, Hungarian, Swedish, Slovak and Finnish.

DaDaBIK on Sourceforge

The DaDaBIK project is hosted also on Sourceforge: http://sourceforge.net/projects/dadabik/, visit the Sourceforge page for old releases and statistics.

Cos'è DaDaBIK?

DaDaBIK è un'applicazione PHP free che permette di creare facilmente un front-end personalizzabile per un database, consentendo ricerca, inserimento, modifica e cancellazione di record, tutto quello che devi fare è specificare alcuni parametri di configurazione.

A partire dalla versione 4.0 alpha DaDaBIK utilizza ADOdb Database Abstraction Library in modo da supportare il maggior numero possibile di DBMS, al momento è stato testato solo con MySQL, PostgreSQL, Oracle e MS SQL Server.

La forza di DaDaBIK sta nel suo livello di personalizzazione, per ogni campo di una tabella puoi scegliere:

• se il campo deve essere o meno incluso nella form cerca/inserisci/aggiorna e nella tabella dei risultati
• l'etichetta (quello che verrà visualizzato nella form a fianco dell'input field)
• il contenuto del campo (es. numerico, alfabetico, e-mail, url......)
• l'input type (es. select, date, text, rich text editor, password......)
• i possibili valori che il campo può contenere, anche letti da un'altra tabella (supporto per foreign key)
• e molto altro......

E' possibile gestire più tabelle contemporaneamente; tra le altre funzioni, c'è la possibilità di effettuare l'upload di files (immagini e altro), di esportare i risultati di una ricerca su un file CSV, di controllare gli inserimenti per prevenire possibili duplicazioni, l'autenticazione e le restrizioni su visualizzazione/modifica/cancellazione, le notifiche via e-mail e gli alias per i nomi delle tabelle.

Il layout grafico di DaDaBIK è personalizzabile per consentire di inserire le form nel tuo sito.

DaDaBIK si differenzia da altre applicazioni come PHPMyAdmin, il suo scopo non è di consentire la completa amministrazione di un database ma la creazione di una Web application semplice e configurable che gestisce le operazione di ricerca/inserimento/aggiornamento/cancellazione record su un gruppo di tabelle. Il target di DaDaBIK non è quindi il DB administrator ma l'utente finale.

DaDaBIK è disponibile in italiano, inglese, olandese, tedesco, spagnolo, francese, portoghese, croato, polacco, catalano, estoniano, rumeno, ungherese, slovacco, svedese e finlandese.

What about the author?

Eugenio works as a consultant for an italian software house (www.elfo.net) and teaches information systems at the Faculty of Economics, Università Cattolica del Sacro Cuore at Piacenza.

What's new?

Next release of DaDaBIK

Hi all,
I'm working on the next release (3.1 beta) of DaDaBIK and probably it will be released on July.

The release will contain:

- a rewritten engine that perform the select query using join and aliases (this fixes the problems related to multiple references to a linked table and the multiple use of the same field name)

- the ability to handle HTML content: a new field type rich_editor which uses htmlarea (http://www.interactivetools.com/products/htmlarea) as rich text editor and a new content type: "html"

- a basic authentication model, that for the moment allows a user to change and delete only his own records.

I'm proud to announce that two people have joined the DaDaBIK project:

Debbie Sontag (debsweb at shaw.ca), who manages the support forum and has started to write some additional documentation and

Marcello Vitali (si13259 at iperbole.bologna.it) who has implemented the rich text editor in DaDaBIK and is working on the authentication feature.


Stay tuned :)

Bye,

Eugenio.

12 Jun 2004 by Eugenio   0 comments

DaDaBIK 3.0 released

Hi all,
DaDaBIK 3.0 final release is available.
This version fix several bugs discovered during the beta test, including some "[08] Error: during query execution" errors which appeared under particular conditions. It has been added also a new configuration parameter used to control the width of the results table columns.

I'm already working to the future 3.1 version, in which I will partially rewrite the engine that produce the SELECT statement, in order to fix the problems related to the multiple reference to a linked table and the multiple use of the same field name.
For further details see the changelog page.

I have also decided, starting from this version, to always release an upgrade procedure that allows to upgrade to a new DaDaBIK release without loosing the previous configuration settings.

Another way to support DaDaBIK, besides donations, is now available; I've put on this site some sponsored links to DWeb, a very interesting software product that allows the deploying of a PHP/MySQL application on CD/DVD. If you buy DWeb from these links I earn some money for every sale.

25 May 2004 by Eugenio   0 comments

DaDaBIK @ Webb.it

On friday may 7, 2004 I will be in Padova (Italy) at Webb.it to give a
seminar about DaDaBIK and rapid MySQL front-end developement.

I will explain how to use and exploit DaDaBIK using a real life example.

Webb.it is the most important italian meeting for ICT professionals and talents.

13 Apr 2004 by Eugenio   0 comments

DaDaBIK 3.0 beta released!!

Hi all,
you have been waiting for one year but I think it is worth the effort :)
I'm proud to announce that DaDaBIK 3.0 beta has been released.

It's difficult to summarize here all the changes, the decision to change the major release from 2.x to 3.x is however due also to the fact that all the code (5000+ lines) has been revisited and in some part rewritten.

Among other changes:

• The primary-foreign key feature is now complete: it is possible to link a field of a table (foreign key) to a number of fields of another table (containing the primary key). The produced HTML select menu will have the linked field values as "options" and the primary key values as "values". This allow to use a normalized DB design.
  
  
• The speed of DaDaBIK in managing DB with a large number of tables is now dramatically increased.
  
  
• "Export to CSV" feature
  
  
• All the HTML code produced can be handle by the CSS file
  
  
• It is now possible to order result records both in ASC and DESC.
  
  
• "Delete all" feature
  

10 Mar 2004 by Eugenio   0 comments

New release

Hi all,
a new version of DaDaBIK, 2.2.1, is available; in this version:

Fixed bugs

• When a record containing an image_file or generic_file field was updated without uploading a new file, the record loosed the link with the old file; this bug has been fixed.
  
  
• When a user perform a search in a table containing an image_file or generic_file field the "browse" button was displayed by the browser for those fields, this behaviour makes no sense; this bug has been fixed.
  
  
• The field names of the where clause in the update statements were not back quoted, consequently the update failed if the name of the primary key field needed to be escaped (e.g. a reserved word), this bug has been fixed.
  
  
• The dutch version of DaDaBIK produced a parse error, this bug has been fixed.
  

• It is now possible to choose if you want to delete (both in the database and phisically) a previously uploaded file.
  
  
• When two or more files with the same name are uploaded, a new name is assigned automatically (e.g. my_file.txt become my_file_2.txt if my_file.txt already exists, my_file_3 if also my_file_2 already exists and so on).
  
  
• It is now possible to configure DaDaBIK to accept all files (regardless to the extensions) coming from upload.
  
  
• Since DaDaBIK requires to set magic_quotes_gpc = on in php.ini (which is the default setting), now if magic_quotes_gpc is off DaDaBIK will stop and display an error message.
  

11 Mar 2003 by Eugenio   0 comments