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?

Lost comments

Hi all,
I realized that all the news comments disappeared.

Unfortunately my ISP can't provide the backup I need; anyway I have got almost all the old posts from the google cache, and maybe I'll repost them.

I don't know if this is due to a bug of the news management system I use (cutenews), but if someone has intentionally deleted the posts I just want to say: thank you, good job man, you are a true hacker...woooow...

1 Mar 2005 by Eugenio   0 comments

Back to Italy

Hi all,
my vacation has finished, I arrived yesterday in Italy after a 30 hours trip....as you can see, DaDaBIK has arrived also in Australia.

I don't know if there are any DaDaBIK australian users over there, just want to say that Australia is really a wonderful and unforgettable place, and one of the best place to forget about PHP & c. for a while :-)

Bye,

6 Jan 2005 by Eugenio   0 comments

Next release of DaDaBIK

Hi all,
DaDaBIK 3.1 rc1 will be available in the first months of 2005.
I thought to release a new version during this week but I then realized that the authentication class we are using is too difficult to integrate in DaDaBIK maintaining our code style.
I've decide to rewrite that part of code.

DaDaBIK 3.1 rc.1 will:
- store user data in a database (encrypted passwords)
- manage the users table (e.g. insert, modify and delete users) with DaDaBIK itself
- have the possibility to use a pre-existent customized users table (useful if you want to share DaDaBIK users with other applications)

I'm going to take a vacation, I'll leave for Australia on Monday, so I wish all DaDaBIK users a merry Christmas and a happy new year :)

Bye,

18 Dec 2004 by Eugenio   0 comments

DaDaBIK and italian open source contest

Hi all,
the new release of DaDaBIK (3.1 rc 1) should be available in the next week.

In the meantime, if you appreciate and enjoy DaDaBIK, I ask you a favour: take a minute to vote for it in the italian open source contest (www.opensourcecontest.it). DaDaBIK is one of the 10 selected projects in the business category and now needs your vote :)

The site is only in italian, but voting is very easy:
1) you have to register (email, first name and text in the picture should be enough)
2) and then to vote DaDaBIK for the category "Business (Database, Office, System Integration)" using the code you will receive by e-mail after registration

Thank you :-)

Bye,

7 Dec 2004 by Eugenio   0 comments

DaDaBIK 3.1 beta released

Hi all,
DaDaBIK 3.1 beta is available.
The main improvements:

• A new select query engine, that fixes the problems related to multiple references to a linked table and the multiple use of the same field name. This should also increase DaDaBIK speed.
  
  
• A basic authorization model: it is now possible to allow a user to delete only his own records, modify only his own records, view only his own records. For the authentication the class simpleLogin (http://www.phpclasses.org/browse/package/1492.html) has been (probably temporary) used, but it is possible to easily customize the authentication.
  
  
• A new field type is available: rich_editor; it is a rich text editor (htmlArea 2.03 by interactivetools.com http://www.interactivetools.com/products/htmlarea/) that allows to easily insert/modify HTML content
  

19 Jul 2004 by Eugenio   0 comments