Embedding MySQL

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Embedding MySQL by tachyon (Chancellor) on Jul 10, 2004 at 11:34 UTC
Is it true when compiling perl script into exe MySQL can not be embedded with that exe. Yes Why is that... Because MySQL is a ~ 10MB+ stand alone application, with its own license, that has SFA to do with perl. do that mean I have to redo my database? Not the data per se but yes to the access mode. If you want to create a standalone exe with perl and an embedded DB (as you sound like you do) you will find DBD::SQLite (a stand alone RDBMS in a perl DBD) works easily. You can compile that in and then add the data file and that's it. cheers tachyon	[reply]
Re^2: Embedding MySQL by Anonymous Monk on Jul 10, 2004 at 17:21 UTC
What is the webserver suitable to be embedded with the standalone exe?	[reply]
Re^3: Embedding MySQL by tachyon (Chancellor) on Jul 10, 2004 at 22:17 UTC
Chromatics jellybean is one option. Simple HTTP in under 100 lines would just need CGI support adding if you want really compact. cheers tachyon	[reply]
Re: Embedding MySQL by strat (Canon) on Jul 11, 2004 at 09:36 UTC
If i need to pack (e.g. with PAR) perl code to run it on a PC where perl is not installed I often use SQLite instead of MySql because this database consists only of a flat file, and the interface mechanism consists of perl modules (e.g. DBI and DBD::SQLite) which can be packed easily. So I don't need to tell people on how to install MySql As a webserver, an interesting alternative to HTTP::Daemon is POE (see the POE-Cookbook -> Web) Best regards, perl -e "s>>F>e=>y)\martinF)stronat)=>print,print v8.8.8.32.11.32"	[reply]