Posts tagged "database"

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Building Event-Driven Go applications with Azure Cosmos DB and Azure Functions

The Go programming language is a great fit for building serverless applications. Go applications can be easily compiled to a single, statically linked binary, making deployment simple and reducing ext...

25.04.2025 0 Read More

Oracle Database 23ai : Group By and Having using Column Aliases

Starting with Oracle Database 23ai, you can use column aliases directly in the GROUP BY and HAVING clauses. This functionality was not available in earlier versions of Oracle Database.Example in Oracl...

25.04.2025 0 Read More

Troubleshooting tempdb Growth: Identifying Idle Sessions Holding Temporary Resources in SQL Server

To find out how much tempdb disk space is occupied by each session that is connected and is idle in a SQL Server database, you can use the following query. This query leverages Dynamic Management View...

25.04.2025 0 Read More

EF Core seeding data

Introduction Learn how to seed data with Microsoft EF Core 9 using UseSeeding and UseAsyncSeeding methods, which provide a convenient way of seeding the database with initial data.💡 AI was...

25.04.2025 0 Read More

Efficient Progress Aggregation in a Deeply Nested Task Hierarchy with Real-Time Sync (PostgreSQL + PowerSync)

I’m developing a task management application with a deeply nested task hierarchy (mother-child tasks). Each task has the following structure (PostgreSQL schema): ⛶sql id UUID PRIMARY KEY, creator_...

25.04.2025 0 Read More

NyaruDB2: A Mobile-First Experiment in Table Partitioning for iOS

NyaruDB2 What is NyaruDB2? NyaruDB2 is an experimental, embeddable database library for iOS & macOS, written in Swift. Its primary goal is to explore table partitioning and index...

25.04.2025 0 Read More

Running MongoDB in Docker: A Simple Guide

Running MongoDB in Docker: A Simple Guide By Md Ariful Haque Sajib (arifulhaque313) Quick Steps Setting Up MongoDB Pull the MongoDB image ⛶docker pull mongo Run MongoDB containe...

26.04.2025 0 Read More

Introduction to SQL Using PostreSQL

PostgreSQL for Absolute Beginners: Your First Step into Data Management Imagine managing millions of Instagram posts or handling customer orders worldwide without confusion. Behind the scenes...

26.04.2025 0 Read More

How I do local development CockroachDB Backups

I have this taskfile tasks to make running commands easier: ⛶version: 3 tasks: backup: desc: Backup the local CockroachDB database cmds: - task: backup-to vars: FOL...

26.04.2025 0 Read More

Count Date Ranges per Year — From SQL to SPL #23

Problem description & analysis: The x field of the database table example is ID, and the ts field is the time interval.Task: Now we need to count which years are included in the time inte...

26.04.2025 0 Read More

Building Event-Driven Go applications with Azure Cosmos DB and Azure Functions

Oracle Database 23ai : Group By and Having using Column Aliases

Troubleshooting tempdb Growth: Identifying Idle Sessions Holding Temporary Resources in SQL Server

EF Core seeding data

Efficient Progress Aggregation in a Deeply Nested Task Hierarchy with Real-Time Sync (PostgreSQL + PowerSync)

NyaruDB2: A Mobile-First Experiment in Table Partitioning for iOS

Running MongoDB in Docker: A Simple Guide

Introduction to SQL Using PostreSQL

How I do local development CockroachDB Backups

Count Date Ranges per Year — From SQL to SPL #23

#reading

#popular