Author Topic: Deployment for small k-12 school system  (Read 2312 times)

dhottinger

  • Jr. Member
  • **
  • Posts: 10
  • Karma: 2
    • View Profile
Deployment for small k-12 school system
« on: April 11, 2008, 06:54:14 AM »
I made the mistake of showing my SOS page to our technology people and showing them how easy it is to have a good looking webpage up and running without having to do a lot of html coding.  Now they are wanting to give each of our teachers access to it.  Each teacher already has webspace, but I am trying to figure out a way to create the mysql databases during the setup process for SOS instead of having to login to the server and create it as root.  Would it be possible to create one mysql database and have each users website be part of it? 

thanks,

ddh

HandsomeWeb

  • SOS Developer
  • Administrator
  • Full Member
  • *****
  • Posts: 85
  • Karma: 2
    • View Profile
    • SOS Webpages
Re: Deployment for small k-12 school system
« Reply #1 on: April 11, 2008, 09:51:24 AM »
During installation, you are allowed to add a database table prefix.  The default is "sos_".  If you choose the prefixes like this:

"teacher_01_"
"teacher_02_"
"teacher_03_"

They will all be able to use the same database.  MySQL is very robust, so several of these not-high-traffic sites could be used with the same database.  I don't know if thousands of tables in a MySQL database will be slow, but if you used a different database per grade or per school it would certainly ease your workload.

-----------------------

I would also be interested in the opinions of teachers as to what they would like added.  I could make new modules.  I am also a teacher and have considered the same.
« Last Edit: April 11, 2008, 01:19:55 PM by HandsomeWeb »
Chris
http://www.soswebpages.com
http://www.handsomeweb.com
http://www.handsomewebservices.com

dhottinger

  • Jr. Member
  • **
  • Posts: 10
  • Karma: 2
    • View Profile
Re: Deployment for small k-12 school system
« Reply #2 on: April 11, 2008, 04:00:54 PM »
I set it up for our ITRT (They teach techology to our teachers and help me out when new things come up).   They will be playing around creating sites.  I'll let you know what they say.  Im thinking the calendar module will be very helpful for our teachers.  I havent deployed it yet.  But plan on 'sharing' it in the future.

thanks,

ddh