creating an app with an embedded db

[minckle]

hi

dont know if this is possible

i currently develop apps in delphi using mysql as a backend database. this means when i want to put the app onto another computer it needs to have mysql installed.

is there a way where i can create an app with the database embedded into it, or where the database is stored in a seperate file but the other computer doesn't need any extra drivers or software

basically what i want to finish up with is an install cd with the app and db, and the user doesn't need to install any 3rd party drivers or software

any help or advice would be grateful

 

[Griffyn]

I would dare suggest what you're asking is a bit restrictive. You could always store your data in a text file - there's no extra drivers needed for that.

Otherwise, I'd suggest using the ADO components and an Access database. You would need to have Jet installed on the computer though. This is installed by default on Windows XP, and can be downloaded and installed automatically by your install program for other operating systems.

 

[DelphiAaron]

there are database VCL's avaliable to do what you want
i use dbisam

http://www.elevatesoft.com

i havent seen 1 that supports a mysql db.

Aaron Taylor
John Mutch Electronics

http://www.jme.com.au

 

[rdale2]

Since I'm a noob to Delphi, please excuse my ignorance... don't know if one of these would help you or not...

Absolute Database

http://www.componentace.com/bde_alternative.htm

or

EasyTable

http://www.aidaim.com/products/tet/tet_spec.php

 

[VintageWine]

How about using Installshield (bundled with Delphi) to create a setup.exe that installs MySQL and your application?

Simon