What is DaDaBIK?    

No programming skills are needed to use it; if however you are a PHP programmer with DaDaBIK you can save tens of hours of work.

With DaDaBIK (differently from many competitors) you don't produce a PHP script, which would become outdated when you modify the schema of your database, but instead you directly use its abstraction layer that can be easily updated every time you modify your database's schema.

DaDaBIK uses the ADOdb and the PDO database abstraction libraries in order to support as many DBMSs as possible, at the moment it has been tested on MySQL, PostgreSQL, SQLite, Oracle and MS SQL Server.

The strength of DaDaBIK lies in its ability to be customized. For example for each table field you can choose:

• if the field must be included or not in a search/insert/update form and results table
• its label
• its content format (e.g. numeric, alphabetic, e-mail, url...)
• the HTML input type (e.g. textbox, menu, date, rich text editor, password box...)
• the possible values, also driven from another table (foreign key support)
• and more...

Other features include file uploading, master/details view, export to CSV, checking for possible duplication during an insert, authentication and authorization restrictions on view/update/delete, e-mail notices.

The graphic layout of DaDaBIK is customizable to help you to embed it in your own site.

DaDaBIK differs from PHPMyAdmin: it has not been created to offer the complete administration of a database, but rather to allow the creation of a customizable and user friendly database application. The target of a DaDaBIK application can be the final user instead of a DB administrator.

DaDaBIK is available in Italian, English, Dutch, German, Spanish, French, Portuguese, Croatian, Polish, Catalan, Estonian, Rumanian, Hungarian, Swedish, Slovak and Finnish.

Since its first release in 2001 it has been downloaded more than 150.000 times and its users community has produced about 10.000 posts in the forums.

Follow DaDaBIK on Twitter!

DaDaBIK on Sourceforge

The DaDaBIK project is also hosted on Sourceforge: http://sourceforge.net/projects/dadabik/, visit the Sourceforge page for old releases and statistics.

Cos'è DaDaBIK?

DaDaBIK è un'applicazione PHP open source molto diffusa e matura che permette di creare facilmente un database front-end o una database application personalizzabile senza scrivere codice. Puoi utilizzare DaDaBIK per sviluppare un semplice CRUD (create, read, update, delete) database front-end oppure per sviluppare una database application piu' sofisticata.

Non è necessario avere competenze di programmazione per utilizzarlo; se pero' sei un programmatore PHP con DaDaBIK puoi risparmiare decine di ore di lavoro.

Con DaDaBIK (e a differenza di molti software simili) non viene prodotto uno script PHP, poco manutenibile e che diventa obsoleto non appena modifichi lo schema del tuo database, ma viene utilizzato direttamente il suo abstraction layer che può essere facilmente aggiornato ogni volta che modifichi lo schema del tuo database.

DaDaBIK utilizza le librerie ADOdb e PDO in modo da supportare il maggior numero possibile di DBMS, al momento è stato testato con MySQL, PostgreSQL, SQLite Oracle e MS SQL Server.

La forza di DaDaBIK sta nel suo livello di personalizzazione, per esempio 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
• il contenuto del campo (es. numerico, alfabetico, e-mail, url...)
• l'input type (es. textbook, menu, data, rich text editor, password box...)
• i possibili valori che il campo puo' contenere, anche letti da un'altra tabella (supporto per foreign key)
• e molto altro......

Tra le altre funzioni c'è la possibilità di effettuare l'upload di file (immagini e altro), di utilizzare una visualizzazione master/details, 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.

Il layout grafico di DaDaBIK è personalizzabile per consentire di inserirlo nel tuo sito.

DaDaBIK si differenzia da PHPMyAdmin: non è stato creato per consentire la completa amministrazione di un database ma la creazione veloce di una database application user friendly e personalizzabile. Il target di una DaDaBIK application può quindi essere l'utente finale invece di un DB administrator.

DaDaBIK è disponibile in italiano, inglese, olandese, tedesco, spagnolo, francese, portoghese, croato, polacco, catalano, estoniano, rumeno, ungherese, slovacco, svedese e finlandese.

Dalla sua prima release nel 2001 è stato scaricato piu' di 150.000 volte e la sua comunita' di utenti ha prodotto circa 10.000 post nei forum del sito.

Was ist DaDaBIK?

DaDaBIK is eine sehr populäre und ausgereifte Open Source PHP Anwendung, mit der sich sehr einfach anpassungsfähige Datenbank Frontends und Applikationen erstellen lassen. Innerhalb von nur wenigen Minuten kann man einfache CRUD (create, read, update, delete) Datenbank Frontends erstellen oder auch sehr leistungsfähige datenbankbasiert Applikationen entwickeln.

