Nostr Web Client

Do you know what the motivation for this over just-using-postgres was? I’m confident you can beat postgres if you’re careful and thoughtful, but I’m also reasonably confident rolling your own system like this is at minimum going to be brittle, and probably have at least as many performance pitfalls at the end of the day.

Alex Gleason 2y ago

I wouldn't use Postgres again after how much of a pain it was in Pleroma. The better question is why not just use LMDB if you're going to go through all this trouble. They're equally hard, but at this rate LMDB would be easier.

Reply to this note

Please Login to reply.

Discussion

Ademan 2y ago

I was always under the impression that was more due to pleroma’s schema not postgres itself.

LMDB does look interesting though…