(Peter Zeidman) If you’re going to run an intranet site, then you’ll probably want a content management system (CMS) — a tool used to organize documents and keep track of what’s where. I’ve covered a plethora of such systems in previous articles, but for many businesses there can be only one solutio
Other News
Oracle Locking Survival Guide
In multi-user systems, many users may update the same information at the same time. Locking allows only one user to update a particular data block; another person cannot modify the same data. The basic idea of locking is that when a user modifies data through a transaction, that data is locked by
Send Critical MySQL Data to Your Users Automatically
(Karam Chand) Many organizations are developing applications that provide information to users and employees when they need it—regardless of their locations. These types of applications, called notification applications, offer these organizations many beneficial uses, including the following: —
An introduction to MySQL permissions
(Ian Gilfillan) MySQL newbies often have problems with the MySQL access control system. But once you get used to it, I think you will find it flexible and easy to use, so this month we’re going to examine how to get started with MySQL permissioning.
Protecting MySQL Sessions with SSH Tunnel (Port Forwarding)
(kenlin) SSH stands for Secure SHell and is typically used as an encrypted version of telnet. In a telnet session, all communications are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Such sessions are also susceptible to session h
Temporal Functionality
Many changes have been made to temporal – DATE, TIME, DATETIME, and TIMESTAMP – functions in MySQL 4.1. This includes support for microseconds and time zones. In this article, a time value is one of either: TIME, DATETIME, or TIMESTAMP. A date value is one of either: DATE, DATETIME, or TIMESTAMP.
Using ext/mysqli: Part I – Overview and Prepared Statements
(Zak Greant and Georg Richter) Since the mid-90s, ext/mysql has served as the major bridge between PHP and MySQL. Although there have been a few misfeatures and growing pains over the years, in general, ext/mysql has performed its duty quite well, and kept pace with the changes both in PHP and in My
Storage Engine (Table Types)
This chapter covers the MySQL architecture, locking and concurrency, and transactions. It also discusses how to select the right engine and looks at each of MySQL’s storage engines in detail. (From the book High Performance MYSQL: Optimization, Backups, Replication and Load Balancing, by Jeremy Zawo
A DIY Approach to Stored Procedures in MySQL
(Subha Subramanian) If you have avoided using MySQL in the past due to its lack of support for stored procedures, here’s good news. The latest developer release of MySQL (MySQL 5.0) supports stored procedures. Drum roll, please! If you want to jog your memory before you begin to create those cretins
Troubleshooting Problems with MySQL Programs
This appendix from MySQL Administrator’s Guide (by MySQL AB, Sams, ISBN: 0672326345) lists some common problems and error messages that you may encounter when running MySQL programs. It describes how to determine the causes of the problems and what to do to solve them.