4 ms·

Here's one that works entirely clientside via Webassembly - https://sqliteviewer.app/ https://sqliteviewer.app/ Upload your bloated firefox `places.sqlite` and

Here's one that works entirely clientside via Webassembly - https://sqliteviewer.app/ 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/ https://inloop.github.io/sqlite-viewer/) is, though. But it uses a JS reimplementation of sqlite rather than true sqlite in WASM.

hiccuphippo 3y ago
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/ https://orca-app.dev/) so you don't even need to trust the website.
- Snapstromegon 3y ago
  It already works completely clientside. The page makes no requests to the server after putting your DB into it.
  - hiccuphippo 3y ago
    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?
    - qwtel 3y ago
      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.
throwaway4aday 3y ago
What about the official project? https://sqlite.org/wasm/doc/trunk/index.md https://sqlite.org/wasm/doc/trunk/index.md
- creatonez 3y ago
  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.
  - throwaway4aday 3y ago
    Check out the "In the Wild" section on that page, here's the first link https://github.com/nalgeon/sqlime https://github.com/nalgeon/sqlime
- qwtel 3y ago
  https://beta.sqliteviewer.app 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.
allknowingfrog 3y ago
I've had success using sql.js (https://sql.js.org 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.

hiccuphippo 3y ago

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/ https://orca-app.dev/) so you don't even need to trust the website.

Snapstromegon 3y ago
It already works completely clientside. The page makes no requests to the server after putting your DB into it.
- hiccuphippo 3y ago
  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?
  - qwtel 3y ago
    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.

throwaway4aday 3y ago

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

creatonez 3y ago
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.
- throwaway4aday 3y ago
  Check out the "In the Wild" section on that page, here's the first link https://github.com/nalgeon/sqlime https://github.com/nalgeon/sqlime
qwtel 3y ago
https://beta.sqliteviewer.app 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.

allknowingfrog 3y ago

I've had success using sql.js (https://sql.js.org 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.