Sportwire contains the essential components to translate an ANPA sports newswire feed into XML format and then to read the XML into relational tables. The story parser is extensible and can be easily adapted. Parser classes included in this release can parse scoreboards, game updates, recaps and previews; it is just the components needed to construct sports news websites using ANPA news stories and a relational database. Also, since the ANPA tagging scheme is not fully normalized, the parser must use some heuristics to match certain incoming news items with the specific games.
iVote is a sort of visual poll/image voting system that allows you to set up a collection of images that users can then vote on. A full administration screen is available that allows you to add/delete entries, sort by fields, gather statistics and manage the database. Users are presented a visual preview page where they can vote. It includes theme support.
XML-DBMS is a set of Java packages for transferring data between XML documents and relational databases. It views the XML document as a tree of objects in which element types are generally viewed as classes and attributes and PCDATA as properties of those classes. It then uses an object-relational mapping to map these objects to the database. An XML-based mapping language is used to define the view and map it to the database.
Sixpack is a graphical and command-line bibliography database manager written in Perl/Tk. It interacts with the supplied package 'bp', which can import and export from a number of formats including bibtex, endnote, medline, procite, and many others. It can download references directly off the Web, and open articles using external viewers. It can also interface with Emacs/XEmacs and Lyx.
Expresso Framework is an open standards-based J2EE architectural framework that allows the developer to concentrate on application logic. It is a library of extensible Java Server application framework components for creating database-driven Web applications based on open standards. Expresso integrates with Apache Jakarta Struts, which emphasizes presentation and application configuration, and bringing a powerful tag library to Expresso. Expresso adds capabilities for security, robust object-relational mapping, background job handling and scheduling, self-tests, logging integration, automated table manipulation, database connection pooling, email connectivity, event notification, error handling, caching, internationalization, XML automation, testing, registration objects, configuration management, workflow, automatic database maintenance, and a JSP tag library.
xplain2sql converts files from Xplain to SQL. It supports a very large subset of Xplain, and it can convert from Xplain to Microsoft SQL Server, DB/2, Inprise InterBase, PostgreSQL, Oracle, MySQL 5, SQLite 3 or ANSI-92 SQL. It can also generate an XML description of the generated SQL. This XML description can be used to create low-level middle-tier code. Example stylesheets for Eiffel/ECLI and Delphi/ADO are included. The C source code release should compile on any platform with an ANSI C compiler. There are binary releases for FreeBSD, Linux, Solaris x86, and Windows 2000.
Metabase is a DBMS-independent PHP API to access SQL databases. It supports MySQL, PostgreSQL, Oracle, Microsoft SQL server, Microsoft Access, ODBC, Interbase, Informix, MiniSQL, and SQLite. It supports nested transactions, blobs, and prepared queries. It can install database schemas defined in a DBMS independent XML format that describe tables, indexes, primary keys, and auto-increment sequences. It is also able to upgrade a database to a new schema without affecting the data that was stored since it was installed or upgraded for the last time. There is also schema reverse engineering support.
WCN:Talk (originally called "FutureForum") is a Web discussion forum written in Perl and MySQL. It has many options, including message selection and sorting on the top index page. It also has collapsible branches, a menu that toggles between 'no menu', 'simple', and 'advanced' modes, full text search capability, the ability to send email to the admin and original poster, and many other features. It includes password protection, HTML templates, file uploads, message subscription, multiple discussion sections, and a lot more.