(Curtis Poe) Maybe you know how to drive a car. Maybe you can fix the carburetor. You probably don’t assume that you know how to design the car. However, programmers who can write huge SQL statements and understand the output of an EXPLAIN statement often assume that they can design a database. Admi

(Alejandro Gervasio) Building database-driven web sites is one of the most popular trends today in web site development. However, this approach implies that potential visitors must be provided with a straightforward mechanism that allows them to search through web site content. This three-part serie

(Peter Zaitsev) I start to see applications being built utilizing VIEWs functionality which appeared in MySQL 5.0 and quite frequently VIEWs are used to help in writing the queries – to keep queries simple without really thinking how it affects server performance.

(Mark Cafazzo) In the recent “Race to Linux 2.0” competition, a .NET programming event hosted by DevX, .NET developers were invited to get ASP.NET applications up and running on Linux. The three-part competition allowed entrants to download preselected .NET applications and either port them or rewri

(Jan Kneschke) The idea is as old as Replication is: How do you know which is the most current slave.

(Joshua Hoskins) While data replication between Microsoft SQL Server 2000 and MySQL databases is not technically supported by either application, it is possible if you follow the correct steps. This TechRepublic How do I… walks you through the complicated procedure necessary to make data replication

(Erik Wetterberg) In a previous post I described how you could create XML output from SQL using stored functions. But that was a flat structure, with only one table and simple XML structure with a tag for every row in the result set, and column values as attributes or sub tags. Part of the real powe

(Alejandro Gervasio) If you’re a PHP developer looking for an approachable guide on how to build an expandable search engine with MySQL and PHP 5, then this series of articles might be quite useful to you. Welcome to the second installment of the series that began with “Building a Search Engine with

(Vadim Tkachenko) Recently we were puzzled by question how query_cache works with column level privileges. The question was appeared as we discovered function query_cache_send_result_to_client is called before real parsing of query, so at the moment of execution the query_cache is not able to know w

(Alejandro Gervasio) If you maintain a medium-sized, growing web site, you might find that it needs an internal proprietary search engine to improve your visitors’ experience. This article, the first of three parts, will get you started with building such an engine using PHP and MySQL.