OIO is a Web-based metadata/data management front-end which is built using Zope and works with Postgresql. No programming is required to build and manage Web-forms or to perform data mining/analysis on the collected data. It is in production at the Harbor/UCLA Medical Center for clinical outcomes management and research data. Forms created with OIO and hosted on any OIO server can be downloaded as XML files. Once downloaded from the "Forms library" and imported into an OIO server, the necessary database tables are automatically recreated and the imported forms become immediately available to the users of that OIO server.
Paloma is a program to manage an SQL database of digital music files, and facilitate their retrieval and playback in interesting ways. It works with music files of any form -- MP3, Ogg Vorbis, MIDI... whatever you've got a player for. Paloma makes it easy to rip your entire CD collection and store it on your hard disk (or a collection of CD-Rs) for instant random access; playlists can then be generated using arbitrary SQL commands.
Photo Collection is a Web-based picture organizer. Pictures are indexed in a relational database (currently MySQL), and can be organized in hierachical categories. Each picture has a thumbnail and can have a name. It is written in PHP on the Web side, and there is a Perl client for database administration.
php-stream is a front end for the stream-db icecast/shoutcast MP3 file streamer. php-stream uses the same database backend for queues and logs as stream-db. Users will be able to make their own playlists of songs, and the system playlists will be the complete set of songs that make up an individual album. Full access control will be provided, to set limits on the number of songs and playlists a user can submit to the system. The aim the project is to allow people to create their own streaming media stations, with users, requests, song histories, and playlists.
phpDVD is a simple PHP script to keep track of your DVD collection. The information is stored in a MySQL database and an interface is provided to add, edit and delete entries. Customizable fields allow you to display the details of importance to you; the default fields are: Title, Studio, Year, Aspect Ratio and Audio Format. You can optionally link each title to its corresponding page at the Internet Movie Database, or to a URL of your choice. The look and feel is fully customizable through header/footer/style sheet templates.
phpGraphy is a PHP script that allows you to display a picture book/photo gallery on your Web site in a very convenient way. It has many features such as both static and on-the-fly low resolution and thumbnail picture generation, user comments, picture ratings, EXIF/IPTC handling, security levels, and Web interface management. It's also easy to install and highy customizable.