DaDaBIK is a very popular and mature Open Source PHP application which allows you to easily create a
highly customizable database front-end/application without coding. You can use it to create in a few minutes a very basic CRUD (create, read, update, delete) database front-end or to develop a more sophisticated database application.
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 officially supports MySQL, PostgreSQL and SQLite.
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, Russian 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.
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.
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, russo 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.
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, Russisch 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.
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, ruso 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.
How about the author?
Eugenio Tacchini, Ph.D., is an Italian software analyst & developer, University lecturer of Information Systems and researcher in Music Recommender Systems. He has been a visiting scholar at the Freie Universitat Berlin and at the University of California, Berkeley.
Enjoying PHP and open source technologies, he created the very first version of DaDaBIK in 2000, twelve years ago, and he continues developing it to this day.
A new section of the site, services, has been added; the page contains information about DaDaBIK-related professional services which I can provide, for example installation, customization or new features development.
Hi,
a new version, 4.4 patch level 1, is available.
The main reason of this release is fixing two bugs which can cause errors and insert/update of wrong data in the database.
New stable version (4.4), new distribution model and a video tutorial!
Hi all,
DaDaBIK 4.4 final version is out! A lot of bugs have been fixed (thanks to all the guys who reported them through the forum!) and this can be considered the new stable version of DaDaBIK, which officially supports MySQL, PostgreSQL and SQLite. Since some bugs are critical and affect not only the previous release, all the users are strongly encouraged to upgrade.
As you could have noticed, I removed the official support to Oracle and MS Sql Server; the percentage of Oracle and MS SQL Sever users is very small and I prefer, for the moment, to focus my effort on the other DBMSs.
This new version also added three new features: the official support for Views management, in addition to tables (this can help a lot in creating more flexible database applications); the possibility to hide the NULL checkboxes in forms (a change which a lot of users requested) and a new language translation: Russian (thanks Eugeniy!).
Many users asked me a simple tutorial to start with DaDaBIK (in addition to the documentation) so I decided to record a video tutorial which, in less than 15 minutes, explains how to create a very basic DaDaBIK database application without coding. The video is available on Youtube (http://www.youtube.com/watch?v=uPmXoep91Vk). This is the first of a serie of episodes, please let me know your feedback!
Since I want DaDaBIK to be part of my daily Job, I also decided to change the distribution model; now a donation (or, if you prefer, a variable price) is required to download DaDaBIK. You can download DaDaBIK starting from 3 euros including VAT, less than a beer, but if you can afford it you can also pay more. A regular invoice is produced and sent.
I hope that everyone will understand this new approach, which also means a personal commitment to the development of the software, and realize that DaDaBIK actually worths much more than 3 euros. To give some examples, two other applications having similar purposes cost respectively US$159.95 and US$79.
Hi all,
I would like to understand which are the DBMSs DaDaBIK is mostly used with, in order to understand where to focus the implementation efforts on.
Hi all,
thanks to the rewards program of Dreamhost, I can provide a $65.00 discount for a year of Web hosting; the normal price for a year is $119.40, using the promo code DADABIK you'll pay just $54.40 if you are a new customer.
I tried several Web hosting services during my career of Web developer and it's difficult to find the perfect one; Dreamhost, as the others, isn't without defects. I don't like, for example, their marketing approach, which makes prices and features not very clear. However, it is probably the best Web hosting service I have ever tried. I am impressed by their very complete control panel, from which you can really do everything you need.
About the support, I am using Dreamhost for a project I'm working on (sharing Web hosting and VPS Mysql) and I had the chance to test it: I don't know if the service is the same for all the plans but they literally saved my life last Christmas night when, by mistake, I dropped a very important MySQL table....yes, I did it, it happens :(
After having waited some time, I managed to chat - during Christmas night - with a guy from the support and the next day they provided a backup of the table (created automatically) that let me recover almost all the data; I lost only the last 36 hours of activity. Just for this reason I think I can promote their services, something I usually don't do.
Let me know, if you try it, your impressions.
P.S. Note that sometimes Dreamhost provides other special discounts, different from the one I'm providing and that you can't combine discount with additional discount.
UPDATE: I realized that, to use the DaDaBIK promo code, you have to go directly to http://signup.dreamhost.com/; at some point, the subscription procedure will ask you for an (optional) promo code. Furthermore, you should clean dreamhost cookies if you visited the homepage before, because otherwise the system takes the current dreamhost promotion as default. Very bad, I know :(
So I advise to look at the homepage and see if there is a promotion available, check if it is better than the one I am offering (could be) and if not clean the cookies and subscribe through http://signup.dreamhost.com/ using the DADABIK promo code.
