There are various PNG optimizer apps for Mac OS X (check this WRD article for them) but only a few for Windows.

PNGGauntlet is a free Windows application for squeezing each and every byte in PNG files.

With a very nice drag 'n' drop enabled user interface, the application can optimize any given number of files pretty quickly.

It combines the algorithms of PNGOUT, OptiPNG, and DeflOpt for creating the smallest file and generates a lossless output.

The image to be minified doesn't need to be in PNG format, other popular formats can be used as well for converting them to PNG.

There are also several settings for anyone looking to fine tune the compression process.

Find my Font, a very useful desktop font identifier application, is giving away 5 Pro licenses ($69/each) to WRD readers.

Details on joining the giveaway can be found at the bottom of this post and here is what this tool offers:

What is Find my Font?

We sometimes see a beautiful logo and wonder which font is used to create it. Guessing and try-catches is the popular method for reaching to a result but it takes time and usually hard.

Find my Font is a desktop application (with Windows and Mac OS X versions) that can identify a font used in images and helps browsing your font library.

It works by selecting the letters in the image and asks us to type these letters and runs a quick scan within the fonts in our system (any number of font folders can be defined) to find the ones with the closest match.

The great thing is that the application doesn't only return a single result but also lists and orders the fonts according to their similarity score which is handy for finding alternatives.

Find my Font has an easy-to-use toolbox for taking screenshots, rotating images or selecting letters to make sure that the image to be analyzed is ready for a scan.

As mentioned previously, the application is also a font browser where you can type a text and quickly see how it looks. Also, the scan works during browsing fonts so that the alternatives to the system fonts (or their duplicates) can be instantly catched.

How to join the giveaway?

Find my Font is giving away 5 * Pro licenses and it is enough to comment for joining this giveaway -and let us know you favorite font in the comments which can help other commenters meet new lovely fonts – totally optional : )-.

Winners will be selected randomly with the query below on 13 Dec 2011 (a week later):

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

Good luck to all.

And, the winners

The winners are selected and here they are:

