Fairly recent and related:<p><a href="https://news.ycombinator.com/item?id=40909076">https://news.ycombinator.com/item?id=40909076</a>
411 points | 84 days ago | 68 comments
I'm working on something related but for the web: <a href="https://www.sqltab.com/" rel="nofollow">https://www.sqltab.com/</a><p>It's an alpha version and barely works at this point but at the very least you can use it to browse SQLite tables without installing anything on your computer.<p>It uses the WASM build of SQLite with OPFS for persistence. The main focus of this will be to manipulate JSON stored in an SQLite table. I need this for one of my existing workflows. In particular, I want the ability to flatten a JSON tree into tabular format: <a href="https://youtu.be/z0QvxyMybKA" rel="nofollow">https://youtu.be/z0QvxyMybKA</a>
Great tool, just found it a few months ago. I am a pretty hardcore CLI/TUI user so I am generally reluctant to reach for GUIs but this gets the job done and comes in quite handy when the sqlite3 cli just doesn't cut it.