victor on Nostr: I was hoping to use Sqlite3 and avoid JSON in the database itself. I don't plan to ...
I was hoping to use Sqlite3 and avoid JSON in the database itself. I don't plan to have messages be easily reconstructable, since this is mostly for storing and analyzing things, but I guess I could store raw messages as blobs for future use/relaying.
The big problem I'm having is how to deal with tags in nip01 events. I want them in separate tables for easier indexing/lookup but think join tables (e.g. for the many-to-many relationship between public keys and events) might be making the solution too complex.
I'm sure plenty of people have already whiteboarded this and am wondering what the general consensus is so far.
The big problem I'm having is how to deal with tags in nip01 events. I want them in separate tables for easier indexing/lookup but think join tables (e.g. for the many-to-many relationship between public keys and events) might be making the solution too complex.
I'm sure plenty of people have already whiteboarded this and am wondering what the general consensus is so far.