DaDaBIK

Last updated
DaDaBIK
Developer(s) Eugenio Tacchini
Initial releaseNovember 21, 2001 (2001-11-21)
Stable release
11.0 Elba / June 17, 2021;2 months ago (2021-06-17)
Written in PHP
Operating system Cross-platform
Available inFront-end multilingual (22)
Type Database Web Application Builder, no-code Web development platform
License before 4.5 GPL, after 4.5 proprietary
Website dadabik.com

DaDaBIK is a no-code / low-code development platform [1] written in PHP for quickly creating a CRUD (create, read, update, delete) database front-end or a more sophisticated database-driven Web application without coding. The database management systems currently supported are MySQL, PostgreSQL, SQLite and, starting from version 9.2, Microsoft SQL Server.

Contents

History

DaDaBIK was originally released in 2001 on SourceForge under the GNU General Public License by Eugenio Tacchini and supported only MySQL.

With the version 4.5 release in June 2012, the license changed from GPL to a proprietary "DaDaBIK 1.0" license [2] which requires payment before downloading, and prohibits further redistribution. The (old) GPL code (DaDaBIK v. 4.x) has been removed from the official website and from the Sourceforge project but can still be distributed freely, [3] the current version (at the moment, 11.0 "Elba") can be downloaded only from the official Website.

Version 6 has introduced some new features including the possibility to add custom (hand-coded) PHP pages to a DaDaBIK application.

Version 8 Lerici had a new, responsive, front-end has been introduced, together with many new features, including graph reports generation, calculated fields, hooks and smart installation (DaDaBIK tries to automatically configure an application according to its database schema).[ citation needed ] A new license, DaDaBIK license v. 2.0, has also been introduced.[ citation needed ]

Version 9 "Monterosso" has been another important milestone in the development of DaDaBIK. DaDaBIK 9 allows to build a Web application without coding starting from an Excel, CSV or ODS file (before V.9, you could build a DaDaBIK application only starting from a database). Several new features which help power users to develop complex applications have also been introduced, including: custom buttons, dashboards and layout hooks. [4] [5] A new license, DaDaBIK license v. 2.1, has also been introduced [6]

Version 9.2 introduced the support for Microsoft SQL Server.

Version 10 "Manarola", released on December 2019, celebrates 18 years of DaDaBIK and introduced a new way of developing DaDaBIK applications thanks to the new data section (developers can now create tables from within DaDaBIK, without using external applications) and to the new form configurator live preview (developers can see a live preview of the form they are configuring, without leaving the admin section). . Many new features have also been introduced, including: HTTP API, Audit/revision, Conditional Fields, Pivot/Summary tables, multiple records selection. The performances of the DaDaBIK engine has also been improved. [7] [8]

Version 11 "Elba", released on June 2021 introduced some new features, including: "live edit"; Import and synchronization with MS Excel, CSV and ODS files; Ajax uploads. [9] [10]

Current status

The current release is the 11.0 "Elba" (released on June 17, 2021). [11] The original author is still the main developer behind the core of the code while Simone Magnaschi takes care of the UX e UI design and some of the Javascript front-end programming. A group of mother tongue users handle the translation/localization of the front-end (available in 22 languages).

Features

Some of the main features are: forms customization (e.g. labels, different types of HTML input field, content check), lookup fields, master/details view, files upload, calculated fields, conditional fields, hooks, graph/pivot report generation, export to CSV and PDF, checking for possible duplication during insertions, authentication, authorization restrictions on view/update/delete, and e-mail notices.

Popularity and notability

DaDaBIK has been used by developers, companies, non-profits and Universities worldwide. Since its first releases, it has been particularly popular in the academic world [12] and has been adopted by several big organizations like the University of Cambridge, [13] [14] the Università Cattolica del Sacro Cuore. [15] and the Yale University. [16]

Most of the applications created with DaDaBIK are for internal use (some examples: general data-entry applications, admin tools, tools for Business process management automation, Web databases, CRMs, libraries management, museums catalogue management) and are not publicly accessible on Internet.

Considering that it was originally released in 2001, it can be considered one of the very first Web No-code development platform

DaDaBIK is listed in many software repositories, including Capterra [17] and Hotscripts. [18]

Meaning of the name

DaDaBIK is a recursive acronym which stands for: "DaDaBIK is a DataBase Interfaces Kreator". [19]

Related Research Articles

PostgreSQL Free and open-source relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres.

SQLite Serverless relational database management system (RDBMS)

SQLite is a relational database management system (RDBMS) contained in a C library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.

Movable Type Blogging software

Movable Type is a weblog publishing system developed by the company Six Apart. It was publicly announced on September 3, 2001; version 1.0 was publicly released on October 8, 2001. The current version is 7.0.

Clarion is a commercial, proprietary, fourth-generation programming language (4GL), multi-paradigm, programming language and integrated development environment (IDE) from SoftVelocity used to program database applications. It is compatible with indexed sequential access method (ISAM), Structured Query Language (SQL), and ActiveX Data Objects (ADO) data access methods, reads and writes several flat file desktop database formats including ASCII, comma-separated values (CSV), DOS (binary), FoxPro, Clipper, dBase, and some relational databases via ODBC, Microsoft SQL Server, Sybase SQL Anywhere, and Oracle Database through the use of accelerated native database drivers, and XML, Clarion can be used to output to HTML, XML, plain text, and Portable Document Format (PDF), among others.

GNOME-DB is a database application by the GNOME community. The project aims to provide a free unified data access architecture to the GNOME project for all Unix platforms. GNOME-DB is useful for any application that accesses persistent data, since it now contains a data management API.

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

