Hacker News Reader

Comment by creatonez | Hacker News Reader

Here's one that works entirely clientside via Webassembly - https://sqliteviewer.app/

Upload your bloated firefox `places.sqlite` and select `moz_places` and it loads it without a hitch... if you trust the website not to steal your browsing history.

Unfortunately sqliteviewer.app is not open source. This one (https://inloop.github.io/sqlite-viewer/) is, though. But it uses a JS reimplementation of sqlite rather than true sqlite in WASM.

View on HN

What about the official project? https://sqlite.org/wasm/doc/trunk/index.md

Yep. Getting sqlite working in webassembly is almost a production-ready feat these days. I was mainly looking for things that bolt management GUIs on top of what is already possible.

Check out the "In the Wild" section on that page, here's the first link https://github.com/nalgeon/sqlime

https://beta.sqliteviewer.app uses this (with some modifications) under the hood.

Since it's OPFS-based instead of in-memory, it can open much larger sqlite files, up to the browser-determined size limit.

I've had success using sql.js (https://sql.js.org) for small, hobby projects. It's just SQLite compiled to WASM. They have a link to an online demo at the top of the homepage, which may be the exact tool that you're hoping for.

Since it's webassembly, I wonder if it can be made to work completely on the client with something like Orca (https://orca-app.dev/) so you don't even need to trust the website.

It already works completely clientside. The page makes no requests to the server after putting your DB into it.

I meant without the browser as its own client. How can you be sure the page won't change and upload your db the next time you use it?

You can't, but as the author I can assure you that I'm very trustworthy lol

I've been thinking about a standalone version for a while, but haven't gotten around to it. You could use the vscode/codium extension and disable auto updating for a similar effect.

Reply on news.ycombinator.com