Remix.run Logo
▲ bob1029 an hour ago

> 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.

▲testtestmetest 7 minutes ago | parent [-]

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