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.
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)
pvergain (framapiaf)
boosted
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/
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/
pvergain (framapiaf)
boosted
I'm having so much fun with Grist. Open source spreadsheet-like database-based app builder. Use their hosted version, host your own, or get the local desktop app.
https://youtu.be/3IZiBdDePSI
@grist #Grist #getGrist #openSource #foss #spreadsheets #databases
I'm having so much fun with Grist. Open source spreadsheet-like database-based app builder. Use their hosted version, host your own, or get the local desktop app.
https://youtu.be/3IZiBdDePSI
@grist #Grist #getGrist #openSource #foss #spreadsheets #databases
alcinnz
boosted
Build your own database
#programming #databases #javascript #blog #softwaredevelopment
Build your own database
#programming #databases #javascript #blog #softwaredevelopment
alcinnz
boosted
/dev/null is web scale
https://jyu.dev/blog/why-dev-null-is-an-acid-compliant-database/
/dev/null is web scale
https://jyu.dev/blog/why-dev-null-is-an-acid-compliant-database/
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.