Articles about databases

2019

• Running PostgreSQL in Docker for local dev
• How to run Oracle DB on a Mac with Docker
• How to Run SQL Server on a Mac

2009

• Cheat Sheet for SQL Server

2007

• Use Char instead of Varchar to Store UUID's

2006

• Sphinx - Open Source SQL Full Text Search Engine
• Google Video: MySQL Performance Tuning Best Practices
• Updated SQL Reserved Words Checker

2005

• Oracle's Free Database Server
• MySQL FULLTEXT Indexing and Searching
• EnterpriseDB - PostgreSQL with Oracle Compatibility
• SQL to Select a random row from a database table
• Insert Delayed with MySQL
• The MySQL Query Cache
• Multiple Inserts with MySQL
• Related Posts
• SQL Reserved Key Words Checker Tool
• Prepared Statements with JDBC
• Understanding MSDE 2000's Limitations in Web Applications

2004

• Finding Duplicates with SQL

Pete has written about databases a total of 20 times. In articles about databases, Pete also often writes about: sql, mysql, oracle, sqlserver, and postgresql.