(Roger Smith) The age of industrial-strength open-source databases has arrived. No longer collaborative science experiments, open-source database projects are growing up and going mainstream. In a recent survey, Evans Data Corp. found that two-thirds of database developers were currently using open-
Other News
Candidate Recommendation for Voice Extensible Markup Language (VoiceXML) 2.1
W3C’s Voice Browser Working Group has released a new version of the Voice Extensible Markup Language (VoiceXML) 2.1 specification at Candidate Recommendation level. VoiceXML “enables integration of voice services with data services using the familiar client-server paradigm. It is is designed for
Using Data Transformation Services, part 7: Transferring Files with DTS
(Jayaram Krishnaswamy) File Transfer Protocol (FTP) is a custom task in SQL 2000 Server’s Data Transformation Services. The files from an internet site can be transferred to a directory, or files can be transferred from one directory to another directory. This, in conjunction with the other DTS
Using Threading to Build a Responsive Application with Visual Studio 2005
(Brad McCabe) Building multithreaded applications is easy with the new BackgroundWorker component in Visual Studio 2005, and it allows you to create interactive applications with minimal work.
MySQLWrapp: MFC-Extension Library for MySQL
(Ovidiu Cucu) This article presents a collection of MFC-Extension classes that use the MySQL API. They are implemented in an MFC Extension DLL—MySQLWrapp.dll. The main goal of these classes is to optimize query and fetch time, handle errors, easily use query results, work with BLOB fields, and l
Finding the Declarative Tipping Point; XQuery, XML, and the RDBMS
(David Kershaw) Moving information from a database into an application may be the most common challenge developers face. How many of us make it through life without meeting object/relational (O/R) mapping in some form? Certainly not too many. Lately it has become equally difficult to avoid XML/relat
z/OS Diagnostic Data Collection and Analysis
(Paul Rogers and David Carey) This IBM Redbook provides some guidelines to assist with the collection of relevant diagnostic data to be used for problem diagnosis and resolution. This is not a definitive list of techniques, and while it covers many of the products that we deal with on a regular
Cleaning up with AJAX
(Christopher Harrison) For the end user, AJAX transforms hitherto clumsy, simple Web applications with characteristically slow response times into Web applications more akin to their native cousins (Microsoft Window or UNIX clients) by shortening page response time and providing rich enhancements in
Tip: Loop with recursion in XSLT
(Elliotte Harold) XSLT is a functional programming language like Haskell or Scheme, and unlike C or Fortran. Thus it has no loops and no mutable variables. Instead, you must replace these constructs with recursion and parameters. This tip demonstrates how to provide this functionality using named te
Clone database objects with dynamic SQL
(Scott Stephens) If you want to take a copy of one table and make a copy of it in another schema (under another username), you can use the SQL*Plus COPY command, or a simple “create table foo as select * from other.foo;”, as long as you have select privileges on the other user’s table.