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
- PostgreSQL trigger for updating last modified timestamp
- Selecting rows before and after
- Enforcing foreign keys for inherited tables
- Selecting n rows from each category
- Creating a lookup table with id reference
- Creating a Lookup Table
- Using a PostgreSQL foreign data wrapper to analyze log files
- Advisory locking to prevent concurrent script execution
- Storing and comparing colors with PostGIS
- A basic UPSERT in PostgreSQL
- pg_dump Command Builder
- Counting Page Views in PostgreSQL
- PostgreSQL String Functions
- Postgres vs. MySQL
- PostgreSQL Date/Time Functions
- PostgreSQL SELECT
- PostgreSQL Commands