💭 Meet Gor on X: "SQLite added generated columns in 3.31 (around...
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

!https://x.com/MeetGor21/status/1967818642768470447

Date: September 16, 2025

Image: Meet Gor (@MeetGor21) on X — SQLite added generated columns in 3.31 (around Jan 2020) <p>Postgres added generated columns with virtual and as default in v18 (to be released September 2025)</p> <p>There is still a lot to learn in SQL and adoption is still going on, even in the most used databases" loading=“lazy”> </div> <div class= <https://pbs.twimg.com/profile_images/1525159269716271104/qDL6ffwc_200x200.jpg> 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

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?

Image: screenshot-2025-09-16T13-52-48-868Z.png <https://dropper.waylonwalker.com/api/file/2b763b3d-1709-47e6-a13d-bfec7baef47d.png>

NOTE
│ This post is a thought </thoughts/>. It’s a short note that I make about someone else’s content online #thoughts