Mission accomplished: Exam #Databases graded! This year's results were good: 130 out of 173 students passed the course: 75%. Lowest grade: 1.7; Highest grade: 9.8
Travis F W
boosted
Do you really need Kafka for every queue? 🤔
Alexander Kukushkin revisits PgQ, PostgreSQL’s lock-free, high-performance queue, and why SKIP LOCKED falls apart under load. https://lnkd.in/dSrpHGmJ
#PostgreSQL #PgQ #P2D2 #EventDriven #Databases
Do you really need Kafka for every queue? 🤔
Alexander Kukushkin revisits PgQ, PostgreSQL’s lock-free, high-performance queue, and why SKIP LOCKED falls apart under load. https://lnkd.in/dSrpHGmJ
#PostgreSQL #PgQ #P2D2 #EventDriven #Databases
The challenges of soft delete
https://atlas9.dev/blog/soft-delete.html
#HackerNews #softdelete #challenges #datarecovery #webdevelopment #databases #techblog
Databases in 2025: A Year in Review
https://www.cs.cmu.edu/~pavlo/blog/2026/01/2025-databases-retrospective.html
#HackerNews #Databases #2025 #Technology #Trends #DataScience #YearInReview
🫧 socialcoding..
boosted
Has there been any attempts at integrating Fedi stuff with open databases, such as those for movies and games?
Edit:
Found NeoDB!
#fediverse #activitypub #db #databases #movies #games #music
Has there been any attempts at integrating Fedi stuff with open databases, such as those for movies and games?
Edit:
Found NeoDB!
#fediverse #activitypub #db #databases #movies #games #music
Djoerd Hiemstra 🍉
boosted
We asked the students of this year's #Databases course for their favorite track, and you can now listen to all of them at:
The #SQL GROUP BY ALL syntax introduced by analytical systems like DuckDB, Databricks, and Snowflake will be part of the next SQL standard. #Databases
https://peter.eisentraut.org/blog/2025/11/11/waiting-for-sql-202y-group-by-all
Anna's Archive will provide the audio files too. The AI music generation tech bros will be so happy... #Fail (or, likely, they already know and used the same vulnerability to get the audio)
Some nice #SQL in the wild in the blog post! Examples for SQLite should work for DuckDB with minimal adaption (which is probably your system to go to if you want to recreate the nice analysis and visualisations on this much data on a single machine). #Databases
https://annas-archive.li/blog/backing-up-spotify.html#metadata-files
There is now a slightly bigger music database than the one we provided in the #Databases course: The metadata for 256 million of #Spotify tracks are torrented as 9 files of about 22GB each by Anna's Archive
There is now a slightly bigger music database than the one we provided in the #Databases course: The metadata for millions of Spotify tracks are torrented as 9 files of about 22GB each.
Anna's Archive really has lots of books. Here, as a random example, Halpin and Morgan's "Information Modeling and Relational Databases": https://annas-archive.li/search?q=Information+Modeling%2C+Relational+Databases
#Databases
I was invited by students to give a public mini lecture "Ethical Data Management" on Monday 8 December at 17:30h. in the Huygens building's Giga-Bite space. #Databases
@djoerd Sounds like the student feedback was of great help! Maybe you should reward them a little and give them indeed some test data during the exam 😊
Also, just as a question, are there any cons to point 2?
@Derida I agree and think I should. There are no real cons to Point 2, as long as it is a small database with "toy examples", but this happened while I was trying to convince the digital exam team to add DuckDB. It took more than a year to get this implemented, and in the end I simplified my requirements to: "please, just add DuckDB without any special configuration or files and stuff"... #Databases
Need a quick intro into #SQL? Get "Become a SELECT Star!" by Julia @b0rk Evans. #Databases
Today's #Databases practice exam learnt us a few things: 1. the database schema should be printed along-side the questions, otherwise students keep scrolling;
2. Just giving everybody DuckDB without real data makes things cumbersome; maybe we should provide (some) test data anyway? #Databases
Today's #Databases practice exam learnt us a few things: 1. the database schema should be printed along-side the questions, otherwise students keep scrolling;
Djoerd Hiemstra 🍉
boosted
Djoerd Hiemstra 🍉
boosted
While doing a bibliometric analysis, I noticed something strange – recent papers from 🇹🇷 scholars seemed to disappear from my dataset. The reason? The country officially changed its name to #Türkiye, no longer wishing to be associated with turkey (the bird).
https://doi.org/10.1080/10875301.2025.2565176
Names and identities matter. Respecting them is essential, and so is being careful with citation databases whose metadata is not always reliable.
