(Falko Timme) In this tutorial I will describe how to install and configure MyDNS, a DNS server that uses a MySQL database as backend instead of configuration files like, for example, Bind or djbdns. This has the advantage that you can easily use web-based frontends to administrate your DNS records.
Tag: Open Source
Interview with Kai ‘Oswald’ Seidler from the XAMPP project
(Lenz Grimmer) I recently had the pleasure to get in touch with Kai “Oswald” Seidler from the Apache Friends team. He is one of the people behind “XAMPP”, an easy to install software distribution containing MySQL, PHP and Perl which is available for Linux and Windows. The project also added support
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
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
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
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
How To Set Up Database Replication In MySQL
(Falko Timme) This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the s
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
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
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.