PMPRAVIN Minpravinm.hashnode.dev·1d ago · 2 min readWhat is SQL? Understanding SQL Basics, DDL, DML, DCL, Tables, Rows & ColumnsWhat is SQL? SQL stands for Structured Query Language. It is the standard language used to communicate with relational databases. Using SQL, we can: Create databases Create tables Insert records R00
ATApoorv Tyagiinapoorvtyagi.tech·2d ago · 14 min readHow to Size Java Database Connection Pools in KubernetesIntroduction I was reviewing a PR at work a month ago where a new application was setting up its database service, and I saw the connection pool properties, which made me think about how a small confi00
NUNoor ul Hassaninengineeringdeepdives.hashnode.dev·3d ago · 7 min readHow to Prevent Users from Overwriting Each Other's Data: Optimistic Locking in Next.js & PrismaImagine you're building a collaborative business dashboard. Two project managers are reviewing the same contract at the same time. The contract currently has a budget of $4,000. Manager A updates the 00
WWisserinwisser.hashnode.dev·4d ago · 10 min readTeaching an LLM Your Schema's Rules: Inside Jailer's AI Subsetting AssistantJailer is an open-source tool for referentially-intact database subsetting and relational data browsing. Source: github.com/Wisser/Jailer Anyone who has tried to build a small, realistic test database00
MMMihai Marinescuinfeaturingcode.com·5d ago · 31 min readI can't remember SQL syntaxReading a SELECT SQL English reading SELECT name FROM users from the users table, give me name for every row SELECT * every column SELECT name, email just these two columns SELECT DISTINCT10
VKVishal Kushwahaindetailsnotes.hashnode.dev·5d ago · 34 min read🎯 SQL Chapter 1Core Foundations - With Hands-On Learning, Visual Guides & Practice Exercises 🗄️ What is SQL? 📖 Definition SQL (Structured Query Language) is a programming language used to communicate with databas00
IWItay Waismanin1-db-2-rule-them-all.hashnode.dev·5d ago · 7 min readOne Storage Layer Isn't One Database: A Look at Databricks' LTAP"Every few years, a vendor with enough scale and engineering budget takes another run at the oldest unsolved problem in databases: can transactional and analytical workloads live on the same data witho00
AMAudrey Murigiindatahackstudio.hashnode.dev·5d ago · 13 min readData Rich, Insight Poor: The Quiet Crisis of Purposeless CollectionHere is a number that should terrify every business leader: 60% of organizations say at least half their data is "dark data" — collected, stored, paid for, and completely unused. One in three companie00
SHSanskriti Harmukhinvultr.hashnode.dev·6d ago · 6 min readDeploying ClickHouse on KubernetesClickHouse is an open-source, column-oriented database built for OLAP workloads, running complex analytical queries across large datasets with sub-second latency. The official ClickHouse Kubernetes Op00
TDTiger Dataintigerdata.hashnode.dev·6d ago · 7 min readWhy Your PostgreSQL Partition Key Is Creating a Write BottleneckOriginally published on June 19, 2026. Written by NanoHertz Communications. At 50K inserts per second, a skewed partition key can concentrate 40K of those inserts onto a single partition. That one par00
