I am helping run a Model United Nations conference for high school students. The conference is completely organized and staffed by university students. I am writing an application that will keep track of UN Resolutions passed by the students, print them out, and so on. The database backend doesn't need to be high-performance (no more than a few queries a minute will be processed), but if it were to fail during the weekend-long conference, it'd be a serious catastrophe. What can I set up in order to decrease the likelihood of this happening? I am open to using any database system as long as it fits within our generous technology budget of $0.00 and a few donated laptops.
feedback
|
|
Sign up for a 30 day SQL Azure trial account: http://www.microsoftplatformready.com/us/home.aspx?WT.mc_id=AzurePass_HomePageBanner ...or better yet, contact Microsoft and ask them if they want to sponsor your event with a SQL Azure instance for free. | |||||
feedback
|
|
I wrote something like this for the Yale University Model United Nations conference. http://ymun.yira.org/ . I used django which is an application framework that in turn uses MySQL as its database. You can start with a virtual private server running ubuntu linux. You don't really need mirroring, because your database will only store links to the files. So if the database crashes you'll still have access to the files. | |||
|
feedback
|
|
Use SQLite and copy the database for a time line of backups automated by cron. Back them up on a different laptop or on some remote location to get survivability beyond a laptop being dropped. | |||
|
feedback
|
