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?

Version 4.2 beta released

Hi,
NULL values are an important aspect of the relational model so I decided not to wait for the 5.x release and to add this feature in this 4.2 beta version. Now DaDaBIK can handle NULL values.

Another feature implemented in this release is the new "is empty" search operator.

Check the change log for the complete list of changes.

Bye,

8 Feb 2007 by Eugenio   1 comments

Version 4.1 released, Web Design Contest

Hi all,
after almost three months of public beta testing, more than 4000 downloads and several bugs fixed I'm proud to announce the final version of the 4.1 release of DaDaBIK.

This version fixes some minor bugs; check the change log for the complete list of changes.

Thanks to all people who daily post bug reports on the support forum.

Some people experienced problems using DaDaBIK on MySQL 5 with STRICT_TRANS_TABLES enabled; I was not able to replicate the problem, if you have any clues please report them on the support forum.

Regarding my last call for developers, two people wrote me in order to start the collaboration so I hope DaDaBIK will have a new administration interface soon.

Now I'm asking for WEB DESIGNERS: DaDaBIK needs a new, usable and cool interface; send me your proposals: two simple HTML page (one for the record results view and one for the record details view) are OK; the best one will be the new standard DaDaBIK interface. The contest will close on March 31, 2007; more about the rules of the game in the next few days.

For the winner will be a good chance to spread his name on the Web, through this popular piece of software.

Bye

19 Jan 2007 by Eugenio   8 comments

New release

Hi all,
DaDaBIK version 4.1 rc2 produced a "[08] Error: during query execution." error message during the installation so I have fixed the bug and published a new version, 4.1 rc3.

Bye,

14 Jan 2007 by Eugenio   0 comments

New release, call for developers, RSS feed available.

Hi all,
a new version of DaDaBIK (4.1 release candidate 2) is available.
This version fixes some bugs, in particular the "Refresh installation" bug and the one about previous and next record links, which didn't work correctly.

Check the change log for the complete list of changes.

Call for developers: I'm looking for someone who wants to join the staff; the goal is the restyling (in terms of layout and features) of the admin section of DaDaBIK, in order to increase usability. I have realised that the admin section needs an update in order to be really usable; to work on this code you don't need to know how the DaDaBIK engine works, it is a very simple programming task. If you are interested, please contact me (eugenio dot tacchini at unicatt dot it).

An RSS feed of this "What's new?" section should be available in a few minutes.

Bye,

14 Jan 2007 by Eugenio   0 comments

Thanks RHX!

Many thanks to RHX, which decided to become an official sponsor of the DaDaBIK project.

RHX is an italian company which provides software development and network configuration services, Web hosting, other internet related services and Linux training. It is based in Pieve di Soligo (Treviso).

RHX, as a DaDaBIK sponsor, freely hosts this site and freely maintains the dadabik.org and dadabik.it domains.

14 Dec 2006 by Eugenio   0 comments