Crystal is a database toolkit for PHP which aims to help developers build & scale reusable, database-dependent, framework-agnostic applications.

It has 3 independent components:

• Database wrapper – for CRUD operations
• Validation module – provides a comprehensive data validation
• Database manipulation module – used for creating databases, tables, etc.

The queries written with Crystal are database-independent which currently supports MySQL & PostgreSQL (SQLite is on the way).

For anyone who is familiar with SQL, learning Crystal wouldn't take no more than 5 minutes.

And, for many developers, it can be an option against framework-specific database layers like Zend_Db and Codeigniter's active record library or complex ORM's like Doctrine.

InDefero is an open source software forge application, built with PHP, that enables anyone to create a multi-project Google Code/Sourceforge-like system to manage their codes.

It eases tracking bugs, providing downloads, documentation and having an easy overview of the code base both for you & your team.

Also, it makes communicating with the user-base possible which is vital for a healthy development process.

InDefero has other powerful features like:

• every user has their personal dashboards
• code browser with git, Subversion & Mercurial support
• project timeline
• powerful search engine
• diff visualization of the commits
• inline display of text files from the repository with syntax highlighting
• & much more..

It requires a webserver supporting PHP as module or fast-cgi & PostgreSQL, SQLite or MySQL 4.1+ as the database to run.

myTinyTodo is a free to-do-list application with a very simple & clean interface.

The application is built with PHP & uses MySQL or SQLite for storing data

It has very nice features like:

• adding notes to tasks
• tags (and tag cloud)
• due dates (input format: y-m-d, m/d/y, d.m.y, m/d, d.m)
• priority (-1, 0, +1, +2)
• password protection
• sorting by priority or due date
• search
• smart syntax improves creation of tasks (usage: /priority/task/tags/)
• print-friendly CSS

myTinyTodo has a ready-to-use styling for mobile devices & comes with multilanguage support.

Tracks is a web based, advanced & open source to-do-list (getting things done) application built with Ruby on Rails.

It comes with a built-in web server (WEbrick) which makes it easier to run on your own computer or it can be installed to any Ruby on Rails enabled web server.

Application has a very slick interface & offers a high usability with drag’n drops & Ajaxed actions.

Tracks is a multi-user to-do-list application where everyone can have their own tasks.

Items can be categorized, proritized, scheduled & starred (for reaching them easier).

With a chart-supported statistics page, you can see the progress of your tasks, analyze them better like finding out which are your productive days, which task took more then expected & more.

The application has a powerful feed support (text, iCal and RSS). You can subscribe to a list & get status updates for them.

Tracks also makes it possible to getting integrated with other apps. with its API. And, it provides a lightweight interface for mobile phones at  http://tarcksurl/mobile/.

Frog CMS is a simple yet powerful content management system. It is the PHP variant of Radiant CMS (Ruby on Rails CMS app. – see WRD post) with a similar interface and logic.

This CMS application is ideal to be used both by designers & developers as, in general, they already know the basics of PHP and can insert simple loop, if else type codes while creating the pages and Frog CMS lets code usage in certain places. On the other hand end-users can use it too as it has a HTML editor for contents.

Some features of Frog CMS:

• Unlimited hierarchically structured page navigation menu
• Flexible page content: body, sidebar, extended, summary
• Per page layout customization
• Simple and reusable content snippets
• Drag and drop page ordering
• Password protected administration
• Simple user and permission management
• File manager

For storing data, you can choose between MySQL database or SQLite 3 with PDO.