dbgate
sqlitestudio
Our great sponsors
dbgate | sqlitestudio | |
---|---|---|
27 | 41 | |
4,102 | 4,135 | |
7.5% | - | |
7.9 | 9.2 | |
15 days ago | 4 days ago | |
Svelte | C | |
MIT License | GNU General Public License v3.0 or later |
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.
sqlitestudio
-
C# program not able to open or connect to an encrypted SQLite Database
DB4S provides only one algorithm based on official SQLite cipher. You can encrypt your database with another in SQLiteStudio or sqlite-gui (I'm an author). Both applications use SQLite3 Multiple Ciphers-library.
- Lightweight SQLite Editor for Windows
-
What if Joplin disappears?
SQLiteStudio is my favourite - https://sqlitestudio.pl/
-
SQLite interface(s) for creating complex queries with a table that has 68 million rows?
The most popular apps areDB4S and SQLiteStudio. If you are planning to run long time queries, then you might encounter with problems by running them in parallel in these tools. To run several queries in a real parallel mode you can use Navicat for SQLite or my sqlite-gui.
-
Utility to create a database for TTRPG content entries?
If you are up to learn SQL queries, I would suggest using SQLite. It stores all information in a single file. You even can use https://sqlitestudio.pl solution so it can be a little more visual.
- Is there a way to update sqlite3 version within python? (windows)
- Python projects with best practices on Github?
-
No/Low Code sqlite Front End GUI/Forms
DB Browser for SQLite and SQLiteStudio both exists, not sure if this is what you are looking for.
-
Is there a way to backup the cookies and site data exceptions list?
They're database files that you can inspect with a program like DB Browser or SQLiteStudio. You should be able to import permissions.sqlite to different Firefox profiles by just copying it to the right profile directory.
-
Working with more than 10gb csv
https://sqlitestudio.pl is awesome, super easy to set up and pull in CSVs
What are some alternatives?
sqlitebrowser - Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
dbeaver - Free universal database tool and SQL client
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Sequel-Ace - MySQL/MariaDB database management for macOS
sqlite-gui - Lightweight SQLite editor for Windows
antares - A modern, fast and productivity driven SQL client with a focus in UX
Adminer - Database management in a single PHP file
Jailer - Database Subsetting and Relational Data Browsing Tool.
sqlite - A simple sqlite3 library for Haskell
litecli - CLI for SQLite Databases with auto-completion and syntax highlighting