I need to set up a simple php based website on a university server. It would need basic data from a database, mostly news entries. I'm not sure yet how much control I have except I know there is php installed. I'm pretty sure you cannot use the database unless you request it and get approved and I'm just assuming I won't go that route. Anyway, is there a good database replacement I could use that stores data in flat files? Or will I have to build a simple system myself for that purpose?
Looking for suggestions of what people have used and what works. Thanks!
If you can use sqlite then that's great. Using flat files can be very complicated when it comes into simultaneous file update (i.e. 2 requests needing to write to the same file at the same time).
CouchDB is a relatively new database management system, designed from the ground up to suit modern software applications that tend to be web-based, document-oriented, and distributed in nature.
For several decades now, relational database management systems have reigned supreme in application and database development, with the likes of Oracle, SQL Server, and MySQL being used in every type of software application imaginable.
Many of these developers were prolific at SQL, and open source relational databases such as MySQL simply made the most sense. Today, MySQL is used on millions of web sites across the world.
Although the strict schema-based structure these databases adhere to is required in some web applications, such as transaction systems, it is not a good fit for many modern web projects, such as blogs, wikis, and discussion forums, which by their nature are a better fit to a document-oriented database like CouchDB.
Well I'm emailing the administrator of the computer systems. I may be able to get MySQL access or they may add php support for sqlite (which is apparently disabled). I guess I'll go one of these routes hopefully.