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

Load Shedding for High Traffic Systems

https://www.codereliant.io/load-shedding/

Web Pages performance improvement - pagespeedchecklist.com

 https://pagespeedchecklist.com/

MySQL - finding out slow queries

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

Database related - How We Learned to Stop Worrying and Read from Replicas

https://medium.com/box-tech-blog/how-we-learned-to-stop-worrying-and-read-from-replicas-58cc43973638 

Rails - Counter Cache

Counter Cache

https://rubyinrails.com/2019/04/10/rails-counter-cache-associations/

https://scoutapm.com/blog/how-to-start-using-counter-caches-in-rails

For many-many association:

https://coderwall.com/p/muvy9w/forget-counter-cache-for-many-to-many-associations-in-rails

https://stackoverflow.com/questions/9595338/counter-cache-for-a-model-with-a-many-to-many-association

https://stackoverflow.com/questions/5256897/counter-cache-with-has-many-through

Rails related - Performance improvement

View performance: 

https://blog.appsignal.com/2020/01/22/rails-is-fast-optimize-your-view-performance.html 

ActiveRecord performance:

https://blog.appsignal.com/2021/02/24/troubleshooting-activerecord-performance.html

Rails - performance - Finding slow ActiveRecord queries with Scout

 https://scoutapm.com/blog/finding-slow-activerecord-queries-with-scout

Monitoring Kubernetes with Prometheus

https://scoutapm.com/blog/monitoring-kubernetes-prometheus

Implementing a Task Queue in SQL

 https://reflect.run/articles/sql-queue/

How to serve scaled images

 https://twitter.com/michaelketzer/status/1424651837848834049?s=21

SQL, NoSQL, and Scale: How DynamoDB scales where relational databases don't

https://www.alexdebrie.com/posts/dynamodb-no-bad-queries/ 

developer.mozilla.org - Populating the page: how browsers work

https://developer.mozilla.org/en-US/docs/Web/Performance/How_browsers_work 

https://developer.mozilla.org/en-US/docs/Web/Performance

Applying Textbook Data Structures for Real Life Wins

 https://heap.io/blog/engineering/applying-textbook-data-structures-for-real-life-wins

The Problem with Threads

https://www2.eecs.berkeley.edu/Pubs/TechRpts/2006/EECS-2006-1.pdf 

https://www.reddit.com/r/programming/comments/jwkdqq/the_problem_with_threads/

Do You Actually Need Kubernetes?

https://medium.com/better-programming/do-you-actually-need-kubernetes-a342b0a90fd8

 

Concurrency In The Erlang VM

 https://www.skcript.com/svr/concurrency-in-the-erlang-vm/

Custom CloudWatch Metrics From Your App

 https://insights.dice.com/2020/08/14/learning-aws-custom-cloudwatch-metrics-from-your-app/

The myth of NoSQL (vs. RDBMS) “joins dont scale”

https://blog.dbi-services.com/the-myth-of-nosql-vs-rdbms-joins-dont-scale/

Rack::Attack - Rack middleware for blocking & throttling abusive requests

iptables
    |
   V
nginx  -   ngx_http_limit_conn_module
    |
   V
rack middleware - rack attack

Iptables:
https://duckduckgo.com/?q=iptables&t=brave&ia=web

Nginx ngx_http_limit_conn_module:
https://nginx.org/en/docs/http/ngx_http_limit_conn_module.html#limit_conn_zone

Rack Attack links:
https://github.com/kickstarter/rack-attack
https://kickstarter.engineering/rack-attack-protection-from-abusive-clients-4c188496293b
https://blog.bigbinary.com/2018/05/15/how-to-mitigate-ddos-using-rack-attack.html
https://dylanwolff.com/posts/blocking-abusive-requests-to-your-ruby-app-with-rack-attack/
http://blog.hayleyanderson.us/2015/06/05/using-and-testing-rack-attack-to-improve-the-security-of-your-rails-app/