PostgreSQL

  • LATERAL JOIN Official doc
  • Calculate similarity: fuzzystrmatch or pg_similarity
  • COPY to load data fast (but no replace yet as PostgreSQL 12)
  • selective aggregates
  • tsvector & tsquery types are important for Full Text Search
  • bulk insert INSERT INTO ... ON CONFLICT UPDATE

(and check out https://modern-sql.com/)