databases

PostgreSQL – removing foreign keys

PostgreSQL – removing foreign keys I’m a big fan of PostgreSQL. I really like that database. I’ve been working with client/server databases since 1989 using a wide variety of databases including Sybase, Oracle, DB2, mySQL, Access, SQL Server, and SQL Anywhere. Everything has advantages and disadvantages but right now, I prefer PostgreSQL. Every relationship has …

PostgreSQL – removing foreign keys Read More »

Adding procedural language support to PostgreSQL

Adding procedural language support to PostgreSQL This document was originally written for PostgreSQL 7.0.3 but was updated on 13 October 2001 for version 7.1.3. I’m in the process of creating a new version of FreshPorts.  This version will track all of the FreeBSD source tree, not just the ports collection.  Initial testing of database design …

Adding procedural language support to PostgreSQL Read More »

PostgreSQL – installation and configuration

PostgreSQL – installation and configuration Here’s another plug for FreshPorts.  I’ve been playing with ideas and I’ve come up a few good improvements.  But they will require a database with more features than mySQL.  Specifically, I’m going to need stored procedures and functions. I actually installed PostgreSQL back in late July, but never did anything …

PostgreSQL – installation and configuration Read More »

Keeping mysql passwords secure

Keeping mysql passwords secure Regular readers will remember my article about installing and configuring mysql.  In that article you’ll see how I did a database backup.  I’ve found a way to improve that script. ~/.my.cnf The script I use for backing up my database is available from: samples/database_dump2.sh.txt In that script, I include the password …

Keeping mysql passwords secure Read More »

Scroll to Top