Tag Archives: MySQL

PHP on Google App Engine – Quick First Review

This is fresh out of the news (Ars; Wired; WHIR; VB), and what Google wants to offer looks like a very cool package. So if you hadn’t had the time to view the video, here is a quick summary and … Continue reading

Posted in Features, Hakre's Tips, PHP Development, Pressed, Reports, Tools | Tagged , , , , , , , , , , , | 7 Comments

Prepared Statements

In Programming With Anthony – Prepared Statements (by Anthony Ferrara; 12 Dec 2012) the author needs only two minutes and 17 seconds (Youtube Video) to explain *Prepared Statements*. Worth to watch. See as well the Playlist of Programming With Anthony … Continue reading

Posted in Hakre's Tips, Linked, PHP Development, Pressed, Surviving the Internet | Tagged , , , , , , , , , | Leave a comment

WordPress Database Charset and Collation Configuration

Pootzko over at this years new Q&A site for WordPress Administrators and Integrators was wondering why creating database tables via wpdb->query() / SQL didn’t reflect his worpdress collation settings. As it was not obvious for him, I thought about writing … Continue reading

Posted in Hacking The Core, Hakre's Tips, Pressed, Reports | Tagged , , , , , , , | 5 Comments

Mysql Batch Mode – Handle Multiple Tables with Ease

MySQL has a batch mode that takes any SQL command from a file: where batchfile contains the sql commands, e.g. one per line. This can save some inter-action. I just wanted to upgrade some web software. But I didn’t wanted … Continue reading

Posted in Hakre's Tips, Pressed, Uncategorized | Tagged , , , , , , , | 2 Comments

freshly served: oclHashcat v0.19

The kitty catty on speed (oclHashcat) is there with a new release. oclHashcat uses specialized attacks ported from hashcat (a CPU based variant) that reflects both: GPU and hardware architecture (the way how specialized chipsets are integrated into the personal … Continue reading

Posted in Pressed, Reports, Tools | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 1 Comment

WordPress Single-Sign-On Preview

I’m currently working on a more detailed article related to wordpress and single-sign-on. It is a nice topic and because of that I started to create some concept art now that should picture the whole thing. That is a sample … Continue reading

Posted in Pressed | Tagged , , , , , , , , , | 10 Comments

WordPress Administration Hell

Friday night was a little longer yesterday. I had to migrate and upgrade three wordpress 2.3.x based blogs to a new server. When you look at the version number you can be pretty sure that all those three moves and … Continue reading

Posted in Hacking The Core | Tagged , , , , , , , , , , , , , , , | 3 Comments

Chive – Webinterface for your MySql Database

Chive wants to offer a more modern webinterface to your MySQL database. It’s doing so by those features: Syntax highlighted SQL Editor Re-Use of Queries by Bookmarks Search while you type Inline Editing for Rows and Tables Supports Views, Routines … Continue reading

Posted in Pressed, Tools | Tagged , , , , , , | 4 Comments

WPDB include problems in wordpress 3.0

From time to time my brain remembers me that there is a major bug within wordpress in case of the re-instantiation of the wordpress database class. When a replacement class is in use, the original WPDB one will get re-created … Continue reading

Posted in Hacking The Core | Tagged , , , , , , | 4 Comments

mysql_real_escape_string and SET NAMES

In #11819 I was so hardly looking for a clear documentation for mysql_real_escape_string() combined with the usage of SET NAMES. I finally found it where I should have looked first: within the MySQL manual. PHP is using the MySQL client library … Continue reading

Posted in Hacking The Core | Tagged , , , , , , | Leave a comment