Instance: programming.dev
Joined: 2 years ago
Posts: 18
Comments: 0
Backend (and sometimes frontend) software engineer working on sports data at Elias Sports Bureau.
Experience with: Python, Django, Typescript/JS, infrastructure, databases
Find me: - Github: github.com/jnovinger - Mastodon: https://mastodon.social/@jnovinger

c/python
c/sql




Python Performance: Why 'if not list' is 2x Faster Than Using len() (blog.codingconfessions.com)
How not to change PostgreSQL column type | boringSQL (notso.boringsql.com)
Via https://fosstodon.org/@hunleyd/113205392466307810
Improved query cancellation in PostgreSQL 17 and Psycopg 3.2 (blog.dalibo.com)
Via https://fosstodon.org/@hunleyd/113080821469886930
Adding a Primary Key To An Existing Table [via RoR] (stevenan.com)
Via https://mastodon.social/@stevenan/112899205276153700
PostgreSQL Lands Support For Incremental Backups (phoronix.com)
Via https://mastodon.social/@hunleyd@fosstodon.org/112220150255942506
“But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL (stormatics.tech)
Don't Do This - PostgreSQL wiki (wiki.postgresql.org)
Nine ways to shoot yourself in the foot with PostgreSQL (philbooth.me)
Query Exercise: Find Posts with the Wrong CommentCount (smartpostgres.com)
Via https://mstdn.social/@michristofides/111738621686733546
SQL Reserved Words: Troublesome words in SQL (modern-sql.com)
Upsert in SQL (antonz.org)
donno2048/pygoto: Use goto in Python (github.com)
SQL:2023 is finished: Here is what’s new (peter.eisentraut.org)
saulpw/visidata: A terminal spreadsheet multitool for discovering and arranging data (github.com)
Works with Postgresql, MySql, and SQLite natively.
SQLite Release 3.42.0 [16 May 2023] (sqlite.org)
SQL Murder Mystery (mystery.knightlab.com)
Can you find out whodunnit?
Interview with: Ryan Booz | PostgreSQL Person of the Week [15 May 2023] (postgresql.life)
Interview with: Floor Drees | PostgreSQL Person of the Week [8 May 2023] (postgresql.life)