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
- A basic UPSERT in PostgreSQL
- Advisory locking to prevent concurrent script execution
- Counting Page Views in PostgreSQL
- Enforcing foreign keys for inherited tables
- pg_dump Command Builder
- PostgreSQL Commands
- PostgreSQL Date/Time Functions
- PostgreSQL SELECT
- PostgreSQL String Functions
- PostgreSQL trigger for deleting old records
- PostgreSQL trigger for updating last modified timestamp
- Postgres vs. MySQL
- Storing and comparing colors with PostGIS