I think if you will closely read you own analysis of your efforts you will realize that all of the "down side" issues you have enumerated relate directly to the implementation language and not the database or its structure. In Java there is no such thing as AnythingLite, IMHO. Java, like so many other languages has grown well beyond its initial intent, small, simple applets imbedded on a web page.
With all of our advances in programming we still have not evolved that "perfect" language, and most likely never will. I spite of what those "C" guys tell you :-) Fred > -----Original Message----- > From: Steve O'Hara [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 21, 2006 7:37 AM > To: sqlite-users@sqlite.org; [EMAIL PROTECTED] > Subject: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java > > > > I did loads of research on this and even tinkered with a c to Java > converter, which got me a little bit further forward. However, I > realised that I would be facing a huge effort to create the code base > and then have to support it within our projects. So despite being an > SQLite zealot, I had to reluctantly nail my colours to one of the > existing Java tools. > > I chose HSQLDB, after trying out most of the others, this was the only > one that got close to the file distribution format of SQLite i.e. > database in a file. It took quite a bit of tinkering to get the right > mix of CACHED and MEMORY tables so that performance on start-up was > good. Also, I had terrible trouble with mass imports causing memory > (what a surprise - Java) problems and it took a good few runs > to get it > to properly index etc. Also, I had to be much more specific about the > column definitions than with SQLite, otherwise my database files grew > horribly. Also, you can only interact with HSQLDB via JDBC, not a big > problem in Java obviously. Performance was nowhere near as good as > SQLite. > > However, the upside is that HSQLDB is free, simple to deploy, has > standalone/server/servlet/in-memory deployment versions and is > reasonably perfomant. > > Hope this helps, > > Steve > > p.s. I'd still prefer a Java SQLite but there you are........ > > > > -----Original Message----- > From: > [EMAIL PROTECTED] > [mailto:sqlite-users-return-9982-sohara=pivotal-solutions.co.u [EMAIL PROTECTED] rg] On Behalf Of Ran Sent: 19 January 2006 14:13 To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: [RBL] Re: [sqlite] Sqlite and Java If I am not mistaken, the following thread might be relevant: http://www.mail-archive.com/sqlite-users@sqlite.org/msg11005.html Ran On 1/19/06, Nilo Paim <[EMAIL PROTECTED]> wrote: > > Hi all, > > Does anybody here knows something about a port of sqlite to java? > > Please, note that I'm not talking about java calling sqlite via JNI, but > about a real rewrite of sqlite using java. Obviously, a second step > would be the writing of a JDBC driver. > > Would be useful that port? > > Comments? Suggestions? > > Thanks to all. > > Nilo > Porto Alegre - Brasil >
