Forem

Athreya aka Maneshwar profile picture

Athreya aka Maneshwar

Technical Writer | 300k+ Reads | i3 x Mint | Learning, building, improving, writing :)

Three Year Club
Go
Top 7
2
C++
Java
8 Week Community Wellness Streak
GraphQL
Two Year Club
4 Week Community Wellness Streak
100 Thumbs Up Milestone
Writing Debut
One Year Club
Pager Interface Functions in SQLite: The Narrow Doorway to Persistence
Cover image for Pager Interface Functions in SQLite: The Narrow Doorway to Persistence

Pager Interface Functions in SQLite: The Narrow Doorway to Persistence

20
Comments 1
4 min read

Want to connect with Athreya aka Maneshwar?

Create an account to connect with Athreya aka Maneshwar. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
The Pager Interface: How Higher Layers Touch Storage
Cover image for The Pager Interface: How Higher Layers Touch Storage

The Pager Interface: How Higher Layers Touch Storage

23
Comments
4 min read
The Pager: Where SQLite Transactions Touch Disk Reality
Cover image for The Pager: Where SQLite Transactions Touch Disk Reality

The Pager: Where SQLite Transactions Touch Disk Reality

24
Comments
3 min read
How SQLite Turns Hardware Chaos into Correctness
Cover image for How SQLite Turns Hardware Chaos into Correctness

How SQLite Turns Hardware Chaos into Correctness

23
Comments
6 min read
Unlocking and Journaling in SQLite
Cover image for Unlocking and Journaling in SQLite

Unlocking and Journaling in SQLite

22
Comments
4 min read
Lock Management in Multithreaded SQLite Applications
Cover image for Lock Management in Multithreaded SQLite Applications

Lock Management in Multithreaded SQLite Applications

20
Comments
4 min read
Lock Management Inside a Process: Why Native Locks Alone Are Not Enough
Cover image for Lock Management Inside a Process: Why Native Locks Alone Are Not Enough

Lock Management Inside a Process: Why Native Locks Alone Are Not Enough

22
Comments 1
4 min read
Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite
Cover image for Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite

Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite

15
Comments 2
5 min read
Lock Management in SQLite
Cover image for Lock Management in SQLite

Lock Management in SQLite

17
Comments 2
5 min read
From System Transactions to User Transactions in SQLite
Cover image for From System Transactions to User Transactions in SQLite

From System Transactions to User Transactions in SQLite

21
Comments
4 min read
From Journals to Transactions: How SQLite Executes Work Safely
Cover image for From Journals to Transactions: How SQLite Executes Work Safely

From Journals to Transactions: How SQLite Executes Work Safely

18
Comments
3 min read
Journals Beyond the Basics in SQLite
Cover image for Journals Beyond the Basics in SQLite

Journals Beyond the Basics in SQLite

24
Comments
4 min read
Deep Dive into SQLite Storage
Cover image for Deep Dive into SQLite Storage

Deep Dive into SQLite Storage

16
Comments
4 min read
Sqlite Database File Structure
Cover image for Sqlite Database File Structure

Sqlite Database File Structure

17
Comments
5 min read
Inside SQLite: Naming files
Cover image for Inside SQLite: Naming files

Inside SQLite: Naming files

16
Comments
3 min read
Inside SQLite Backend: Virtual Machine, Storage, and the Build Process
Cover image for Inside SQLite Backend: Virtual Machine, Storage, and the Build Process

Inside SQLite Backend: Virtual Machine, Storage, and the Build Process

12
Comments
3 min read
Inside the SQLite Frontend: Tokenizer, Parser, and Code Generator
Cover image for Inside the SQLite Frontend: Tokenizer, Parser, and Code Generator

Inside the SQLite Frontend: Tokenizer, Parser, and Code Generator

21
Comments
4 min read
SQLite Limitations and Internal Architecture
Cover image for SQLite Limitations and Internal Architecture

SQLite Limitations and Internal Architecture

21
Comments
4 min read
Concurrency Control and Database Recovery in SQLite
Cover image for Concurrency Control and Database Recovery in SQLite

Concurrency Control and Database Recovery in SQLite

12
Comments 1
4 min read
Working with Multiple Databases, Transactions, and SQLite Internals
Cover image for Working with Multiple Databases, Transactions, and SQLite Internals

Working with Multiple Databases, Transactions, and SQLite Internals

11
Comments
5 min read
Direct SQL Execution and Concurrency in SQLite
Cover image for Direct SQL Execution and Concurrency in SQLite

