Software:WebDB
 | |
 | |
| Developer(s) | Alexandre Biche |
|---|---|
| Initial release | July 22, 2023 |
| Repository | https://github.com/WebDB-App/app |
| Written in | Node.js Angular (web framework) |
| Operating system | Cross-Platform |
| Platform | ARM x86-64 |
| Size | 230 MB |
| Available in | English |
| Type | IDE |
| License | GNU Affero General Public License version 3 |
| Website | https://webdb.app |
WebDB is an advanced database integrated development environment (IDE) known for its innovative features in database management and development. With a main focus on efficiency, it aims to ease common database tasks
History
WebDB took it's origin from the correction on a GUI course given by Alexandre at My Digital School. The course had objective of GUI conception and phpMyAdmin was choose to be the subject to redesign. WebDB was the example of the redesign and became after some weeks a real application.
The project became open source on december 2023 and distributed on Github[1]
Korben, a famous french IT media, publish a article about WebDB on 22 January 2024[2] followed by Programmez![3]
Features
WebDB's notable features include:
- DBMS Discovery & Credential Guess: Allows for quick server connection and automatic setup.
- Time Machine: Capability to revert database changes with a history retention of up to 200 versions.
- Powerful Query Editor: SQL / NoSQL autocomplete, comprehensive documentation, and error location capabilities.
- AI Assistant: Integrates Together AI, ChatGPT and Google Gemini API. Auto pre-prompt conversation with database structure and data sample to enrich LLMs.
- NoSQL Structure Manager: Automatically infers relationships between collections in NoSQL databases.
- Modern ERD: Modern ERD with export capabilities.
- Intelligent Data Generator: Incorporates FakerJS and Falso for generating probable data, respecting foreign keys and Enum values.
DBMS Supported
WebDB support following Database Management System:
- MySQL 5.6+
- PostgreSQL 12+
- MongoDB 4+
- CockroachDB 22.2+
- YugabyteDB 2.18+
- MariabDB 10.4+
- Percona 5.6+
- TiDB 5+
Tests are runned everyday against each version to ensure compatibility. Results of these test are available here[4]
See Also
External links
References
- ↑ WebDB (2024-01-26), WebDB-App/app, https://github.com/WebDB-App/app, retrieved 2024-01-28
- ↑ Korben (2024-01-22). "WebDB – Vos bases de données enfin accessibles facilement" (in fr-FR). https://korben.info/webdb-accessibilite-facile-bases-de-donnees.html.
- ↑ "WebDB : un IDE open source dédié aux bases de données" (in fr). 2024-01-22. https://www.programmez.com/actualites/webdb-un-ide-open-source-dedie-aux-bases-de-donnees-36076.
- ↑ "WebDB – Open Source and Efficient Database IDE". https://webdb.app/compatibility.
 |  |
