chive is an open source & web-based MySQL management application that is built with PHP.

It can achieve the most common tasks like creating, editing & executing:

• databases
• tables
• indices, keys, triggers, views, routines
• privileges management
• import/export

The application has a built-in editor with syntax-highlighting which is nice when running complex queries & an easy-to-use interface that makes browsing fast.

chive has one major fallback (which may pr may not effect you): it only supports MySQL 5+.

jqFancyTransitions is a jQuery plugin for displaying images as a slideshow with fancy effects.

It has support for 3 transitions: wave, zipper & curtain but they can be diversified with the ability of setting the position & direction of the animations.

The slideshow has few other configuration options like:

• delay between transitions
• delay between strips
• number of strips
• title speed
• title opacity

Compared to many other slideshow scripts, jqFancyTransitions doesn't require an unordered list of items but, simply, needs an element wrapping the images.

PHP RSS Reader is an application which can crawl an unlimited number of feeds & presents them with an easy-to-use interface.

For an organized navigation, It is possible to create categories & place feeds inside them.

A handy feature is "keyword-based" categories which can auto-move items with the keywords mentioned into the related categories which is great for anyone who follows multiple feeds but hunts for specific keywords.

PHP RSS Reader comes with a complete admin panel where every setting can be controlled.

The application creates SEO-friendly URLs for every category & article which is important for anyone who will use PHP RSS Reader for creating a feed-based website rather than using it as a personal feed-reader.

It is possible to change the look & feel of the interface by simply playing with the CSS files.

There is a web-based installer that help making the application online in a few minutes.

PHP RSS Reader comes with 2 versions:

• free version (has some limitations like no keyword-categorization & unlimited sub-categories)
• complete, paid version which includes all the features.

The application is a must-check for anyone looking for an advanced RSS reader, planning to create a feed-based website or integrate feeds into an application (where PHP RSS Reader can be used only as the backend engine).

P.S. This post is a sponsored review.

AeroSQL is an open source web application, for managing MySQL databases.

It can control databases from different servers in a single, desktop-like interface where records can be easily browsed or edited within a grid.

The application displays every query executed & can run a batch of sql queries to save you time.

It is possible to select the columns to be displayed while editing a table which will help reaching the data in an organized way.

AeroSQL is built with PHP & uses ExtJS to provide the desktop-like functionality.

YoxView is a highly-customizable jQuery image viewer plugin (Lightbox) for displaying single-to-multiple images.

It helps browsing a list of images in a modal box with previous-next buttons or as a slideshow.

The viewer supports displaying multiple instances in a page where each of them can be configured independently.

YoxView is multilingual & already comes with multiple language files.

Besides standard navigation, images can be navigated with keyboard too.

The plugin has many options like opacity levels, background colors, title display/fade durations & more.

Ivan Lazarevic is sharing 2 different plugins for creating bar charts with jQuery & MooTools:

• jqBarGraph (for jQuery)
• mooBarGraph (for MooTools)

Both plugins can create simple or stacked bar charts & data to be displayed is loaded with an array.

jqBarGraph has support for animated loading of the charts however mooBarGraph offers more features like:

• url bars
• info boxes (interactive charts)
• negative values
• AJAX data loading

They are both very easy to use & support all major browsers.

Almost every web developer has a favorite database that he/she feels comfortable working with as all the tricks & gimmicks are already experienced.

It can be one of the popular databases below:

• MySQL
• PostgreSQL
• MSSQL
• SQLite
• MS Access

or even simpler ones like XML, text, etc.

It is understandable why these databases are frequently used; they are well-documented, have a community behind them, integrated with most popular CMSs', easy-to-use, offered by most of the hosting companies ,etc..

But there are also many other databases which are getting popular day-by-day & may have advantages over what you're already using.

Here are 25+ open source alternative databases that you may consider using in your next project:

MongoDB

It is an open source, high-performance, scalable, schema-free & document-oriented (JSON-like data schemas) database.

There are ready to use drivers for most popular programming languages like PHP,Python, Perl, Ruby, JavaScript, C++ + more.

Hypertable

Hypertable is a high performance distributed data storage system designed to support applications requiring maximum performance, scalability, and reliability.

It is modeled after Google's BigTable and mostly focuses on large-scale datasets.

Apache CouchDB

A document-oriented database that can be queried and indexed in a MapReduce fashion using JavaScript.

CouchDB offers a RESTful JSON API which can be accessed from any environment allowing HTTP requests

Read the rest of this entry »

Sypex Dumper is an open source web application for creating instant or automated backups of MySQL databases.

It is built with PHP, has an Ajaxed interface & can restore databases as well.

The application can work with gb-level huge databases as it easily bypasses the timeout limits of PHP by pausing/starting backup jobs.

Sypex Dumper can optionally check, optimize & repair tables or automatically delete older backups to save space.

It has support for file compression (Gzip and Bzip2) & offers a multilingual interface.

Grafico is an open source JavaScript charting library built with Raphaël & Prototype.js.

It is possible to create multiple types of charts like line, area, bar & stacked charts, sparklines and more.

Each chart type has numerous API options to customize it’s look & behavior.

Charts created with Grafico can, optionally, be interactive which means they can provide data when hovered, clicked, etc.

The library is well-documented & supported with examples.

Quicksand is a very functional jQuery plugin for reordering and/or filtering items with a nice shuffling animation.

It simply replaces a collection of items with another & only requires the sets to be provided which can be done in multiple ways:

• using plain HTML, like an unordered list
• downloading data by an Ajax call
• transforming HTML items by JavaScript

Quicksand also comes with few options like setting the duration or the easing type of the animation (optionally, Easing plugin can be used for more easing types).