« Return to Thread: Sqlite 3 adapter

Re: Sqlite 3 adapter

by Joseph Athman :: Rate this Message:

I'm sure other DB's like H2 will work fine for everyone, but I'm sure there are a lot of people who are new to the JRuby community that will create a fresh rails app, try to run it, and have it not work because there isn't sqlite adapter. I think supporting all the defaults of Rails should be something the community aims for. I've looked at the activerecord-jdbc site, but I haven't found anything like "if you want to add support for a new DB, here's where to start".

Is there any documentation out there explaining the architecture behind ar-jdbc?

Joe

On Sun, Apr 20, 2008 at 9:01 AM, Larry Myers <larry@...> wrote:

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