(Paul Dubois) Last week, we began our discussion of MySQL database security. This week, we continue that discussion with user account management. The

(Robin Schumacher) Many of you have responded very positively on the first and second partitioning articles that I wrote some time back. It’s clear that a lot of you are excited about the upcoming MySQL 5.1 release, and in particular, the new data partitioning feature that’s being offered. That’s no

(Mike Kornienko) Adobe have recently released its Spry Ajax framework for public beta-test by developers and I’ve been playing with this baby for a while. And here’s some kind of report of what I have learned.

(Paddy Sreenivasan) The number of web and enterprise applications based on the LAMP application stack is growing. LAMP applications use Linux or BSD as the operating system, Apache as the web server, MySQL or PostgreSQL as the application database, and PHP, Perl, or Python as the programming languag

(Larry Ullman) With the fundamentals of PHP under your belt, it’s time to begin building truly dynamic Web sites. Dynamic Web sites, as opposed to the static ones on which the Web was first built, are easier to maintain, are more responsive to users, and can alter their appearance based upon differi

(Giuseppe Maxia) Sometimes my customers (especially the ones who are used to different database servers,) ask me about the CPU and memory consumption of a MySQL server process.

(Paul Dubois) If you maintain a MySQL database, you understand the importance of security. This article covers that topic in detail.

(Jim Rapoza) Open-source and .Net zealots can both take away positives from eWEEK Labs testing of various application stacks, but a mix-and-match approach wins the day. Bottom line: Open source and .Net better learn to play nice.

PostgreSQL is a sophisticated relational DBMS, supporting almost all SQL constructs, including subselects, transactions, triggers and user-defined types and functions. It is the most advanced open-source database available anywhere, and we offer the most comprehensive PostgreSQL training available a

(Philippe Campos) In this article we explore how to program foreign keys into a MySQL Server. This is important when your application requires referential integrity and the storage engine you’d like to use, as in the case of MyISAM or NDB (Cluster), does not support this functionality natively. We s