4 ms·
This is the best tool in its category that I've found. It's the only that can stream results (so you can run SELECT without LIMIT and see the first results immi
by amadeuspagel 1y ago
This is the best tool in its category that I've found. It's the only that can stream results (so you can run SELECT without LIMIT and see the first results immidiately) and display them as a table.
EDIT: Crashes often though.
- deafpolygon 1y agoHow is that best in class, then? If it crashes often, it’s not production-ready.
- amadeuspagel 1y agoI wrote that in a burst of enthusiasm before I noted the crashes.
- 0cf8612b2e1e 1y agoIf only my production tools did not crash.
- ugh123 1y agoFor development (and table browsing purposes), some crashing is acceptable (to me at least), as long as the tool overall gives me a productivity boost. Perhaps OPs use-case of streaming large sqlite files for browsing purposes is not typical.
- Intralexical 1y agoIf it crashes a lot because it's full of undefined behavior/unhandled errors, then what is it doing when it encounters those issues and doesn't crash?
- zX41ZdbW 1y agoMy SQL Playground can stream results and display them as a table: https://play.clickhouse.com/ https://play.clickhouse.com/ And for a command-line client, clickhouse-client has been around since 2016.
- amadeuspagel 1y agoImpressive, but the category I was refering to is SQLite clients.