Jump to content

Querying an SQLite Database With Python

I recently posted asking about how to use python to interact with SQLite effectively and figured it out with help from the community so I thought I would ask this new question. I have transferred data into an SQLite database, but I need to query that same database with the same program in order to compare new data to the data already in place. This needs to be run repeatedly to check for changes. The problems are that I have one table with that I need to extract data from in chunks of varying size, and compare it with the same chunk from the new data. Another problem is that the rows of each chunk may not have matching data, but overall, in one cell or another, every piece should be there. I simply cant think of a way to check for something like that, not to mention I'm not really sure of the most effective way to query that data from the database to begin with. Any help is appreciated

Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×