Posts tagged: db

Meet Gor (@MeetGor21) on X SQLite added generated columns in 3.31 (around Jan 2020) Postgres added generated columns with virtual and as default in v18 (to be released September 2025) There is still a lot to learn in SQL a… X (formerly Twitter) · x.com [1] I’ve never tried generated columns, but it is something that I’m interested in. It is nice to have things computed and in the database if you ever need to query on them. My brain is now churning with possibilities and quesions, does this work with Alembic? How does this compare to views? [2] Note This post is a thought [3]. It’s a short note that I make about someone else’s content online #thoughts References: [1]: https://x.com/MeetGor21/status/1967818642768470447 [2]: https://dropper.waylonwalker.com/api/file/2b763b3d-1709-47e6-a13d-bfec7baef47d.png [3]: /thoughts/