Kexi

Kexi is a visual database applications creator tool by KDE, designed to fill the gap between spreadsheets and database solutions requiring more sophisticated development. Kexi can be used for designing and implementing databases, data inserting and processing, and performing queries. It is developed within the Calligra project but is released separately.

ADOdb is a database abstraction library for PHP, originally based on the same concept as Microsoft's ActiveX Data Objects. It allows developers to write applications in a consistent way regardless of the underlying database system storing the information. The advantage is that the database system can be changed without re-writing every call to it in the application.

LAMP (software bundle) Acronym denoting one of the most common solution stacks for many of the webs most popular applications

LAMP is an acronym denoting one of the most common solution stacks for many of the web's most popular applications. However, LAMP now refers to a generic software stack model and its components are largely interchangeable.

Silverstripe CMS

Silverstripe CMS is a free and open source content management system (CMS) and framework for creating and maintaining websites and web applications. It provides an out of the box web-based administration panel that enables users to make modifications to parts of the website, which includes a WYSIWYG website editor. The core of the software is Silverstripe Framework, a PHP Web application framework.

SPIP

SPIP is a free software content management system designed for web site publishing, oriented towards online collaborative editing.

phpCodeGenie is a code generator for web applications. Once the user designs their database tables, phpCodeGenie generates the scripts and programs. It will build data entry forms, insert scripts, database lister scripts, edit record forms, update record scripts, delete confirmation scripts, delete scripts, search forms, search scripts and other frontend/database interaction code.

Navicat

Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, MongoDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.

Web2py is an open-source web application framework written in the Python programming language. Web2py allows web developers to program dynamic web content using Python. Web2py is designed to help reduce tedious web development tasks, such as developing web forms from scratch, although a web developer may build a form from scratch if required.

Hyper Text Structured Query Language (HTSQL) is a schema-driven URI-to-SQL query language that takes a request over HTTP, converts it to a SQL query, executes the query against a database, and returns the results in a format best suited for the user agent The HTSQL language is implemented on "HTSQL servers," which use HTSQL to convert web requests into equivalent SQL, executes requests on a server-side database, and returns results in XML, HTML, CSV, JSON, or YAML formats. The current implementation as of April 2010 uses Python and works with PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server databases.

Scriptcase

Scriptcase RAD is a development platform for PHP applications, is web oriented and can be installed in a server in the internet. It acts as a platform for developers and allows them the use of a graphical interface directly through a web browser to automatically generate the codes. It was developed by NetMake in the year 2000. Can be used on Mac, Windows, and Linux operating system.

PunBB

PunBB (PunBulletinBoard) is a lightweight PHP-based internet discussion board system released under the GNU General Public License. The project's primary goal is to be a faster, smaller and less graphic alternative to discussion boards such as phpBB, Invision Power Board or vBulletin. Many open-source and commercial projects' discussion boards use PunBB. Until September 2011, Facebook's Developers were using Facebook Developer's Forum for discussions and bug reports, which was powered by PunBB.

Fat-Free Framework

Fat-Free Framework is an open-source web framework distributed under the GNU General Public License and hosted by GitHub and Sourceforge. The software seeks to combine a full featureset with a lightweight code base while being easy to learn, use and extend.

The following outline is provided as an overview of and topical guide to MySQL:

DBeaver

DBeaver is a SQL client software application and a database administration tool. For relational databases it uses the JDBC application programming interface (API) to interact with databases via a JDBC driver. For other databases (NoSQL) it uses proprietary database drivers. It provides an editor that supports code completion and syntax highlighting. It provides a plug-in architecture that allows users to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. This is a desktop application written in Java and based on Eclipse platform.

References

  1. ↑ "What is a Low-Code Development Platform? Discover the basics of Low-Code development with DaDaBIK".
  2. ↑ http://www.dadabik.org/dadabik_license.txt
  3. ↑ see harwoodr Github repository
  4. ↑ "DaDaBIK Blog - DaDaBIK 9 Monterosso is here".
  5. ↑ https://www.youtube.com/watch?v=d4h3Dui46B8
  6. ↑ "License - DaDaBIK".
  7. ↑ "DaDaBIK Blog - 18 years of low-coding / No-coding with DaDaBIK - DaDaBIK 10 "Manarola" is here".
  8. ↑ https://www.youtube.com/watch?v=oIoEgCygmi0
  9. ↑ "DaDaBIK Blog - DaDaBIK 11 Elba is here: Live edit, import/Synch from MS Excel and more".
  10. ↑ https://www.youtube.com/watch?v=nwsVaraF6DE
  11. ↑ PHP database front-end / CRUD generator for MySQL SQLite PostgreSQL - Create a PHP online database application / data entry application without coding - DaDaBIK is a DataBase ...
  12. ↑ Google Scholar - DaDaBIK
  13. ↑ World Oral Literature Project : Research & Outreach
  14. ↑ Disappearing Languages Arrested Online Archived 2011-03-07 at the Wayback Machine
  15. ↑ European Centre for Media Literacy - Services - Content repository Archived 2013-12-14 at the Wayback Machine
  16. ↑ Yale Center for International and area studies - working papers database Archived 2003-02-19 at the Wayback Machine
  17. ↑ Capterra - Database software - DaDaBIK
  18. ↑ Hotscripts ... - Database Tools - DaDaBIK
  19. ↑ PHP database front-end / CRUD generator for MySQL SQLite PostgreSQL - Create a PHP online database application / data entry application without coding - DaDaBIK is a DataBase ...
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.