2 ms·
In a terminal, `sqlite3 mydb.` works pretty well also. I find this generally a lot faster than GUI tools for quick peek or some queries (although for complex re
by mythrwy 10y ago
In a terminal, `sqlite3 mydb.` works pretty well also. I find this generally a lot faster than GUI tools for quick peek or some queries (although for complex relations and visualization a good GUI is the thing to have). Not a huge MS fan but SQL Management Studio is pretty good (don't know about sqlite support.. I bet it's possible though).
.tables (list tables).
.schema <table> (show table schema).
.help shows commands.
Or just enter some SQL to get results.
- voltagex_ 10y agoIt'd be really cool to use SSMS for SQLite. It's possible but not nice: https://superuser.com/questions/138787/is-it-possible-to-open-a-sqlite-database-from-within-microsoft-sql-server-manage https://superuser.com/questions/138787/is-it-possible-to-ope... DataGrip from Jetbrains looks promising but the connect/disconnect/setup process is really painful.