Hacker News new | ask | show | jobs
by a-saleh 3358 days ago
I have learned SQL with Postgres, provided by my university, and found the "explain analyze" and "explain cost" to be a god-send :-) Especially when I was trying to learn the impact of various things on the query-execution time.

When I used MYSQL, I found its EXPLAIN counterpart much more rudimentary.

But if I were to teach somebody SQL, I would probably just use sqlite because it just uses a simple binary file as a backend and doesn't need a running process :)

I am not really OPS or DB guy, so I can't comment on meirts of the databases in production.