Direct SQL Execution and Concurrency in SQLite

22
Comments
5 min read
Understanding How Applications Talk to SQLite Internally
Cover image for Understanding How Applications Talk to SQLite Internally

Understanding How Applications Talk to SQLite Internally

11
Comments
4 min read
SQLite: A Simple Database with Serious Engineering Inside
Cover image for SQLite: A Simple Database with Serious Engineering Inside

SQLite: A Simple Database with Serious Engineering Inside

12
Comments
4 min read
Components of a RDBMS: From SQL to Disk
Cover image for Components of a RDBMS: From SQL to Disk

Components of a RDBMS: From SQL to Disk

11
Comments
4 min read
An Algebraic View of Databases
Cover image for An Algebraic View of Databases

An Algebraic View of Databases

6
Comments
3 min read
RDBMS: Where Relations Meet Files
Cover image for RDBMS: Where Relations Meet Files

RDBMS: Where Relations Meet Files

12
Comments
2 min read
DB Interactions: How Applications Talk to DB
Cover image for DB Interactions: How Applications Talk to DB

DB Interactions: How Applications Talk to DB

11
Comments
4 min read
Transaction Management: Making ACID Real
Cover image for Transaction Management: Making ACID Real

Transaction Management: Making ACID Real

12
Comments
5 min read
Making DB Changes Predictable with Transactions
Cover image for Making DB Changes Predictable with Transactions

Making DB Changes Predictable with Transactions

15
Comments 1
4 min read
Indexes and the Rise of the DBMS
Cover image for Indexes and the Rise of the DBMS

Indexes and the Rise of the DBMS

15
Comments
4 min read
How Databases Give Structure to Data
Cover image for How Databases Give Structure to Data

How Databases Give Structure to Data

15
Comments
4 min read
From Blocks to Meaning: Data Items and Databases
Cover image for From Blocks to Meaning: Data Items and Databases

From Blocks to Meaning: Data Items and Databases

10
Comments
4 min read
Learning Databases from the Ground Up: Disks and Blocks
Cover image for Learning Databases from the Ground Up: Disks and Blocks

Learning Databases from the Ground Up: Disks and Blocks

19
Comments
4 min read
How Bf-Tree Executes Reads and Writes Using Mini-Pages
Cover image for How Bf-Tree Executes Reads and Writes Using Mini-Pages

How Bf-Tree Executes Reads and Writes Using Mini-Pages

15
Comments
4 min read
Managing Mini-Page Memory: The Buffer Pool Behind Bf-Tree
Cover image for Managing Mini-Page Memory: The Buffer Pool Behind Bf-Tree

Managing Mini-Page Memory: The Buffer Pool Behind Bf-Tree

15
Comments
4 min read
Basics to Improve Your Reasoning
Cover image for Basics to Improve Your Reasoning

Basics to Improve Your Reasoning

15
Comments
2 min read
Why Bf-Tree Pins Inner Nodes and What That Unlocks
Cover image for Why Bf-Tree Pins Inner Nodes and What That Unlocks

Why Bf-Tree Pins Inner Nodes and What That Unlocks

10
Comments
4 min read
Mini-Pages: Rethinking the Leaf Page Boundary
Cover image for Mini-Pages: Rethinking the Leaf Page Boundary

Mini-Pages: Rethinking the Leaf Page Boundary

10
Comments
4 min read
High-Performance SQLite Reads in a Go Server
Cover image for High-Performance SQLite Reads in a Go Server

High-Performance SQLite Reads in a Go Server

12
Comments
4 min read
LSM-Trees, NVMe SSDs, and Modern Storage Realities
Cover image for LSM-Trees, NVMe SSDs, and Modern Storage Realities

LSM-Trees, NVMe SSDs, and Modern Storage Realities

10
Comments
3 min read
Bf-Trees: Breaking the Page Barrier
Cover image for Bf-Trees: Breaking the Page Barrier

Bf-Trees: Breaking the Page Barrier

16
Comments
3 min read
B-Trees, Pages, and the Hidden Problems Behind Traditional Indexin

B-Trees, Pages, and the Hidden Problems Behind Traditional Indexin

16
Comments
3 min read
If It’s Hard to Read, It’s Hard to Build
Cover image for If It’s Hard to Read, It’s Hard to Build

If It’s Hard to Read, It’s Hard to Build

23
Comments
3 min read
Rust vs Node.js: How They Work, Why Rust Is Faster, and Where Each Fits
Cover image for Rust vs Node.js: How They Work, Why Rust Is Faster, and Where Each Fits

