Posts

Showing posts from May, 2023

What I learned this week - 22nd May 2023

CockroachDB   CockroachDB is a distributed SQL database that is designed to be scalable, reliable, and easy to use. It is a good choice for applications that need to be able to handle a large amount of data and traffic, and that need to be highly available. Feature CockroachDB MySQL PostgreSQL Scalability Horizontal Vertical Vertical Availability High Medium Medium Consistency Strong Eventual Eventual SQL compatibility Yes Yes Yes Geo-replication Yes No No FerretDB FerretDB is an open-source, distributed, and scalable document database that is compatible with MongoDB. It is built on top of PostgreSQL and uses its query planner and execution engine. This makes it a good choice for developers who are familiar with MongoDB and want to use a more scalable and reliable database. Feature FerretDB MongoDB DocumentDB Open source Yes No No Built on top of PostgreSQL MongoDB .NET Scalability High Medium Medium Reliability High Medium Medium Complexity High Medium Medium System Design Concept...

AWS RDS KMS Key Deletion

   Run script to delete the KMS Key Once keys are deleted, AWS doesn't delete the key permanently, it just marks the keys for deletion only, makes the keys disabled and delete after 7 days. AWS RDS using the key, won't be accessible. And we will see below error instead [  inaccessible-encryption-credentials ]. instead Recovery, in order to recover the RDS database back, followed below steps enabled the KMS Key, such that its not longer scheduled for deletion Restore the RDS database snapshot Create a new RDS database instance, you can't use the exact name, must name it something different , lets call is DB-2 Review all the details are correct such that Virtual Private Cloud, Security Group etc Delete the old RDS database ( DB-1 )  Rename database DB-2 and DB-1 Run all the tests and connectivity with database

What I learned this week - 15th May 2023

  inaccessible-encryption-credentials Spring IO AWS Serverless Innovation Spring GraphQL Python TikTok Netflix using Python - job posting Angular Signals - https://www.freecodecamp.org/news/angular-signals/ Some SQL rewind     - Find number of movies each director has directed            SELECT Director, count(*) as 'no. of movies' FROM movies group by Director;     -  Find the total domestic and international sales that can be attributed to each director                     SELECT m.Director , sum(b.Domestic_sales + b.International_sales) as total_Sales FROM movies m JOIN Box_Office b ON m.Id = b.Movie_id group by Director;

What I learned this week - 8th May 2023

SRE Site Reliability Engineering SCORP  Security Cost Operation Excellence  Reliability Performance DuckDB No to ENUM in TypeScript Tech Leadership Maker to Multiplier Technical Leadership Models As a leader, one of the most crucial aspects is to recognise how your behaviour and traits influence the team. use CFR (Cross Functional Requirements) not NFR (Non Functional Requirements) Influencing Styles -  revolutionlearning Assertion Persuasion Attraction Bridging Playlist on Tech Leadership  youtube.com Platform Engineering  Database Sharding  architecturenotes.co Serverless-Side Rendering Micro-Frontends by Luca Mezzalira  youtube.com LiFi - is a wireless communication technology which utilises light to transmit data and position between devices.

What I learned this week - 1 May 2023

 Vector Database Streaming Database RisingWave https://www.risingwave.dev/docs/current/intro/ Functionless https://www.alexdebrie.com/posts/aws-api-gateway-service-proxy/ https://serverlessfirst.com/functionless-integration-trade-offs/ Newman pre-request Saga Pattern https://microservices.io/patterns/data/saga.html prime video - microservices to monolith story