Comments by "Lawrence D’Oliveiro" (@lawrencedoliveiro9104) on "PostgreSQL in 100 Seconds" video.

  1. The world’s most popular DBMS is so widespread, you probably have a copy literally within arm’s reach right now, in your purse or pocket. It’s SQLite, and it ships with every Android smartphone.
    17
  2. “select *” is not something I would ever use in production code. Always select exactly the fields that you need, no more, no less.
    7
  3. ORMs are a waste of time. When they try to map more advanced DBMS features, they just end up creating a new syntax that is no simpler than the underlying SQL.
    3
  4. Not sure why I would want to use custom structured data types in a DBMS. That breaks normalization.
    2
  5. Same here. put the application logic in the application language, not the DBMS.
    1
  6. I was able to do a database dump from old MYD files by starting an instance of a compatible-version MySQL server in a container.
    1