pf » Databases
February 18, 2008
INFORMATION_SCHEMA Support in MySQL, PostgreSQL
March 12, 2007
Amazon S3 Storage Engine for MySQL
February 16, 2007
Use Char instead of Varchar to Store UUID's
January 18, 2007
Calculating Distance in Miles from Latitude and Longitude
January 10, 2007
Backwards LIKE Statements
January 04, 2007
Toggle a Bit with SQL
January 02, 2007
MySQL Optimization Hints
November 01, 2006
Sphinx - Open Source SQL Full Text Search Engine
September 22, 2006
MySQL Command Line Help
May 11, 2006
Google Video: MySQL Performance Tuning Best Practices
March 28, 2006
Updated SQL Reserved Words Checker
January 14, 2006
Forta's MySQL Crash Course
November 23, 2005
Top 20 Internet Security Vulnerabilities of 2005
October 31, 2005
Oracle's Free Database Server
September 29, 2005
MySQL FULLTEXT Indexing and Searching
September 14, 2005
EnterpriseDB - PostgreSQL with Oracle Compatibility
September 14, 2005
SQL to Select a random row from a database table
September 07, 2005
Cheat Sheet for PostgreSQL
September 07, 2005
Temporary Stored Procedures on SQL Server
September 07, 2005
SQL Server Express 2005, Finally Installed
September 01, 2005
Cheat Sheet Roundup - Over 30 Cheatsheets for developers
August 31, 2005
Faster Inserts with PostgreSQL
August 30, 2005
Multiple Dynamic Inserts with SQL
August 29, 2005
LIMIT and OFFSET SQL Pagination
August 11, 2005
MySQL DELAY_KEY_WRITE Option
August 02, 2005
Insert Delayed with MySQL
July 19, 2005
Oracle Critical Updates
June 21, 2005
The MySQL Query Cache
June 20, 2005
Performance of database tag schemas
June 10, 2005
Multiple Inserts with MySQL
May 18, 2005
Detecting SQL Injection with ScriptProtect
May 16, 2005
SQL: Distinct values from two tables
May 16, 2005
Multiple Statements with MySQL and JDBC
May 16, 2005
Prepared Statements in PHP and MySQL
April 28, 2005
High Performance MySQL
April 08, 2005
Related Posts
March 28, 2005
SQL Reserved Key Words Checker Tool
March 09, 2005
PostgreSQL for Mac OS X
February 25, 2005
I give up! Installing SQL Server 2005 Express
February 25, 2005
Microsoft adds SQL Server 2005 Workgroup Edition
February 17, 2005
MySQL Slow Query Log File
February 04, 2005
Triggers in MySQL 5
January 26, 2005
jTDS 1.0 Released
January 19, 2005
PostgreSQL 8 Released
January 12, 2005
Understanding MSDE 2000's Limitations in Web Applications
November 19, 2004
MySQL Popular among ColdFusion Developers
November 12, 2004
jTDS - Open Source Type 4 JDBC Driver for SQL Server
October 06, 2004
Finding Duplicates with SQL
August 20, 2004
Things I didn't know about mysql
April 22, 2004
PostgreSQL vs MySQL vs Commercial Databases
February 11, 2004
SQLServer Books Online Updated
December 04, 2003
Client Variables unnecessary overhead?
October 23, 2003
Top 3 differences between PostgreSQL and MS SQL
September 05, 2003
PostgreSQL And ColdFusion
August 07, 2003
Searching without Verity
July 16, 2003
Interview with PostgreSQL developers
April 30, 2003
Working with PostgreSQL
April 30, 2003
Clustered JDBC
April 18, 2003
Returning TOP N Records
April 14, 2003
Confirming Transaction support
February 28, 2003
Turning a JDBC Result set into a ColdFusion query
Subscribe to my RSS Feed:
RSS
RSS








Pete Freitag is a software engineer, and web developer located in



