the "f" parameter in the UNIX tail command stands for "follow". Probably you have used it for logfile monitoring, a fantastic feature!

Now you can do the same in a MySQL table, using HeidiSQL: Just click Tools > Auto-refresh > Active (or press Ctrl+F5) to start monitoring a table's data:



This feature has been implemented moments ago. Select Help > Check for updates in HeidiSQL or go here to get the latest build.

A while ago Dries wondered about Contributing back to Drupal .

Now Inuits is not a Webshop, we are an Open Source shop, so you won't see a zillion Drupal modules being contributed by us in the near future (albeit there are a couple) , we are company assisting other organisations in their adoption of Open Source, and Drupal is amongst the projects we care for. You'll notice code from us in the different other Open Source projects, including the Linux Kernel and other core infrastructure. And not all of it was code, there is a lot of published documentation, methodologies, bughunting and also spreading the words, or talking about our experiences around different topics such as MySQL Cluster and Drupal, or different alternatives to Monitor , or to Monitor MySQL etc ..

But we've been contributing in …

Wow, big wins for NetBeans (best IDE, best Java tool, best development utility (profiler), best mobility tool, best open source product) and MySQL Workbench (best database tool). This is particularly impressive for MySQL Workbench given that it's quite new. Congratulations!

http://www.developer.com/java/other/article.php/3795991

This may come as a complete shock based on the title of my website… but I have come to the conclusion that all DBA’s should be eliminated from all companies hierarchies. WHAT? Yep I do not think any company should employ a “DBA” ever again.

Before the mob comes and beats me up for heresy, Let me explain. The term and more specifically the job title “Database Administrator” is way to broad. More so then most titles in my opinion. In fact I feel it is an ancient description that does a disservice to most modern database professionals. I have seen titled DBA’s responsible for entire infrastructure stacks, and I have seen DBA’s who only know how to run SQL and perform backups. It hardly seems fair that all these folks end up lumped in together. I think we need better definitions and a somewhat common vocabulary to truly tell what sorts of tasks and responsibilities people have.

Winners of the Developer.com Product of the Year 2009 have been announced and you won’t be surprised to know..

NetBeans is certainly back with a bang ! We won FIVE awards out of TWELVE..

Here’s an excerpt from the announcement,

In the past due to close races, runner ups were also recognized. This year there were no close calls. Each winner won its category with a respectable margin.

In the case of Java Tools the winner had almost three times the votes of the others finalists in the category combined.

It is no surprise that the Development Tool category received the most votes. The second most popular category continues to be Open Source. Looking back …

There's a lot to be said that's positive about our declining economy. (Yeah, it's an odd beginning. But hang in there with me.) In the publishing industry, for example, we're having to be a lot more careful about what products we release. We're also having to be more efficient in our products; people want more for less.

As part of that, we've been doing a lot of thinking about non-book products. O'Reilly has offered books through Safari for a long time, and there's certainly the O'Reilly School of Technology. But what about folks that want traditional book topics, like JavaScript or PHP & MySQL, in a non-book form? These people don't necessarily want or need course credits, but they expect more than a PDF-style view of a book.

When you start to think about effective learning in an online medium, one the very first …

Working with localized data is one of the widespread problem our users encounter with. We try to cover the following questions in this article:

• How MySQL server works with textual data
• How to correctly set encoding when working with dbForge Studio for MySQL and dbForge Fusion for MySQL
• Widespread errors when working with textual data

Note: In the article examples, cp1251 is set as Windows code page*.

How MySQL server works with different character sets

Server has the following options for working with data with different character sets: character_set_client, character_set_connection, and character_set_results. They are set at the server side when installing MySQL server. Default settings are latin1. The set names command changes all the three options for your session. We will call this option set the connection character set or …

Microsoft released Windows 7 Beta 1 - the next major version of Vista, download here. There are tons of improvments mostly centered around making the content easily & intuitively accessible. But hey, Mac OSX already serves that purpose well for quite some time ;-)

But I still want to make sure that our Rails stack (NetBeans, GlassFish, and MySQL) work fine on it. And it very well do, without any issues, as you'll realize at the end of this blog :)

Lets first get started with installing Windows 7 Beta as a Virtual Box image. Few points to note here:

• Only IE can be used for downloading …

Now that the core of Gearman is rewritten in C, I’ve started working on a new module to provide persistent queues and queue replication. The current Gearman implementation is fine when the jobs can be unreliable, but there are many cases when we want to guarantee that jobs get run.

Because Gearman is such a flexible system, there are a couple of places where we can plug in a persistent queue and/or replication. Now, in most cases, these features are only going to be useful for background jobs since failed foreground jobs can be detected and restarted by a client. Many applications using Gearman want to just throw a job in the queue and go back to doing something else, not caring when it gets done. Enter persistent queues. It may also be the case that a job should be run multiple times, mot likely on a separate set of servers for backup and geographic redundancy. I’m currently …

Wheel of protocol, turn turn turn.
Tell us the lesson that we should learn. (with apologies to the original source)

Writing a book comes with many challenges. For me, writing a MySQL book for MySQL beginners, who may or may not be database beginners, has fed my compulsion to research and test bizarre interactions.

Today’s lesson is on what protocol is used when connecting to a local mysqld instance on a non-Windows machine. The TCP/IP protocol is used by default when connecting on a Windows machine, and connecting from any operating system to a non-local mysqld instance. I am assuming the connections are being made by a command line client such as mysql, mysqladmin or mysqldump. Connections made via …