Open School Admin (OSA) is a Web-based school administration system primarily focused on ease of use and access to school information. It has been in continuous use and development for the past 7 years. It manages all aspects of school administration: student enrollment, class scheduling, mark reporting, attendance, user accounts, and room booking. Through the use of various plugins, it also manages email announcements (including automated attendance notices), government reporting, dorm room management, Alumni relations, etc. It is a standalone application written using a Perl/MySQL back end. It requires a Web server (Apache/Lighttpd tested) and should run out of the box on any Unix system. While OSA itself is very mature, the installation and setup is still a young and evolving process.
datafromdump is a class that manipulates table dumps from full MySQL database dumps. The SQL CREATE and INSERT statements for a number of given tables can be extracted and executed immediately or saved to a new database dump file. During the first scan of a dump file, it tries to create a "metadata" file, so the subsequent data extraction jobs will be much faster. CREATE TABLE operators can be executed or included into the resulting SQL file or not, according to passed parameters. A short "statistic page" can be printed after the job.
Print Release System provides Web-based management of System V printing. It sits between Samba and the System V printing system. It ought to be relatively easy to make it work with other printing systems. After the job is printed, the user needs to consult a Web page that shows their queued jobs, which can be selected and released for printing (or canceled). A record is maintained for each job and, once the user reaches a quota, they can't release any further jobs to the printer.