dbgate
dbeaver
Our great sponsors
dbgate | dbeaver | |
---|---|---|
27 | 27 | |
4,102 | 36,996 | |
7.5% | 3.1% | |
7.9 | 9.9 | |
15 days ago | 1 day ago | |
Svelte | Java | |
MIT License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
dbgate
- DBeaver – open-source Database client
-
Document your database simply and easily
This tool doesn't let you run SQL queries or create tables. SchemaSpy describes and visualizes an already-created database.
To work directly with SQL, I recommend https://www.beekeeperstudio.io/ or https://dbgate.org/
-
15 open-source tools to elevate your software design workflow
Link | Github | License
-
👻Top 8 Free, Open Source SQL Clients🔥
DbGate works in Windows, Linux, Mac, and your web browsers without compromises in functionality. Both SQL and noSQL databases are supported, from MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, to CockroachDB.
-
Do you use pgAdmin? Why?
Have you tried dbgate? https://github.com/dbgate/dbgate
-
No/Low Code SQLite Front End GUI/Forms
For browsing the SQL data in an IDE, I prefer https://www.beekeeperstudio.io/ or https://dbgate.org/
-
Show HN: Slashbase – open-source collaborative IDE for databases in browser
The two open source SQL IDEs I really like are https://www.beekeeperstudio.io/ and https://dbgate.org/ . Both very nice for my somewhat simple querying needs
-
SQLite GUI
DbGate (https://dbgate.org/)
-
Database GUIs in JavaScript
DbGate is the most feature rich client from this list. It uses multi-connection and multi-database in one window paradigm, with tabs labeled with asociated database. It has interesting data-navigating features, like master/detail and form views, and excel-like data editing. Also you could use features which you may know from classical clients, like query designer or ER diagram viwer. It is the only client from this list, which offers also web version (you could play with it in demo app). But if you need only to write simple SQL query into one database, you could use simpler solutions. Otherwise, when you don't like to write repeating simple queries, this tool is right choice for you. DbGate is developed by Jan Prochazka (author of this article).
-
New to MySQL, tips about client tools
You could also try DbGate. https://dbgate.org . It's free and open source, cross platform, runs as application and also as web client. DbGate author here.
dbeaver
-
DBeaver – open-source Database client
Yes but not in the community version:
-
👻Top 8 Free, Open Source SQL Clients🔥
DBeaver is a veteran SQL client. In addition to basic visualization and management capabilities, it has a SQL editor, data and schema migration capabilities, monitor database connections, and more. It supports a full range of databases (both SQL and NoSQL). DBeaver is also hooked up with GPT-3, which converts your natural language to SQL.
-
SQLite is not a toy database
dbeaver is an excellent option as well, plus it supports basically every kind of SQL database in existence.
-
Most popular PostgreSQL GUIs in 2022: the (almost) scientific list
OmniDB is more complex than a Postico or TablePlus but less advanced than a DataGrip or Navicat. It's a good free option but maybe less complete than DBeaver, which has a better documentation and a seemingly larger community.
- What are the free tools in your web development workflow that not many people know about?
-
Headless BI: Metric Standardization in Action
First, the SQL client—DBeaver in this case— needs to be connected to GoodData FDW.
-
Consider SQLite
I think the usual approach would be to SSH into the server and run sqlite3 there. This issue [0] mentions some workarounds for connecting from DBeaver, which I assume would work for other graphical client software. I haven't tried those approaches, and they seem pretty hacky, but I guess that's to be expected given that SQLite isn't designed for that type of access.
What are some alternatives?
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
LINQ to DB - Linq to database provider.
liquibase - Main Liquibase Source
antares - A modern, fast and productivity driven SQL client with a focus in UX
Gravitational Teleport - Protect access to all of your infrastructure
Adminer - Database management in a single PHP file
LevelDB - LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.
sqlitestudio - A free, open source, multi-platform SQLite database manager.
Sequel-Ace - MySQL/MariaDB database management for macOS
Flyway - Flyway by Redgate • Database Migrations Made Easy.
mondrian - Mondrian is an Online Analytical Processing (OLAP) server that enables business users to analyze large quantities of data in real-time.
Jailer - Database Subsetting and Relational Data Browsing Tool.