Category Archives: PostgreSQL

PostgreSQL 8.3 Beta

Warning: IANADBA I was just reading the release notes for PostgreSQL 8.3 beta1, and there’s quite a lot of exciting improvements coming: Full text search is now a built-in feature Support for the SQL/XML standard, including a new xml builtin … Continue reading

Posted in Open Source, PostgreSQL, SQL, Technology | Leave a comment

Debian Etch Released

It appears Debian GNU/Linux 4.0, codenamed Etch, (quite a mouthful) has been released as the latest stable version of Debian. Go download it using BitTorrent to be cool. Tip #1:  You do not have to download all of the CDs, … Continue reading

Posted in GNU/Linux, Mono/.Net, Open Source, PHP, PostgreSQL, Python, Technology | 6 Comments

PostgreSQL Killed My Harddrive

The harddrive died in the server that dumps our firewall’s syslog output into a nice PostgreSQL database for easy reporting. PostgreSQL didn’t do anything evil in order to kill the drive, but because it syncs data to the harddrive for … Continue reading

Posted in PostgreSQL, SQL, Technology | Leave a comment

Connecting SQLObjects to PostgreSQL via SSL

I’m trying to learn TurboGears, but I got stumped yesterday trying to figure out how to connect to PostgreSQL via SSL. Turns out this works in SQLObject (TurboGear’s default ORM): sqlobject.dburi=”postgres://username:pass@servername/mydb sslmode=require” Turns out the syntax I was trying to … Continue reading

Posted in Open Source, PostgreSQL, Python, SQL, Technology | Leave a comment

PostgreSQL 8.2 Released

Just noticed PostgreSQL 8.2 was released yesterday. I chose PostgreSQL 8.x for a large project when MySQL 5 either wasn’t out or was too new for my comfort. I learned database application programming on MySQL, but now I choose PostgreSQL … Continue reading

Posted in Open Source, PostgreSQL, SQL, Technology | Leave a comment

SchoolWorks on Linux: Part 1 of Many

Now that SchoolWorks has officially been released, I guess I can begin posting about my attempts to get it running on Linux. First of all SchoolWorks is school administration software (or SIS) built using: ASP.NET 2.0 (in Windows using Microsoft … Continue reading

Posted in GNU/Linux, Mono/.Net, Open Source, PostgreSQL, SQL, Technology | Tagged | 1 Comment