Guymon

Joomla: SQL 2 Excel

SQL 2 Excel ist ein recht spezielles Joomla 1.5 Modul, was aber sicher mal hilfreich sein kann:

SQL 2 Excel is a Joomla 1.5 module which allows you to deliver data from your database directly to your users as downloadable Excel files. Write any valid SQL query in the configuration of this module. The query is run when a user clicks the link and the current information in the database is delivered to the users browser as an Excel file.

Da man das SQL selbst schreiben muss sicher kein Modul für Anfänger, aber sehr praktisch wenn man weiß was man tun.

Vielen Dank für den Hinweis an Joomla Downloads

Yahoo! Query Language

YQL klingt auch spannend:

The YQL platform provides a single endpoint service that enables developers to query, filter and combine data across Yahoo! and beyond. YQL exposes a SQL-like SELECT syntax that that is both familiar to developers and expressive enough for getting the right data. Through the SHOW and DESC commands we enable developers to discover the available data sources and structure without opening another web browser.

Ausprobieren lässt sich YQL einfach mit der YQL-Console. Die Abfragen sehen z.B. so aus:

select title,abstract,url from search.web where query="pizza"

SQL JOINS Visuell Erklärt

Jeff Atwood unternimmt einen schönen Versuch SQL JOINS visuell zu erklären.

Zwar wird in den Komentaren darauf hingewiesen, dass die Visualisierung nicht jeden Fall abdeckt, trotzdem ein lesenswertes Posting.

PHP persistent MySQL connections

Der MySQL Performance Blog geht der Frage nach ob PHP persistent connections evil sind.

The reason behind using persistent connections is of course reducing number of connects which are rather expensive, even though they are much faster with MySQL than with most other databases. (…)

Lets talk now about why Persistent connections were disabled in mysqli extension. Even though you could misuse persistent connections and get poor performance that was not the reason. The real reason is - you could get much more problems with it.

Persistent connections were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough so you could recycle connections easily without any problems. In later versions number of problems however arose - If you recycle connection which has uncommitted transactions you run into trouble. If you happen to recycle connections with custom character set settings you’re in trouble back again, not to mention about possibly changed per session variables.

via phpdeveloper

Webbased MySQL monitoring Tools

Baron Schwartz untersucht auf onlamp.com Open Tools for MySQL Administrators

Sehr nützlich finde ich die beiden folgenden Programme:

There are two web-based mytop clones, phpMyTop and ajaxMyTop. These are useful when you don’t have shell access and can’t connect remotely to your database server, but can connect from a web server. ajaxMyTop is more recent and seems to be more actively developed. It also feels more like a traditional GUI program, because thanks to Ajax, the entire page does not constantly refresh itself.