« Return to Thread: Sqlite 3 adapter

Re: Sqlite 3 adapter

by Larry Myers-3 :: Rate this Message:

Reply to Author | View in Thread

I'd highly recommend using H2 in place of sqlite3, it's already  
supported by activerecord-jdbc, so it should be a drop-in replacement.  
It's probably about the closest java equivalent you'll find. It  
supports in-memory databases, which great for running your tests.

I know there has been some work done on using JNI to interface with  
the sqlite C library, but I'm not sure how complete that is.

-- Larry

On Apr 20, 2008, at 1:17 AM, Nick Sieger wrote:

> On Sat, Apr 19, 2008 at 11:34 PM, Joseph Athman <jjathman@...>  
> wrote:
>> Is there a reason why there isn't a sqlite activerecord-jdbc gem?  
>> I would
>> have thought since sqlite is the default Rails DB now that there  
>> would be
>> one.  Just curious if this is something that's being worked on.  
>> Thanks.
>
> Yeah, it seems like it, but sqlite is just not nearly as commonly used
> in the Java world. There are JDBC adapters out there, but I haven't
> tried them and don't know how well they work. We'd love to have
> support for it, as it would make the JRuby story more complete and
> help address questions like yours. I haven't heard of anyone working
> on it, so it seems like fair game for someone that has an itch to
> scratch.
>
> Cheers,
> /Nick
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>    http://xircles.codehaus.org/manage_email
>
>


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email


 « Return to Thread: Sqlite 3 adapter