# Prototype SQLite3 support for IronRuby **URL:** \ **Category:** IronRuby\ **Created:** [March 11, 2008, 12:50am UTC](https://www.ruby-forum.com/t/prototype-sqlite3-support-for-ironruby/131529 "2008-03-11T00:50:58Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Brian\_Blackwell](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/c4cdca/32.png) [@Brian\_Blackwell](https://www.ruby-forum.com/u/Brian_Blackwell)\ **Post date:** [March 11, 2008, 12:50am UTC](https://www.ruby-forum.com/t/prototype-sqlite3-support-for-ironruby/131529/1 "2008-03-11T00:50:58Z")
A quick introduction: I was previously a member of Wayne K.'s [Ruby.NET](http://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](http://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/](http://sqlite.phxsoftware.com/)) Regards Brian Blackwell ---
**Author:** ![Brian\_Blackwell](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/c4cdca/32.png) [@Brian\_Blackwell](https://www.ruby-forum.com/u/Brian_Blackwell)\ **Post date:** [March 11, 2008, 3:57pm UTC](https://www.ruby-forum.com/t/prototype-sqlite3-support-for-ironruby/131529/2 "2008-03-11T15:57:46Z")
Brian Blackwell: > System.Data.SQLite.DLL in the zip file was a little bit indulgent 🙂 > You can grab it from [http://sqlite.phxsoftware.com/](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](http://ADO.NET). There’s certainly quite a bit of unmanaged code in the SQL Server driver in [ADO.NET](http://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 ---
**Author:** ![Brian\_Blackwell](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/c4cdca/32.png) [@Brian\_Blackwell](https://www.ruby-forum.com/u/Brian_Blackwell)\ **Post date:** [March 11, 2008, 5:56pm UTC](https://www.ruby-forum.com/t/prototype-sqlite3-support-for-ironruby/131529/3 "2008-03-11T17:56:41Z")
On Tue, 11 Mar 2008 08:47:17 -0600, John L. (DLR) [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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](http://sourceforge.net/projects/sqlite-dotnet2) \*\* 2: [PHP Development Company - Hire Senior PHP Developers - Astec](http://www.phpguru.org/downloads/csharp/SQLite.NET/) Wrapper around [ADO.NET](http://ADO.NET) – /M:D M. David P. Co-Founder & Chief Architect, 3rd&Urban, LLC Email: removed\_email\_address@domain.invalid | removed\_email\_address@domain.invalid | Mobile: (206) 418-9027 Web: [http://amp.fm/](http://amp.fm/) | [http://www.oreillynet.com/pub/au/2354/](http://www.oreillynet.com/pub/au/2354/) ---
**Author:** ![Brian\_Blackwell](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/c4cdca/32.png) [@Brian\_Blackwell](https://www.ruby-forum.com/u/Brian_Blackwell)\ **Post date:** [March 11, 2008, 5:58pm UTC](https://www.ruby-forum.com/t/prototype-sqlite3-support-for-ironruby/131529/4 "2008-03-11T17:58:26Z")
On Tue, 11 Mar 2008 10:53:55 -0600, M. David P. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Wrapper around [ADO.NET](http://ADO.NET) That should have been prefixed with \*\*. – /M:D M. David P. Co-Founder & Chief Architect, 3rd&Urban, LLC Email: removed\_email\_address@domain.invalid | removed\_email\_address@domain.invalid | Mobile: (206) 418-9027 Web: [http://amp.fm/](http://amp.fm/) | [http://www.oreillynet.com/pub/au/2354/](http://www.oreillynet.com/pub/au/2354/)