SQLyog Community Edition – MySQL GUI

SQLyog is an all-round Management Tool (/’GUI’/'Frontend’) for the MySQL database. The Community Edition is Free & Open Source under GPL license.

SQLyog is also available in 3 other editions.

Download: SQLyog Community Edition 8.3

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 50 languages.

Features

- browse and drop databases, tables, views, fields and indexes
- create, copy, drop, rename and alter databases, tables, fields and indexes
- maintenance server, databases and tables, with proposals on server configuration
- execute, edit and bookmark any SQL-statement, even batch-queries
- load text files into tables
- create and read dumps of tables
- export data to CSV, XML, PDF, Word, Excel and LaTeX formats
- administer multiple servers
- manage MySQL users and privileges
- check referential integrity in MyISAM tables
- using Query-by-example (QBE), create complex queries automatically connecting required tables
- create PDF graphics of your Database layout
- search globally in a database or a subset of it
- transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
- support InnoDB tables and foreign keys
- support mysqli, the improved MySQL extension
- communicate in 50 different languages

Download: phpMyAdmin 3.3.1

BuddyPress will transform an installation of WordPress MU into a social network platform.

BuddyPress is essentially a set of WordPress MU specific plugins. Each plugin component adds a distinct feature to BuddyPress and only handles functionality for that specific component (for example, private messaging). BuddyPress also has a core plugin that all other plugins require, it contains shared functions and performs the basic modifications to the WordPress MU interface.

Each BuddyPress component is independent. This means you can pick and choose which features you’d like.

It also means BuddyPress can be used in two different ways. You could use BuddyPress to create a complete social network from scratch, or you could use it to add desirable features to your existing blog network.

Download: BuddyPress 1.2.2.1

Ever dream of running hundreds of thousands of blogs with a single install of WordPress?

WordPress MU, or multi-user, is designed to do exactly that. It is most famously used for WordPress.com where it serves tens of millions of hits on hundreds of thousands of blogs each day.

Who is WordPress MU ideal for?
• Newspapers and magazines, like Le Monde.
• Universities, like Harvard.
• Blog networks
• Niche-specific blog hosts, like Edublogs

Download: WordPress MU 2.9.2

PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.

PHP is an HTML-embedded scripting language. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of the language is to allow web developers to write dynamically generated pages quickly.

Download: PHP 5.3.2

Download: PHP Development builds

Download: PHP 6.0 Beta

Drupal is an open source content management platform. Equipped with a powerful blend of features, Drupal can support a variety of websites ranging from personal weblogs to large community-driven websites.

Drupal is software that allows an individual or a community of users to easily publish, manage and organize a great variety of content on a website. Tens of thousands of people and organizations have used Drupal to set up scores of different kinds of web sites, including: community web portals and discussion sites
corporate web sites/intranet portals, personal web sites, aficionado sites, e-commerce applications, resource directories.

Drupal includes features to enable: content management systems, blogs, collaborative authoring environments, forums, newsletters, picture galleries, file uploads and download, and much more. Drupal is ready to go from the moment you download it. It even has an easy-to-use web installer!

Drupal is open source software licensed under the GPL, and is maintained and developed by a community of thousands of users and developers.

Download: Drupal 6.16

e107 is a content management system written in php and using the popular open source mySQL database system for content storage. It’s completely free and totally customisable, and in constant development.

Download: e107 0.7.19

WordPress is a state-of-the-art publishing platform with a focus on aesthetics, web standards, and usability. WordPress is both free and priceless at the same time.

More simply, WordPress is what you use when you want to work with your blogging software, not fight it.

WordPress started in 2003 with a single bit of code to enhance the typography of everyday writing and with fewer users than you can count on your fingers and toes. Since then it has grown to be the largest self-hosted blogging tool in the world, used on millions of sites and seen by tens of millions of people every day.

WordPress started as just a blogging systems, but has evolved to be used as full content management system and so much more through the thousands of plugins, widgets, and themes, WordPress is limited only by your imagination.

Download: WordPress 2.9.2

WordPress for iPhone, the only iPhone app that lets you write posts, upload photos, edit pages, and manage comments on your blog from your iPhone or iPod touch. With support for both WordPress.com and self-hosted WordPress (2.7 or higher), users of all experience levels can get going in seconds.

Features
- Support for WordPress.com blogs and self-installed blogs version 2.7 and higher
- Embedded Safari for true previews of posts
- Full tag and category support
- Photo support for both camera pictures as well as library photos
- Support for multiple blogs
- Ability to password protect a post, save as a draft, or mark the post for later review
- Auto-recovery. This will recover posts which have been interrupted by phone calls

WordPress for iPhone is compatible with the iPhone 3G, the original iPhone, and iPod touch.

Download: WordPress for iPhone 2.2

DbVisualizer is the universal database tool for developers and database administrators. It is the perfect solution since the same tool can be used on all major operating systems accessing a wide range of databases.

• DbVisualizer 7.0.2 is tested and verified for Microsoft Windows 7/Vista/XP, Linux Fedora Core 7, Ubuntu 8 and Mac OS X 10.6.
• DbVisualizer 7 require Java 1.6.

Download: DbVisualizer 7.0.2

The MySQL database server is the world’s most popular open source database. Its architecture makes it extremely fast and easy to customize. Extensive reuse of code within the software and a minimalistic approach to producing functionally-rich features has resulted in a database management system unmatched in speed, compactness, stability and ease of deployment. The unique separation of the core server from the storage engine makes it possible to run with strict transaction control or with ultra-fast transactionless disk access, whichever is most appropriate for the situation.

Download: MySQL 5.1.43 | MySQL 5.5.1 m2 Beta

Database GUI tool

MySQL Workbench is a next-generation visual database design application that can be used to efficiently design, manage and document database schemata.

It is available for OSX, Linux and Windows as both, open source and commercial editions.

Download: MySQL Workbench 5.2.15a Beta

Database .NET is an intuitive database management tool for multi-database.

Capture .NET is 100% Adware/Spyware FREE

Requires .NET 2.0 , Compatible with .NET 2.0/3.0/3.5/4.0

Supported Platforms: Windows 2000/XP/2003/Vista/2008/Windows 7 (x86/x64)

Download: Database .NET 3.0.3666

Prototype is a JavaScript Framework that aims to ease development of dynamic web applications.

Featuring a unique, easy-to-use toolkit for class-driven development and the nicest Ajax library around, Prototype is quickly becoming the codebase of choice for web application developers everywhere.

Download: Prototype JavaScript Framework 1.6.1

Your All-in-One Social Publishing Platform. Powerful enough for building blogs, websites or social networks on a single platform.

Movable Type makes it simple to start a blog, manage entire websites and build an engaged community of readers and customers.

· Create beautiful blogs and websites
· A simple and powerful content management system
· Build a vibrant social network

Download: Movable Type 5.01

XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. XAMPP is really very easy to install and to use – just download, extract and start.

At the moment there are four XAMPP distributions:

XAMPP for Linux
· The distribution for Linux systems (tested for SuSE, RedHat, Mandrake and Debian) contains: Apache, MySQL, PHP & PEAR, Perl, ProFTPD, phpMyAdmin, OpenSSL, GD, Freetype2, libjpeg, libpng, gdbm, zlib, expat, Sablotron, libxml, Ming, Webalizer, pdf class, ncurses, mod_perl, FreeTDS, gettext, mcrypt, mhash, eAccelerator, SQLite and IMAP C-Client.

XAMPP for Windows
· This version contains: Apache, MySQL, PHP + PEAR, Perl, mod_php, mod_perl, mod_ssl, OpenSSL, phpMyAdmin, Webalizer, Mercury Mail Transport System for Win32 and NetWare Systems v3.32, Ming, JpGraph, FileZilla FTP Server, mcrypt, eAccelerator, SQLite, and WEB-DAV + mod_auth_mysql.

XAMPP for Mac OS X
· The distribution for Mac OS X contains: Apache, MySQL, PHP & PEAR, SQLite, Perl, ProFTPD, phpMyAdmin, OpenSSL, GD, Freetype2, libjpeg, libpng, zlib, Ming, Webalizer, mod_perl, phpSQLiteAdmin.

XAMPP for Solaris
· The distribution for Solaris (developed and tested with Solaris 8, tested with Solaris 9) contains: Apache, MySQL, PHP & PEAR, Perl, ProFTPD, phpMyAdmin, OpenSSL, Freetype2, libjpeg, libpng, zlib, expat, Ming, Webalizer, pdf class.

XAMPP is free of charge

Download: XAMPP 1.7.3

Download: XAMPP Beta

WP e-Commerce is the most industrial strength and feature rich WP Shopping Cart solution.

The WordPress e-Commerce plugin is a state-of-the-art e-Commerce platform with a focus on aesthetics, web standards and usability. It is both free and priceless at the same time.

Over 175,000 + downloads, stability, security and tight WordPress integration make it the right choice for growing your business online.

You will install WP e-Commerce in minutes. Just like all well architectured plugins WP e-Commerce bolts right on. You simply download the plugin, copy it to your Plugins folder and activate it via your admin panel.

WordPress e-Commerce integrates seamlessly with the WordPress Update System – so when you upload a new product the world knows about it!

We help ensure your site is a success by providing you with a range of tools that allow you to import your products into the Facebook Marketplace and Google Base. WP e-Commerce also utilises the populor “Share This” plugin so that your happy customers can bookmark and promote your products too!!!

WP e-Commerce makes it easy for you to accept payments online. WP e-Commerce integrates with Google Checkout, Paypal, Authorize.net, Payment Express and many other trusted payment processors.

Evidence has shown that the less pages your customers have to browse to make a purchase the more sales you will make. WP e-Commerce is streamlined, quick and simple to use so that your customers have a great experiance shopping your site.

Not only do you get to choose from a range of slick store front styles but you can customize and tweak your site to look however you want. We have made it easy for you by utilising WordPress PHP template tags, WordPress shortcodes and WordPress Widgets.

Download: WP e-Commerce 3.7.5.3

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.

FREE LIKE A BIRD. Anyone can build a custom version of Firebird, as long as the modifications are made available, under the same IDPL licensing, for others to use and build on.

FREE LIKE FREE BEER. No fees for download, registration, licensing or deployment, even you distribute Firebird as part of your commercial software package.

Download: Firebird 2.1.3 | Firebird 2.5.0 RC1

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

Pre-built binary packages are available for a number of different operating systems: FreeBSD · Linux · Mac OS X · Solaris · Windows

Download: PostgreSQL 8.4.2-1

SqlDbx is a fast and easy to use database SQL development IDE for database administrators and application or database developers who work in heterogeneous Database Server environments. SqlDbx built around an advanced SQL Editor and Database Object Explorer. SqlDbx provides a consistent user interface between different DBMS Systems. The intuitive and straight forward interface allows developers to improve their productivity by having easy access to the most commonly used features. Run queries, execute scripts and browse database objects without leaving editor window. SqlDbx is a standalone executable file, so no installation is necessary. Furthermore, SqlDbx does not install or modify anything on the user’s computer.

SqlDbx Personal Edition is a free version of the Professional Edition, and is for personal non-commercial use. It does not have time limit or nagging screens.

Download: SqlDbx Personal Edition 3.41

A new Java-based technology for programming dynamic web content. The obvious and common approach to this well known task is to combine mark-up and decision-taking information in one text. This means combining in one compact source HTML and operators of some general programming language. One old way of doing that is to embed HTML into a program e.g. writing print(““) in a CGI/C program. Another, more recent – to embed elements of programming language into HTML. There is also a symmetric way of doing things and Java Server Pages (JSP) technology is of that kind. Unfortunately that seems to be the only advantage of JSP.

HybridJava™ (HJ) is a new language that is a symmetric cross between Java and HTML and in this sense HJ is a direct successor of JSP. The great difference is that JSP processor is just a ‘template engine’ – it performs a blind text substitutions while HJ is a strictly defined compilable language that equally incorporates Java and HTML.

The immediate advantage of HJ over JSP is a dramatic drop of junk syntax of <% and %> delimiters that usually makes JSP pages barely readable. Another immediate advantage is earlier check for syntax errors.

Besides Java and HTML entities the HJ syntax has a simple but powerful support for code factorization and reuse. Widgets are defined in HJ code and that does not lead to any additional Java programming. Unlike known implementations of user-defined tags HJ widgets may have several named points of insertion. Recursive usage of widgets is supported. A unique feature is transparency of widgets for Java context when variables from a page are accessible in its widgets.

For each page the compiler generates a presentation Java class (P-class) with a method ($render) that, when executed, provides HTML output sent to the client. Code of widgets gets properly inserted into the generated class.

Pages may have a corresponding Java class for page state (PS-class) that contains session-persistent data of the page and/or methods operating on that data. The $handlePage is a special method known to and called by the framework. P-class is created as derived from PS-class so all the non-private members of the latter are plainly accessible in the former and thus in $render and in the page and widgets HJ source.

Widgets may have a corresponding Java class for widget state (WS-class) that contains session-persistent data of the widget and/or methods operating on that data. The $handleWidget is a special method known to and called by the framework. While processing a widget compiler generates access to identifiers defined in its WS-class. Together a widget plus its WS-class (when provided) constitute a component. The framework supports transmission of messages from a component to a senior component or to the page. Components declared as “shared” may be used on several pages with a single component data instance used.

HybridJava language is easy to learn for those who already know both Java and HTML.

HybridJava is free for non-commercial use.

Download: HybridJava 0.97