Athreya aka Maneshwar

Software Dev | Technical Writer | 400k+ Reads | Learning, building, improving, writing :)

Joined on Jan 5, 2023 athreyac4@gmail.com https://linktr.ee/maneshwar

Pinned

Mar 15 '25

Domain Driven Design

#webdev #programming #beginners #java

108

5 min read

Athreya aka Maneshwar

Mar 2 '25

Implementing an API with Background Tasks: A Pragmatic Approach

#webdev #programming #javascript #beginners

4 min read

Athreya aka Maneshwar

Feb 24 '25

Why Kafka? A Developer-Friendly Guide to Event-Driven Architecture

#webdev #programming #javascript #beginners

103

6 min read

Athreya aka Maneshwar

Feb 6 '25

Speed Up DB Queries Like a Pro

#webdev #programming #beginners #database

250

6 min read

Athreya aka Maneshwar

Dec 27 '24

Understanding Webhooks: A Humble Guide for Developers

#webdev #programming #beginners

4 min read

Cover image for SQLite Interface Handler: Understanding the sqlite3 Core Structure

Athreya aka Maneshwar

Mar 31

SQLite Interface Handler: Understanding the sqlite3 Core Structure

#database #webdev #programming #architecture

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.

Create Account

Already have an account? Sign in

Cover image for From Queries to Bytecode: The Final Pieces of SQLite’s Frontend

Athreya aka Maneshwar

Mar 28

From Queries to Bytecode: The Final Pieces of SQLite’s Frontend

#webdev #programming #database #architecture

5 min read

Cover image for Which index should SQLite use?

Athreya aka Maneshwar

Mar 27

Which index should SQLite use?

#webdev #programming #architecture #database

4 min read

Cover image for Inside SQLite’s Frontend: Join Table Ordering

Athreya aka Maneshwar

Mar 26

Inside SQLite’s Frontend: Join Table Ordering

#webdev #programming #database #architecture

3 min read

Cover image for Inside SQLite’s Frontend: BETWEEN, OR, LIKE, and GLOB Optimizations

Athreya aka Maneshwar

Mar 24

Inside SQLite’s Frontend: BETWEEN, OR, LIKE, and GLOB Optimizations

#webdev #programming #architecture #database

4 min read

Cover image for Inside SQLite’s Frontend: How the WHERE Clause Drives Optimization

Athreya aka Maneshwar

Mar 23

Inside SQLite’s Frontend: How the WHERE Clause Drives Optimization

#webdev #programming #architecture #database

5 min read

Cover image for Inside SQLite’s Frontend: How the Query Optimizer Makes Your SQL Fast

Athreya aka Maneshwar

Mar 22

Inside SQLite’s Frontend: How the Query Optimizer Makes Your SQL Fast

#webdev #architecture #database #programming

5 min read

Cover image for Inside SQLite’s Frontend: How Bytecode Is Generated and Names Are Resolved

Athreya aka Maneshwar

Mar 21

Inside SQLite’s Frontend: How Bytecode Is Generated and Names Are Resolved

#webdev #programming #database #architecture

5 min read

Cover image for Inside SQLite’s Frontend: The Parser- Turning Tokens into Meaning

Athreya aka Maneshwar

Mar 20

Inside SQLite’s Frontend: The Parser- Turning Tokens into Meaning

#webdev #programming #database #architecture

4 min read

Cover image for Inside SQLite’s Frontend: How Your SQL Becomes Bytecode

Athreya aka Maneshwar

Mar 19

Inside SQLite’s Frontend: How Your SQL Becomes Bytecode

#webdev #programming #database #architecture

4 min read

Cover image for The Secret Engine Behind Semantic Search: Vector Databases

Athreya aka Maneshwar

Mar 16

The Secret Engine Behind Semantic Search: Vector Databases

#webdev #ai #vectordatabase

5 min read

Cover image for Why AI Lies (And How RAG Fixes It)

Athreya aka Maneshwar

Mar 15

Why AI Lies (And How RAG Fixes It)

#webdev #programming #ai

4 min read

Cover image for How SQLite Converts Data: Affinity Rules in Action

Athreya aka Maneshwar

Mar 6

How SQLite Converts Data: Affinity Rules in Action

#webdev #programming #database #architecture

4 min read

Cover image for SQLite’s Flexible Typing: Storage Types and Column Affinity

Athreya aka Maneshwar

Mar 5

