[IronPython] sqlalchemy + sqlite on ironpython

[Jeff Hardy]

Hi Harry,
Two other options that I know of:

1) IronPython.Sqlite (http://bitbucket.org/jdhardy/ironpython.sqlite):
This is a pure managed implementation with no external dependencies
but it's not complete.

2) A wrapper around System.Data.Sqlite:
http://bitbucket.org/jdhardy/adonet-dbapi. A slightly older version of
this is in the FePy trunk. This is only a partial implementation as
well.

I think #1 is the better long-term option because System.Data.Sqlite
(#2) isn't capable of supporting all of Python's sqlite3 module and is
thus a bit of a dead end. I don't know which of the two is actually
more capable currently, though.

- Jeff

On Sun, Apr 18, 2010 at 10:39 AM, Harry Percival
<harry.percival at gmail.com> wrote:
> Hey all,
>
> trying to get SQLAlchemy + SQLite working on IronPython.  Any tips?
>
> I think SQLAlchemy is installing OK, but slqite seems to be the real
> stumbling block. Here's what I've tried so far:
>
> 1/ use cpython sqlite via Ironclad: doesn't work (
> http://code.google.com/p/ironclad/issues/detail?id=19 )
> 2/ fepy version of sqlite: unable to import dbapi2 from sqlite
> 3/ using dist-tools to install pysqlite2 on ipy - falls over with
> 'need visual studio 6.0 compiler' error
> 4/ manually copying 'stuff' from c:\Python26\Lib to IronPython lib
> folder - not working (as you can tell from the use of the word
> 'stuff', i clearly don't really know what i'm doing here)
>
> suggestions gratefully appreciated!
>
> rgds,
> Harry
> _______________________________________________
> Users mailing list
> Users at lists.ironpython.com
> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>