I recently had to rescue a legacy application that was running on an old Compaq Proliant server. This custom application is primarily a web application running on MS SQL Server, however there are various services and automated tasks and the application is fairly well embedded onto this hardware. The application has gone through various changes [...]
Archive | June, 2007
Beyond auto-id: Advanced Sequential Numbering with MySQL
MySQL auto-id function provides the ability to automatically create a new id for each new record on insert. This works great for unique ids, but sometimes more logic is required. For a recent assignment we needed to populate a table that reflects seating in a stadium. The seating was typical of most venues consisting of [...]