logoalt Hacker News

bob1029 • today at 10:33 AM • 1 reply • view on HN

> JSON blobs

An alternative to faster blob storage is to represent the blob's schema in SQL directly.

If most blob updates are incremental you can eliminate a significant amount of storage IO and garbage collection this way.

One SQLite database per blob type with a metadata SQLite db that tracks each. We could leverage powerful AI reasoning models to produce SQLite schemas and virtual table adapters for each encountered JSON schema type.


Replies

testtestmetest • today at 11:33 AM

You want an LLM to be modifying your db schemas on the fly?? Seems slow and error prone.