Single-user lightweight database options


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Single-user lightweight database options

Hybrid View

  1. #1
    Tim Romano Guest

    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

  2. #2
    MarkN Guest

    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



  3. #3
    Rob Abbe Guest

    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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center