Sie brauchen keine Programmierkenntnisse um DaDaBIK zu nutzen; und falls Sie ein PHP Entwickler sind können Sie durch den Einsatz von DaDaBIK viel Zeit und Aufwand sparen.

Mit DaDaBIK erstellen Sie keine PHP Skripte (wie mit anderen Alternativen), die bei jeder Anpassung Ihres Datenbankschemas veralten würden. Stattdessen nutzen Sie eine Abstraktionsschicht die leicht aktualisierbar ist wann immer sich Ihr Datenbankschema ändert.

DaDaBIK nutzt die ADOdb (oder PDO) Database Abstraction Library für die Unterstützung aller gängigen Datenbanksysteme, darunter MySQL, PostgreSQL, SQLite, Oracle und MS SQL Server.

Die Stärke von DaDaBIK liegt in seiner Anpassungsfähigkeit. So können Sie zum Beispiel für jedes Tabellenfeld Ihrer Datenbank auswählen:

• ob das Feld in Search/Insert/Update Formularen und Resultatlisten vorkommen soll
• die Feldbezeichnung
• das Datenformat (z.B. numeric, alphabetic, e-mail, url, ...)
• den HTML input type (z.B. textbox, menu, date, rich text editor, password box, ...)
• den Wertebereich, mit Unterstützung von Fremdschlüsseln
• und vieles mehr...

Weitere Features sind Datei-Upload, Master/Detail Views, CSV Export, Duplikat-überprüfung bei Inserts, Authentifizierung und Authorisierungs, Beschränkung von View/Update/Delete-Befehlen, E-Mail Benachrichtigungen.

Das graphische Interface von DaDaBIK ist vollständig auf Ihre Bedürfnisse anpassbar, damit Sie DaDaBIK nahtlos in Ihre eigene Seite integrieren können.

DaDaBIK ist anders als PHPMyAdmin: es soll keine komplette Datenbankadministration bieten, sondern erlaubt Ihren anpassbare und nutzerfreundliche Datenbankanwendungen zu erstellen. DaDaBIK Anwendungen werden für den Endnutzer gemacht, nicht für Datenbank Administratoren.

DaDaBIK ist verfügbar in folgenden Sprachen: Italienisch, Englisch, Holländisch, Deutsch, Spanisch, Französisch, Portugiesisch, Kroatisch, Polnisch, Catalan, Estnisch, Rumänisch, Ungarisch, Schwedisch, Slovakisch und Finnisch.

Seit dem ersten Release im Jahre 2001 wurde DaDaBIK über 150,000 mal heruntergeladen, und seine Nutzergemeinschaft hat sich in über 10,000 Forumsbeiträgen ausgetauscht.

¿Qué es DaDaBIK?

DaDaBIK es una aplicación PHP de código abierto muy popular y madura que permite al usuario crear fácilmente una "database front-end" o una "database application" altamente personalizable sin tener que escribir nada de código. Se puede utilizar para crear una base de datos CRUD (create, read, update, delete) muy simple o para desarrollar una base de datos de mayor sofisticación.

No es necesario tener habilidades de programación para usarlo. Aún así, si eres un programador PHP, con DaDaBIK podrás ahorrarte decenas de horas de trabajo.

DaDaBIK, a diferencia de otros programas similares, no produce simplemente un script PHP, de difícil manutención y que se vuelve obsoleto con el más mínimo cambio en el esquema de la base de datos, sino que utiliza su propia "abstraction layer" (capa de abstracción) que es muy fácilmente actualizable cuando se requiere un cambio en la estructura de la base de datos.

DaDaBIK utiliza ADOdb (o PDO) Database Abstraction Library con el objetivo de ser compatible con el mayor número de DBMSs (Databse Management System) posible. Por el momento, ha sido probado con MySQL, PostgreSQL, SQLite, Oracle y MS SQL Server.

El poder de DaDaBIK reside en su nivel de personalización. Por poner un ejemplo: por cada campo de una tabla se pueden elegir los siguientes parámetros:

• si el campo debe estar incluido (o no) en un formulario de search/insert/update (búsqueda/inserción/actualización) y en una tabla de resultados
• su label (etiqueta)
• el formato del contenido (por ejemplo, numérico, textual, e-mail, url, etc.)
• el tipo de input (entrada) HTML (por ejemplo, un cuadro de texto, un menú, un rich text editor (editor de textos), o un cuadro para introducir un password)
• los posibles valores, que pueden haber sido obtenidos de otra tabla (foreign key support)
• y mucho más...

Otras características incluyen la subida de archivos, vista de master/details, exportación de los resultados de una búsqueda a CSV, control de las inserciones para evitar posibles duplicados, autenticación y restricciones sobre la visualización/modificación/cancelación y notificaciones vía e-mail.

