(Tal Olier) In the following article we are going to cover the use of key-value tables in a database design. They can help you with flexibility in design, but will trip you up in other areas (such as data filtering) if you are not careful. I assume that the audience for the following article is fami
Tag: Open Source
Visual Basic 2005 and MySQL 5 Developer Notes – Part One
(Mike Hillyer) In my original series of VB.Net/MySQL articles, I created a sample application that tracked a collection of users and whether they were in or out of the office.
Introducing Perst, an Open Source, OO Embedded Database for .NET
(Ted Kenney) On February 6, 2006, McObject announced its official release of Perst, an open source, object-oriented embedded database for Java and C#. In addition to high performance and a modest footprint, one of Perst’s greatest achievements is its tight integration with Java and C#, resulting in
Migration to Open Source Databases
(Jutta Horstmann) With Open Source database management systems getting mature, they are evolving as a target system for database migration. This diploma thesis focuses on migration scenarios and strategies, proposing an elaborate migration workflow. (pdf)
Ingres’ New CFO Is Out for Enterprise Blood
Q&A: Ingres is no MySQL. It’s not shy about wanting to squeeze up to 8 percent of customers away from enterprise players like Oracle, says its new CFO, and to squeeze some goodies out of developers in the open-source community.
Accessing Distributed Data with the Federated Storage Engine
(Robin Schumacher) It’s no secret that corporations are swimming in more data than ever before. IDC has recently pegged data growth at 48% a year, which means that corporate data nearly doubles every two years at many companies. In addition, purchased applications and custom built systems contin
Writing MySQL Programs Using C (Sample Chapter)
(Paul Dubois) MYSQL provides a client library written in the C programming language that you can use to write client programs that access MySQL databases. This library defines an application programming interface that includes the following facilities: –Connection management routines that establ
Programming OTL using PostgreSQL and ODBC in the Windows environment: a step-by-step guide
(ccrosetti) The purpose of this article is to show how to configure ODBC under Microsoft Windows for readiness to programming a C++ OTL application with the PostgreSQL database. This article is an iteration on my previous article on the Solaris platform. You are going to see how portable is the samp
Comparing Open Source Licenses: GPL vs. BSDL
(David Chisnall) This article compares the two most popular software licenses in the free and open source software (F/OSS) communities: the GNU General Public License (GPL) and the Berkeley Software Distribution License (BSDL). Each has advantages, but the distinctions are sometimes quite subtle.
Using Regular Expressions in PostgreSQL
(Robert Bernier) You know what I love about open source? The tricks you learn in one activity can effectively transfer over to another one. It’s like using the skills learned from mathematics on the dance floor. Take regular expressions, for example. Did you know that becoming an expert in using reg