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
- Enforcing foreign keys for inherited tables 2023-05-08
- Selecting rows before and after 2018-03-20
- Storing and comparing colors with PostGIS 2018-02-27
- Selecting n rows from each category 2013-11-29
- Counting Page Views in PostgreSQL 2013-10-22
- Creating a lookup table with id reference 2013-08-16
- A basic UPSERT in PostgreSQL 2013-08-14
- Creating a Lookup Table 2013-08-14
- PostgreSQL trigger for deleting old records 2013-08-12