JODPIE is a software that allows to import Open Directory Project RDF dumps into a relational database. JODPIE comes with a PHP script, JODPIE Lite, that allows to browse and search imported ODP RDF dumps; this PHP script is based on templates that can be customized. JODPIE has been developed having in mind portability among different platforms; it’s written in Java and run from command line. This allows to run it even from a remote shell; the import process relies on a custom optmized parser for each ODP RDF dump; the interface to the database is based on JDBC in a way that import can transparently work with any relational database, provided that proper JDBC driver and SQL schema are available; we provide SQL schemas for the use of JODPIE with PostgreSQL and MySQL. The PHP script we provide relies on a database abstraction library allowing to change the database backend without customizations: only an appropriate SQL schema is needed. In this way it’s possible to have a local copy of the Open Directory Project RDF dumps with about 5,000,000 reviewed websites and about 600,000 categories. Main advantages: Fast elaboration of DMOZ RDF dumps; support for full import of ODP RDF dumps; support for partial import of ODP RDF dumps (i.e. importing only category Arts with about 50,000 subcategories and 300,000 links to external pages in less than 15 minutes); reduced bandwith usage as you don’t need anymore to query live Open Directory Project web pages; local browsing of DMOZ data through retrievial from your local copy; local searching of Open Directory from your local copy; both HTML and XML output; support for thumbshots from Thumbshots.org; support for full UTF-8encoding; support for foreign languages DMOZ RDF dumps are free to use if you comply with their terms of use.

ProjTimer is a small Java app that measures the time you spent on various tasks / projects. Features: Simple / light weight & works, Automatic timing / no need to manually enter the times, and Handy export function to save data to file (text format).