La apariencia de DaDaBIK es altamente personalizable para permitir una buena integración con la página web en la que se pretende utilizar.

DaDaBIK se diferencia de PHPMyAdmin en que no es una interfaz para administrar todos los aspectos de una base de datos, sino que permite la rápida creación de una aplicación para una base de datos user-friendly y personalizable. Por tanto, crea una base de datos manejable por el usuario final (que no tiene necesariamente que ser un administrador de bases de datos profesional).

DaDaBIK está disponible en italiano, inglés, holandés, alemán, español, francés, portugués, croata, polaco, catalán, estonio, rumano, húngaro, eslovaco, sueco y finlandés.

Desde su primera aparción en 2001 ha sido descargado más de 150.000 veces y su amplia comunidad de usuarios ha creado cerca de 10.000 posts en el foro de la página web.

What about the author?

He created the very first version of DaDaBIK in 2000, ten years ago, and released DaDaBIK as GPL in 2001.

What's new?

DaDaBIK roadmap and OT: the Mentor.FM project

Hi folks,
thanks for your patience and sorry for the long period of silence!

The new security/permissions model of DaDaBIK has been designed and a new dedicated admin interface has been built for providing to the user an easy way to set permissions. There are users, there are groups and the system provides a fine granularity approach: for example you can disable the edit for a specific field and a specific user or group.

All this new logic needs now to be integrated into the DaDaBIK engine; I don't think this new DaDaBIK version (5.0) will be published before the new year, most probably the first months of 2012. Two intermediate versions (4.4 beta and 4.4 stable) will anyway be released before.

OT: I'm working on a research project about Music Recommendations and I published a Radio application I'm using to test some algorithms, the Mentor.FM radio. You can listen to music for FREE and without ADVERSTIMENT, according to your taste, until the end of the year. You can find further info at the page "What's mentor.fm?".

Please try Mentor.FM, I would be glad to receive your feedback! if you want, you can also like the Mentor.FM page on Facebook.

Cheers from California,

4 Nov 2011 by Eugenio   2 comments

Tweet

Share

Next releases of DaDaBIK and new security model

Hi all,
I am glad to announce that Alessandro Andreoli, an Italian student of the University of Milan, decided to join the DaDaBIK team and to do a very important work on DaDaBIK as part of his master thesis in Computer Science.

Alessandro is working on the new DaDaBIK security model, something I wanted to implement since years but I didn't find the time to.
When his work will be finished, it will be possible to create group of users and to set permissions at a very granual level, for example saying that the group X has read permissions on the table customers while user Y has also write permission on that table, but not on the field customers.phone_number.

It is a very important shift toward the adoption of DaDaBIK in an enterprise environment.

A big "thank you!" to Alessandro from all the DaDaBIK community.

Another big news is that I'm writing from the United States, where I'm going to live for some months as a visiting scholar at UC Berkeley.

I Hope to give you some news about the next release of DaDaBIK soon!

Ciao,

22 May 2011 by Eugenio   3 comments

Tweet

Share

The locking mechanism is the feature chosen from the Wiki, tell us how to implement it!

Hi,
the locking mechanism is the feature chosen among all the ones proposed by users in the Like, disLike and Propose Wiki.

I want to discuss the implementation details with the users so please leave your comments in the Wiki! Registration is not mandatory to write.

Thanks!

Ciao,

8 Apr 2011 by Eugenio   0 comments

Tweet

Share

I need feedback from SQLite users

Hi all,
as you probably know, DaDaBIK now supports SQLite. Since February 2 2001, more than 30 SQLite installations have been registered online.

I would like to have feedback (good and bed feedback) from those users, because I'm going to release a new version.

I also remind you that the Like, disLike & Propose Wiki will still be available for one month. Please use it to tell what you like, dislike and propose about DaDaBIK. A feature selected anong the ones proposed will be implemented.

Ciao,

Eugenio

2 Mar 2011 by Eugenio   0 comments

Tweet

Share

Like, disLike & Propose, the DaDaBIK Wiki is here!

Hi folks,
today the DaDaBIK Wiki (http://www.dadabik.org/wiki) opens to anyone who wishes to express his opinion about DaDaBIK.

Like, disLike & Propose is the title of the Wiki and the aim is to allow users to freely and easily tell three things: what they LIKE about DaDaBIK, what they DON'T LIKE and what they PROPOSE for the future releases.

The Wiki is open to anyone, registration is not needed to edit. If you prefer you can register and login, in that case you can also easily sign your edits.

After six weeks since its opening, one of the proposals will be chosen; through the Wiki the DaDaBIK developers together with the users will discuss about high-level aspects of its implementation and finally the developers will implement the proposal as a new DaDaBIK feature.


Ciao,

14 Feb 2011 by Eugenio   0 comments

Tweet

Share