The spatialite extensions for SQLlite include a *read-only* virtual table adapator (VirtualText) for CSV files.
http://www.gaia-gis.it/spatialite-2.2/spatialite-2.2_manual.html#t7 If the data-volumes are reasonably small, and the csv clients are read- only and the frequency of updates to the database are fairly small then I would be inclined to port the table to a vanilla sqlite database and have some mechanism to dump out a CSV representation. pjjH On Jul 9, 12:51 pm, "Michael Bayer" <[email protected]> wrote: > SQLAlchemy is a SQL generation tool. a SQL engine for csv files (I > believe MS Access can do this against excel files) would be required, as > well as a DBAPI. > > pierre imbaud wrote: > > > google wont let me answer to Lukasz Szybalski, I guess the message > > was too old, so I have to quote it by hand. > > > I am New to sqlAlchemy, I have another good reason to ask for a csv > > engine: > > I wish to adapt an existing system, built around a csv file (to be > > modelled as a single table), by a pylons application. Some existing > > pieces of code use the csv file; If I use a db engine, I have 2 de > > facto repositories, I have to keep in sync: wether automatically, or > > thru a "sync screen" with 3 functions (file >> db, db >> file, diff): > > would be much easier with a csv engine! No progress on this? > > > original message: > > Hello, I was wondering if there are any plans to have a csv engine for > > sqlalchemy. I would like to see support for csv. There are some cases > > where csv is the best way to convert data to and from especially when > > they require cleaning. What I would like to see is a sqlalchemy > > wrapping over csv module and providing file definition and some of the > > sql functionality into csv world. This would be really helpful when > > moving things over from one system to another. Ideas? Thanks, Lucas -- > > OpenOffice and Pythonhttp://lucasmanual.com/mywiki/OpenOffice > > Commercial Grade Backup with Baculahttp://lucasmanual.com/mywiki/Bacula > > More options Sep 3 2008, 10:25 pm > > From: "Lukasz Szybalski" <[email protected]> > > Date: Wed, 3 Sep 2008 15:25:36 -0500 > > Local: Wed, Sep 3 2008 10:25 pm --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
