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+.

SQL Buddy is an open source web-based MySQL administrator with an Ajaxed interface.

It requires no setup and works once the files are uploaded.

SQL Buddy handles logins with the MySQL user tables. Ordering & resizing the columns makes browsing easier.

Although browsing is mostly with Ajax, the application is browser back-forward friendly. And, it enables you to import/export to/from .CSV files.

Navicat, which is a powerful MySQL admin tool, is giving away 3 standard version licenses ($129/each) to WebResourcesDepot readers. You can find the details on how to win the licenses in the post.

Special Discount:

Navicat standard version licenses can be purchased with a %50 discount ($64.50 discounted price) during the giveaway, which will end 1 week later which will end at 08.21.2008 (updated at 08.08.2008) , via this link:

https://secure.shareit.com/shareit/checkout.html?PRODUCT[300175400]=1&COUPON1=promo08

What is Navicat?

Navicat is a feature rich & very easy to use MySQL admin tool with an intuitive interface that runs on Windows, Linux & Mac.

As a developer, I’m an user & fan of Navicat for 2+ years. I have used several web based or Windows-based applications but the easiest, fastest & least (even non) problematic application one for me was Navicat.

My favorite feature is "HTTP tunnel" which enables you to connect MySQL databases when direct connections can not be done (many hosting companies only allow local connections) by simply uploading a special PHP connector file.

Databases can be exported/imported between different formats like SQL, Excel, Text, XML, Access & more.

Another beautiful feature is task scheduling. You can run automated backups, tasks & get notified via e-mail.

Some other powerful features are:

• Manage databases, tables, records, stored procedures, triggers…
• SSH Tunnel for secure connections.
• Backup: backups your databases with few clicks and makes them easily reachable.
• Transfer data between local & remote databases (great when switching from test to production environment or opposite).
• Visual query & view builder.
• Server monitor: monitors process list, variables or status of MySQL servers.
• And many more. See the full features list.

Navicat also has a PostgreSQL version & they will be releasing an Oracle version tomorrow (Friday).

Conclusion:

As an user of Navicat, I strongly suggest any developer to use this great tool to save time & have more functional features.

And, the tool can be tried with a 30 day trial version.

How to win the giveaway licenses?

Just comment to this post with at least "I want the license" text besides any other comment.

Winners will be selected randomly from commenters 1 week later (08.14.2008) with the SQL query below:

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

Good luck to all : ).

P.S. Winners will be able to choose the OS version of the license to fit their needs.

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.

It is a time consuming process to create an admin interface with standard functions such as add-edit-delete-update again and again.

ActiveScaffold, a Ruby On Rails plugin handles all the ActiveRecords smartly. It adds add-edit-delete-update functionality with an Ajaxed interface & sorting, searching and pagination support.

ActiveScaffold features:

• AJAXified table interface for creating, updating, and deleting objects
• Automatic handling of ActiveRecord associations
• Sorting, Search and Pagination
• Graceful JavaScript degradation
• RESTful API support (XML/YAML/JSON)
• Sexy CSS styling and theming support
• More extension points than you can shake a stick at
• Guaranteed to work on Firefox 1+, IE 6+ and Safari 2+
• Released under the MIT License, the same one as Rails itself, so you can use it freely in your commercial applications.

htmlSQL is a PHP class for querying HTML using a SQL-like query.

It saves you from writing complex regular expressions to extract values.

htmlSQL example:

This query returns an array with all links that contain the attribute class="list".

Isn’t it great?

How to use?

You simply insert the PHP files from th download package and that’s all.