Rust vs Node.js: How They Work, Why Rust Is Faster, and Where Each Fits

16
Comments
4 min read
Don't Just Guess, Measure: A Deep Dive into the Web Performance API
Cover image for Don't Just Guess, Measure: A Deep Dive into the Web Performance API

Don't Just Guess, Measure: A Deep Dive into the Web Performance API

21
Comments
7 min read
Faster SQLite Lookups in Node.js Using Hash Keys & Indexing
Cover image for Faster SQLite Lookups in Node.js Using Hash Keys & Indexing

Faster SQLite Lookups in Node.js Using Hash Keys & Indexing

24
Comments
4 min read
Scaling SQLite with Node worker threads and better-sqlite3
Cover image for Scaling SQLite with Node worker threads and better-sqlite3

Scaling SQLite with Node worker threads and better-sqlite3

26
Comments
8 min read
SFTP, FTPS, or Something Better? Choosing the Right File Transfer Approach for 2026
Cover image for SFTP, FTPS, or Something Better? Choosing the Right File Transfer Approach for 2026

SFTP, FTPS, or Something Better? Choosing the Right File Transfer Approach for 2026

33
Comments
7 min read
Understanding SQLite PRAGMA (And How better-sqlite3 Makes It Nicer)
Cover image for Understanding SQLite PRAGMA (And How better-sqlite3 Makes It Nicer)

Understanding SQLite PRAGMA (And How better-sqlite3 Makes It Nicer)

21
Comments
4 min read
Your SQLite Queries Deserve Their Own Workers
Cover image for Your SQLite Queries Deserve Their Own Workers

Your SQLite Queries Deserve Their Own Workers

22
Comments
4 min read
Running Local AI on Linux With GPU: Ollama + Open WebUI + Gemma
Cover image for Running Local AI on Linux With GPU: Ollama + Open WebUI + Gemma

Running Local AI on Linux With GPU: Ollama + Open WebUI + Gemma

24
Comments 1
4 min read
When Static Sites Stop Scaling: Migrating FreeDevTools (125K+ Pages) from Static Astro to SSR
Cover image for When Static Sites Stop Scaling: Migrating FreeDevTools (125K+ Pages) from Static Astro to SSR

When Static Sites Stop Scaling: Migrating FreeDevTools (125K+ Pages) from Static Astro to SSR

22
Comments 3
4 min read
How to Run Efficient ClamAV Scans on a 4GB RAM Server (Without Killing Your Machine)
Cover image for How to Run Efficient ClamAV Scans on a 4GB RAM Server (Without Killing Your Machine)

How to Run Efficient ClamAV Scans on a 4GB RAM Server (Without Killing Your Machine)

26
Comments
3 min read
What I Learned About Trailing Slashes While Migrating to a Static Site
Cover image for What I Learned About Trailing Slashes While Migrating to a Static Site

What I Learned About Trailing Slashes While Migrating to a Static Site

15
Comments
5 min read
Building a Producer–Consumer Pipeline in Go Using Goroutines and Channels
Cover image for Building a Producer–Consumer Pipeline in Go Using Goroutines and Channels

Building a Producer–Consumer Pipeline in Go Using Goroutines and Channels

31
Comments 6
3 min read
Docker Was Blocked on My macOS Machine, but I Found an Unexpected Way Around It
Cover image for Docker Was Blocked on My macOS Machine, but I Found an Unexpected Way Around It

Docker Was Blocked on My macOS Machine, but I Found an Unexpected Way Around It

17
Comments
4 min read
Serving an Astro Static Site with Brotli and Gzip on Nginx: A Complete, Practical Guide
Cover image for Serving an Astro Static Site with Brotli and Gzip on Nginx: A Complete, Practical Guide

Serving an Astro Static Site with Brotli and Gzip on Nginx: A Complete, Practical Guide

15
Comments 1
4 min read
Understanding Goroutines, Concurrency, and Parallelism in Go
Cover image for Understanding Goroutines, Concurrency, and Parallelism in Go

Understanding Goroutines, Concurrency, and Parallelism in Go

22
Comments 1
4 min read
What is SimHash?
Cover image for What is SimHash?

What is SimHash?

21
Comments 1
5 min read
PostgreSQL vs SQLite: Dive into Two Very Different Databases

PostgreSQL vs SQLite: Dive into Two Very Different Databases

22
Comments
4 min read
loading...