@danieltanfh95 Postgres is currently being used just to store blobs of our own index data structure (the hitchhiker tree). We have some ideas of how to integrate SQL into Datalog though. What are your specific needs?
no, i was just exploring, and was surprised that pgsql is a supported backend
Do I understand correctly that datahike loads the whole db into memory?
So it’s not possible to have only part of the db in memory and thus the limitation is that db must fit in memory?
kind of like a durable datascript
or does it pull in segments as necessitated by queries?
@geodrome It does not load the full database into memory, it only caches the most used parts of the immutable data structures. We have support both for DataScript's fast in-memory indices and Redis though, if you have enough memory to hold everything in memory.
ahh ok, thanks!
README says redis is slated for 0.4.0
but i guess this is ready? https://github.com/replikativ/datahike-redis