Self contained Delphi/MySQL Application

Posted on 2006-05-04
Last Modified: 2010-04-05
How does one go about creating a standalone Delphi application on top of a MySQL database?

i.e., I want to create and access the MySQL database purely from the application itself (no MySQL install, no BDE, etc.) if that is possible.

I recently started using nessusWX (a windows front-end for nessus) and it appears to be doing this (via libmysql.dll?).

Question by:timboc
    LVL 18

    Expert Comment

    It sounds from your question that you would like to have a MySQL database sitting somewhere without MySQL running. If that is the case, that is impossible as MySQL in itself is a daabase system or engine, like Firebird, MS SQL, Oracle and etc. has to be running and installed somewhere.

    Now, you can have a client that accesses a MySQL database server, whether it is installed and running locally or on a networked server. This can be accomplished within Delphi as there are quite a few components, both free and commercial, that use the libmysql.dll. There are also those that have direct access (DAC) without using a dll.

    One component to look at and experiement with, which will allow you to access most any kind of database inclusing MySQL, is ZEOS

    Their forum is at:

    and it can be downloaded from:

    It is free and opensource.

    Hope I helped.

    Author Comment

    What I was hoping for what is a server free no install SQL database that I can access (easily) from Delphi.  I don't need multi-user access, it would be single user only.

    I don't want the overhead of BDE, ODBC Drivers, etc.  I want it all to be compiled into my .exe or externally accessed through .dll's.

    Any ideas?

    LVL 18

    Expert Comment

    It simply cannot happen using MySQL... impossible is a better word.

    What you could do is use like a dBase database structure (clone) and use tDBF available from SourceForge. It compiles directly into your application. The database "engine" is there but it is not the best for multi-user access.

    The latest versions are really stable but have commercial use restrictions. The last freeware and unrestricted license version is stable but has some flaws (bugs) and that was version 6.3.8

    Author Comment

    Does it support SQL?
    LVL 18

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
    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…
    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…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    760 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

    7 Experts available now in Live!

    Get 1:1 Help Now