Database in Delphi

Posted on 2004-11-03
Last Modified: 2010-04-05
Hi friends, If I want to write a program with a database that works Desktop (not Client/server) and need a simple database, wich database do you sugguest me? (MS Access/ Paradox/ DB2)
Question by:Ehsun
    LVL 27

    Accepted Solution

    my recommendations:

    access (is up to date)
    paradox (comes with delphi, but is outdated)
    firebird(interbase) (local server) (real sql server)

    there are also some properitary thirdparty databases

    meikl ;-)
    LVL 5

    Expert Comment


    If you want simple and cheap try Easy Table from this is a cool product.

    If you want something really excellent then I recommend DBISAM from

    Access is a great database but difficult to deploy (people are going to jump all over me for saying this - but with 10 years of commercial experience with VB and Access - I speak from experience).

    Paradox is a clunker and difficult to deploy.

    Firebird is a complex product and difficult to deploy.

    DBISAM is my choice although it is not cheap it is well worth the money - a simply superb product which is an absolutle joy to use.

    Just my own opinions - good luck

    LVL 17

    Expert Comment

    by:Wim ten Brink
    Not an easy one but FlashFiler is open-source, free and fully implemented in Delphi. See
    However, FlashFiler isn't easy to use. But it's biggest advantage is that you can keep everything contained in one single executable without any dependencies of any database drivers or whatever more. (It also works great for network solutions but that's not one of your problems.)

    When deciding which database to use, you have to consider how you're going to access the database. The BDE is an ancient dinosaur, which was great in it's time but now we're waiting for it to turn into oil. So if you won't be using the BDE, Paradox and DBase will be no option anymore.
    You could use ADO, which allows you to connect to SQL Server (expensive) or Access. While Voodooman complains about the difficulty of deploying applications that use ADO, I think it's just more a matter of personal experience. All you need to make sure is that MDAC is installed on the clients system with proper ADO support and then all you need is install the database and application and make sure you're using the correct connection string to connect to the database. I've used Access for my own website for all kinds of things and this webserver won't allow me to run installation programs. Yet deploying my Access webapplications to it is just a piece of cake, since it does support ADO.
    The third option is just using native database components and if you choose for this, there will be a large amount of options available for you. Interbase and it's free version Firebird would be a good choice in that case, although MySQL is a good option too.

    In the past, Paradox was my favorite choice but the BDE is giving me too much pains lately. ADO with Access makes development for my website a lot easier. And for local applications I either use FlashFiler or Interbase. FlashFiler for simple projects and Interbase for projects that require a large amount of data to be stored.

    However, in some situations I haven't even bothered by using a database but just stored data in an XML file. A single XML file could have many layers inside and if you're experienced enough, you could use transformations to extract specific data and schema's to just validate the contents. It's not useful for half a million of records but if the amount of records of all tables is less than 5000 or so records then XML is a good alternative. Even funnier, I've used XML combined with transformations so I can open the XML file in a webbrowser and the webbrowser will show me a nice overview in tables, with summaries, clear headers and whatever more.
    LVL 4

    Expert Comment

    Firebird embedded, difficult to deploy? The embedded server is very simple
    to deploy on a desktop app. Of course, it's like killing flies with a atomic bomb.

    LVL 5

    Expert Comment


    When you kill the flies with the A-bomb can I watch?

    Some people have such exciting jobs....

    LVL 4

    Expert Comment


    Firebird embedded is quite easy to deploy to a stand-alone,
    desktop user. If the needs are very simple, it's really overkill but
    you gain later: if the company central db is firebird, going
    from desktop app to C/S will be much simpler... Just a case
    of changing connection strings.

    I prefer kill them with Rodasol(spray)... ;-)
    But I'll call if I use the A-Bomb ;-)
    LVL 4

    Expert Comment

    Since most people gave him answers that
    respond to his necessity.... There is a lot
    of correct answers. What is THE answer, well,
    I don't know.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    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…
    Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    759 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

    14 Experts available now in Live!

    Get 1:1 Help Now