TermTrix is a community for developers and tech enthusiasts dedicated to mastering the terminal. Share tips, tricks, and troubleshooting techniques to supercha
Joined March 2024
- Tweets 52
- Following 6
- Followers 4
- Likes 13
11 Photos and videos
Lost $100 in production. No exception. No rollback. No error log.
Just two requests hitting the same DB row at the same time.
The fix?
That's it. Row locked. Race condition gone.
Full breakdown → medium.com/@termtrix/the-two…
#PostgreSQL #SQL #Backend #WebDev #Database
1
7
Two requests try to update the same row
at the exact same time.
One waits.
One wins.
One might silently overwrite the other.
Do you know how to prevent this in SQL? 🤔
#SQL #Database #Databases #OptimisticLocking #RowLocking #RaceCondition #DistributedSystems #PostgreSQL
7
Your database crashes mid-transaction.
Which rows got saved? Which didn't?
How does Postgres even know?
The answer is WAL 🧵
#PostgreSQL #DataEngineering #DatabaseInternals
#WAL #BackendDev #SQL
#PostgresSQL #PythonDeveloper #DatabaseDesign #SystemDesign #100DaysOfCode
18
Your database crashes mid-transaction.
Which rows got saved? Which didn't?
How does Postgres even know?
#PostgreSQL #SQL #DatabaseEngineering #DataEngineering #BackendDev
14
🐘 PostgreSQL 19 Beta 1 just dropped.
Here's what actually matters for backend devs:
→ Parallel autovacuum (finally)
→ 2x faster inserts with FK checks
→ SQL/PGQ — graph queries in standard SQL
→ etc.
Start testing now 👇
postgresql.org/about/news/po…
#PostgreSQL #Backend
20
Already dropped the full breakdown on Medium 📖
How the X-Powered-By header exposes your stack — and how to fix it across Express, PHP & nginx.
Read it here 👇
medium.com/@termtrix/bacfb23…
#WebSecurity #BackendEngineering #Termtrix
1
36
Most devs can write SQL queries.
Few know what _ actually does.
What does this return?
WHERE name LIKE '_a%'
Vote → I'll reply with the full explanation 🧵
0%
🅰️ Names containing "a"
0%
🅱️ Names where 2nd chara
0%
🆎 Names starting with
0%
🆑 No idea honestly
0 votes • Final results
11
If you're a developer who learns best by building real things —
Termtrix is where you belong.
Join the community → discord.gg/XqqcAhg63f
#DevCommunity #SoftwareEngineering #OpenSource #BuildInPublic
11
What happens when someone types your server's raw IP directly into the browser?
143.198.xxx.xxx
Most devs don't think about this — until it's too late.
Drop your answer below. Answer coming tomorrow. 👇
#Nginx #WebSecurity #DevOps #BackendEngineering
1
33
Did you know PostgreSQL has built-in Full-Text Search? 🔎
⚡ Language-aware tokenization
📊 Relevance ranking
🚀 Fast GIN index queries
No Elasticsearch needed.
Follow @termtrix for more dev tips 👇
#PostgreSQL #FullTextSearch #DevTips #100DaysOfCode
1
24
AWS just bumped SQS max payload from 256 KB → 1 MB 🚀
No more S3 claim-check workarounds for large messages.
No more chunking hacks.
Just send the payload.
Small change. Huge DX win.
#AWS #SQS #Serverless #BackendDev
1
27
Still using Pydantic just for serialization?
Meet msgspec ⚡
✅ Zero-cost schema validation
🧱 Structs 5–60x faster than dataclasses
pip install msgspec
Sleeping on this is a crime.
#Python #msgspec #BackendDev
1
20