Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Single-user lightweight database options

I haven't had much call to work with Java, and therefore haven't kept up
with the very small footprint lightweight single-user database options. I
have an app written in .NET which uses OleDB against the JET4.0 provider,
which is giving very good response times, sub-second against a table of >
4 million rows. But someone has asked me for a Java port that would run
on the Macintosh and I don't know what to say at this point. One of the
strengths of the Oledb/JET combination is the support for SQL, which
spared me a considerable amount of coding. Are there any lightweight,
very easy-to-deploy databases available for Java that have true SQL
support? By "lightweight" I mean a deployment package of a few hundred
kilobytes and no need to start a background database service on the
end-user's machine. SQL support is a must.
Thanks
Tim Romano
[922 byte] By [Tim Romano] at [2007-11-9 22:30:41]
# 1 Re: Single-user lightweight database options
Try http://www.pointbase.com/home.shtml. When you get it to work - cool thing
is when you do it for Mac you'll have one for Linux and Unix and ... without
a 'port'.

Tim Romano <timUNDERSCOREromano@yahoo.com> wrote:
>I haven't had much call to work with Java, and therefore haven't kept up

>with the very small footprint lightweight single-user database options.
I
>have an app written in .NET which uses OleDB against the JET4.0 provider,

>which is giving very good response times, sub-second against a table of
>
>4 million rows. But someone has asked me for a Java port that would run

>on the Macintosh and I don't know what to say at this point. One of the

>strengths of the Oledb/JET combination is the support for SQL, which
>spared me a considerable amount of coding. Are there any lightweight,
>very easy-to-deploy databases available for Java that have true SQL
>support? By "lightweight" I mean a deployment package of a few hundred

>kilobytes and no need to start a background database service on the
>end-user's machine. SQL support is a must.
>Thanks
>Tim Romano
MarkN at 2007-11-11 23:01:01 >
# 2 Re: Single-user lightweight database options
Tim,

You have a number of options available to you.

pointbase as was mentioned. I think sybase has an offering as well. Also
checkout the following:

http://www-3.ibm.com/software/data/cloudscape
http://hsqldb.sourceforge.net/

JDBC is very powerful and easy to use. You'll have no problem picking it
up.

Also, dev-archive is not the best site for Java assistance from what I can tell.
You should check out the forums on www.javasoft.com for more support.

Also, these sites provide good info as well.
www.javaworld.com
www.theserverside.com
www.jguru.com
www.onjava.com

Rob Abbe

Tim Romano <timUNDERSCOREromano@yahoo.com> wrote:
>I haven't had much call to work with Java, and therefore haven't kept up

>with the very small footprint lightweight single-user database options.
I
>have an app written in .NET which uses OleDB against the JET4.0 provider,

>which is giving very good response times, sub-second against a table of
>
>4 million rows. But someone has asked me for a Java port that would run

>on the Macintosh and I don't know what to say at this point. One of the

>strengths of the Oledb/JET combination is the support for SQL, which
>spared me a considerable amount of coding. Are there any lightweight,
>very easy-to-deploy databases available for Java that have true SQL
>support? By "lightweight" I mean a deployment package of a few hundred

>kilobytes and no need to start a background database service on the
>end-user's machine. SQL support is a must.
>Thanks
>Tim Romano
Rob Abbe at 2007-11-11 23:02:01 >