sql
Posts tagged "sql"
5 posts
How to write tests in Postgres
Writing simple tests in Postgres without requiring extra dependencies.
Org-mode and SQL
Literate programming with org-mode and sql.
How to Safely Upsert DataFrames into Postgres
A Python script that upserts Pandas DataFrames into Postgres with psycopg2, building the SQL safely against injection and batching writes with execute_batch.
Useful Postgres techniques
Some notes on useful SQL commands and when they might be useful.
When should you use the JSONB type in Postgres?
A review of different sources on when JSONB is suitable for use.