Ever wondered about the frequency of a particular tag or tags over time? The SQL query below can quickly mine that information from a Drupal database: select count(*), mons from ( select n.nid,n.changed, t.tid, DATE_FORMAT( FROM_UNIXTIME(n.changed), '%Y%m') mons from node n inner join term_node as t on t.nid=n.nid where t.tid=14769 group by n.nid) as trm_x_node...

You probably know that CeBIT is going full force, right now. As you would expect from a leading IT and telecom trade fair, loads of new interesting solutions were presented. However, one stands out, right away. Not so much with its features but rather by price - $1,500 for a keyboard? And it’s not even...

pru·dent [prood-nt] - careful in providing for the future; Mike Cannon-Brookes of Atlassian recently wrote a wonderful blog post about successful hiring practices. A related, interesting subject is the matter of discipline, often emphasized by HR professionals. Apparently, well-organized individuals are better workers, or so they tell us. Well, we know it is not necessarily...

According to Caucho, you can run Drupal in Java now. Following is the excerpt from Quercus website: “Quercus is Caucho Technology’s 100% Java implementation of PHP 5 released under the Open Source GPL license. Quercus comes with many PHP modules and extensions like PDF, PDO, MySQL, and JSON. Quercus allows for tight integration of Java...

The next Washington, DC, Drupal Meet-up will be on Wednesday, March 14th, at the Science Club (1136 19th Street, NW) at 7pm. You can find more information in Eric’s announcement.

We have all heard about the relaxed corporate atmosphere at Google. Nothing wrong about that. In fact, it’s awesome. However, aparently somebody at Google’s external communications (or whatever the department is called there) thought it was a good idea to share a piece of internal “nerdiness” with the public at large. Recently, they have published...

Adobe (ex-Macromedia) Flash is a core technology of today’s Web. Unfortunately, it got a wrong start back in the days. Many designers sold their souls to the unprecedented opportunities offered by graphical web and forgot that Flash is a complement to HTML, not - a replacement. This confussion ended us in the initial flood of...

BMW gets it. Watch the phenomenal integration of Google Maps and German manufacturer’s navigation system.

Even though Russian is one of the few languages i can speak and I have worked on both the internationalization of Web applications, as well as Java quite a lot, in the past, particular problem of Russian i18N has never come to my attention. That is - until now. Unfortunately, I was unpleasantly surprised as...

Or: how can you install FFMPEG encoder on Linux? How many times have you been annoyed by online videos in different proprietary streaming encodings? Have you looked at the beauty of Youtube, Google Video, Revver etc. with owe? Did you envy the way they accept long list of different encodings, re-encode them into FLV and...

A transaction in the database modifies data. Due to its impotance, any extra care and security you can apply to a transaction, can pay back big time in a critical situation. There is one measure which is relatively easy to implement in MySQL and can save you a lot of headache if something goes south....

A lot of nice Drupal themes have HTML body styled with fancy backgrounds. Unfortunately, most of the theme authors do not test their themes with a popular WYSIWYG editor module TinyMCE. If they did, they would notice how bad the text entry window looks with their themes on: As you can see, the body background...

You can do it very easily using IcoMaker. Just compose the ico as a GIF in any editor of your choice, save it. Start IcoMaker, go to “New Document”, import your existing image with File->Include Image, then save. That’s it.

In Drupal 4.7 and 5.x correct way to add your custom Javascript onload events is to a) Make sure there is no onload attribute on HTML body tag. b) Make sure you are not calling window.onload= directly c) Insert the following snippet, in the generic section (outside any methods!) of your module’s javascript file: if...

If you noticed that your Firefox installation takes significant time to connect to websites, there may be an easy solution. It will take you 30 seconds and save you a lot of time/annoyance in the future. So: Type “about:config” in the address field and have Firefox open it as if it was an Internet URL....