Which Database for portable Application?

Posted on 2011-05-08
Last Modified: 2012-05-11
Hi all,

I am working on an applications which will require database connection and I was wondering...

Which is the best database to use on my delphi project ?

1.  I need to be able to add my whole project to a zip file, take it to another computer and be able to unzip it and run the application without having to download and install external libraries etc.
I don't mind having dll's in my project's folder but that's about it.
2. I need to be able to create tables and modified them easily.
3. There must be delphi component for it.

Question by:error77
    LVL 25

    Accepted Solution

    FireBird is an excellent choice, in your case the embedded version :

    * it is free
    * it only requires a set of dll, and your DB file to operate
    * you can use any component set for InterBase DB (FireBird is an opensource branch of InterBase), like IBxxx component all included in Delphi, or ADO, or ODBC with InterBase connections, or if even specific thrid-party component sets for FireBird (you will gain just a bit of extra performance, and maybe some extended compatibility with advanced functionalities)
    * It will be easy to make your application run with a real DB, multi-user and everything, simply by setting the FireBird server and copy the correct dll along your client application : no change at all in the executable, it will find itself that you want it to run no longer with the embedded version.

    look there :

    the embedded version (x86) is the 4th link. There is also the x64 just a bit bellow.
    You can find other documentation in this official site, or simply ask Google for more
    LVL 25

    Expert Comment

    I forgot to mention :
    there are a few free solutions to help you create and manage your DB :

    * SQL Manager for InterBase & Firebird (Free for the Light version, which is enough to start)

    * FlameRobin : Open Source, Lightweight, simple to use. Not as complete nor pretty than SQLManager, but hey, Free and Unlimitted !

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
    Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now