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
I share a Python script that safely upserts Pandas DataFrames into a Postgres database using psycopg2, highlighting the importance of handling potential SQL injection risks. I explain the process of constructing SQL statements to manage inserts and updates based on specified constraints, while utilizing the `execute_batch` function for efficient batch processing.
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.