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.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

26 Jan 2007 by Tekon

Hi:

I have had an idea called 'viewmode' mod for Dadabik for a while. I found a programmer who ported your mod over to PHP Nuke, calls it Dadabik4nuke. He had this to say about my idea....sounds like it may be something you can better know the answer to:
--
sorry, no can do.

the thing is that the function (code) that deals these 3 icons are not included in a do... while loop. meaning that we can't pass it an argument array of record numbers to edit.

also... what happens when you get a list of 20 records and you click update? you need update 20 records in a row...
--

I have a screen shot where I edited it to show what my mod would look like if it were implimented.....but its on my home computer. If interested, drop me an email, and can point you to a hotlink for it uploaded on my site. Steve from USA.

29 Jan 2007 by Eugenio

Hi Steve,
I didn't get exactly what you mean but I'm very curious to see your mod.
I will contact you via e-mail soon.

25 Feb 2007 by Mike

I'm not a web designer and am not trying to win the contest but I found a way to modify the code to combine the record results and details views into a single page, where details can be hidden or revealed through clicking on the entries. It won't work for most users, but is great for timelines.

25 Feb 2007 by Eugenio

I saw your mod results, it looks good for some particular uses; you can publish your mod in the support forum if you want.

27 Feb 2007 by 0711concept

Hello Dadatik-Users,
I can think of a Theme-Switcher, which enables you to switch the look of the databik-user-interface. The styles, Images and placeholders should be changeable within a theme-editor. Moreover you can offer users to present their themes on this website. This way we will find different styles and ways.

I am looking forward to this. 0711concept

26 Mar 2007 by Marc

I would like information in order to submit my cool new interface for dadabik please.

29 Mar 2007 by Eugenio

Hi Marc,
at the moment I'm looking for the best way to legally accept graphic works with a copyright transfer, for this reason I haven't talked again about the Web design contest.

I also had a talk with a Free software foundation staff member (or maybe a volunteer) but without results.

Bye,

3 Apr 2007 by Marc

Hi Eugenio.

The interface, with it's graphics works and all, were to be released as GNU/GPL too.

Never had I thaught that the design would be copyrighted.

I learned this from people such as yourself. And I just want to give back... It's a matter of being fair I guess.

But anyways, you are the team leader and I would not want to appear like I am telling you what to do.

GNU/GPL is my way to go.

Thanks again.

(see my entries plus a working demo of my favourite in the general talks forums)

*Name:
*E-mail:	(will not be published)
Web site:
*Comment: (no HTML)
Copy the black characters below (case sensitive), this prevents spam