(Jon Stephens and Chad Russell) In the previous chapter, you saw how MySQL’s date and time datatypes can save storage space—50% or more over storing dates as strings—but that’s not the only reason for using them. One aspect of applications programming that’s often troublesome is working with dates.
Other News
Avoid database auto-resizing to resolve access dilemmas
(Serdar Yegulalp) When a data file is created in a SQL Server database, the file’s autogrowth factor is set by default: Files are set to grow by 10% of their size whenever they’re close to running out of free space — and they are set to grow in an unrestricted fashion. For modestly sized databases
A Hype-Free Introduction to AJAX
(Chris Schalk) You’ve probably heard all the AJAX hype by now, as well as seen the many products that claim AJAX support or “compliance.” However, you probably haven’t seen a good, simple technical explanation of what AJAX really “is.” In this article, you’ll get an overview of the core fundamentals
Deploying ASP.NET 2 Web Site to Production Server: Part II
(Moustafa Arafa) On the first part we discuss in detail how to move our database which contains the membership tables from the default aspnetdb Database to our database. On this part we will show how to change the default settings of asp.net membership and role providers to read from tables which
Develop DB2 applications using persistence-based frameworks
(Naveen Balani) Get an overview of various persistence-based frameworks for DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows, including Hibernate, Java Data Objects (JDO), and Java DataBase Connectivity (JDBC) 3.0. Build DB2 persistence-based applications employing the widely used Hiber
Oracle Recovery Manager
A complete high availability and disaster recovery strategy requires dependable data backup, restore, and recovery procedures. Oracle Recovery Manager (RMAN), a command-line and Enterprise Manager-based tool, is the Oracle-preferred method for efficiently backing up and recovering your Oracle databa
Oracle Supports AJAX With Updated Fusion Middleware
Oracle VP Ted Farrell recently spoke to SYS-CON in an exclusive recorded interview about the company’s emerging AJAX strategy.
Homeland Security Survey Takes First Pass at LAMP
(Vance McCarthy) First results are in for the Department of Homeland Security’s vulnerability survey of some 40 Open Source projects. Early findings, released by Stamford University and source code analysis software vendor Coverity reveal that the LAMP stack has a higher-than-average code quality, w
More Subtemplates
have seen a few questions around sub templates on the forum recently. Using subtemplates is a very powerful way of making your life as a template developer much easier, if you have a piece of formatting functionality that you intend to use across multiple templates then break it out as a sub templat
SQL Formatter Web Service
(tako.lee) SQL code is much easier and faster to read and understand when it is formatted, especially when it is a long and complicated SQL statement you are dealing with, or you have to read other people’s code. Writing a decent SQL formatter is not an easy task. In this article, I would like to cr