@raphael@mastodon.communick.com
Post #1067946
2026-03-17 19:16 UTC
using #pouchdb created one database to store AP objects, expanding the JSON-LD. Added 2 indices (type and published) After ~2000 documents, it takes 30+ seconds for it to complete indexing. Add more indices and it takes even longer.
Then you learn that the best practice is to create "documents" that are nothing but an encoded set of ordered attributes, so that you can "filter" by selecting start and end keys. Ok, clever hack, but then every possible query needs its own "index".
Replies (1)
-
@raphael@mastodon.communick.com 2026-03-17 19:19
So, if you are working and your app has already a few thousand documents, every time you need to make a script that "builds" those keys. It's like having to run a migration script every time you need a new query.