miércoles, 30 de octubre de 2019

Postgres 12 and a db course

Postgres 12 was recently released with some great features like concurrent reindex, jsonpath, and other stuff: https://www.postgresql.org/about/news/1976/  and https://www.postgresql.org/docs/12/release-12.html are good general info pages for the new stuff there.

Then, this is a great course about databases. It is about the internals of databases: https://www.youtube.com/watch?v=1D81vXw2T_w&list=PLSE8ODhjZXjbohkNBWQs_otTrBTrjyohi&index=1 . Really cool (at least the first 4 lectures).

Another sql thingie:
Julia Evans has this select order of execution that also is quite helpful if you're learning SQL https://news.ycombinator.com/item?id=21150606 .

EDIT: An advanced db course from Pavlo (great, more courses!): https://www.youtube.com/playlist?list=PLSE8ODhjZXja7K1hjZ01UTVDnGQdx5v5U

viernes, 18 de octubre de 2019

Updated interview questions

My new questions for interviews:

  • Tell me about 3 (tech?) talks you think are worth mentioning (you like them very much or you dislike them)
  • 3 books (technical or not)
  • Show me something in your Github, or github log (timeline matters)
  • Would you recommend me to read any code from a library? 
  • do you have any comments on the following code? Imagine it comes in a PR you are reviewing. 
  • name 3 famous computer scientists/programmers. Expand on why if you want.