SQL

Most of the content in this section relates to PostgreSQL, with occasional references and comparisons to MySQL. We find Postgres to be an all-round better database with the main advantages being: adherence to standards; advanced command-line interface; security; consistency; and having many functions not available in competing systems (views, constraints, arrays, date/time and geometric functions to name but a few).

Articles relating to SQL

Order by: topic | title | most popular | most recent

• PostgreSQL trigger for deleting old records
• Selecting rows before and after
• PostgreSQL trigger for updating last modified timestamp
• Creating a lookup table with id reference
• Selecting n rows from each category

• Creating a Lookup Table
• Counting Page Views in PostgreSQL
• Using a PostgreSQL foreign data wrapper to analyze log files
• Storing and comparing colors with PostGIS
• pg_dump Command Builder
• A basic UPSERT in PostgreSQL
• Advisory locking to prevent concurrent script execution
• Postgres vs. MySQL

• PostgreSQL SELECT
• PostgreSQL Commands
• PostgreSQL String Functions
• PostgreSQL Date/Time Functions