Aha, what solution would you recommend? I would like some open and free product working in linux and win, easy to interact with other products and some relation among tables capabilitie (foreign index, constraint...).
I focused on sqlite because It seem to match this requirements and it is already available on most linux distros. I did not know you had to pay for mysql, I thought they made money from services. El jue, 04-11-2004 a las 09:43 -0600, mos escribió: > At 09:14 AM 11/4/2004, you wrote: > >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 > > -- ______________________________ < hola, soy una firma horrible > ------------------------------ \ ^__^ \ (oo)\_______ (__)\ )\/\ ||----w | || || email: [EMAIL PROTECTED] web: http://txemi.webhop.org web2: http://txemi2.webhop.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]