If you are not too far from France, and you are discarding old hardware, consider donating it to @videolan.
As you've seen, we did lately updates to VLC to fix support for Windows XP and macOS 10.7 (and iOS9).
Because you should not need to buy new hardware because of software.
Bro, no matter how much you prepare, things won’t always go as planned. That’s life. Pressure will hit. Plans will break. Unexpected problems will show up. That’s why you must learn to stay calm and think clearly under pressure.
Pressure reveals who you really are. Weak men panic. Strong men adapt. Real success isn’t about perfect plans. It’s about adjusting fast, staying disciplined, and still finding a way to win when everything goes wrong.
Storing JSON in Postgres? You should change `default_toast_compression` to lz4 and save on CPU, memory and storage.
It is supported since pg14, has better cpu/compression tradeoff... and it will soon be the default by default.
⚠️PSA: Don't use Docker's official Postgres image in production.
Or, if you do, make sure you specify your Debian image.
The long version:
Postgres minor version upgrades (17.6 -> 17.7) are generally easy, safe and recommended. They should never break anything.
*But* if you use the official docker image and recently (since August) did a minor version upgrade, you may have seen this warning:
"The database was created using collation version 2.36, but the operating system provides version 2.41.
Rebuild all objects in this database that use the default collation and run ALTER DATABASE "mydb" REFRESH COLLATION VERSION, or build PostgreSQL with the right library version."
This is because:
- Docker only supports 2 debian versions for the PG image
- When a new version comes out, it automatically becomes the default unless you specify the image.
- Debian's new release included a new glibc, which includes new locale files.
- So now you are running Postgres linked against one set of locale files, but with a database with data and indexes that assume a different locale file.
Since this situation can lead to anything from bad query results to corruption, Postgres correctly warns you to refresh the collation for the DB, which you do *after* rebuilding every object in your database (to avoid corruption).
This is something we do on **major** upgrades, and absolutely do not expect on **minor** upgrades.
But Docker forces this on the users of their official image.
Be careful out there! Official image does not mean "responsible production behavior".
300 Real SQL Interview Questions with Solutions
Asked at PwC, Deloitte, EY, KPMG, Tredence, Persistent Systems and Accenture & More.
To get it FREE 👇
Like & Repost
Comment “SQL”
Follow (must) so I can DM you the PDF
All Handwritten colorful notes for Free!
Hurry up! Free for 24 hours.
✅ Python
✅ Node.js
✅ React.js
✅ JavaScript
✅ Oops in C++
✅ HR interview
✅ Machine learning
✅ Cloud Computing
✅ Computer networks
To Get it:
1. Follow me (so that i can DM you
2. Repost
3. Comment "handwritten"
Here’s your
100+ LeetCode Problems with Solutions
Perfect for mastering coding interviews and problem-solving in 2024!
All, FREE of cost!
Simply:
1. Follow me (So I can DM)
2. Like & Repost
3. Comment "LeetCode" to receive the guide.
Let’s ace those coding interviews together!
I was laid off in 2012 for the first time ever in my career.
I was quite social at workplace, used to hang out with colleagues, have drinks, dinner with em. I felt I had a good network out there.
After I got laid off, not one of em bothered to contact me. None helped out in giving leads that would have helped in job search. None even bothered to check whether I was dead or alive.
Don't take workplace friendships seriously, it's everyone to their own. Just do your work go home.
It was a lesson learnt the hard way.