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?

DaDaBIK 4.1 beta released!

Hi all,
it has been a big effort this time but I'm proud to announce the new release of DaDaBIK, which adds a lot of new and important features that will increase the end-user usability.

Here is a list of the most important:

• Better form errors handling: if an error occurs when the user fills a form (e.g. an URL format is not correct), DaDaBIK will display again the form and point out the type of error.
  
  
• E-mail notices: DaDaBIK sends an e-mail message to some specified people when a new record is inserted or an existent record modified.
  
  
• Previous and next buttons are now available in edit and details views.
  
  
• Also the administration pages are now protected by authentication (if enabled); only administrator users can enter the administration pages.
  
  
• DaDaBIK now remembers the last search executed on a table, even if you change table.
  
  
• It is now possible to choose the number of result records displayed per page on the fly.
  
  
• It is now possible to set an alias for each table.
  
  
• DaDaBIK now uses tinymce 2.0.7 (http://tinymce.moxiecode.com) to implement the rich_editor field type instead of htmlarea. This leads to FireFox compatibily.
  
  
• Rows highlighting.
  
  
• Finnish language is now available.
  

25 Oct 2006 by Eugenio   0 comments

New demo available

Hi all,
a new demo, based on the latest official version of DaDaBIK (4.0), is available.


Bye,

Eugenio.

6 Oct 2006 by Eugenio   0 comments

DaDaBIK 4.0 released

Hi all,
DaDaBIK 4.0 is available.

The main changes: this final version fixes some bugs on Oracle, has a new language (Swedish) and an improved documentation.

You can find the complete list of new features and fixed bugs in the change log.

Bye,

Eugenio.

4 Oct 2006 by Eugenio   0 comments

What's happening and poll

Hi all,
I'm trying to perform some tests on Oracle before releasing 4.0 final.

While you are waiting for the new release please answer the poll I have put in the homepage; it's important for me to know the DBMS you use with DaDaBIK.

23/09 update: if you are an Oracle user and want to help during the test process please contact me: eugenio dot tacchini at unicatt dot it

Bye,

Eugenio.

22 Sep 2006 by Eugenio   0 comments

DaDaBIK 4.0 beta and 4.0 beta 2 released

Hi all,
DaDaBIK 4.0 beta and 4.0 beta 2 are available.

The main new feature is about DBMS compatibility: DaDaBIK now officially supports Oracle and MS SQL Server DBMS. A special thanks to Claude Moreau (claude dot moreau dot olom at gmail dot com) for the great work he did on the Oracle porting.

Among the various bug fixes, the most important one is the possibility to use the required property with file types: it is now possible without problems.

Why two versions, beta and beta 2? Just because in the 4.0 beta release there was some missing information in the documentation, the 4.0 beta 2 release fix this issue.

You can find the complete list of new features and fixed bugs in the change log.

Bye,

Eugenio.

24 Jan 2006 by Eugenio   0 comments