0

I'm querying an existing read-only database with SQLAlchemy, and wonder if there is a way to cache the queried table object locally (in an automatic way) so that I can use it later. The main reason of this need is not to lock the database while my script is running (e.g. I have to keep a session connected to wait for user's response), and the database is read-only so I really don't need the modified data to be synchronized back.

Right now I'm working through a solution to convert the queried results into pd.DataFrame, but it would be nice to keep the advantage of SQLAlchemy where the queried result can retain it's structure rather than being converted to a flat table in pd.DataFrame.

I'm new to SQLAlchemy and still learning. Any suggestions about the solution or if I miss some major features already provided in SQLAlchemy package would really be appreciated!

Improve this question
2
  • Do you mean the results of a query or the actual table to query against? Commented Apr 19, 2022 at 17:08
  • @IanWilson I meant to say 'the results of query', and I have been using eager loading so I assume all the information including the children are queried once and loaded into the query result object. Commented Apr 19, 2022 at 18:03
Related questions
40
Does SQLAlchemy support caching?
1
SQLAlchemy Caching Objects Beyond Transaction
4
sqlalchemy caching some queries
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.