• Aldo (comment #454823)
• Josh D. (comment #457922)
• NRL (comment #454441)
• Robert Barcus (comment #454262)
• Webster (comment #455313)

Congratulations..

The giveaway for the popular MySQL admin tool SQLyog has ended, winners of 5 Single Developer Licenses with premium support ($179/each) are selected and announced below.

Here is a short re-introduction of the product in case you are not one of the winners but considering a purchase (btw, a trial version exists).

What is SQLyog?

It is a desktop application for managing any number of MySQL databases that run on any number of hosts.

SQLyog handles creating/editing and deleting databases, users, tables and records like a breeze.

The application can import/export data (CSV/XML/HTML/Excel) and backup or restore databases/tables. It can even run such commands (or any other commands/queries) as scheduled tasks.

There are many other advanced capabilities offered like:

• index analyzer
• schema optimizer
• query profiler
• SQL formatter
• visual query builder and schema designer
• and more..

SQLyog works on Windows and can be used on Linux or Mac OS X devices with the help of Wine.

The winners

Here are the winners of 5 Single Developer Licenses with premium support:

• Matt Rogowski (comment #396714)
• Albena Patleeva (comment #399389)
• Angel Velichkov (comment #399388)
• Marcin Kłeczek (comment #396999)
• Martin (comment #396683)

Congratulations to the winners and thanks to everyone for joining the giveaway.

SQLyog, a powerful MySQL admin software, is giving away 5 Single Developer Licenses with premium support ($179/each) to WebResourcesDepot readers.

Detailed information on "how to join the giveaway" is provided at the bottom of this post.

What is SQLyog?

It is a MySQL GUI application with a user-friendly interface that offers many features for easily managing a MySQL database.

The application can control any number of databases in any number of hosts (can also connect to firewalled MySQL servers via HTTP(s) or SSH tunneling).

SQLyog does everything we can expect from a MySQL admin software like: CRUD operations on databases/tables/records, running custom queries, backup-restore and import-export (CSV/XML/HTML/Excel).

Also, it has many other advanced capabilities like:

• index analyzer
• schema optimizer
• query profiler
• SQL formatter
• visual query builder and schema designer
• and more..

There is a scheduling engine that can run any of the tasks at a given time for once or regularly. A very handy feature for regularly optimizing a database or taking backups.

It can also work as an interface for data-entry, thanks to the form-view support. And small-but-useful stuff like auto-complete or 100% keyboard support makes such usage much easier.

SQLyog is available for Windows and can be used on Linux or Mac OS X devices with the help of Wine.

How to join the giveaway?

SQLyog – MySQL admin tool is giving away 5 Single Developer Licenses with premium support. In order to join the giveaway:

• Share this giveaway with a tweet: "Just joined the @webyog SQLyog – MySQL Admin giveaway at WebResourcesDepot – http://goo.gl/igJKg" (click to tweet easily)
• Follow @webyog Twitter user
• Share your tweet URL within the comments

The winners will be selected with the query below on 22 September 2011 (1 week later):

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

Luck is believing you're lucky (by Tennessee Williams).

Antialiaser is a free application that eases OpenType and TrueType font visualization and customization for using them inside Flex and AIR projects.

Using the application, it is possible to use any font, fine tune them and get the generated CSS.

Its interface shows the system + embedded fonts, standard + zoom view and has various options like activating transparent background, comparisons and snapshots.

Advanced and beginner Flex developers will probably both find the application useful for a better typography in their projects.

Antialiser comes with versions for for Windows and Mac OS X.

Subversion, the open source and popular version control system, is a great tool for an organized coding environment where multiple users can work on the same files and tracking the changes/versions is possible.

uberSVN is a free application which transforms a standard Subversion setup into the next level by adding social features and more to it.

With the application, teams get a homepage that profiles the team members, lists the projects they’re working on, repositories they’re using and their latest activity and status.

Team members can see each other’s real-time progress by simply subscribing to Twitter-like feeds that managers can also monitor.

Besides managing Subversion, 3rd party applications can be integrated into the system (like Trac, Jenkins, etc.) so that the development team uses only a single login for managing projects.

uberSVN comes with installers for Windows and Linux.

MyDB Studio is a free MySQL database manager application that has almost every feature you can expect for.

It can connect to an unlimited number of databases. If they are behind a firewall or local-only, there is support for SSH tunneling to overcome that.

Databases, tables and records can be created, edited or deleted, they can be backed up/restored and exported into multiple formats.

The interface of MyDB Studio is very friendly, switching between data and design views is very fast and treeview of databases>tables>columns helps working effectively.

There is a WYSIWYG editor or designing and running SELECT queries on single or multiple tables.

And, as an original feature, it can automatically create PHP code for displaying data from tables.

P.S. The application is currently Windows-only but a cross platform Adobe AIR version is on the way.

Hub List is an open source to-do list application that works on the desktop.

It has versions for Windows, Mac OS X + Linux and a mobile one that mostly targets the iOS platform.

The application supports creating folders>sub-folders and tasks>sub-tasks for an unlimited hierarchy.

Hub List is currently in beta status and working on impressive features like auto-synchronize data to any private cloud, collaboration and importing-exporting data.

SOFA is an open source statistics, analysis, & reporting application that can collect data from a selected source.

It doesn't force you to work with an offline data and can connect to various live databases including:

• MySQL
• SQLite
• PostgreSQL
• Microsoft SQL Server
• Microsoft Access

by just mentioning your login details. After that, you can customize the reports to be generated by selecting any columns from the tables and by applying filters.

Optionally, it is possible to import data from Excel spreadsheets, ODS spreadsheets, CSV files and Google Docs spreadsheets.

SOFA creates beautiful and interactive HTML outputs (powered with JavaScript). Also, it has tabular outputs that can be directly opened in MS Excel or pasted into OpenOffice Calc.

If small things change in your dataset, you don't need to re-import data but they can be edited manually.

There are many ready-to-use reports like row and column percentages, mean, median, standard deviation, min – max and more.

Unify is a software, powered by Deutsche Telekom, which provides a common API developing cross-platform applications that will look and feel like native ones.

It makes use of HTML5, CSS3, JavaScript and other resources like qooxdoo, PhoneGap, Adobe AIR and Sass.

The code can be re-used between platforms and supported ones are iOS, Android, WebOS, Windows and Mac OS.

Unify also eliminates the traditional limitations of the web browser and can detect the current geo location, access the file system, etc.