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 development branch and development status

Hi all,
I have created today the 4.1 branch of DaDaBIK.

In the subversion repository (https://gna.org/svn/?group=dadabik), /branches/4.1 folder, you can already find a working version which includes the following new features:

- Previous and next buttons are now available in edit and details views.
- DaDaBIK now remembers the last search executed on a table, even if you change table.

While I'm working on the future 4.1 version, some people are working to make DaDaBIK Oracle-compatible; when the porting is finished I will officially release v. 4.0 beta.

Bye,

8 Dec 2005 by Eugenio   0 comments

MS SQL Server support

Hi all,
the current development version of DaDaBIK (http://www.dadabik.org/index.php?function=show_download) offers support for MS SQL Server. All DaDaBIK features but the admin refresh and the insert "other...." on select_single field operations seem to work fine on this DBMS.

At the moment there is also a person who is testing DaDaBIK on Oracle, applying the needed changes to the code.

I think the next official release of DaDaBIK (4.0 beta) will contain support for both MS SQL server and Oracle.

Since I have found a way to stop spam comments posting (at least I hope so), I have enabled again anonymous news comments.

Bye,

Eugenio.

18 Nov 2005 by Eugenio   0 comments

Subversion support

Hi all,
DaDaBIK has now the subversion support.

Subversion is a version control system similar to (should be better than) CVS, you can find information about it here: http://subversion.tigris.org/.

You can find instructions for checking out the very last development version of DaDaBIK here:
https://gna.org/svn/?group=dadabik

Bye,

Eugenio

3 Nov 2005 by Eugenio   0 comments

I'm looking for Oracle tester

Hi folks,
I'm looking for DaDaBIK beta testers who can test DaDaBIK with Oracle; I want to release DaDaBIK 4.0 beta after a MS SQL Server and Oracle test.

If you are interested, please contact me (eugenio dot tacchini at unicatt dot it)

Bye,

Eugenio

13 Oct 2005 by Eugenio   0 comments

Spam fighting

Hi all,
as you probably noticed, the support forum was becoming unusable because of the enormous quantity of spam and garbage posted.

I have deleted all the garbage and set the authentication required to post on the forum to prevent bot posting. The forum is now clean and usable as it used to be.

I have also deleted the spam comments from news, but since I haven't found any anti-spam method, it is not possible to post news comments any more. If you have any advise about, please let me know. I use cutenews (http://cutephp.com/cutenews/) here.

I hope not to have deleted any important posts/comments during this dirty job.

Bye,

Eugenio.

8 Oct 2005 by Eugenio   0 comments