4 ms·
> “I think the biggest complication for us is that there’s no tooling for it.” said Mackey. “We have people deploy apps. They’re like, ‘How do I connect to my d
by smitty1e 4y ago
> “I think the biggest complication for us is that there’s no tooling for it.” said Mackey. “We have people deploy apps. They’re like, ‘How do I connect to my database and like query things? How do I import data?’”
Wut?
Every scripting language includes a SQLite driver.
Python's SQLAlchemy wraps SQLite beautifully. You can develop locally and then deploy to an enterprise server with a simple change of connection string.
I must be missing the speaker's point.
- nicoburns 4y agoI think they mean GUI tooling for ad-hoc inspection of the database. And possibly the stumbling block is difficulty accessing it over a network?
- smitty1e 4y agohttps://sqlitebrowser.org/ https://sqlitebrowser.org/
- stefanos82 4y agoI prefer https://sqlitestudio.pl/ https://sqlitestudio.pl/ to be honest with you.
- edwinyzh 4y agoI've tried over 15 sqlite management tool, but SqliteStudio is my favorite! And recently discovered https://github.com/little-brother/sqlite-gui https://github.com/little-brother/sqlite-gui
- 41b696ef1113 4y agoI personally love DBeaver for SQL, but I did stumble across a thats-not-how-it-was-intended-for-usecase for Datasette [0]. Datasette is intended to be a way to share static SQLite databases. However, I was recently debugging a Django application where I lacked appropriate tooling to inspect what was happening in the database. However, I am a huge fan of Datasette, so why not? While the Django debug server was running, I was able to launch datasette in a separate terminal and have a live view into the database while the application was free to mutate the underlying data. You can even write custom SQL inside the browser to select/modify any interesting data. [0]: https://datasette.io/ https://datasette.io/