This topic is locked

building an offline database?

10/20/2008 11:02:22 PM
PHPRunner General questions
W
wfcentral author

I have a client who does not have internet. Also, he does not want an internet solution because his database must be UP 100% of the time.
So, I would really like to use phpRunner since I know how to use it.
How hard is it to setup a windows machine with all the Apache/PHP/mySQL that would be needed to run a phpRunner generated product offline?
Has anyone ever done this? or am I better off just going with a database product like OpenOffice for this project?

S
swanside 10/21/2008

Look at this, download it to a memory stick, then install it on your clients machine.
Has Apache, MySQL and PHP all built and ready to go.
http://www.wampserver.com/en/

R
roadyx 10/21/2008

I use XAMPP for windows myself on my laptop and it works just fine. I'm curious to know what the difference is between Wampp and Xampp.
http://www.apachefriends.org/en/xampp-windows.html

I have a client who does not have internet. Also, he does not want an internet solution because his database must be UP 100% of the time.

So, I would really like to use phpRunner since I know how to use it.
How hard is it to setup a windows machine with all the Apache/PHP/mySQL that would be needed to run a phpRunner generated product offline?
Has anyone ever done this? or am I better off just going with a database product like OpenOffice for this project?

V
vytb 10/21/2008

I use EasyPHP. It would be interesting to know your opinion of which is better..

W
wfcentral author 10/22/2008

I downloaded and installed XAMPP on my Vista laptop and did a quick check to see that it is now able to run PHP files - Success! Thanks!
Now, one more tiny question before I get hours into this project.
I'm assuming that I will be able to install XAMPP on Computer1, build my phpRunner project there, then network Computer2 to Computer1 and open those same files. I need to be able to run the database on both computers and I'm assuming that since XAMPP is installed on Computer1 it will act as the "server"
Am I correct?
thanks

hfg 10/22/2008

I have not used either product so I can't really comment on them, but my thought would be a old computer running Linux, Apache, MySQL and PHP. This would give you a dedicated box (or an Intranet server) for the database. It also keeps a user from forgetting and turning off their computer or the PC crashing due to another app that is being run by the user, thus shutting down the DB. It doesn't have to be anything real powerful either, not knowing the size of project I won't make speed recommendations but my guess is you can find a couple year old PC (or even server) cheap that will do the job. You might even find something with a raid 1 setup in it already.
Make sure to setup a backup as well of the DB, since the only place it will exist is that office they need to take a backup off-site nightly.

M
maxcolo 10/22/2008

I use two programs
Mamp for windows e mac PHP4 and PHP5 e MYSQL e server APACHE

WM Tool

Search with Google are free product

Good By

W
wfcentral author 10/23/2008

I have not used either product so I can't really comment on them, but my thought would be a old computer running Linux, Apache, MySQL and PHP. This would give you a dedicated box (or an Intranet server) for the database. It also keeps a user from forgetting and turning off their computer or the PC crashing due to another app that is being run by the user, thus shutting down the DB. It doesn't have to be anything real powerful either, not knowing the size of project I won't make speed recommendations but my guess is you can find a couple year old PC (or even server) cheap that will do the job. You might even find something with a raid 1 setup in it already.

Make sure to setup a backup as well of the DB, since the only place it will exist is that office they need to take a backup off-site nightly.


I thought about that option - decided to go with Vista though... why?
It is a real simple database for a dry cleaner who just needs to know on which (of thousands) of locations a customers clothing is hanging. That's all it does. They are not super comfortable with computers and they wanted two workstations. I did not want to bring in a linux system and have them working with a linux station and a Vista station. They wanted two workstations and I am more comfortable working with Vista than Linux. They will not be using these machines for anything but this. It's actually easier to just go to the local Tech Mart and grab two Vista boxes with monitors than it is to round up two reliable old computers, reformat, install Linux, etc.

W
wfcentral author 10/23/2008

Okay, I installed XAMPP and it's working great. I got two computers networked together with both accessing the PHP that XAMPP is supporting.
Next step, I'm ready to start developing in phpRunner.
So, what do I put in for
Host

User

Password

Port
to connect to this local mySql database?
thanks

Robert