TIL

• PGTune - cal­cu­late con­fig­u­ra­tion for PostgreSQL based on the max­i­mum per­for­mance for a given hard­ware con­fig­u­ra­tion
  • We in­put our server spec and then it will tell what the con­fig­u­ra­tion we can use as starter
• Jitsu : Open Source Data Integration Platform
  • It was a re­al­time data pipeline tools that has script­ing ca­pa­bil­ity
  • It has a fea­ture to track events that is emit­ted from an app
  • It sup­port JS to do data trans­for­ma­tion
  • built in Go
• What is dbt? | dbt Docs
  • DBT is a tool that can trans­form data from an SQL source
  • DBT has a Jinja tem­plate com­piler, so we can add some Jinja logic into our SQL query. Example taken from the blog
    • Ref: https://​blog.get­dbt.com/​what-ex­actly-is-dbt/

    
    select * from {{ref('really_big_table')}}
    
    {% if incremental and target.schema == 'prod' %}         
    
        where timestamp >= (select max(timestamp) from {{this}})     
    
    {% else %}         
    
        where timestamp >= dateadd(day, -3, current_date)     
    
    {% endif %}
    

• Gerrit Code Review | Gerrit Code Review
  • This is a code re­view tool used by Google
  • Quite in­ter­est­ing, have many fea­tures
  • One of them are Go: sta­tus:open -is:wip · Gerrit Code Review