Some system ideas to recap

When fetching data from data base, we could have multiple DB query from client code to get different data we need, and then processing/union form the client side logic.

Another common trick around here, is to using 1 query with JOIN operation to push some of the work load to the database execution engine.

TODO: add some properties around join

MySQL is more friendly to join operation.

Inner join, outer join, left join, right join will produce different results.

2. Different ways of indexing, recap

3. cache inconsistency and cache invalidation

4.API design

which request methods are natural for retry / idempotent. which request methods are checking for duplicate / how to handle user session or id inside request ./ different HTTP request / restful API version concept.

5. scale of number and their interchange? MB -> B, ns->s etc

6. file system VS database.

7. processing queue / encoding queue

8. video / music / photo related techniques.

9. parallel processing, split file in chunk and handling in parallel

--

--

--

engineer + vlogger

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

옵저버, 웨더스테이션 배포관련 공지 #1

Introduction to Graph Database in AWS

Running Flannel on EKS

CS371p Spring 2021 Week 7

What is Media Queries?

Apache Superset Integration with Keycloak

The Challenges Of Open Source From The Eyes Of a Student.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
dknight

dknight

engineer + vlogger

More from Medium

What will future bring?

ADC Blockchain Upgrade FAQ

12 Cybersecurity tools I learned in 2021

TV And Film Investor Rocky Shi Shares His Top Streaming Platforms For 2022