3 ms·

I generally use the Firefox SQLite Manager extension when I need to explore SQLite databases. It serves its purpose pretty well, though it has some annoyances a

I generally use the Firefox SQLite Manager extension when I need to explore SQLite databases. It serves its purpose pretty well, though it has some annoyances and UI quirks. https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage...

mythrwy 9y 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_ 9y ago
  It'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.