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.
Agave Group has released a very good Priority / To-Do / Keep-track-of-stuff List web application. It’s a pretty slick open-source product that uses lots of AJAX mixed with PHP and MySQL. The download info is available in a separate post.
TurboDbAdmin is a single-page AJAX solution for exploring and editing databases from a browser. Edit data just like you would in a desktop application, without submit buttons or page refreshes. This release supports: navigating to and browsing table data, viewing table schema, and editing table data. TurboDbAdmin requires a web server, PHP 4 or higher, and MySQL 3 or higher.
MySQL has just announced the availability of MySQL 5.0 Release Candidate. This version includes many new features including:
To provide a little extra motivation to testers, they will be giving away Apple iPod nanos, and full conference passes to the 2006 MySQL Users Conference, to those who deliver the most valuable feedback.
Matthew Mullenweg, the creator of WordPress, has a post that shows a nifty SQL statement. First Letters is a simple statement that will return a list that counts the number of records based on the first letter of a specified field. Handy for building a sorting feature based on the first letter (ie. a | b | c | … x | y | z)
With the recent release of the MySQL 5.0 beta, the people at MySQL have releases a series of four PDF documents outlining and explaining some of the great new features in this popular open-source database server:
The articles contain lots of code examples to get you started with this new version.
I recently upgraded my MySQL server from version 4.0 to version 4.1 and got a Client does not support authentication protocol… error when attempting to connect to the server using a GUI front end. Turns out that the latest versions of MySql uses a new format for the password, so older client can have problems connecting the laterst version of the server. To find out how to fix this problem, check out the tutorial at Digital Peer.
MySQL Version 4.1 has been certified by the company as production-ready for large-scale enterprise deployment. This significant upgrade to the MySQL database server features advanced querying capabilities through subqueries, faster and more secure client-server communication, new installation and configuration tools, and support for international character sets and geographic data.
The MySql 4.x Database Survival Guide is a nice summary and good jumping off point for anyone new to the MySQL database server. Lots of good tips and examples from database backups to recovering from password problems.
Access 2 MySQL is a free utility from BullZip that will convert your Access databases into MySQL.
