Redux - calling APIs

https://redux.js.org/advanced/asyncactions

https://redux.js.org/introduction/examples#real-world
https://codesandbox.io/s/github/reactjs/redux/tree/master/examples/real-world

https://redux.js.org/advanced/exampleredditapi

About Elixir

LMAX Disruptor concurrent framework

http://lmax-exchange.github.io/disruptor/files/Disruptor-1.0.pdf

React related: API calls when using Redux

https://www.reddit.com/r/reactjs/comments/4yesxn/api_calls_in_a_redux_app_best_practice/

AWS Cloud Development Kit

AWS re:Invent 2018: Infrastructure Is Code with the AWS Cloud Development Kit (DEV372)

https://www.reddit.com/r/programming/comments/a22fay/aws_infrastructure_as_code_using_aws_cdk/

Distributed Databases related - Citus & PostgreSQL

https://www.citusdata.com/blog/2018/11/30/why-rdbms-is-the-future-of-distributed-databases/
https://www.reddit.com/r/programming/comments/a1wwdh/why_the_rdbms_is_the_future_of_distributed/

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

Algorithms related

Elixir - When to use Elixir language?

https://www.amberbit.com/blog/2018/5/15/when-to-use-elixir-language/

Ruby concurrency related

https://vaneyckt.io/posts/ruby_concurrency_in_praise_of_the_mutex/

labex.io - online courses with virtual environments

https://labex.io/courses

Has courses for Alibaba Cloud also.

up - tool for writing Linux pipes

https://github.com/akavel/up

up is the Ultimate Plumber, a tool for writing Linux pipes in a terminal-based UI interactively, with instant live preview of command results.

The main goal of the Ultimate Plumber is to help interactively and incrementally explore textual data in Linux, by making it easier to quickly build complex pipelines, thanks to a fast feedback loop. This is achieved by boosting any typical Linux text-processing utils such as grep, sort, cut, paste, awk, wc, perl, etc., etc., by providing a quick,interactive, scrollable preview of their results.

IronDB, EverCookie

https://github.com/gruns/irondb
https://github.com/samyk/evercookie

Internationalization - React vs Angular

https://hackernoon.com/internationalization-in-angular-and-react-applications-a-comparison-93883f4e1cdb

Make sure to read the comments too.

Rails: scopes

https://www.justinweiss.com/articles/how-to-preload-rails-scopes/

Phoenix related - LiveView, Drab, Texas - alternatives to using Frontend JS Frameworks

Drab:
https://elixirforum.com/t/drab-remote-controlled-frontend-framework-for-phoenix/3277

LiveView:
https://elixirforum.com/t/phoenix-liveview-info/16569

Texas:
https://gitlab.com/dgmcguire/texas

Erlang 'process'

https://www.quora.com/What-is-the-difference-between-system-threads-and-process-threads-as-in-Java-threads

Excerpt:

Erlang uses the term "process" because it does not expose a shared-memory multiprogramming model. Calling them "threads" would imply that they have shared memory.

Comparison of Erlang Runtime System and Java Virtual Machine

http://ds.cs.ut.ee/courses/course-files/To303nis%20Pool%20.pdf
https://www.javacodegeeks.com/2011/04/erlang-vs-java-memory-architecture.html
https://tech.labs.oliverwyman.com/blog/2006/09/10/erlang-processes-vs-java-threads/

Redis use cases

https://www.quora.com/Why-use-Redis-What-use-cases-is-it-good-for-and-why
https://www.quora.com/Is-Redis-an-alternative-to-a-database-Why-do-I-need-Redis-if-Im-using-a-MySQL-DB

Why Akka & Java versus Elixir/Erlang

http://qr.ae/TUGS10
https://www.quora.com/Why-should-we-reinvent-the-wheel-by-using-Akka-with-Java-if-we-have-Elixir-Erlang-ready-for-production

Elixir Intro

MySQL: Status variables in MySQL

https://stackoverflow.com/a/44856922

react-native-turbolinks

https://github.com/lazaronixon/react-native-turbolinks

Mongo - exporting and importing a single database

On Source Machine
-------------------------
mongo
> show dbs
> exit

mongodump -d abc_xyz_development

