Kovid Rathee
Data & Infrastructure Engineer who writes about tech, music, and other things.
Recently Published
What is a multi-model database?
What is a multi-model database?
Top SQL GUIs for Your Data Warehouse (Snowflake, BigQuery, Redshift)
Top SQL GUIs for Your Data Warehouse (Snowflake, BigQuery, Redshift)
Compare the top SQL GUIs for data warehouses—Preset, Metabase, Hex, and Retool—plus pros, cons, and features for each.
Overcoming database scaling issues with Fauna’s serverless offering
Overcoming database scaling issues with Fauna’s serverless offering
Edge computing reference architectures
Edge computing reference architectures
What is Change Data Capture? Common CDC methods
What is Change Data Capture? Common CDC methods
What is change data capture (CDC), and what are the common methods for implementing CDC?
Choosing Effective SLIs
Choosing Effective SLIs
Doing SRE The Right Way
Doing SRE The Right Way
A well-thought-out approach to SRE, which will help site reliability engineers and software engineers develop and maintain a useful, consistent, and effective SRE strategy for their products!
Automatic Instrumentation and OpenTelemetry
Automatic Instrumentation and OpenTelemetry
Browser-based Database Clients
Browser-based Database Clients
Data Warehouse Migration with AWS DMS
Data Warehouse Migration with AWS DMS
Notes on Migrating an existing Data Warehouse from Aurora PostgreSQL to Redshift
QuestDB vs. TimescaleDB
QuestDB vs. TimescaleDB
The Art of Discarding Data
The Art of Discarding Data
AWS RDS Cheatsheet
AWS RDS Cheatsheet
And notes on using the relational database service by AWS
Git for Data Engineers
Git for Data Engineers
Proof of Concept Work
Build a Crypto Price Tracker using Node.js and Cassandra
Build a Crypto Price Tracker using Node.js and Cassandra
Since the big bang in the data technology landscape happened a decade and a half ago, giving rise to technologies like Hadoop, which cater to the four ‘V’s. — volume, variety, velocity, and veracity there has been an uptick in the use of databases with specialized capabilities to cater to different types of data and usage patterns. You can now see companies using graph databases, time-series databases, document databases, and others for different customer and internal workloads.
Real-time Stock Price Alerts using Python, Grafana & QuestDB
Real-time Stock Price Alerts using Python, Grafana & QuestDB
Use Python to query stock prices via REST API, stream the results to QuestDB, and configure Slack alerts based on changes in time series data using Grafana.
SQL Extensions for Time Series Data in QuestDB
SQL Extensions for Time Series Data in QuestDB
Schemaless Ingestion in QuestDB using InfluxDB line protocol
Schemaless Ingestion in QuestDB using InfluxDB line protocol
Database Testing
Common Database Testing Problems
Common Database Testing Problems
Automation Testing for Data Systems
Automation Testing for Data Systems
A short introduction to automation testing for Databases, Data Warehouses, and Data Lakes
ML/AI
Machine Learning Reliability Engineering
Machine Learning Reliability Engineering
The MLOps Toolkit
The MLOps Toolkit
Data & Infrastructure Engineering
Handling Geospatial Data in AWS
Handling Geospatial Data in AWS
The New Data Engineering Stack
The New Data Engineering Stack
The Case for Using Timeseries Databases
The Case for Using Timeseries Databases
Data Pipeline Design Principles
Data Pipeline Design Principles
Numbers Every Data Engineer Should Know
Numbers Every Data Engineer Should Know
Git Best Practices for SQL
Git Best Practices for SQL
Rookie Git Mistakes to Avoid
Rookie Git Mistakes to Avoid
Ultimate PySpark Cheat Sheet
Ultimate PySpark Cheat Sheet
Easy Fixes for SQL Queries
Easy Fixes for SQL Queries
Complete Data Engineer's Dictionary
Complete Data Engineer's Dictionary
Easy Fixes for Redshift Performance
Easy Fixes for Redshift Performance
How to Think About Data
How to Think About Data
How to Avoid Writing Sloppy SQL
How to Avoid Writing Sloppy SQL
4 Advanced SQL Features You Haven't Used Enough
4 Advanced SQL Features You Haven't Used Enough
Easy Fixes for SparkSQL Performance
Easy Fixes for SparkSQL Performance
Newsletters & other Publications
Updates on Amazon Redshift's RA3 Type Instances
Updates on Amazon Redshift's RA3 Type Instances
How to Think about Data (Spanish Translation), Featured in datasource.ai
How to Think about Data (Spanish Translation), Featured in datasource.ai
Featured in The Institute for Ethical AI & Machine Learning Newsletter
Featured in The Institute for Ethical AI & Machine Learning Newsletter
AWS HealthLake & Redshift ML
AWS HealthLake & Redshift ML
Featured in Software Testing Weekly Issue #65
Featured in Software Testing Weekly Issue #65
Featured in DBWeekly Newsletter
Featured in DBWeekly Newsletter
Year in Writing
2020
2020
LinkedIn
LinkedIn
Email
Email
Payment
Payment
View on mobile
Explore other Linktrees
Newt
@newton
straycats
@straycats
rachelscanlon
@rachelscanlon
Melissa Becraft
@melissabecraft
Jenn Leuke
@jenneatsgoood
Popcast
@popcast
Billie Eilish
@billieeilish
morepurposepod
@morepurposepod
Sabrina Carpenter
@sabrinacarpenter
breakingrust
@breakingrust
previous
next
Discover more
See all
@Reason2x
@zabutom
@titoguerra
@fatimasblog
@Yuby_fig
@Intersect_news
@mapaylosamigos
@evitapkcoaching
@stathanasius
@lmnegociosimobiliarios_
@support_test_tompro
@Nellieedens
@ignacio.djk
@nellyjewelrys
@qcompra
@ohmycases
@shampoo.acondicionador
@farmstable
@aseeraproject
@masatoshi.fukumoto
@thejoyfullrose
@DolceliciousByErica
@redaakash
@stephanconradi
@Cearamor
@velvetvintageclt
@Jenny__Cervantes
@rosiikhaa
@rabab.alhassan
@jahzreuben
@marcela.aguilar
@agsmun
@LostMarbles89
@danielbovolon
@triplepick
@CustomerXSuccess
@DaveSongseah
@dLaycutty
@cafezouklahore
@Juliana.rossato
@Gamemie
@atleticafatectatuape
@Makaydagustave
@lifemodel.rach
@drvegroom