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

Be a Better Programmer

D-Obfuscating Google Play Store Crashes/Logs(Android)

Website Video Production in Syderstone | ShowReel #Website #Video #Production #Syderstone https://t.

Practical Tips for new & aspiring Chingu mentors

Analytics on Kafka Event Streams Using Druid, Elasticsearch and Rockset

AWS Lambda, creating your first lambda function…

RAGE is now on Bitbns!

10 tips for building “Purely” horizontal scalable Architectures

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

Bitcoin sits at the last level of crucial price support

Bitcoin sits at the last level of crucial price support

Opening Up on Open Source

How Parents Can Educate Toddlers And Promote Early Learning

IS Webinars 2022 Experience