Freeway is a feature-rich open source e-commerce platform which lets you sell services, subscriptions or events besides the standard products.

This e-commerce application is built with PHP and uses MySQL as the database.

A nice feature of Freeway is; it helps you promote your products with a powerful discount - campaign module which lets you create "get x and y is free" or "get 3 and 1 is free" type price breaks. And also, an included affiliate system lets anyone refer you and get a commission on sales.

Some other features of Freeway:

• Supports most of the popular payment systems
• Multilingual
• Newsletter management
• SEO friendly URLs
• Role-based admin
• Sales, stock, shipping and similar reports
• Ticket support feature
• SMS marketing
• And much more..

Freeway can be integrated to Joomla with the ready to use modules and modules for Typo3 and Drupal is on the way.

Pixelpost is an open source photoblog application with powerful image gallery features.

It can be used only as an image gallery or a website of a designer, photographer and so.. easily.

Pixelpost lets the users browse the image archive, view images in detail and comment to them.

Having an active community, you can find 200+ plugins & templates for the application.

This photoblog application has also RSS & multilanguage support.

Click to see a nice photoblog created with Pixelpost.

MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project.

This tool helps you to see the relations, indexes, tables of your MySQL database as a clear snapshot. With its simple yet effective interface, you can easily get used to MySQL Workbench.

For any developer who uses MySQL, this tool saves so much time for concentrating on other tasks rather than data modeling. You can also print the diagrams and use that sheet for faster coding (that’s what I do).

It is definitely a must use.

E-mail marketing, when done professionally, has a serious return rate and measurable.

OpenEMM is a beautiful e-mail marketing (or newsletter management) application with business level capabilities. And best of all, it is open source.

Using this e-mail marketing tool, event and time triggered e-mails can be sent which is a great feature for smarter mailing lists.

Some other features of OpenEMM are:

• Set of pre-configured action forms and template
• Import and export workflows simplified by wizards
• Configuration of different users with different rights/roles
• Create mailing lists for groups of recipients
• Subscription to your mailing lists via confirmed opt-in, double opt-in or via e-mail
• Unsubscription with one click, optional with confirmation query and unsubscribe confirmation by e-mail
• Import and export wizards
• Separation of layout and content (like a content management system)
• Templates
• Detailed real-time statistics with graphical output
• Analysis of opening rate, click rate, unsubscriptions, bounces
• Comparison of multiple mailings based on key data

OpenEMM is mainly written in Java and Python and uses MySQL for storing data.

TYPOlight is one of the most attractive open source content management systems I have seen.

Built with PHP5, TYPOlight uses MySQL for storing the data. Besides the powerful features, this CMS application is very well documented and has an active users community.

As a feature spotlight, XHTML output, form generator and being able to manage multiple websites under 1 system are really nice.

Features of TYPOlight

• Live update feature
• Uses Ajax technology
• Intuitive user interface
• Accessible XHTML strict output
• Versioning and undo management
• Accessible administration area
• Front end output 100% template based
• Automatic e-mail encryption (spam protection)
• Powerful permission system (user management)
• Newsletter management
• Form generator
• Multi-language support (character set UTF-8)
• Generates search engine friendly URLs
• Web 2.0 support (e.g. lightbox)
• Advanced search and sorting options
• Multiple back end languages and back end themes
• Supports multiple websites in one tree
• Supports GZip compression
• Print articles as PDF

Free document management software is something really hard to find.

Epiware (thanks Jim for the suggestion) is an open source document management solution built with PHP & MySQL.

In a business environment, such a document management system is very helpful as it makes all documents reachable for everyone and keeps the versions of the documents which is a great feature if there are many people editing the same document.

It has many attractive features like:

• Manage multiple projects
• Calendar
• WIKI
• Tasking/Gantt Chart
• News room
• Search document contents and metadata
• Control folder access via groups and/or users
• Document access history
• Document version history
• Check-in and Check-out

Besides the multi-user version, this document management solution has a single user version and a complete - no requirements - version including PHP, MySQL and a web server too.

Smoot is a tool, developed with xajax and Pear::DB for creating diagrams of icons and links between them.

Features include Google Maps and Google Earth integration, configurable tool palettes, and automated palette generation from a Google local query.

Smoot builds relations between objects with mouse clicks and the result can be stored easily. This nice tool can be a starting or an inspiration point for many projects like "online heritage services", "online diagram services" and much more.

Achievo is an open source web-based project management tool which also enables users to manage the business resources like human resources or customers with a CRM point of view.

Project management part of Achievo covers projects, phases, tasks, notes, statistics, planning, members and project templates.

The CRM section of Achievo allows you to administer your suppliers, prospects and customers and for each of these contact persons. It also includes a contract management part where contracts can be managed by relation. Projects are also managed by relation.

Achievo’s scheduler enables users to share a schedule with the other users. The scheduler includes dayview, weekview, monthview, recurring events and e-mail notices. Furthermore, it is possible to compare schedules.

Achievo is also an expandable project management software with ready to use extension modules and more than 20 languages supported.

Sending newsletters to 1000’s of users, tracking clicks, unsubscribe links, risk of sending e-mails twice? Yes, these are some concerns of newsletter management.

phplist, an open source PHP - MySQL based newsletter management application makes sending newsletters easy, professional and managable.

Some powerful features of phplist:

• No duplicate messages. No ‘forgotten’ messages.
• View and click tracking
• Templating and multiple subscribe pages
• Dynamic subscriber columns
• User specific content like "name, e-mail"
• Lists
• RSS subscription
• Scheduling
• CVS import and export
• Bounce detection and cleaning
• Auto PDF messages
• Attachments
• Throttling to prevent server overload

This open source newsletter manager can also be integrated with the current subscriber base with the built-in import feature or some coding for syncronazing databases.

Sphinx is a standalone search engine application that can be integrated with your data sources to provide fast, size-efficient and relevant fulltext search functions.

To clear how powerful it is, Sphinx is already used in BlogCatalog, Joomla & phpBB community forums and more.

Sphinx currently supports:

• MySQL
• PostgreSQL
• XML Pipe mechanism that allows indexing of XML data

Some features of Sphinx:

• high indexing speed (up to 10 MB/sec on modern CPUs)
• high search speed (avg query is under 0.1 sec on 2-4 GB text collections)
• high scalability (up to 100 GB of text, upto 100 M documents on a single CPU)
• supports distributed searching (since v.0.9.6)
• supports phrase proximity ranking, providing good relevance
• supports any number of document fields (weights can be changed on the fly)
• supports different search modes ("match all", "match phrase" and "match any" as of v.0.9.5)