Tag: Open Source

Community

Using More Perl in PostgreSQL

(Andrew Dunstan) The first article in this series examined the use of PL/Perl to create triggers. The trigger inserted a row into a database table for audit purposes using a new PL/Perl method called spi_exec_query(). This article looks in more detail at uses of that function and its new cousin, as

Community

Primary Keyvil, Part II

(Josh Berkus) What follows are a number of reasons people have given me, on IRC and the PostgreSQL.org mailing lists, for using autonumber keys. Some of them are “good” reasons which demonstrate and understanding of the costs and benefits. Others are “bad” reasons based on sloppy thinking or lack of

Community

Using MySQL with .NET

(cardinals33) Ever wanted to combine the power and ease of the .NET platform with a free database like MySQL? Well thanks to ODBC database functions in ADO.NET it’s really easy. All you need is the latest drivers for ADO.NET and MySQL installed. For this tutorial we will use C# to build a simple app

Community

Primary Keyvil, Part I

(Josh Berkus) Two actual conversations I had on IRC, handles changed to protect the ignorant, and edited for brevity (irc.freenode.net, channel #postgresql): newbie1: schema design: http://www.rafb.net/paste/results/Bk90sz89.html agliodbs: hmmm … why do you have an ID column in “states”? You’r

Community

Date and Time in MySQL 5

(Ian Gilfillan) In April 2003, I wrote two articles on MySQL’s Date and Time functions (part1 and part2). With MySQL 5 now released, and in widespread use, it is time for an update. Much remains the same, but there have been a few significant changes you will need to be aware of. This article, which

Community

New Event Feature

(Trudy Pelzer) In this article, I’ll give a preliminary description of a new MySQL feature for scheduling and executing tasks. In version 5.1.6, MySQL has added support for events. That is, you can now say: “I want the MySQL server to execute this SQL statement every day at 9:30am, until the end of

Community

Using MySQL, Joins

(Keith Brown) In this Virtual Workshop we will look at retrieving data from a relational database structure, i.e. with multiple tables, using the SQL JOIN Syntax. Most databases have multiple tables to avoid repeating data. i.e. why enter the details of a customer over and over again.