8
votes
Curses-based SQLite console browser
My choice for browsing tabular data in the console or terminal is [Visidata] (https://www.visidata.org). It works well with SQLite and a variety of other data sources. It does allow editing data in ...
- 116
6
votes
Curses-based SQLite console browser
Check the sqlectron. It comes both in GUI and in Term version.
Also there is sqlcrush.
- 161
6
votes
Software tool to create/modify/view table relationships in SQLite database
The viewing part can be achieved using SchemaCrawler; amongst its features, it generates database diagrams. It supports various database formats, including SQLite. Disclaimer: I haven't used it (yet).
...
- 2,033
3
votes
SQLite GUI editor
"DB Browser for SQLite" (DB4S)
https://sqlitebrowser.org/
https://github.com/sqlitebrowser/sqlitebrowser
seems to do most of what you require, though I am uncertain about the "link&...
- 131
2
votes
Software tool to create/modify/view table relationships in SQLite database
Datagrip by jetbrains supports SQLite. I've used it for other (MySQL, Oracle) types of databases, and it's been good. However, I haven't used it for SQLite.
2
votes
Accepted
need sqlite data content compare
I haven't used this, just DuckDucklGo'ed it, but what about
KS DB Merge Tools for SQLite is an easy to use diff & merge tool for SQLite databases. This tool allows to compare and import/export ...
- 9,110
2
votes
Accepted
Generating Python classes for SQLite database
Peewee helped me reduce the code by ~50%.
And then I found that Peewee comes with a tool called Pwiz, which generates Python code from the database, which helped a lot, because that way I only need to ...
- 10.4k
1
vote
Accepted
Desktop application for browsing and editing SQLite database files that works natively in Apple Silicon (M1)
You can check out the "Universal Database Tool" DBeaver Community Edition.
It supports SQLite and several other databases and on their download page they provide an image for MacOS for M1/...
- 560
1
vote
How to visualize / debug SQLite database? (python application)
Take a look at Sqlite workbench
SQLite Workbench is a full SQLite editor which allows you to create, edit and manage your SQLite databases. It also allows you to export data or access it through ...
- 9,110
1
vote
C# What is the best free and reliable database solution for storing configuration?
Not sure if it would fit your requirements, and I hope it's not bad form to recommend something I have developed, but over the last few months I have been developing a simple, fast SQL database ...
- 111
1
vote
Choosing the right database management system?
There is alway an "it depends" aspect to these type of questions, however let's give it a try. I will give 3 scenario's which you have determine which best describes your situation.
Proof of concept /...
- 305
1
vote
Accepted
Embedded database to distribute with an open source webapp
Several open source webapps (namely Alfresco and Liferay) distribute a small amount of data with the webapp, to make it easy to get started with. A beginner can just run the start script, and the ...
- 19.5k
1
vote
Accepted
Software tool to create/modify/view table relationships in SQLite database
Dbeaver is also a great tool to work with databases including SQLite and can visualize the relations between tables
- 305
1
vote
Free program to generate ER diagram for exisiting SQLite Database
I have recently discovered this tool which has an ER Diagram capability based on SQLite datatbase (in actual fact, I use geopackages - a GIS implementation of sqlite databases.
DBeaver
The only issue ...
- 241
1
vote
SQLite GUI editor
I'm the author of sqlite-gui for Windows. This tool has most standard features such code highlighting and export/import and some unique/rare:
Search in whole database (Heidi has it too)
Charts (hi, ...
- 111
Only top scored, non community-wiki answers of a minimum length are eligible