I have designed and implemented a website (seetucson.com) using php & mysql. I hacked it together. Not complicated, but extensive.

Now I'd like to do something on my PC with no internet involved. I don't know where to start. Just looking for some ideas.

SQL - I'd like to use PostgreSQL. It's already installed and running with PT2 and HM.

.php - No idea. I'm sure it's available, but are there different versions, etc. What should I use.

Can I/Should I use IE (or Safari) as an interface??

Input: Daily - Comma delimited DB, One "static" DB w/daily updates of a different DB.

Processing: Import daily DB, update other DB, compare records with preinput data and generate output file/DB.

Output: Comma delimited DB (or Excel file) with records merged from both original DBs.

I already have the php & SQL skills, sorta, and just want to hack together something to aid my business. Don't have time or energy to learn new lanquages. (?)

------------Jeff

PS. Specifics = Input complete list of homes for sale DB and update Real Estate Salesman DB. Compare homes for sale with specific "approveable" addresses. If approvable, then output home info merged with RE salesman info. I'm sure I'll be adding other stuff.

Get Xampp, its a webserver you can download and install on your home computer, complete with php and sql support. It uses mysql tho, i guess its possible to change the apache (webserver) configuration and have it use postgresql instead of mysql.

xampp

EDIT: you might want to use another language than php that doesnt require a webserver running on your computer, at least if you dont need to output webpages. I recommend looking at c#, its really easy and you can get it for free from microsoft http://www.microsoft.com/express/vcsharp/

This has nothing to do with apache, but with php. Just google php + postgresql and you'll see how you can connect with PostgreSQL using PHP.