[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

Self contained Delphi/MySQL Application

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?).

-Tim
0
timboc
Asked:
timboc
  • 3
  • 2
1 Solution
 
JohnjcesCommented:
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:
http://zeosforum.net.ms/

and it can be downloaded from:
http://sourceforge.net/projects/zeoslib/

It is free and opensource.

Hope I helped.
0
 
timbocAuthor Commented:
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?

-Tim
0
 
JohnjcesCommented:
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

http://sourceforge.net/projects/tdbf

http://tdbf.sourceforge.net/
0
 
timbocAuthor Commented:
Does it support SQL?
0
 
JohnjcesCommented:
No
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now