-
Archives
- July 2010
- January 2010
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- July 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- August 2005
-
Meta
Category Archives: SQL
Less Pagination, More More
We live in a brave new (to some) world of databases other than a relational database with a SQL interface. Normally end users never notice a difference, but the astute viewer may notice the slow demise of an old friend: … Continue reading
Fun with SQLObject and mxDateTime
I’m working on a small CherryPy web service that among other things saves timestamps to a database. The timestamp is in RFC 3339 format (like 2007-07-31T16:05:00.000-05:00), and I needed to store the timezone. Luckily mxDateTime and SQLObject’s DateTimeCol both support … Continue reading
Posted in Open Source, Python, SQL, Technology
Tagged cherrypy, mxdatetime, Python, sqlobject, xml
1 Comment
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
Drupal Database Maintenance Script
I love Drupal, but its insistence on saving every session its ever created causes the sessions table to become massive. So I usually end up creating a shell script like the following: drupal-db-maint.sh (I posted a copy to pastebin since … Continue reading
Posted in GNU/Linux, Open Source, PHP, SQL, Technology
3 Comments
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