Embedded mysql for simple user programs
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. -- __ 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]
Re: Embedded mysql for simple user programs
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded mysql for simple user programs
Hi. You may tell MySQL where the data files are stored in the argc, when you are calling mysql_server_init. Also you may put other server variables into this array. I think, MySQL can do most tasks, which you are looking for. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html txemi [EMAIL PROTECTED] 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. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded mysql for simple user programs
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]
Re: Embedded mysql for simple user programs
Thanks, I did have a look at it and it seems that I could use embedded mysql with no conffiles at all. :-) I like it becouse I would prefer application configuring mysql based on its own config or status and not having spread conffiles for each used library. Besides, various applications using this library and editing some mysql conffile at user home (/home/user/.my.cnf) could finish in a mess. El jue, 04-11-2004 a las 17:51 +0200, Gleb Paharenko escribió: Hi. You may tell MySQL where the data files are stored in the argc, when you are calling mysql_server_init. Also you may put other server variables into this array. I think, MySQL can do most tasks, which you are looking for. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html txemi [EMAIL PROTECTED] 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. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- __ 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]
