Searching for a database to replace Access

From: Harri Pesonen (fuerte_at_sci.fi)
Date: 03/25/04

  • Next message: Christophe Vanfleteren: "Re: Searching for a database to replace Access" 
    Date: Thu, 25 Mar 2004 04:30:30 +0200

    Hello, I am searching for a database as many other people are as well in
    this newsgroup it seems. I have a free open source project that is
    programmed in Visual Basic 6 and it uses MS Access .mdb database via
    ADO. It seems that now it's time to switch to some other programming
    language (java) and database system, partly because I want to make it
    multi-platform (win32+Linux).

    My requirements are:
    * Must have good SQL support (sub-queries etc)
    * Must be robust
    * Must be free, preferably open-source
    * Preferably embeddable
    * Database engine development should continue

    I have looked at the following products:
    * PostgreSQL
            http://advocacy.postgresql.org/advantages/
            + best feature set?
            - does not have native Win32 version yet, not embeddable
    * HSQLDB
            http://hsqldb.sourceforge.net/web/hsqlFeatures.html
            + free, open source, pure java
            - not really a robust database system, instead
              saves actual SQL statements into files
    * MySQL
            http://www.mysql.com/products/mysql/index.html
            ? need more information, problems with license?
    * Firebird
            http://www.firebirdsql.org/index.php?op=guide&id=ib6_overview
            + free, open source, embeddable?

    I am an experienced database developer and I will probably end up
    developing the actual database engine.

    Any advice is most welcome!

    Harri

  • Next message: Christophe Vanfleteren: "Re: Searching for a database to replace Access"

    Relevant Pages

    • Gluon 1.15 is out
      ... Gluon 1.15 is out. ... This is a free open source framework for agile ... Python, programmable in Python. ... 
it creates the database, ...
      (comp.lang.python)
    • Re: Theres got to be a better way
      ... I work with annoyingly complex database tables whose structure ... Programming is all about reinventing the wheel. ... But we're still writing code must like we did 40 years ago. ...
      (comp.lang.php)
    • Re: Theres got to be a better way
      ... I work with annoyingly complex database tables whose structure ... changes as my client changes their requirements, ... Instead of repeatedly writing code to format output from the DB, ... Programming is all about reinventing the wheel. ...
      (comp.lang.php)
    • Re: Theres got to be a better way
      ... I work with annoyingly complex database tables whose structure ... changes as my client changes their requirements, ... Instead of repeatedly writing code to format output from the DB, ... ALways with programming it's bread and butter, ...
      (comp.lang.php)
    • Re: What is .net
      ... software) for installing and running ASP.NET desktop applications and Web ... You just want to learn, and have no experience programming (nothing ... relational database design in general and SQL Server in particular. ... don't ignore the topic of "relational database design" - ...
      (microsoft.public.dotnet.faqs)