(Above command will create a dump/abc_xyz_development folder and put all the files inside it. This folder will need to be zipped and sent to whoever wants to import the database)

On Target Machine
-------------------------

Drop existing database
mongo

> show dbs

> use abc_xyz_development;
> db.dropDatabase();
> exit

Restore from Dump folder:
Command:
  mongorestore -d
E.g.
  mongorestore -d abc_xyz_development ~/abc_xyz_development

Elixir, OTP related: Basics

Elixir GenServer

Phoenix’s LiveView

https://shift.infinite.red/phoenixs-liveview-client-side-elixir-at-last-2280716ae791

Cons of NoSQL, Intro to MemSQL

https://www.memsql.com/blog/nosql/

How to create an OS from scratch

https://github.com/cfenollosa/os-tutorial

Graphql related: Cons of Graphql

https://blog.logrocket.com/5-reasons-you-shouldnt-be-using-graphql-61c7846e7ed3

Elixir: Algorithms & Data Structures

https://elixirforum.com/t/exads-elixir-algorithms-and-abstract-data-structures-collection/139
https://github.com/sashaafm/exads
https://medium.com/@sashaafm/developing-an-algorithm-and-data-structures-collection-in-elixir-part-ii-binary-search-tree-8c18e2294dee

React & JSX related: using JSX without React, minimal setup for trying out React

using JSX without React:
https://itnext.io/lessons-learned-using-jsx-without-react-bbddb6c28561

Minimal React.js Without A Build Step:
https://shinglyu.github.io/web/2018/02/08/minimal-react-js-without-a-build-step-updated.html

zeu.js - A JavaScript library for real-time visualization

https://github.com/shzlw/zeu
https://shzlw.github.io/zeu/docs/introduction.html

Infinite Scroll related

https://stackoverflow.com/questions/23961566/javascript-infinite-scroll-inside-a-div

Elixir Umbrella - Microservices or Majestic Monolith? Georgina McFadyen - Elixir.LDN 2017

Robust Data Processing Pipeline with Elixir and Flow - Laszlo Bacsi - ElixirConf EU 2018

Building videochat with Elixir and Phoenix - Anil Wadghule - ElixirConf EU 2018

43:45 / 43:54 Rewriting a legacy application in Elixir - Raphael Costa - ElixirConf Eu 2018

Elixir vs Node

https://slides.com/chrisgeihsler/elixir-v-node#/110

Rails - Consuming local JSON API from another controller

https://stackoverflow.com/questions/15042783/rails-consuming-local-json-api-from-another-controller

Only Remote Developers Job Board

http://eastvox.com/

Getting started with DevOps

https://linuxacademy.com/blog/devops/what-does-it-mean-to-do-devops/

A step-by-step implementation for genetic algorithms

https://www.aitribune.com/article/2018071087

ramd.js JavaScript library for making web applications.

https://github.com/vladocar/ramd.js

CAP Theorem

http://www.acodersjourney.com/2018/07/system-design-interview-cap-theorem/

Spotify Engineering Culture

Spotify Engineering Culture

Spotify Engineering Culture - Part 1 - 
Video: https://vimeo.com/85490944
Medium article: https://medium.com/project-management-learnings/spotify-squad-framework-part-i-8f74bcfcd761

Spotify Engineering Culture - Part 2 - 

Video - https://vimeo.com/240501738

Medium article - https://medium.com/project-management-learnings/spotify-squad-framework-part-ii-c5d4b9398c30

React JS prototyping - Building a high-fidelity prototype

https://www.youtube.com/playlist?list=PLqGj3iMvMa4LFqyGab_aR7M0zfQm2KTuX

How is JavaScript used within the Spotify desktop application?

Quora question & answer:

https://www.quora.com/How-is-JavaScript-used-within-the-Spotify-desktop-application-Is-it-packaged-up-and-run-locally-only-retrieving-the-assets-as-and-when-needed-What-JavaScript-VM-is-used

Reddit Comments:

https://www.reddit.com/r/programming/comments/901p0j/former_software_engineer_at_spotify_on_their/

EDIT: It turns out that the Quora post was from 2015. The Reddit comments are scathing in their appraisal now.

Using jQuery vs more advanced JS frameworks

"Jquery results in mostly event handling and procedural code. The more advanced frameworks, if used properly end up more declarative with some event handling. That's much easier to write, read and understand."

