The Benefits of Materialized Views (and how to use them in your Ruby on Rails project)

https://medium.com/@rebo_dood/the-benefits-of-materialized-views-and-how-to-use-them-in-your-ruby-on-rails-project-4ac1b5432881

Ruby map, each, collect, inject, reject, select quick reference

http://queirozf.com/entries/ruby-map-each-collect-inject-reject-select-quick-reference

Caching strategies in Phoenix

https://elixirforum.com/t/what-are-the-caching-strategies-in-phoenix/12351/4

Rails Performance related: Using nginx as Reverse Proxy Cache

https://mattbrictson.com/nginx-reverse-proxy-cache

PostgreSQL & Homebrew

https://stackoverflow.com/questions/15301826/psql-fatal-role-postgres-does-not-exist
If you're using postgres from Homebrew, then you want /usr/local/Cellar/postgresql/9.2.4/bin/createuser -s postgres (for version 9.2.4, obviously). 

Internationalization using Gettext in the Phoenix framework

https://sevenseacat.net/posts/2015/i18n-in-phoenix-apps/

memory_profiler for ruby

https://github.com/SamSaffron/memory_profiler
https://blog.skylight.io/hunting-for-leaks-in-ruby/
https://samsaffron.com

C++ book

http://www.informit.com/store/modern-c-plus-plus-design-generic-programming-and-design-9780201704310

Database Indexes - How to determine if an Index is required or not

https://dba.stackexchange.com/questions/56/how-to-determine-if-an-index-is-required-or-necessary
http://blog.celerity.com/how-to-design-sql-indexes

MIPA

 

22/08/2017, 19:03:36

B-Trees in databases are not binary trees, they are BALANCED trees

Server-side Swift for Java Developers

MySQL - importing JSON (and new feature related to it)

https://mysqlserverteam.com/import-json-to-mysql-made-easy-with-the-mysql-shell/
https://mysqlserverteam.com/importing-data-from-mongodb-to-mysql-using-python/

Reversing an immutable list

https://hackernoon.com/interview-question-reversing-an-immutable-list-in-java-57a891a521c5

UUID related

Seems like an exercise in trying to hack something using UUID guessing -

https://medium.com/@evinsellin/communicating-through-uuid-conflicts-fe50134304db

DoodleMaster - a UI Mocking Tool

https://github.com/karanchahal/DoodleMaster

Electron, Desktop PWAs

Medium article:
https://medium.com/dailyjs/goodbye-electron-hello-desktop-pwas-f316b8f39882


YouTube video:

Elixir learning resources

https://alchemist.camp/start
https://exercism.io/

RxJS Reactive Programming

https://sinxloud.com/explain-rxjs-reactive-programming/

Virtual Machines and Docker

http://zonov.me/achieving-continuous-delivery-part-2-virtual-machines-and-docker-explained/

gzip, tar

https://unix.stackexchange.com/questions/445897/unzipping-a-gz-file-to-get-a-text-file-but-getting-a-binary-file

gzip -d document.txt.gz

https://unix.stackexchange.com/questions/93139/can-i-zip-an-entire-folder-using-gzip

How to use “grep” command to find text including subdirectories

https://askubuntu.com/questions/55325/how-to-use-grep-command-to-find-text-including-subdirectories

grep -Hrn 'search term' path/to/files

MySQL Slow Queries

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

Database related - Composite Indexes

How do composite indexes work - https://stackoverflow.com/questions/795031/how-do-composite-indexes-work


https://stackoverflow.com/a/795068

Composite indexes work just like regular indexes, except they have multi-values keys.

If you define an index on the fields (a,b,c) , the records are sorted first on a, then b, then c.

Example:

| A | B | C |
-------------
| 1 | 2 | 3 |
| 1 | 4 | 2 |
| 1 | 4 | 4 |
| 2 | 3 | 5 |
| 2 | 4 | 4 |
| 2 | 4 | 5 |

shareimprove this answer

edited Apr 27 '09 at 20:50

answered Apr 27 '09 at 20:05

Rik

21.9k114561

• 12 Please note also that indexes are stored as Btree, so an (a,b,c) index will help on a search on (a) and on (a, b),
   but not on other searches like (b) or (b,c). – aexl Apr 30 '16 at 17:53

Two single-column indexes vs one two-column index in MySQL?

https://stackoverflow.com/a/2349824

"MySQL can use multiple-column indexes for queries that test all the columns in the index, or queries that test just the first column, the first two columns, the first three columns, and so on. If you specify the columns in the right order in the index definition, a single composite index can speed up several kinds of queries on the same table." - Multiple-Column Indexes – AlikElzin-kilaka Sep 9 at 4:46


https://stackoverflow.com/questions/2349817/two-single-column-indexes-vs-one-two-column-index-in-mysql
https://stackoverflow.com/questions/179085/multiple-indexes-vs-multi-column-indexes?rq=1

Phoenix related: Future of Drab & LiveView discussion

https://elixirforum.com/t/drab-and-liveview-community-oddities/16483/26
https://elixirforum.com/t/54-elixirconf-us-2018-closing-keynote-chris-mccord/16445/30

Reddit discussion - Let's talk about Phoenix.LiveView from Chris McCord's talk at ElixirConf 2018 US

https://www.reddit.com/r/elixir/comments/9e7n88/lets_talk_about_phoenixliveview_from_chris/

Blockchain 2018: Myths vs Reality

https://www.erlang-solutions.com/blog/blockchain-2018-myths-vs-reality.html?utm_source=Reddit&utm_campaign=BlockchainMythsvsReality2018

Elixir - How can I schedule code to run every few hours in Elixir or Phoenix framework?

https://stackoverflow.com/questions/32085258/how-can-i-schedule-code-to-run-every-few-hours-in-elixir-or-phoenix-framework