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
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;
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.
It turns out a misconfigured #ClickHouse #SQL query brought down the internet managed by #Cloudflare... #Databases
We asked the students of this year's #Databases course for their favorite track, and you can now listen to all of them at:
In next week's #Databases lecture, we will discuss my Frisian family tree where every child is named after their father (oh sweet patriarchy); and we discuss transactions where Daen updates all beer prices in his pub to take some of the fruits of this year's greedflation, and Sally finds that the minimum beer price exceeds the maximum price.
Yesterday, Benard Wanjiru gave the #Databases lecture about SQL and systematic SQL query construction. Some information about the course can be found at: https://djoerdhiemstra.com/category/course-databases/
(the rest, including the slides and the lecture video is behind the university's BrightSpace "paywall", unfortunately)
How to use UUIDv7 in Python, Django and PostgreSQL by @paulox https://lobste.rs/s/svyej1 #databases #python #web
https://www.paulox.net//2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/