SQLite’s Flexible Typing: Storage Types and Column Affinity

#webdev #programming #database #architecture

4 min read

Cover image for Datatype Management in SQLite

Athreya aka Maneshwar

Mar 4

Datatype Management in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for Index Key Format in SQLite

Athreya aka Maneshwar

Mar 3

Index Key Format in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for Table Record and Key Format in SQLite

Athreya aka Maneshwar

Mar 2

Table Record and Key Format in SQLite

#webdev #programming #database #architecture

3 min read

Cover image for The Hidden Program Behind Every SQL Statement

Athreya aka Maneshwar

Mar 1

The Hidden Program Behind Every SQL Statement

#webdev #programming #database #architecture

6 min read

Cover image for Internal Datatypes and Record Format in SQLite

Athreya aka Maneshwar

Feb 27

Internal Datatypes and Record Format in SQLite

#webdev #database #architecture #programming

4 min read

Cover image for How the VM Actually Executes a Program in SQLite

Athreya aka Maneshwar

Feb 26

How the VM Actually Executes a Program in SQLite

#webdev #programming #database #architecture

3 min read

Cover image for How INSERT and JOIN Actually Execute in SQLite

Athreya aka Maneshwar

Feb 25

How INSERT and JOIN Actually Execute in SQLite

#webdev #database #programming #architecture

4 min read

Cover image for Understanding the Core Opcodes in SQLite

Athreya aka Maneshwar

Feb 24

Understanding the Core Opcodes in SQLite

#webdev #database #architecture #programming

5 min read

Cover image for Inside SQLite’s Bytecode Language

Athreya aka Maneshwar

Feb 23

Inside SQLite’s Bytecode Language

#webdev #programming #database #architecture

4 min read

Cover image for Forcing a Review Between Claude and git commit

Athreya aka Maneshwar

Feb 21

Forcing a Review Between Claude and git commit

#showdev #webdev #programming #github

2 min read

Cover image for Bytecode: SQLite’s Internal Programming Language

Athreya aka Maneshwar

Feb 20

Bytecode: SQLite’s Internal Programming Language

#webdev #programming #database #architecture

3 min read

Cover image for Virtual Database Engine in SQLite

Athreya aka Maneshwar

Feb 19

Virtual Database Engine in SQLite

#webdev #programming #database #architecture

2 min read

Cover image for Space Management: Where Bytes Are Won and Reclaimed in SQLite

Athreya aka Maneshwar

Feb 18

Space Management: Where Bytes Are Won and Reclaimed in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for The Tree Module Functionalities in SQLite

Athreya aka Maneshwar

Feb 17

The Tree Module Functionalities in SQLite

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 16

The Tree Module Functionalities in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for Structure of a Cell in SQLite

Athreya aka Maneshwar

Feb 15

Structure of a Cell in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for Structure of the Storage Area in Tree Page of SQLite

Athreya aka Maneshwar

Feb 14

Structure of the Storage Area in Tree Page of SQLite

#webdev #programming #database #architecture

3 min read

Cover image for Page Structure: From Logical Trees to Raw Bytes

Athreya aka Maneshwar

Feb 13

Page Structure: From Logical Trees to Raw Bytes

#webdev #programming #database #architecture

4 min read

Cover image for Delete Operation in B+-Tree: Removing Without Destabilizing

Athreya aka Maneshwar

Feb 11

Delete Operation in B+-Tree: Removing Without Destabilizing

#webdev #programming #database #architecture

4 min read

Cover image for Insert Operation: How a B+-Tree Grows Without Losing Order

Athreya aka Maneshwar

Feb 10

Insert Operation: How a B+-Tree Grows Without Losing Order

#webdev #programming #database #architecture

4 min read

Cover image for Operations on a B+-Tree: How the Search Works

Athreya aka Maneshwar

Feb 9

Operations on a B+-Tree: How the Search Works

#webdev #programming #database #architecture

4 min read

Cover image for B+-Tree Structure: How Order Is Maintained at Scale

Athreya aka Maneshwar

Feb 8

B+-Tree Structure: How Order Is Maintained at Scale

#webdev #programming #database #architecture

4 min read

Cover image for Statement Subtransactions and Tree Mutation in SQLite

Athreya aka Maneshwar

Feb 7

Statement Subtransactions and Tree Mutation in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for The Tree Interface: Where Pages Become Structure in SQLite

Athreya aka Maneshwar

Feb 6

