SQLite File Format Viewer • Hacker News Board

Re: SQLite File Format Viewer

#41

Post by invisal » Tue, Apr 15, 2025, 1:22 PM UTC

NoSalt wrote: post #12

Really nice, looks great! However, I am not a fan of uploading databases to "strange" sites on the internet, so I will probably never use this.

It is completely frontend. Everyone can review the code or host it themselve. :)

Re: SQLite File Format Viewer

#42

Post by roelschroeven » Tue, Apr 15, 2025, 1:41 PM UTC

invisal wrote: post #39

roelschroeven wrote: post #37

I tried with a simple database, and it just shows me a blank screen. The console in developer tools shows an exception (both in Firefox and Chromium): index-CGfYebmt.js:85 Uncaught RangeError: Offset is outside the bounds of the DataView at DataView.prototype.getUint32 ( ) at R0 (index-CGfYebmt.js:85:4683) at X0 (index-CGfYebmt.js:85:7966) at index-CGfYebmt.js:85:8157 at Array.map ( ) at Q0 (index-CGfYebmt.js:85:8150…

Probably I might made mistake somewhere in my parser. Do you have small reproducible database with no sensitive database and add to the https://github.com/invisal/sqlite-internal/issues I will try to fix it

Issue created: https://github.com/invisal/sqlite-internal/issues/3

Re: SQLite File Format Viewer

#43

Post by hinkley » Tue, Apr 15, 2025, 7:50 PM UTC

79a6ed87 wrote: post #29

hinkley wrote: post #18

Earlier quoted context omitted.

I really want a data format that is effectively binary JSON. What is the subset of all of the features of SQLite that makes either a read-only or an updatable data set that is compact. But better searchability than a streaming parser.

Have you tried MessagePack[0]? 0: https://msgpack.org/index.html

I would probably just use bson or gRPC. As o clarified elsewhere, I means JSON as an analogy. I want something that can be scanned and queried cheaply.

Re: SQLite File Format Viewer

#44

Post by hinkley » Tue, Apr 15, 2025, 7:51 PM UTC

w10-1 wrote: post #28

hinkley wrote: post #18

Earlier quoted context omitted.

I really want a data format that is effectively binary JSON. What is the subset of all of the features of SQLite that makes either a read-only or an updatable data set that is compact. But better searchability than a streaming parser.

MongoDB's BSON?

Mongo sits on a throne of lies and I will never condone anyone using it for any purpose except to make a joke.

Re: SQLite File Format Viewer

#45

Post by roelschroeven » Sat, Apr 19, 2025, 5:28 PM UTC

invisal wrote: post #39

roelschroeven wrote: post #37

I tried with a simple database, and it just shows me a blank screen. The console in developer tools shows an exception (both in Firefox and Chromium): index-CGfYebmt.js:85 Uncaught RangeError: Offset is outside the bounds of the DataView at DataView.prototype.getUint32 ( ) at R0 (index-CGfYebmt.js:85:4683) at X0 (index-CGfYebmt.js:85:7966) at index-CGfYebmt.js:85:8157 at Array.map ( ) at Q0 (index-CGfYebmt.js:85:8150…

Probably I might made mistake somewhere in my parser. Do you have small reproducible database with no sensitive database and add to the https://github.com/invisal/sqlite-internal/issues I will try to fix it

Fixed now!