While creating web applications, finding data we need can be a very difficult process. Whether it is a signup page that requires all countries/cities or a "restaurants directory" which needs the data of restaurants.

Factual is a website which can be a quick solution for reaching data. It is a free-to-use platform where anyone can share & mash open data on any subject.

There are lots of different data tables provided like:

• Video Games & Cheats
• Popular Books of the 1990s and 2000s
• Hiking Trails
• American Idol Finalists
• Beer Qualities
• & much more

It is possible to view the data in a table form, make changes, filter or export as a CSV file. Also, all data can be reached via Factual API which we’ll probably be seeing lots of applications built around it.

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.

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.

MySQL Ajax Table Editor has permissions support which can be set on a per column or table basis for limiting functions.

Users can hide/show & re-order columns which is very useful when working with the data.

The application works with both PHP4 & PHP5 and comes with 5 ready-to-use languages where new ones can be created.

Webyog, a company who creates innovative database tools, is giving away $1300 worth of products to WebResourcesDepot readers:

• 3 SQLyog Enterprise – MySQL GUI ($99/each)
• 1 MONyog Unlimited Servers – MySQL Monitoring Tool ($999/value)

Details on "how to win the free licenses" can be found at the bottom of the post, but before that:

What is SQLyog?

It is a powerful MySQL manager and admin tool that makes controlling multiple databases so easy with features like:

• query profiler
• visual query & schema designer
• scheduled backups
• data synchronization
• HTTP(s) & SSH tunneling

besides the standard database management functions the application offers.

SQLyog MySQL GUI uses the native MySQL C API for the fastest communication with servers & offers a 100% keyboard-friendly usage.

What is MONyog?

It is a very well-thought software to help MySQL DBAs manage more MySQL servers, tune MySQL servers and fix problems with their MySQL database applications before they can become serious problems.

It is installed on any computer & monitors MySQL servers remotely.

With amazing features like:

• history/trend analysis
• quick performance tuning & optimization
• analysing slow query logs
• MySQL hacking attempts detection

MONyog is a time-saver & must-have for every database administrator.

How to win the free licenses?

Commenting to this post is enough to join the giveaway & winners will be selected randomly via the query below on 25 August 2009 (1 week later).

SELECT * FROM wp_comments WHERE comment_post_id=1111 AND comment_approved=1 AND comment_type='' GROUP BY comment_author_email ORDER BY RAND() LIMIT 4

Good luck to all : ).

P.S. Both applications offer free trials which you can see how functional they are before purchasing.

Adminer is a phpMyAdmin-like MySQL management application which is only 1 file (PHP) that makes it so easy to install.

It is multilanguage with 11 ready-to-use language files & supports most PHP & MySQL versions (PHP 4.3+, MySQL 4.1+).

Adminer can connect to local/remote MySQL databases, create new ones & complete almost every other database transactions like:

• Create, alter, drop indexes/foreign keys/views/stored procedures & functions
• List data in tables with search, aggregate, sort and limit results
• Insert new records, update and delete the existing ones
• Supports all data types, blobs through file transfer
• Execute any SQL command from a text field or a file
• Export table structure, data, views, routines, databases to SQL or CSV
• Print database schema connected by foreign keys
• Show processes and kill them
• Display users and rights and change them
• Display variables with links to documentation
• Manage events and table partitions (MySQL 5.1)

phpMyBackupPro is an open source application for taking scheduled backups of MySQL databases & FTP files.

It offers a flexible usage as backup jobs of multiple databases/files from multiple servers can be scheduled, completed & compressed.

Backups can be taken to any location including remote FTP servers.

Besides taking backups, phpMyBackupPro can restore & e-mail backups. As a third option, it is also possible to download them.

The application has mutlilanguage support & 10+ language files are ready for download.

Navicat, an impressive database admin tool which has versions to manage specific databases is now offering an unique tool named Navicat Premium which can manage:

• MySQL
• PostgreSQL
• Oracle

within a single application with amazing features.

Navicat Premium allows you to control these 3 database types like they are the same & saves you too much time. You can:

• drag’n drop tables from Oracle to MySQL, PostgreSQL to MySQL and vice versa
• schedule operations for different databases such as print report in MySQL, backup data in Oracle and synchronize data in PostgreSQL to run automatically

The application comes with all the nice features of the Navicat family:

• advanced import/ export wizard
• query builder
• report builder
• data synchronization
• backup
• job scheduler
• & more

For anyone who works cross-database, Navicat Premium is a must-have software that removes all the headache of working with multiple applications & compatibility problems between databases.

It is available for two platforms – Microsoft Windows and Mac OS X.

Special 50% Discount to WebResourcesDepot Readers:

Navicat is offering a 50% discount to WRD readers for Navicat Premium. To get the discount, you need to choose the "Shareit" as the payment option and use the coupon code: webpre50.

Note: Discount will be available for 2 weeks starting today (until 17 July 2009)

One Navicat Premium License Giveaway (How To Win It?)

To get a chance to win a free license ($369 value) of this beautiful application, simply comment to this post with your thoughts. The winner will be selected randomly on 10 July 2009 (1 week later) randomly via the query below:

SELECT * FROM wp_comments WHERE comment_post_id=1028 AND comment_approved=1 AND comment_type='' GROUP BY comment_author_email ORDER BY RAND() LIMIT 1

Good luck.

SQLServerPedia is a wiki that is concentrated on SQL Server that is edited & administered by SQL Server professionals.

There is a serious amount of content that is well-categorized & easy to reach. Some of the categories are:

• Architecture & configuration
• Monitoring SQL Servers
• Performance tuning & more..

There are also various podcasts which are great for watching & learning the details from professionals.

And, besides the editors, there are bloggers & other contributors who help the content get wider.

For any developer who is into SQL Server, SQLServerPedia is a must-bookmark.

WWW SQL Designer is an open source application that enables anyone to create database schemas from a browser.

It supports most of the database features like:

• keys
• foreign key constraints
• comments
• indexes

Once a database schema is created, you can:

• save your design to modify later
• print it
• export as SQL script

It is possible to retrieve (import) schema from an existing database.

MySQL, MSSQL, SQLite & Web2py are supported.

A fully-functional demo can be found here.

MySQL Sidu is a free web based MYSQL GUI similar to PHPMyAdmin.

It has most of the features other GUIs have & besides them MySQL Sidu can:

• Group tables by first x chars of table names, and which you can control freely;
• Sort results in 1 column or 2 columns, which you can switch to your favorable mode;
• Sort & filter results.

There are 2 firewall security levels for the GUI for a safer data: user & global levels, that control who can access the application.

For anyone using another web-based MySQL GUI, it is very hard to switch to another tool & you may not need it. But this application has some nice UI features that make some jobs easier and you may want to check.

There is also a Firefox addon for MySQL Sidu that enables you to insert data from text fields & textareas in a webpage.

VFront is a dynamic front-end for MySQL & PostgreSQL databases written in PHP and Javascript.

It is not a database administration tool like phpMyAdmin and not replacing it: interface is for basic user working on data. Think about VFront as an interface tool for database, similar to MS access, but taking the lead with an easy access via web.

Using VFront, masks for managing your data in AJAX style, different rules and privileges for groups can be created.

It has reporting features in XML,HTML,PDF, statistics and much more.

To run this application, the database must be MySQL 5+ or PostgreSQL 7.4+.