![]() ![]() It was the default tool for LAMP and MAMP at that time. PhpMyAdmin was born in 1998, written in PHP, and is a classic SQL client. The codebase for HeidiSQL originally came from the author's own MySQL-Front 2.5 software, but he later sold the MySQL-Front brand and the author renamed his project HeidiSQL and has maintained it to this day. In addition to basic SQL client functionalities, users can export structures and data to SQL files or copy them to the clipboard or other servers. HeidiSQL is also a lightweight SQL client that supports a long list of databases including MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase and Firebird. It seems someone (semi-)took it over, with the most recent release last May. ![]() Similar to the story of the two aforementioned tools, the original authors of Sqlectron built this because he couldn't find a tool on the market that worked well and solved his pain points (a simple, lightweight SQL client desktop with cross-database and platform support), but 2018 he mentioned that he hadn't used SQL databases since changing jobs, and opened a GitHub Issue looking for a successor. It has cross-database (PostgreSQL, Redshift, MySQL, MariaDB, SQL Server, Cassandra, SQLite) and platform (Mac, Linux, Windows) support. Sqlectron is lightweight SQL client with simplicity in mind. He had built SQL clients for Windows in the past, so this was influenced by his own work experience. The author of DbGate says this was his passion project because he couldn't find a SQL client for Linux. Both SQL and noSQL databases are supported, from MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, to CockroachDB. DbGateĭbGate works in Windows, Linux, Mac, and your web browsers without compromises in functionality. After almost a year of hardwork, the first version was released in early 2020. The author of Beekeeper Studio is an independent developer who started building this tool in 2019 because he couldn't find an easy-to-use cross-platform SQL client. It is available on Linux, Mac and Windows. Beekeeper Studioīeekeeper Studio is a modern (aesthetic) and lightweight SQL client that supports MySQL, Postgres, SQLite, SQL Server, etc. ![]() It's worth noting that DBeaver just announced a $6M seed round two weeks ago (the press release also mentions that DBeaver has over 8M users and 5,000+ paying subscribers), and the first since the author built it in 2013. DBeaver is also hooked up with GPT-3, which converts your natural language to SQL. It supports a full range of databases (both SQL and NoSQL). In addition to basic visualization and management capabilities, it has a SQL editor, data and schema migration capabilities, monitor database connections, and more. SQL Chat launched on Product Hunt mid April, and it gained lots of attention that there's a limit to the free service.ĭBeaver is a veteran SQL client. You can access it directly via sqlchat.ai or deploy it via Docker. Databases supported now include MySQL, PostgreSQL and MSSQL. SQL Chat is a young player (released in March, 2023), prompting SQL clients from the traditional GUI-based to the Chat-based stage: it's powered by ChatGPT to write and polish SQL for you. In this post, we are taking a look at some open source SQL clients options for you to try. So people began to develop tools with a graphical user interface (GUI), and that became what we now know as SQL clients, which are basically front-end applications for database services. In the past, the only way to access or modify a database was through the command line, which was not only not intuitive, but also prone to errors that could lead to major problems. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |