-
Archives
- November 2011
- September 2011
- May 2011
- February 2011
- January 2011
- December 2010
- 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
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
Setting Up Yet Another Debian Etch Server
A teacher e-mailed me the other day wondering if I could setup a server with Moodle on it for him to test. I was overjoyed at the request because the teacher had discovered Moodle, MySQL, PHP, and Linux (as well … Continue reading
Posted in GNU/Linux, IT, Open Source, PHP, 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
When dealing with 1 GB databases…
…create good indexes. This should be obvious, but for some reason I was getting frustrated with MySQL for taking almost 30 seconds to query a 1 GB table that only had a worthless index on a surrogate key. With proper … Continue reading
Posted in Open Source, SQL, Technology
Leave a comment
ODBC Test Tool
Today I find myself once again fighting Crystal Reports. It claims that it can’t connect to the ODBC datasource I created for it since it can’t use Npgsql. Just to prove it wrong I quick hacked together an ODBC Test … Continue reading
Posted in Mono/.Net, SQL, Technology
1 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
