React catch up 2

https://github.com/InfiniteLibrary/infinite-reader
https://reactjs.org/tutorial/tutorial.html

Funny geohot meditation

Some shit ab REST API
https://medium.com/@petertboyer/learn-restful-api-design-ideals-c5ec915a430f

ie. 400 code indicate requested information is incomplete or malformed.

https://www.quora.com/Should-every-table-in-a-database-have-an-ID-column
short answer is yes since requirement change all the time and out weight normalization  (in most case) ?

https://stackoverflow.com/questions/16815551/how-to-do-this-in-laravel-subquery-where-in
Products::whereIn('id', function($query){
    $query->select('paper_type_id')
    ->from(with(new ProductCategory)->getTable())
    ->whereIn('category_id', ['223', '15'])
    ->where('active', 1);
})->get();


Faster port check on OSX
sudo lsof -i :8081

alias port3='sudo lsoft -i '
usage: port3 :8081



- You will be part of an agile Scrum team to develop multiple web applications;
- You will be interested in learning about web technologies and be able to educate yourself.

Your Skills and Experience

Must-have Skill:

- Expert understanding of JavaScript and the framework Vue.js;
- Strong knowledge of best practices for clean UI development;

- Knowledgeable in Node.js development;
- Knowledgeable in RESTful APIs and modern web standards;

- Experience with AWS is a plus;
- Willingness to share your experience with your team and lead them;
- Intermediate English skills (understanding of requirements, basic communication).

Experience:  3-5 years of related working experience.

https://itviec.com/it-jobs/fullstack-dev-java-javascript-devops-mgm-technology-partners-vietnam-3005

Cool advertise but not match with ThoughtWork :)
mgm - Software Engineers to the bones. We code for Fortune 100 customers and have fun while doing so

Your Skills and Experience

    Experience with multi-tier or service-oriented web applications
    Understanding of software development tools, processes and architecture
    You use state of the art technologies: Java, TypeScript, React, SQL
    If you do DevOps or .NET/C# we are also curious to get to know you
    Degree in engineering or natural sciences (university or technical college)
    Very good English both written and spoken
    Sense of responsibility, communication skills and team spirit
    Willingness to learn and build a deep understanding
    A passion for software development, new trends and technologies in IT
    2+ years of professional experience in international software projects


https://www.vox.com/science-and-health/2020/3/6/21161234/coronavirus-covid-19-science-outbreak-ends-endemic-vaccine

Eloquent / MySQL increment without primary key.
It seem we can use KEY / Index but Eloquent migration syntax not supported this ?
I mean when use ->increments() => it auto mark as Primary Key (?).

https://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format

Yep, another timestamps() mismatch with MySQL

https://stackoverflow.com/questions/34515938/laravel-timestamps-doesnt-create-current-timestamp

Oh, hasManyThrough
https://laravel.com/docs/5.8/eloquent-relationships#has-many-through
Damn the fucking manual

Yeah magnificent query
Execute    select count(*) as aggregate from `Review` inner join `ShopData` on `ShopData`.`shop_id` = `Review`.`shop_id` where `ShopData`.`deleted_at` is null and `ShopData`.`municipality_id` = '011011'

Damn new stuff I learned that I think I known :(

TODO custom result ie. only get first (latest) review in each municipality or shop ?


https://stackoverflow.com/questions/30770148/what-is-class-in-php
Many thing about PHP and programming that I think useful, I mean productivity and clean/better code... more understanding lib/framework in how it constructed.
It may be more blur and not easy to recognize as for example Bash skill, you know some useful bash then you can apply your knowledge instantly, reduce time, automate etc.


Some shit ab relation
https://stackoverflow.com/questions/21615656/get-array-of-eloquent-models-relations