Thank you!! I completely reworked the database. Now it's optimized for Postgres and uses a jsonb column for tags, making it much faster.
https://ditto.pub is pretty snappy now. Even when you click on the trending hashtags. Nice work nostr:npub1q3sle0kvfsehgsuexttt3ugjd8xdklxfwwkh559wxckmzddywnws6cd26p 🚀
Discussion
I think Ditto is now the snappiest nostr web client
Let try it
If you use a nip-07 extension to log in, there will be a lot of pop ups until you select always allow for a bunch of the event types. After that everything is smooth.
I opened a PR to Alby: https://github.com/getAlby/lightning-browser-extension/pull/3226