The Tree Interface: Where Pages Become Structure in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for The Tree Module: Where Pages Turn Into Rows in SQLite

Athreya aka Maneshwar

Feb 5

The Tree Module: Where Pages Turn Into Rows in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for Commit Operation: Turning In-Memory Changes into Permanent Reality in SQLite

Athreya aka Maneshwar

Feb 4

Commit Operation: Turning In-Memory Changes into Permanent Reality in SQLite

#webdev #programming #database #architecture

5 min read

Cover image for Transaction Management: Where the Pager Becomes the Database in SQLite

Athreya aka Maneshwar

Feb 3

Transaction Management: Where the Pager Becomes the Database in SQLite

#webdev #programming #database #architecture

5 min read

Cover image for Cache Update: When Pages Start to Change in SQLite

Athreya aka Maneshwar

Feb 2

Cache Update: When Pages Start to Change in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for Cache Organization: How SQLite Actually Holds Pages in Memory

Athreya aka Maneshwar

Feb 1

Cache Organization: How SQLite Actually Holds Pages in Memory

#webdev #programming #database #architecture

4 min read

Cover image for Page Cache and Pager State: Where Concurrency Becomes Concrete

Athreya aka Maneshwar

Jan 31

Page Cache and Pager State: Where Concurrency Becomes Concrete

#webdev #programming #database #architecture

4 min read

Cover image for Pager Lifecycle Functions: Pinning Pages, Running Transactions, and Making Them Stick in SQLite

Athreya aka Maneshwar

Jan 30

Pager Lifecycle Functions: Pinning Pages, Running Transactions, and Making Them Stick in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for Pager Interface Functions in SQLite: The Narrow Doorway to Persistence

Athreya aka Maneshwar

Jan 29

Pager Interface Functions in SQLite: The Narrow Doorway to Persistence

#webdev #programming #database #architecture

4 min read

Cover image for The Pager Interface: How Higher Layers Touch Storage

Athreya aka Maneshwar

Jan 28

The Pager Interface: How Higher Layers Touch Storage

#webdev #programming #database #architecture

4 min read

Cover image for The Pager: Where SQLite Transactions Touch Disk Reality

Athreya aka Maneshwar

Jan 26

The Pager: Where SQLite Transactions Touch Disk Reality

#webdev #programming #database #architecture

3 min read

Cover image for How SQLite Turns Hardware Chaos into Correctness

Athreya aka Maneshwar

Jan 25

How SQLite Turns Hardware Chaos into Correctness

#webdev #programming #database #architecture

6 min read

Cover image for Unlocking and Journaling in SQLite

Athreya aka Maneshwar

Jan 23

Unlocking and Journaling in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for Lock Management in Multithreaded SQLite Applications

Athreya aka Maneshwar

Jan 22

Lock Management in Multithreaded SQLite Applications

#webdev #programming #database #architecture

4 min read

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

Athreya aka Maneshwar

Jan 21

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

#webdev #programming #database #architecture

4 min read

Cover image for Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite

Athreya aka Maneshwar

Jan 20

Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite

#webdev #programming #database #architecture

5 min read

Cover image for Lock Management in SQLite

Athreya aka Maneshwar

Jan 18

Lock Management in SQLite

#webdev #programming #database #architecture

5 min read

Cover image for From System Transactions to User Transactions in SQLite

Athreya aka Maneshwar

Jan 17

From System Transactions to User Transactions in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for From Journals to Transactions: How SQLite Executes Work Safely

Athreya aka Maneshwar

Jan 16

From Journals to Transactions: How SQLite Executes Work Safely

#webdev #programming #database #architecture

3 min read

Cover image for Journals Beyond the Basics in SQLite

Athreya aka Maneshwar

Jan 15

Journals Beyond the Basics in SQLite

#webdev #programming #database #architecture

4 min read

Cover image for Deep Dive into SQLite Storage

Athreya aka Maneshwar

Jan 14

Deep Dive into SQLite Storage

#webdev #programming #database #architecture

4 min read

Cover image for Sqlite Database File Structure

Athreya aka Maneshwar

Jan 13

Sqlite Database File Structure

#webdev #programming #database #architecture

5 min read

Cover image for Inside SQLite: Naming files

Athreya aka Maneshwar

Jan 12

Inside SQLite: Naming files

#webdev #programming #database #architecture

3 min read

Hexmos

Want to connect with Athreya aka Maneshwar?