On Nov 3, 2005, at 6:39 PM, Paul McNett wrote:
What if our db wrapper threw the results into an embedded in-memory sqlite database, from which you can run these local queries?
I thought about that, but there are several downsides. First, now SQLite will have to be yet another installation requirement to use Dabo. Not a showstopper, but not ideal. Second, and much more important, is the problem of preserving type. The dbapi interface modules handle the conversion of backend types into Python and back, but if you start throwing SQLite into the mix, where everything is a string, and then have to manage the conversion of every value back to the original type... it just seems like that would be a ton of work. That would also require testing and changes every time a new database is added to the Dabo family, since each db has its own data type issues. Third, we'd now have to start doing something like Fox does with temp cursors: create their filesystem counterparts in the user's temp directory, and manage cleaning them up when the cursor is closed.
-- Ed Leafe -- http://leafe.com -- http://dabodev.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
