[Tutor] Distributing MySQL with my application

[Lauren Snyder]

Alan and André, 

Thank you very much for your assistance. My script takes a long log file,
parses it, puts the data to a database. The application has a GUI interface
and uses the data in the database to make and display various calculations
and graphs. Users will have their own log files...but to use my tool, I need
to either ensure they have a db server (like noted below) to create my db
on...or to somehow provide a db for them to use with my tool. 

1. how do I create a database that is not in users localhost? Currently I
just use MySQL's "create [database]" command after I connect using
MySQLdb.connect Alan mentioned something about 

"Do you not use an environment variable or config file to allow the user to
select where the database server runs?"

--> This sounds like it might be an excellent solution, but I'm not sure how
to do it.

2. I also like the idea of writing a script to check to see if MySQL is
installed. However, I need pointers on writing this script and also the
script to auto install MySQL on another user's computer. 

Thank you again for your help and brilliant ideas!
Lauren




-----Original Message-----
From: andré palma [mailto:andrefsp at gmail.com] 
Sent: Sunday, March 22, 2009 7:29 AM
To: Lauren Snyder
Subject: Re: [Tutor] Distributing MySQL with my application

Hi! It depends for what do you want for your aplication. How about you 
create a database anywhere else(not in users localhost) for each user 
who uses your software? This way you just wouldn't have this problem. 
But if you really need the database on localhost my suggestion is:
- make a script that check if the user already have MySQL installed, 
this way you just need to create an new database on localhost server for 
your software.
if there is no MySQL :
- make a script to install MySQL locally




Lauren Snyder wrote:
>
> Hello!
>
> I have written an application in python that uses a MySQL database. I 
> want to distribute this application to many users so I created an 
> executable using GUI2exe. My executable works marvelously. However, 
> when attempting to run the app on a computer that doesn’t have the 
> MySQL server running, I obviously get the error: Can’t connect MySQL 
> server on localhost.
>
> So I have some questions around this problem:
>
>    1. Is it possible to bundle the database into my application?
>    2. Do I have to write a script that installs the database server
>       locally?
>    3. Do I have to make “Users must have MySQL server running” as a
>       pre-requisite for using my software?
>    4. Did I miss an option in GUI2exe that allows me to set up my exe
>       to use MySQL?
>
> Thank you,
>
> Lauren
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
>