Re: Sqlite 3 adapter

> This stuff was very helpful.  I spent some time hacking something together,
> and it's passing most of the tests.  From the SQLite documentation renaming
> columns is not supported and I didn't want to spend the time trying to
> figure out a way around it.
>
> I'd appreciate it if someone could download what I put together and try it
> out.  I hope that this is enough of a start to get things going on this
> adapter.  It seems to work pretty well for a toy Rails app, but I haven't
> done extensive testing.  I'm pretty sure there will be problems with decimal
> and date columns.  SQLite doesn't have a native Date/Time fields and I
> wasn't sure exactly how that should get handled.
>
> http://jjathman.railsplayground.net/files/ar-sqlite.zip
>
> Just as an FYI, the JDBC driver I downloaded (and included in the zip file)
> is from http://www.zentus.com/sqlitejdbc/.
>
> Thanks for all the help,
> Joe
>
>
>
> On Mon, Apr 21, 2008 at 11:09 PM, Ryan Bell <ryan.l.bell@...> wrote:
> >
> > H2 and HSQL have very similar SQL dialects (I think they were both started
> by the same dev). I think they used to share a hibernate dialect, too.
> >
> >
> >
> >
> > Joseph Athman wrote:
> > I started playing around with this some.  I found what seems like a
> reasonable JDBC Driver at http://www.zentus.com/sqlitejdbc/
> >
> >
> > I do have some basic questions though.  Why does the H2 adapter not have a
> jdbc_adapter file like jdbc_h2.rb?  It seems like it uses the jdbc_hsqldb.rb
> file.    Are the H2 and HSBLDB adapters bad examples to look at?  I'm just
> trying to figure out what I need to do to get it working.  It seems like I
> have migrations at least partially working and I can perform selects, but it
> looks like creates are failing.
> >
> >
> > Anyways, thanks for any help.
> >
> >
> > Joe
> >
> >
> > On Sun, Apr 20, 2008 at 11:05 AM, Joseph Athman <jjathman@...>
> wrote:
> >
> > > 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
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>