@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:
has anyone first hand experience with using live #zfs snapshots of #postgres? what i read seems to confirm that postgres should just start right up like it was recovering from a crash. what i worry about a bit is a quite large and high traffic database thats currently being handled by pgbackrest (which even for diff backups is quite slow).
currently considering something like ZnapZend :think_bread:
background being two dead ssd raids after reboot in a row.
@jmcastagnetto@hrbrmstr When I was a Berkeley undergrad in the 80s Stonebraker was already saying that all CS problems are database problems. I guess building the whole OS on a database is the apotheosis of this idea.
@markigra@jmcastagnetto I've also been trying to find a reason to poke at https://github.com/narumatt/sqlitefs but I've got enough side-projects already (and will just wait til someone with more ambition comes up with a killer use-case).
FerretDB enables you to run MongoDB workloads on #Postgres and #SQLite.
Since Neon maintains 100% compatibility with any application that uses the official Postgres release, that makes #Neon an excellent option to consider as the database backend for FerretDB.
@badrihippo Thank you for the question. MongoDB adopted the Server Side Public license in 2018, which is not an Open Source license.
The SSPL license restricts you from using MongoDB in various scenarios, and also restricts competition among service providers by disallowing them to provide MongoDB as a service.
@tosbourn I like psql but for anything really hairy the DataGrip stuff built into RubyMine is quite lovely (because it came from a strong Java/DB heritage)
@judell That's weird - I got it for both sqlite-utils --load-extension and for datasette --load-extension - both on macOS ARM - in both cases they printed extra stuff out to standard out
Didn't see that with the other plugins I tried, just the Hacker News one
#postgres question - are there any downsides to using uuids for joining tables instead of integers? The advantage of uuids is they don't expose any data, whereas integers tell people how many of something you have, and are easy to guess
