[Ironpython-users] DataSet --> SQLite

Jeff Hardy jdhardy at gmail.com
Fri Mar 16 16:49:08 CET 2012

On Wed, Mar 14, 2012 at 3:34 PM, Vernon Cole <vernondcole at gmail.com> wrote:
> I would suggest opening both databases in their native form, then do the
> comparison using Python code rather than a complex SQL query. It may take a
> while to run, but should work okay. SQLite select statements are quite fast.
> Trying to do the whole thing in one swallow may be too much. Better to do
> lots of querys sequentially and build your result set as you go.

I agree with Vernon, but of course it depends on the operations you need to do.

You'll need to provide a little more information about why
System.Data.SQLite isn't working for you. You could also try 2.7.2's
sqlite3 support, which is more Pythonic.

- Jeff

More information about the Ironpython-users mailing list