I cannot see in mysql online manual Embedded example (http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname telling where de database will be saved in disk. So I suppose it must be some existing database especified on some configuration file.
Could be embebbed mysql be a replacement to sqlite for programs that just want to create some database in some specified file with no configuration if possible?
I was thinking of embebbed mysql as a way for user unprivileged desktop programs creating databases at user's home. The apps I was thinking of were personal databases, addressbooks and so. For being embebbed and created on a personal file or dir they would be easy to create, update and remove. Besides, for using mysql backend it would be powerful (lot of features as foreing indexes and constraints and complex sql commands) and I suppose easy to export data for latter use in other mysql databases and so if neccesary.
So I could thank any opinion on this to help me know if embedded mysql could fit my needs or I would better use a simpler solution as sqlite.
The things I would try to avoid: - An unprivileged desktop user needing to edit system config. - Needing to edit config files. Better to set up everything inside the application. - Being able to create, edit and remove database from application. No need for extra config.
thanks, txemi.
To use the libmysqld.dll you need to create a section in the my.ini or my.cnf file that looks like:
[MyEmbeddedProgram.exe] basedir=U:\MySQL datadir=U:\MySQL_Data tmpdir=f:\mysql_tmp
where MyEmbeddedProgram.exe is the name of your program.
But this could be expensive. If you distribute your application to others, whether for profit or for free, you will need a license for each copy (about $500).
If all you're doing is creating address books or other tables with a few hundred rows in it, then MySQL is overkill. There are plenty of other databases out there that have a zero footprint and no install is necessary. I can suggest some for Windows that work great.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
