News for hackers. Stuff that matters.
Re:Mastery with SQL: Learn Modern SQL with Postgres by molsson on Monday June 24, 2019 @04:15PM (#20267959)
The free "teaser video" starts off showing "actor_id serial NOT NULL" but in postgres 10 and above identity columns can/should be used instead?

https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_s...

Re:Mastery with SQL: Learn Modern SQL with Postgres by nsainsbury on Monday June 24, 2019 @10:45PM (#20270743)
I actually do cover this in the course! I actively recommend and give examples of using autogenerated identity columns for the primary key, but still in many places in the course do expose people to using the serial types due to their popularity.