agora-server icon indicating copy to clipboard operation
agora-server copied to clipboard

Use sqlite as a cache

Open codegod100 opened this issue 1 year ago • 2 comments

Add sqlalchemy ORM

Also made it so that you can point this to a folder and it will load any new files into database since last git pull automatically on page load so we don't need an external database creator. This makes it act more like an in-memory cache.

codegod100 avatar Nov 02 '23 19:11 codegod100

This looks great and it's the approach I wanted to follow, thank you!

I'll run this in a branch for a bit while I grok it and finish work on a separate branch for async node loading; the two probably benefit speed and although your approach is more interesting / more like a real fix we might need both and async loading probably makes sense anyway.

flancian avatar Nov 19 '23 00:11 flancian

Yeah that's why I added api.py in the other PR so we could pick and choose methods based on whatever logic seems right

codegod100 avatar Nov 19 '23 00:11 codegod100