Tutorials by ONLamp.com
Conventional wisdom claims that it's difficult to model hierarchical relationships in relationally minded SQL. Actually, it's easier than you think. Joe Celko explains one method of representing trees in SQL.
July 30,
2008
Today Views:
2 Total Views:
173
MySQL Cluster is a powerful peering system to add high availability and replication across multiple database servers. It's not perfect, though. Using features of MySQL 5.0 and 5.1, it's possible to build a master/slave replication system with fail-over.
July 29,
2008
Today Views:
2 Total Views:
173
Developers often write open source software in public, but what about developers who write about open source software? Do they build tools? How do your favorite books come about?
July 28,
2008
Today Views:
2 Total Views:
131
A new MySQL storage engine allows you to use tables in remote servers as if they were local. Unfortunately, the documentation doesn't explain much more than that.
July 25,
2008
Today Views:
2 Total Views:
128
Many SQL queries misuse their FROM clauses. Misuse them? That's right. Stephane Faroult explains this common mistake and demonstrates how two types of subqueries can improve performance and reliability.
July 21,
2008
Today Views:
1 Total Views:
102
Managing a database by hand with command-line tools is possible, but it can also be tedious. Some web-based administrative tools are good, but there are advantages to graphical desktop applications, as well.
July 17,
2008
Today Views:
1 Total Views:
97
MySQL 5.0 promises trigger support. What will it look like? How will it work? Peter Gulutzan takes MySQL triggers for a test-drive.
July 15,
2008
Today Views:
1 Total Views:
108
PHP 5 has greatly improved object-oriented programming support. It also has new hooks to overload methods and properties. How can you do this? Why would you want to?
July 11,
2008
Today Views:
2 Total Views:
93
The most popular "proper" way to build a web application seems to be to use the Model-View-Controller design pattern. While it sounds complex, the concepts are sound and the ease of development it provides are compelling.
July 9,
2008
Today Views:
3 Total Views:
102
The most popular "proper" way to build a web application seems to be to use the Model-View-Controller design pattern. While it sounds complex, the concepts are sound and the ease of development it provides are compelling.
July 7,
2008
Today Views:
1 Total Views:
80