Card

Rails: Decorators vs Helpers

https://stackoverflow.com/questions/45468184/decorators-vs-helpers-in-rails

Rails related blog

2015 blog by Vaidehi Joshi - has posts about Rails - 1 post per week in 2015

http://vaidehijoshi.github.io/
http://vaidehijoshi.github.io/blog/categories/number-technicaltuesdays/

Computer Science Basics

2017 blog by Vaidehi Josh

https://medium.com/basecs - 

Exploring the basics of computer science, every Monday, for a year.

https://medium.com/basecs/archive/2017/01

Rails related: Specifying rails version to use when creating a new application

https://stackoverflow.com/questions/379141/specifying-rails-version-to-use-when-creating-a-new-application

https://stackoverflow.com/a/42876273

ElixirDaze 2017- Solid Ground by Saša Juric

Design related

https://fundrequest.io/

Checkout the above site for a decent design to try and re-implement for practice

Reactive Programming related

https://itnext.io/i-would-love-to-see-you-do-it-better-and-cleaner-without-reactive-programming-545face12e1a

Ruby related: Hashie::Mash

https://www.schneems.com/2014/12/15/hashie-considered-harmful.html

Dunzo

https://www.dunzo.in/

The Moden C++ Challenge - good book to improve programming with general stuff

Book link in pactpub.com - https://www.packtpub.com/mapt/book/application_development/9781788993869

Blogpost about the book by a C++ expert:
- http://scottmeyers.blogspot.com/2018/06/interesting-book-modern-c-challenge.html

All in all, there are 100 problems in a variety of areas, including string processing, dates and time, concurrency, cryptography, and networking.

Airbnb’s new Design Language System

https://airbnb.design/the-way-we-build/

I did not understand much. Have to read these articles again.

Airbnb moving away from React Native

https://www.reddit.com/r/programming/comments/8saw35/airbnb_moving_away_from_react_native/
https://medium.com/airbnb-engineering/react-native-at-airbnb-f95aa460be1c

Ruby Design Pattern: Command Method

https://medium.com/@nakshtra17/ruby-design-pattern-command-method-3d1e3f41d39d

Common Gems

https://www.reddit.com/r/rails/comments/8r4t96/what_gems_do_you_consider_an_integral_part_of_the/

Ruby on Rails - how to create perfect enum in 5 steps

http://naturaily.com/blog/post/ruby-on-rails---how-to-create-perfect-enum-in-5-steps

Microservices & Mono Repo

http://blog.shippable.com/our-journey-to-microservices-and-a-mono-repository

ES5 vs ES6 ( With example code )

https://codeburst.io/es5-vs-es6-with-example-code-9901fa0136fc

Mongo - Export & Import

https://stackoverflow.com/questions/4880874/how-do-i-create-a-mongodb-dump-of-my-database

Applications of Lambda in Ruby

http://jetrockets.pro/blog/lambda

Learning operating system development using Linux kernel and Raspberry Pi

https://github.com/s-matyukevich/raspberry-pi-os

Large IT companies like TCS, Infosys, Wipro are going Agile

https://economictimes.indiatimes.com/tech/ites/why-it-companies-are-shifting-to-an-agile-work-model/articleshow/64430084.cms

Excerpts:

...

Though this method has been around for decades, it was restricted to small projects. 

....

Constructing HTML with Templates

Using templates with script type="text/template"

https://www.codereadability.com/constructing-html-with-templates/

Vue example

https://laravel-news.com/jquery-vue

Using Rails & Phoneix together

https://littlelines.com/blog/2016/09/27/using-phoenix-with-a-legagy-rails-app
https://medium.com/@sugarpirate/rise-from-the-ashes-incremental-apis-with-phoenix-b08cd66bd142

https://elixirforum.com/t/is-it-possible-to-use-rails-with-phoenix/2851

Gooact: React in 160 lines of JavaScript

https://medium.com/@sweetpalma/gooact-react-in-160-lines-of-javascript-44e0742ad60f

Rails ActiveRecord: Execute direct SQL

https://stackoverflow.com/questions/22752777/how-do-you-manually-execute-sql-commands-in-ruby-on-rails-using-nuodb