3 ms·
I often connect to production databases in read only users to do various data analysis. Is this something you can do with SQLite (besides maybe SSHing into the
by Kaze404 6y ago
I often connect to production databases in read only users to do various data analysis. Is this something you can do with SQLite (besides maybe SSHing into the machine)? If not, how do you get around it (if it ever even comes up)?
- bob1029 6y agoWe have a few paths for this type of thing. One is to simply zip up the entire database and send it across the wire. This is most applicable for local development and QA testing scenarios. Another is to have something in the business application and relevant tooling that allows for programmatic querying of the data we need to look into. We also have some techniques where we do ETL of the data range we care about from 1 SQLite db to another, then pull down the consolidated db for analysis.