Dragonfly db

[Moxypixy]

Hey there guys. Was discussing databases with krcbot this evening because I think nosql might be an interesting idea for Kaspa dapps. He said he is using https://www.dragonflydb.io for his indexer. Perhaps interesting for ksocial?

[thesheepcat]

Always useful to receive suggestions.
What are the advantages of running K-indexer on a "Dragonfly" database, compared to Postgres?

[Moxypixy]

NoSQL databases like DragonflyDB are optimized for:
Extremely fast inserts and updates
Append-heavy workloads
In-memory or hybrid memory/disk operation

So might give a speed boost :)

[thesheepcat]

You didn't provide a comparison.

Consider that, for the moment, we don't have any speed issue, considering the optimizations at Postgres level and the current average query response time.

[Moxypixy]

Will set one up :)