MySQL Command Line Client Tips

If you’re interested in getting to know the native MySQL command-line client better, here are ten handy MySQL CLI tips that could save you a lot of time and effort. Here are some of the subjects it covers in this lengthy post: Automating the login process Automatically switch to a database Send commands from a […]

Building Facebook

Here’s a fascinating video and slideshow of a presentation given by Facebook’s Director of Engineering, Aditya Agarwal talking about Facebook architecture and how LAMP (PHP, MySQL), Memcache, Thrift and Scribe hold it all together. Exceptionally clear and detailed. As big a part as Facebook is now playing in everybody’s life and as big of an […]

Securing MySQL

Code Sherpas have a good article on how to secure MySQL; the author is careful to point out that this is not meant to be an authoritative guide on security relative to a mysql servers, but I think it is a very good quick reminder-type reference to have on hand the next time you do a […]

MySQL Queries Reference

One thing I’ve learned from writing for Digital Media Minute is how much I appreciate a nice collection of facts/examples/information on a subject, for reference as time-savers later on.  I’m not even sure exactly where I ran across this one, but here’s a great listing of MySQL Queries with links to descriptions/definitions of each, to […]

MySQL ERD Tool

A self-proclaimed ‘old school database guy’, Cal Evans gives us an honest and pretty thorough review of the latest version of MySQL Workbench –worth your time if you’re not happy with the MySQL ERD tool you use now, or even if you are. He aims for a real-world simulation test of the workbench, with 18 […]

Building Ruby, Rails, Mongrel, and MySQL on Mac OS X

Dan Benjamin has updated his awesome instructions for Hivelogic – The Narrative – Building Ruby, Rails, Mongrel, and MySQL on Mac OS X. I’ve used these instructions in the past and they work great. The advantage of his method is that you compile the software from source (don’t be afraid it’s really easy) so you […]

MySQL Performance Tuning Best Practices

Jay Pipes – co-author of Pro MySQL – recently spoke at Google on MySQL Performance Tuning Best Practices. You can watch the full video of his presentation to learn more about tuning your database applications.Among other things the topics that Pipes covers in this 40 minute talk include: profiling and benchmarking core concepts  sources of problems […]

Vanilla Goes Gold

My new favorite web-based discussion forum software Vanilla, has just left beta! Version 1.0 is definitely worth a look. This simple and elegant forum software is easy to install and use. It is coded with PHP and MySQL so makes a nice match with most hosting packages. The UI makes good use of AJAX, so […]

Free Open Source Basecamp Clone

activeCollab is a free open source project management and collaboration tool. Like a Basecamp open source app, this web-based application is very similar to 37 Signal‘s Basecamp project management tool, but instead of a hosted service, activeCollab is an application you download and install on your web server. The tool requires PHP and MySQL, so […]

Convert MS Access To MySQL

It continues to amaze me the number of times a client give us an Access database that needs to be converted to a web application. One of the tools I have found to work really well at making the conversion is Access To MySQL. It is a free utility that will help convert your Access […]

PHP MySQL to JSON Class

MySQL to JSON appears to be a very useful PHP class that will convert data from MySQL query results into a JavaScript expression in JavaScript Object Notation (JSON).  Take a look at this: It takes a MySQL query result handle and retrieves the query result column names and the query result data. The class generates […]

Managing MySQL on Mac OS X

Your new Mac makes an excellent web application development system and a great database to power that web app is MySQL. O’Reilly’s MacDevCenter has an article that will help you with Managing MySQL on Mac OS X. Their coverage includeds installing mySQL then getting a GUI based tool to manage your databases– the MySQL administrator […]

Simple Optimization Tips for PHP and MySQL

Looking to make your PHP scripts run a little faster? Check out these Simple Optimization Tips for PHP and MySQL. This is an outstanding little tip sheet with about 20 tips along with code snippets and examples to illustrate. Probably the most valuable thing about this post ironically however its 472 comments! It’s an almost […]

The Best Coding Reference

Quick Lookup is simply the most amazing web programming reference I have come across in quite a long time.  It is an AJAX enabled tool that allows for quick lookup of syntax for PHP, MySQL, JavaScript and CSS.  You can load it into your sidebar for easy access. As you probably will agree if you […]

Database-Driven Tree Structures with XML and XSLT

Pascal Opitz from the Content with Style blog has a fantastic tutorial on creating : Database-driven tree structures with XML and XSLT. The technique uses the preordered tree traversal method on the database, then uses PHP to create the XML that is then styled with XSLT.  I know this is going to be of interest […]