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

An Important Gap in Software Development Process: How to improve what already exists

Current Focus of most Processes is on getting things done (i.e. productivity) and not on encouraging/generating/collecting/discussing Ideas (i.e. innovation?).

Below post is on one of the problematic side-effects of such a focus, and a trivially simple, but powerful solution to deal with that problem.

In Software Development, when Tasks are created in Project Management tools like Jira, they are usually:

• Bugs to fix
• existing stuff is not working as intended
• Feature Improvement
• client wants to make changes/additions to the existing stuff
• OR client asks for a brand new feature

Bugs & Feature Improvements have one thing in common - the Point of Initiation of Work is a very clear business need. If all work is initiated like the above, we will end up with one Big Gap in our product development process - existing stuff never improves.

A Big Gap

Above categories miss one area - improving what already exists & works

Example:

• Let's take one webpage in our web-application where things are working as intended (i.e. no complaints/change-requests have come from clients/users)
• But there are aspects about it, like UI/Performance/UX, that different members of the team/company feel, can be improved.
• Currently there is no way for anyone to initiate work on that webpage 
• and that is the Big Gap i am referring to - there is no way to initiate work on existing stuff
• And this Big Gap continues to exist indefinitely, because there are always going to be tasks with higher priorities that need attending to, than discussing, for example, about some minor UX/UI improvement on a webpage that is seemingly working fine.

A Solution

How do we improve what already exists and works?

I have realized that when a team identifies a problem and discusses it, it generally tends to make a good decision about the solution.

Simply put, if a topic is brought up on the agenda, it gets addressed/resolved.

The converse is unfortunately true as well - if an issue does not reach the agenda, it never gets addressed/resolved.

So we need to somehow bring tasks related to 'improving Existing Stuff' onto the Agenda.

How do such tasks come into existence, so that they can be added to the Agenda?

We need ideas, in fact a lot of ideas, big and small, to improve what already exists.

In order to do this, in my opinion, we need to create/implement a new Category of tasks, perhaps called Suggestion For Discussion, or Discussion Task, or something like that.

• Creating a new category should be a trivial thing to do in tools like Jira

What is a 'Suggestion For Discussion / Discussion Task' ?

• if ANYONE in the team/company has a suggestion/idea, they create a Suggestion For Discussion /Discussion Task in the Project Management Tool (e.g. Jira)

Who is it assigned to?

• this is assigned to whoever is in charge of that specific area (a Project Manager or Product Owner, etc)

What is the Goal of such a task?

• The goal of such a task is to make sure a Discussion happens around the Suggestion given

How is such a task completed?

• the team can meet periodically (once a week, biweekly, monthly etc) to discuss such Suggestions
• the Agenda for such a meeting could be the set of Suggestions that PM/Product Owner has received recently. This is a very important aspect because
• having a very clear list of things to talk about is very different from adhoc-brainstorming-sessions
• ensures a sustainable way for doing the meetings
• People often stop going to meetings that are haphazard, and suddenly such meetings stop happening
• a decision is made to accept a Suggestion, not-accept a Suggestion, or to revisit the Suggestion later on, and this is how such a task is 'resolved'.

How will these tasks help in improving what already exists?

This simple idea/tool can help with the following:

• Provide a path in the process: This will give an official path for an idea/suggestion, however small or big, to reach fruition
• This is the main contribution of this idea/tool.

• Everyone thinks: Instead of Devs only writing code or QA only spotting issues, everyone will get a chance to think about how to contribute via Ideas/Suggestions as well

• Prevent Ideas from being forgotten: A person who has thought of an idea can create a Suggestions-for-Discussion task at that moment - this will prevent ideas from being lost

• Short-term effect: immediatley get to the job of improving existing stuff

• Long-term effect: foster a culture of innovation

• Maximize potential of existing team & Reduce burden on Superstars: Innovation/Ideas/Suggestions will not depend on just a few key individuals in the company, but will be the domain/responsibility of everyone. Superstars (i.e extremely talented individuals) like to work in stimulating & engaging environments where everyone is contributing, otherwise they also get fatigued.
• In cases where teams do not have Superstars, they can at least perform to the best of their collective potential.

• No Barrier for Contributing: New Employees Or Junior Team-members Or even Experienced team-members who are Not so Social, i.e anyone, can contribute ideas/suggestions without depending on what kind of personality they have OR what kind of personal rapport they have with a PM/Product Owner.

• Improved job satisfaction when ideas/suggestions are accepted

Why can't the person who has a Suggestion, just go and talk to the Product Owner/PM, OR discuss the idea in one of the meetings?

The reason why Discussing-with-PM-or-in-Meetings will not work is - 

• Things that are not urgent are better handled in an Asynchronous manner
• e.g. we stick a PostIt note or add a ToDo item somewhere to remember to do stuff that we have to do later.
• The very reason we use ToDo lists or PostIt notes, or even Project Management tools like Jira is because we cannot do all the things that need to be done at the same time.
• By this argument, Ideas/Suggestions for Discussion need to be treated in the same way.
• People might not feel comfortable suggesting minor improvements in a meeting-setting
• Consider the scenario of a Dev/QA who has thought of, not major improvements, but just a couple of minor UX improvements
• They might not feel comfortable speaking about such minor suggestions in meetings

Limit this idea to Existing Stuff ?

This simple tool/technique is actually about gathering ideas from everyone, and hence can be used to gather ideas about Existing Stuff as well as for New Features.

So the question is - is it better to limit this tool to gathering ideas about Existing Stuff? 

I am not sure about this. My current opinion is - 

• Initially i.e. until everyone gets used to it, it is probably better to limit this tool only to suggestions related to Existing Stuff
• This is needed because, it is important for everyone to understand that it is OK (and in fact, desirable) to contribute minor changes as well.
• If brand new Feature Improvements also are allowed to use this tool - this tool might get hijacked by the new & shiny stuff (and people might not feel comfortable contributing 'small' ideas).
• Perhaps we could have 2 separate categories, one for Existing Stuff and one for New Stuff.

Alternative Implementation

UserVoice is a widely used tool whose purpose is to collect ideas like I have discussed above.

However UserVoice is being used to collect feedback mostly from Clients/Users and not from Developers/QA/PMs. 

Perhaps Devs/QA/PMs can use something like UserVoice for the exact same purpose too.

However I feel it is easier & better to treat Discussion of Suggestions/Ideas as Tasks and hence use the same Project Management tool that is used for Bugs and Feature Improvements.

Final words

Current Focus of most Processes is on getting things done (i.e. productivity) and not on encouraging/generating/collecting/discussing Ideas (i.e. innovation?).

Suggestions/Ideas, however minor, are very important and hence need to be handled in the same process that is used for Bugs/Feature Improvements.