Understanding usage of Database Indexes with Rails

Types of Database Indexes when using Rails:

https://chatgpt.com/share/1c4a94ef-2f5d-4c77-8f7c-ebded5e6bf3c

Indexes for Dates:

https://chatgpt.com/share/e71c3bd7-3a05-48d6-8064-7dd64fb53672

MySQL CLI Output Formatting

https://chatgpt.com/share/4c875522-6581-4e91-97b0-1c786e65760e

mysql> pager less -S

MySQL: Importing & Exporting a database via mysql cli

https://chat.openai.com/share/31c2512f-8545-4e90-888b-91ee8a40a22b

MySQL for Developers course

https://planetscale.com/courses/mysql-for-developers/introduction/course-introduction

MySQL for Developers

https://planetscale.com/mysql-for-developers

MySQL - finding out slow queries

 SELECT * FROM `mysql`.slow_log ORDER BY query_time DESC;

SQL Tutorial for MySQL

https://www.mysqltutorial.org/

https://www.mysqltutorial.org/tryit/

SQL Window functions

https://www.sqltutorial.org/sql-window-functions/

https://www.mysqltutorial.org/mysql-window-functions/

Lost connection to MySQL server during query

https://samirbehara.com/2019/09/10/mysql-connectivity/

mysql2 gem problems on Mac

https://github.com/brianmario/mysql2/issues/1005

eremy commented on 26 Oct 2018

To fix for a manual gem install: brew install openssl gem install mysql2 -- --with-opt-dir="$(brew --prefix openssl)" To fix for all bundle installs: brew install openssl bundle config --global build.mysql2 --with-opt-dir="$(brew --prefix openssl)" bundle install

MySQL - compare DateTime fields

https://stackoverflow.com/questions/1058031/mysql-compare-two-datetime-fields

MySQL Slow Queries

SELECT * FROM `mysql`.slow_log ORDER BY query_time DESC;

MySQL: Status variables in MySQL

https://stackoverflow.com/a/44856922