Draft:WebDB

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

Korben, a famous french IT media, publish a article about WebDB on 22 January 2024 followed by Programmez!

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