It didn't like me calling people retards and whores, but someone's gotta do it

"@npub16h43mvfanfmsvkg86vgqwr4h268l23t6034wulepd0m4j3dky9ssraxymy is a racist homophobe transphobe and nobody should talk to him because he is a meany head who says mean things and calls whores on the internet what they are"

Thanks. I may reconsider and start off with Postgres. I want to make a command line tool that anyone can download/run to get metadata and statistics about relays and interactions, hence wanting Sqlite for ease of use. It should give info that's more in-depth than a normal client would show, but not a monstrous Hadoop thing. I want it to be able to answer questions like, "Is such-and-such relay dropping my events specifically, or is it broken?" or "Which relays are filtering such-and-such words?" But I also want it to be able to reconstruct conversations, social graphs, and trends eventually to prove that Nostr is one big circlejerk or to find the pockets of people who don't just talk about zaps.

Sounds like Postgres is probably the way to go. It supports arrays semi-natively, too, which may help solve the nip01 tags problem a little more easily.

There's always IPVS

Super weird, we should all be inside cooooding all day instead

Schizopost, you say?

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.

If they're so benign, why wouldn't the US just run these totally-safe biolabs in...The US?

I did say largely. Every president is subject to his intel agency overlords, and when one of them gets a little bit out of line with the agenda, well...Just take a look at JFK.

In the end, they're all basically just puppets and distractions.

https://www.youtube.com/watch?v=ydSf57SRtcQ

Bioweapons labs in Ukraine, for starters

"Totally not for weapons, but it would be very bad if Russia got them"

I can only assume #[3] is referring to Trump's Operation Warp Speed, in which he unleashed a dangerous "vaccine" on the public and then bragged about it, even as children, teenagers, athletes, and other healthy people got myocarditis from it...Because aside from that, the Trump era was largely free of retarded overseas wars.

Anyone have a good example of SQL schema for Nostr events? I'm debating how to lay out the tables.

Might this also pave the way for using hardware-based keys like Yubikey?

Yeah, Gossip somehow manages to be even worse than Iris, it's pretty impressive how bad it is. Like a Java executable from the 90s.

whore detected

I've heard stories about that sort of thing, and apparently it doesn't work out too well

I heard Zimbabwe wants its white farmers back

Well dat's cauze de white man opres dem

It's gotten so bad. I drive in my car with the windows up and still smell it from the car in front of me. Pull forward in a different lane, glance over, and yep...Future scientist/engineer/astronaut, every single time.