-
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
-
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
-
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, DevX 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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|