XSLT based Powerful And Open Source CMS: Symphony

Symphony is a XSLT-powered open source CMS that is created with PHP & uses MySQL for storing data.

It offers a very flexible usage as the data, logic & templating layers are all independent, meaning that whatever you implement can be modified, added or removed with minimum effort.

When compared to other popular CMS applications, the biggest difference is the template engine used. It is XSLT-based which makes it possible to output much more than just web pages (dynamic CSS & JavaScript, PDFs, SVGs..).

Continue reading

Sequel Pro: Free MySQL Management Tool For Mac OS X

Sequel Pro is a free MySQL management tool for Mac OS X.

It offers full table management (including indexes), supports MySQL views, imports/exports from SQL/CSV files & compatible with MySQL 3/4/5 databases.
sequel-pro

The application supports SSH tunnel connections besides standard local & remote connections for reaching databases behind firewalls.

It can connect to multiple databases at the same time, offers automatic syntax highlighting for your custom queries, supports ~30 different encoding options & much more.

Continue reading

Free Open Source Ajaxed MySQL Table Editor, easy to create admin pages.

Mysql Ajax Table Editor is an open source web application for easily editing MySQL tables & creating admin pages almost instantly.

Besides the standard “add, edit, copy, delete, view” functionality, records can be paged, searched & exported to CSV.

mysql-table-editor

It is possible to JOIN multiple tables to generate a custom view (+ apply any other functions on this view) with the help of a configuration file. Also, column names displayed can be customized for a better presentation.

Continue reading

Useful List of of MySQL Cheat Sheets & Free Quick Reference Guides, Best of designers, developers & programmers,

The following article is a list of MySQL Cheat Sheets & Quick Reference Guides for Web Designers, Web Programmers, Coders & for Web developers for Quick coding with MySQL. These are very helpful for those of us who haven’t memorized all of the MySQL commands. This compilation of MySQL cheat sheets should help speed up your web development. Please feel free to comment on MySQL quick reference guides that we have missed and / or even better yet submit your MySQL quick references guides & cheat sheets here.

Added Bytes : MySQL Cheat Sheets

wwwaddedbytescom_cheat-sheets_mysql-cheat-sheet_

The MySQL cheat sheet is designed to act as a reminder and reference sheet, listing useful information about MySQL. It includes a list of the available functions in MySQL, as well as data types. It also includes a list of MySQL functions available in PHP, and a list of useful sample queries to select data from a database. A description of what is on the cheat sheet follows, or if you are impatient, you can go straight to the full size MySQL cheat sheet.

CSE.edu : (My)SQL Cheat Sheet

CSE.edu : (My)SQL Cheat Sheet

Here are the most commonly used SQL commands and the most commonly used options for each. There are many more commands and options than listed here. In other words, the syntaxes as I have listed them are far from complete. See the links at the bottom for more complete syntaxes and more commands.

Continue reading