MeltedMonitor
11-26-2003, 11:06 PM
OK, my brain hurts. I have been reading database posts for over an hour now and can't seem to find anything that really sways me one way or another.
I need to create a relational database that can be used both on a local computer with no access to the internet (via CD) and on a website running on a Linux box.
I am an intermediate web designer that has long been hacking perl and dbman from www.gossamer-threads.com for my databases. It has worked well for me because all of my dbs have been small. It taught me the basics and I thoroughly understand the principles of databasing now.
My new project is on a much larger scale. My newfound love for php and SQL tells me that it is definitely the way to go as far as the website is concerned, but can I create/modify/use an SQL database on a local computer?
Idealy, I want to be able to create a database locally and upload the db file to my server and have the website run off of it. The inventory side of the db would only be modified on the local computer, the customer db would be modified locally and on the net and the order db would primarily be modified on the net. Whew.
I am open to any suggestions and am willing to learn new tricks. I just want to feel confident that the tricks I am going to learn are the right ones! I wish I would have picked php and SQL over perl and flatfile text dbs a few years ago!
Darren
I need to create a relational database that can be used both on a local computer with no access to the internet (via CD) and on a website running on a Linux box.
I am an intermediate web designer that has long been hacking perl and dbman from www.gossamer-threads.com for my databases. It has worked well for me because all of my dbs have been small. It taught me the basics and I thoroughly understand the principles of databasing now.
My new project is on a much larger scale. My newfound love for php and SQL tells me that it is definitely the way to go as far as the website is concerned, but can I create/modify/use an SQL database on a local computer?
Idealy, I want to be able to create a database locally and upload the db file to my server and have the website run off of it. The inventory side of the db would only be modified on the local computer, the customer db would be modified locally and on the net and the order db would primarily be modified on the net. Whew.
I am open to any suggestions and am willing to learn new tricks. I just want to feel confident that the tricks I am going to learn are the right ones! I wish I would have picked php and SQL over perl and flatfile text dbs a few years ago!
Darren