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