@ascherbaum strictly speaking, the task is an article a month until the end of the year. I have decided since this was assigned today that it doesn't include April
@musicman How about discovering the job market around PostgreSQL, interviewing various companies about their work culture and hiring approach, then post an update each month?
ps.: seeing the weird circumstances around the assignment, I originally wanted to mark the above as joke/sarcasm, but the more I think about it, the more I'm convinced it would work as a serious topic to cover.
(I'm taking bets that I can build this based on SQLite if I set my mind to it I learned a lot of creative database stunts at #postgres meetups and now from #clickhouse and I'm telling you folks a database is a framework to be used to build platforms not to just passively sit there in a corner hidden behind a cache databases aren't some mimimi :)
Anyone here used both #MySQL and #Postgres a lot and could tell me how they compare for larger DBs? Mostly in terms of performance, assuming I don't need some advanced features - talking about 10s or 100s of GBs, a lot of writes but not that many reads. 🤔 #PostgreSQL
@mackuba Pandas and dataframes are ways of representing data operations on top of columnar data (such as Parquet files). This allows you to do the same kind of operations as SQL, joins, selects, etc, but without ever leaving the Python REPL. It’s easily scriptable and insanely fast—considering.
I know of companies that store TBs per day like this.
This is the best pic I have of the late Simon Riggs who passed away yesterday 26 Mar 2024. 💔 Simon's far-reaching influence in the Postgres world changed the course of so many lives. I took this photo when Simon was giving his Postgres keynote at #PGConfEU 2023 last December in Prague. RIP Simon, you will be missed by so many people, whose hearts are broken right now 💔
. @dgapitts wants to organize #postgres meetups in Barcelona and Madrid and is looking for support, speakers, anything you can give. Friends in Spain?! @pgDayParis
After a looong review process I have pushed a patch from Dilip Kumar and Andrey Borodin that vastly improves the overall #Postgres performance under certain conditions (high pressure, lotsa transactions). More details in the commit message: