Re: Sqlite 3 adapter

Cool stuff! Glad you were able to get something working. Keep us
updated on your progress. Since the zentus site seems to be releasing
the sqlite driver under BSD, we could include sqlite support out of
the box as activerecord-jdbcsqlite3-adapter, as you've done.

Could you create an incremental zip of all the new files and attach to
JIRA? It will make it easier for us to check it in later.

Cheers,
/Nick

On Wed, Apr 23, 2008 at 12:32 AM, Joseph Athman <jjathman@...> wrote:
> 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
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>

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

   http://xircles.codehaus.org/manage_email