Other News

Community

MySQL vs. PostgreSQL

MySQL is simplier than PostgreSQL but much faster. MySQL doesn’t support many advanced features that may be important in huge relational and complicated databases. But for JRA1 measurement architecture MySQL should be adequate (we probably wouldn’t use the most advanced features).

Community

Append Commit After Each DML

(Xiang Gao) When generating a script to perform data maintenance, especially DML, one common problem is that the user is required to make multiple commits between the DML operations to reduce the UNDO/rollback segment size. Typically, the script is edited manually after it has been generated.

Community

Client Clones and Server Sessions

(Tony Marston) The session handling functions in PHP are designed to save state between different requests from the same client. This works well if the client device is accessing the application via a single browser window, but what happens if the user decides to open up several browser windows and

Community

Deploying ADO.Net Applications

(Faraz Rasheed) Databases are an inevitable part of most of the real world applications. Deploying such database centric applications has always been tricky in all the platforms, be it Microsoft Visual Basic 6, Microsoft Visual C++ 6, Java or Dot Net. In this article, we have addressed a number

Community

String Manipulation

(Peyton McCullough) Programmers need to know how to manipulate strings for a variety of purposes, regardless of the programming language they are working in. This article will explain the various methods used to manipulate strings in Python.

Community

Managing XML Data

(Thom Robbins) Last week I had lunch with the application manager of a local customer that just completed their enterprise rollout of Office 2003. We had decided to meet and discuss possible ways his team could begin to utilize this deployment. As we sat down he explained that he had been talking to

Community

Hacking a SQL Server

(Joel Scambray and Stuart McClure) Hacking into Web servers and replacing home pages with pictures of scantily clad females and clever, self-ingratiating quips is all fine and dandy, but what can we do about hackers intent on doing more than defacing a few pages? Sooner or later you’ll be up aga