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 Processing Systems (advanced course)" at the Faculty of Economics, Università Cattolica del Sacro Cuore at Piacenza.

What's new?

Web site problems solved

Hi all,
during the last three weeks this Web site has experienced some problems in sending e-mails. The problems have been solved.

About the Forum issues (PHP5 compatibility) you probably noticed (I didn't post about this) that I solved them some time ago, without upgrading Phorum; the only problem is an annoying error message that you can see viewing a post detail without being logged-in (e.g. http://www.dadabik.org/forum/read.php?f=1&i=10323&t=10323) but the forum is totally usable.

I want to thank Rainer Scheidegger for this, who pointed me out a very simple solution.

Bye,

28 Jul 2008 by Eugenio   0 comments

Forum problems

Hi all,
my ISP has unexpectately changed the PHP version of the server which hosts dadabik.org from 4 to 5. Unfortunately the DaDaBIK forum, based on an old version of Phorum, doesn't work on PHP 5.

I have scheduled for the next week an upgrade of my Phorum installation to the last version so the forum will work again!

Sorry for the inconvenience.

Bye,

23 Apr 2008 by Eugenio   0 comments

DaDaBIK OWL Module

Hi all,
I have developed an additional module for DaDaBIK which allows to generate an OWL ontology starting from the database managed; this is the result of my computer science degree thesis.

At the moment I have just uploaded a zip file containing three files: install.php, footer.php and generate_owl_ontology.php. If you want to try this new module, you can download it and, starting from the last development version of DaDaBIK update the install.php and footer.php files and put the generate_owl_ontology.php in the root folder.
You also need to download and import an SQL version of Wordnet from http://www.androidtech.com/html/wordnet-mysql-20.php and to edit the $wordnet_server_* parameters in generate_owl_ontology.php.

Only MySQL is supported at the moment.

I hope I will integrate the module in the development version and write some documentation soon.

Bye,

4 Nov 2007 by Eugenio   0 comments

The forums are now working fine!

Hi all,
all the forum features which need an e-mail sending (registration, generation of a new password, reply e-mail notification) didn't work correctly due to the lack of a setting required by my ISP; the good news is that now everything works!

Sorry for the inconvenience.

Bye,

3 Aug 2007 by Eugenio   0 comments

DaDaBIK 4.2 final released

Hi all,
version 4.2 final is now available, the only difference with the previous version (4.2 beta) is that the Rumanian language is now complete.

In a few days I think I'm going to release version 4.3 alpha, which will support the master-detail view.

I think that for version 5.0 the DaDaBIK code will be in part re-written; even the data structure will change, allowing to have a DaDaBIK db, containing DaDaBIK meta data, separated from the DB(s) you want to manage.

If you have any advices about please discuss them by commenting this post.

Bye,

18 Feb 2007 by Eugenio   19 comments