Clojurians Log v2
Clojure programming
Channels
Apps
pathom
:pathom: https://github.com/wilkerlucio/pathom/ & https://pathom3.wsscode.com & https://roamresearch.com/#/app/wsscode
daniel.spaniel 2020-07-16T17:47:05.302200Z
anyone know any tricks for doing pagination with datomic with pathom ( would like to do filtering and sorting too ) if i have to do in memory i can .. but its painful
daniel.spaniel 2020-07-17T15:33:13.306800Z
thanks wilker .. will ponder some more then ..
2020-07-17T23:24:54.307200Z
If you're running your code on Datomic Cloud Ions or a Peer server doing the sort/pagination in memory is pretty close to order by/limit in SQL- it's happening in the database process. Consider using range queries, where possible. There's also a new index-pull API you should check out: https://docs.datomic.com/cloud/query/query-index-pull.html
daniel.spaniel 2020-07-24T00:21:18.346700Z
thanks @solussd good tips
wilkerlucio 2020-07-16T19:57:46.306600Z
the problem here is how to paginate datomic, they dont have a good solution, I spent a good time trying to get that to be efficient, but no good, the best I could do was paginate by date ranges, this way you can constrain space and make it usable (but has the trade-offs from date pagination, for example, the number of items for different date ranges may change dramatically)