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
- Selecting rows before and after
- PostgreSQL trigger for deleting old records
- PostgreSQL trigger for updating last modified timestamp
- A basic UPSERT in PostgreSQL
- Creating a Lookup Table
- Selecting n rows from each category
- Creating a lookup table with id reference
- Counting Page Views in PostgreSQL
- Storing and comparing colors with PostGIS
- pg_dump Command Builder
- Advisory locking to prevent concurrent script execution
- Postgres vs. MySQL
- PostgreSQL String Functions
- PostgreSQL Date/Time Functions
- PostgreSQL Commands
- PostgreSQL SELECT
Send a message to The Art of Web:
press <Esc> or click outside this box to close