FastAPI in 5 minutes
Here’s a step-by-step guide for getting started with FastAPI with a code example and sample…
Read MorePostgres database performance tuning – step by step guide
Performance tuning a PostgreSQL server can involve a variety of different approaches, depending on the…
Read MoreDifference between Kubernetes and Docker?
Here’s a table summarizing the differences between Kubernetes and Docker: Kubernetes Docker Container orchestration system…
Read MoreWhen to use Apache Kafka?
Apache Kafka is a distributed streaming platform designed to handle high volumes of data in…
Read MoreComparison of different NoSQL solutions. MongoDB vs Cassandra vs DynamoDB vs Couchbase
Partitioning: Cassandra uses a technique called "partitioning" to distribute data across multiple nodes in a…
Read MoreRedshift Copy Command – Advanced Examples
COPY my_table FROM 's3://my-bucket/my-file.csv.enc' IAM_ROLE 'arn:aws:iam::123456789012:role/my-redshift-role' DELIMITER ',' ENCRYPTED KMS_KEY_ID 'arn:aws:kms:us-east-1:123456789012:key/1234abcd-12ab-34cd-56ef-1234567890ab';
Read MoreJoin two dataframe in polars
orders_products_inner_join = orders_df.inner_join(order_products_df, left_on='order_id', right_on='order_id') order_id user_id order_number order_date product_id quantity 101 1001 1 2022-03-15…
Read MoreHow to Join two data frames in pandas
pd.merge(table1, table2, on='id', how='left')
Read MorePython strptime and strftime with examples
Directive Meaning Example %Y Year (4 digits) datetime.datetime.now().strftime("%Y") returns '2023' %m Month (zero-padded) datetime.datetime.now().strftime("%m") returns…
Read MoreConnect redshift form python code
import boto3 import pandas as pd import json # Set up the connection client =…
Read More