DB Discussion
25-March-2025Postgres: TABLE Seperation:⛶Example scene: Movies
In the movies database, several tables are present like, movies, actors, directors, artists.
We can include all the results i...
Authentication and Authorization Microservice with Node.js, Express, PostgreSQL, and 2-Factor : Part 1
In today’s digital landscape, securing user authentication is more critical than ever. Whether you're developing a SaaS platform, an enterprise application, or a multi-tenant system, a robust authen...
Benchmarking Databases for Real-Time Analytics Applications
Choosing the right database for analytics is hard. With many options available, each is optimized for different use cases.Some databases are built for real-time analytics in customer-facing applicatio...
What is a Database? An Introduction
What is DataBase?
A database is a system that stores information so you can easily find, add, or change it later.To work with a database, we use SQL (Structured Query Language), which is a special lan...
Optimizing Data Sync from PostgreSQL to Databricks with Fivetran
In my previous work as a Platform Engineer for a remittance company, we faced a significant issue related to costs. Our Fivetran syncs were consuming an excessive amount of Databricks cluster resource...
How to Optimize Your PostgreSQL Ingest Rate (5 tips)
TLDR: Practical tips to improve ingest rates in Postgres and get more row inserts per second. Including those enhanced with TimescaleDB for time-series workloads. Jump to the full article
The ...
Run Postgres For Free: Top 3 Options
“When life gives you lemons, TAKE THEM; free stuff is cool.” ~ Teo Deleanu. And when life gives you PostgreSQL for free, you take that too. Why? Because taking free stuff isn’t just cool; it’s...
Using TF-IDF Vectors With PHP & PostgreSQL
Vectors in PostgreSQL are used to compare data to find similarities, outliers, groupings, classifications and other things.pg_vector is a popular extension for PostgreSQL that adds vector functionalit...
Introducing Nile Auth for B2B apps
Today, we are excited to introduce Nile Auth, a comprehensive B2B authentication solution explicitly designed for multi-tenant applications. Nile Auth is fully open source and built on top of Nile’s...
Scaling a PostgreSQL database? You need replicas.
PostgreSQL Replication 101: Why It’s Critical for Your Database
Scaling a PostgreSQL database? You need replicas. Replication ensures high availability, load balancing, and failover prote...