Guymon

Joomla! 1.6: Datenbase Changes

Ein Post auf the art of joomla erklärt einige Änderungen im Umgang mit Datenbanken in Joomla! 1.6.

In respond to requests for better future support of other database engines, like MongoDB, MSSQL, et al, Joomla 1.6 introduces a new query builder class that developers can optionally take advantage of. This class allows you to build queries in the order that make sense to you are a developer rather than in the strict SQL format. (…) Joomla 1.6 (has introducde) the jos_extensions table. This table absorbs the jos_components and jos_plugins tables, and adds meta information about all the other installed extension types: modules, templates and plugins.

Database Version Control

Harrie Verveer schreibt im techPortal über Database Version Control. Spannendes Thema weil das lange nicht so einfach und verbreitet ist wie seinen Quellcode unter Versions Controlle zu stellen.

Database version control is something that most developers have to deal with regularly, yet only a few have actually thought about what solution might be best for them. Most people have a solution that sort of works for them, but when you ask them about the subject they are pretty convinced that there must be some better way to manage database changes, they’re just not entirely sure what that solution is – but the silver bullet must be out there somewhere, right?

This article will give you a bit more insight into the theory behind database version control, and gives you several suggestions on how you could deal with the problem. We will look at simple solutions and also take a look at some of the tools available to help.

Drupal: Convert MyISAM to InnoDB

Drupal 7 wird InnoDB statt MyISAM verwenden. Auf Higher Visibility zeigt ein Post wie man die Konvertierung bestehender Drupal 5 und 6 Installationen angeht, denn

…we are going to just skip over a lot of that apprehension and get down to point of this article - there’s no good reason not to hop right into using InnoDB today on your Drupal 5 or Drupal 6 site. The rewards are; a possibly significant improvement in performance, a definite improvement in scalability, and you’ll start getting used to working with what will be more and more common in your Drupal-life, InnoDB.

phpMyAdmin Alternative

Adminer scheint eine schlanke, funktionale Alternative zu phpMyAdmin zu sein.

Adminer (formerly phpMinAdmin) is a full-featured MySQL management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server.

Ich habe es gerade mal auf einem Testserver ausprobiert und denke Adminer wird bei mir nun häufiger zum Einsatz kommen.

UTF-8 in PHP und MySQL

Das Handling von UTF-8 in PHP und MySQL ist noch immer nicht so bequem wie es sein sollte, darum hier ein Posting von Rob Allen: UTF8, PHP and MySQL.