A quick introduction: I was previously a member of Wayne K.'s
Ruby.NET team, and I am now looking forward to making a contribution to
the IronRuby community. I have recently been looking into what is
involved with database API support in IronRuby. Our current thinking is
that it might make sense to implement our database support in pure
(Iron)Ruby, using CLR interop to connect to various databases using
ADO.NET. The email below discusses SQLite3 support using this approach -
the attached zip file contains a quick and dirty prototype.
(I am posting this message again as I have realized that including
System.Data.SQLite.DLL in the zip file was a little bit indulgent 
You can grab it from http://sqlite.phxsoftware.com/)
Regards
Brian Blackwell
Brian Blackwell:
System.Data.SQLite.DLL in the zip file was a little bit indulgent
You can grab it from http://sqlite.phxsoftware.com/)
Thanks for doing this!
One thing to worry about re: DB APIs is the presence of unmanaged code
in ADO.NET. There’s certainly quite a bit of unmanaged code in the SQL
Server driver in ADO.NET, which is what makes it difficult / impossible
to port to run on other platforms like Linux.
Now, assuming that the SQLite driver is pure managed code, I think this
is a great solution (heck even if it isn’t, it means that we can get
some things working with this sooner rather than later).
Thanks,
-John
On Tue, 11 Mar 2008 08:47:17 -0600, John L. (DLR) [email protected]
wrote:
(heck even if it isn’t, it means that we can get some things working with this sooner rather than later).
I’m not sure if there is a SQLite driver in pure manage code, but their
are plenty of wrappers available[1,2] that provide access to SQLite via
.NET on all known platforms. In fact, if not mistaken, Mono ships with
a SQLite driver.
1: ADO.NET 2.0 Provider for SQLite download | SourceForge.net **
2: PHP Development Company - Hire Senior PHP Developers - Astec
Wrapper around ADO.NET
–
/M:D
M. David P.
Co-Founder & Chief Architect, 3rd&Urban, LLC
Email: [email protected] | [email protected] | Mobile: (206) 418-9027
Web: http://amp.fm/ | http://www.oreillynet.com/pub/au/2354/
On Tue, 11 Mar 2008 10:53:55 -0600, M. David P.
[email protected] wrote:
Wrapper around ADO.NET
That should have been prefixed with **.
–
/M:D
M. David P.
Co-Founder & Chief Architect, 3rd&Urban, LLC
Email: [email protected] | [email protected] | Mobile: (206) 418-9027
Web: http://amp.fm/ | http://www.oreillynet.com/pub/au/2354/