News for hackers. Stuff that matters.

A comment on Challenges students face when learning to work with relational databases and SQL. Parent comment

Re:Challenges students face when learning to work with relat... by tpetry on Sunday August 29, 2021 @10:09PM (#28352217)
> An additional problem here is that there’s no standard way to represent EXPLAIN queries across systems so that makes an additional barrier to entry unfortunately.

What so you mean by this?

[ Parent | on HN ]
Re:Challenges students face when learning to work with relat... by prpl on Sunday August 29, 2021 @10:51PM (#28352400)
The outputs from each DBMS are often specific to their implementation, even when there is a lot of overlap. The good news is they are usually similar enough and user friendly enough that an advanced user will have no issue but for beginners it can be daunting.
[ Parent | on HN ]
Re:Challenges students face when learning to work with relat... by fomine3 on Monday August 30, 2021 @02:55AM (#28353315)
Anyway beginners learn by just using single RDBMS, isn't it?
[ Parent | on HN ]
Re:Challenges students face when learning to work with relat... by prpl on Monday August 30, 2021 @06:35PM (#28361734)
Not necessarily. I often see people learn starting with SQLite because it's easy/installed (and quite a bit of tutorials start with it, especially for Python), and then move to MySQL/Postgres, but that is N=2 so it's not too bad.
[ Parent | on HN ]