17 Ağustos 2022 Çarşamba

Perfect visualizations of Joins in SQL

Here they are..





SQL Cheatsheet

 A nice SQL cheatsheet from here:



What did Acemoglu get wrong

Here's an excellent podcast for those interested in development economics and the drivers of economic growth: (Daron Acemoglu interviewed with Alice Evans)

https://open.spotify.com/episode/76fLUVwGM4glpRQ0dwhf58?si=8KuXHzP_TcmtnYbxnF6QfQ&nd=1

Downloading Youtube videos and converting docs to pdf with Python

 Here's a tweet (and the video) showing how to download a Youtube video in mp3 format with Python. You can follow Python coding channel to see such videos.


Another video here shows how to download videos (not just in mp3 format) with the same library:


Lastly, this video shows you how to convert a .docx file to a pdf:

2 Ağustos 2022 Salı

Exercises to improve photographic memory (speed reading exercises)

 Here they are: https://www.hizliokuma.org/mho/

I used to try them years ago and was happy to see some positive results while reading. This exercise is useful to improve eye span and grasp what you see very quickly.

This is just the first step for speed reading. The next step may be doing flashing blocks or numbers tests. (One example here: https://humanbenchmark.com/tests/memory)

These exercises can make it possible to grasp paragraphs or even pages at first sight. (I'm not at that level, unfortunately :) )

I think everyone should try it. If a chimpanzee can do it, why wouldn't we? (test here: https://humanbenchmark.com/tests/chimp, a better one here: https://chimptest.zone/)

Creating indexes for effective queries in SQL

 Here is a nice video about indexing and saving some time while doing SQL queries.