Advanced Search
Search Results
164 total results found
Database Comparisons
SQL Databases relational normalized data (minimum duplicate data) Uses B Tree or B+ Tree indexing, where B+ Tree is more common Fast reads but slow writes good for situations where correctness is more important than performance, like banking, job sched...
Network Protocols
HTTP, WebSocket, gRPC, WebRTC original post: GetStream Communication Protocol? a protocol is a set of rules that govern how data is exchanged over the network Multiplexing to allow multiple requests and responses to be multiplexed over a single connectio...
Database Replications
Sync vs Async replication sync ensures strong consistency, but slower writes async ensures fastest writes, but result in eventual consistency or even data lost in case of failure Single Leader Replication problems with failover some writes from previous l...
Database Indexes
B-Tree Index Pros: fast read, fast range query no limit on number of keys Cons: slow writes Hash Index Pros: O(1) read and write Cons: keys needs to fit in memory no range queries allowed LSM Tree Index Red-black tree, balanced binary tree, et...
Elastic Search Cheatsheet
What is it? a convenience wrapper around Lucene to allow for fast searching in a distributed system it stores data itself across multiple horizontal nodes data are stored in JSON documents excels at full-text search near real time search results, making it su...
Fundamentals
Push Type Message Queue optimized for latency messages are pushed out as soon as they arrive client (consumer) is lightweight load balancing amount competing consumers flow control hard to configure the push speed when not knowing the current work load of...
Cassandra Cheatsheet
ref: Jordan Key characteristics WideColumnStore Eventual Consistency Tunable ACID LSM Tree Index Bloom filter Designed for single partition read and write It's recommended that read and write of the same data go to the same shard Index no global secondary...
CI/CD
What is CI/CD? Continous Integration and Continouse Delivery an automated workflow that simplifies testing and deployment when a feature is pushed, it triggeres automated testing, then if everything is ok, changes are merged to release branch, and when condit...
Apache Flink
Stream Processing Frameworks Key Use Cases: Real-time analytics: Fraud detection, anomaly detection, recommendation systems Data pipelines: ETL (Extract, Transform, Load), data ingestion, data enrichment Stream processing: IoT data processing, financial ma...
K8S Interview Questions
Explain Kubernetes Architecture API server, controller manager, scheduler, etcd kubelet, kube-proxy, POD, containers What is container orchestration create/updaste/delete containers automatically based on the deloyment needs autoscaling What is a context ...
DB Design Tips
Don't use business related field as primary key business related fields examples: individual tax number, national company number, etc it's not a good idea: some business related field data may change don't have control over this field (format may change in f...
Kafka Cheatsheet
Kafka Fail Reason 1: Lack of Expertise and Resources scaling and implementing Kafka solutions requires a high degree of expertise installation, development, operations underprovisioned configuration results in high risk of system failures, but overprovisioned...
Flutter Cheatsheet
Print dependencies tree flutter pub deps -s tree How to get virtual device storage on host machine?
Control Plane Installation
Install Containerd Installation Instructions
AWS Cheatsheet
Get current logged in user $ aws sts get-caller-identity { "UserId": "AIDA3C6FL2I6WTCTDQ5V7", "Account": "762233737789", "Arn": "arn:aws:iam::762233737789:user/logan.13668" } Add a profile to command line vi ~/.aws/credentials # add profile in th...
Data Transfers
TUTK V1GX3K4WXUC6B672333C 5HBNK58NJ83F57L2333C 193RAF6L3G3CA4E4333C LTYCEUA33JBETG7B333C 427M6WBTXDCM5HHP333C IMOU Accounts: tester1@example.com etidev_uce989b93-8257-4436-b283-e19d2c17b0ce_dev@etinc.ca Android https://defender-static-public2.s3.us-eas...
P2P CheatSheet
What is P2P? It's a general term to describe two machine can communicate directly with each other without an intermediate server. Each machine acts as the server and receiver. How does P2P communication work? There is a central server (Rendezvous Server) used...
TUYA Documents
AWS RDS Best Practices
upg.bin.enc reference: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_BestPractices.html https://drive.google.com/file/d/1ntwmblVekoE2FUrEAJaFlolHEJydR9n4/view?usp=drive_link Basic operational guidelines use metrics to monitor memory, CPU, replic...
CloudWatch
Core component of CloudWatch Metrics collects performance data points, like EC2 CPU, or # of reqests to a Lambda function Logs a centralized service for collecting, storing, and analyzing log files Alarms set a threshold on any metric Dashboards Even...