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

109

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

104

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

Athreya aka Maneshwar

Apr 22

AUTOVACUUM in SQLite: How Your Database Cleans Up After Itself

#webdev #programming #database #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

Athreya aka Maneshwar

Apr 20

What Building with MCP Taught Me About Its Biggest Gap

#webdev #programming #ai #mcp

8 min read

Athreya aka Maneshwar

Apr 14

Triggers in SQLite: Automating Logic Inside Your Database

#webdev #programming #architecture #database

3 min read

Athreya aka Maneshwar

Apr 13

What's an AI Gateway and do you think you need one?

#ai #programming #webdev #productivity

5 min read

Athreya aka Maneshwar

Apr 12

AUTOINCREMENT in SQLite

#webdev #programming #architecture #database

3 min read

Athreya aka Maneshwar

Apr 11

Subqueries & Views in SQLite: Writing Smarter, Cleaner Queries

#webdev #programming #database #architecture

3 min read

Athreya aka Maneshwar

Apr 10

SQLite PRAGMA: The Underrated Lever That Controls Your DB

#database #architecture

3 min read

Athreya aka Maneshwar

Apr 3

How SQLite Executes Queries Through Its API Lifecycle

#webdev #programming #database #architecture

3 min read

Athreya aka Maneshwar

Apr 1

How SQLite Internals Connect Into One Unified System

#webdev #programming #database #architecture

3 min read

Athreya aka Maneshwar

Mar 31

SQLite Interface Handler: Understanding the sqlite3 Core Structure

#database #webdev #programming #architecture

4 min read

Athreya aka Maneshwar

Mar 28

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

#webdev #programming #database #architecture

5 min read

Athreya aka Maneshwar

Mar 27

Which index should SQLite use?

#webdev #programming #architecture #database

4 min read

Athreya aka Maneshwar

Mar 26

Inside SQLite’s Frontend: Join Table Ordering

#webdev #programming #database #architecture

3 min read

Athreya aka Maneshwar

Mar 24

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

#webdev #programming #architecture #database

4 min read

Athreya aka Maneshwar

Mar 23

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

#webdev #programming #architecture #database

5 min read

Athreya aka Maneshwar

Mar 22

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

#webdev #architecture #database #programming

5 min read

Athreya aka Maneshwar

Mar 21

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

#webdev #programming #database #architecture

5 min read

Athreya aka Maneshwar

Mar 20

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

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Mar 19

Inside SQLite’s Frontend: How Your SQL Becomes Bytecode

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Mar 16

The Secret Engine Behind Semantic Search: Vector Databases

#webdev #ai #vectordatabase

5 min read

Athreya aka Maneshwar

Mar 15

Why AI Lies (And How RAG Fixes It)

#webdev #programming #ai

4 min read

Athreya aka Maneshwar

Mar 6

How SQLite Converts Data: Affinity Rules in Action

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Mar 5

SQLite’s Flexible Typing: Storage Types and Column Affinity

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Mar 4

Datatype Management in SQLite

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Mar 3

Index Key Format in SQLite

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Mar 2

Table Record and Key Format in SQLite

#webdev #programming #database #architecture

3 min read

Athreya aka Maneshwar

Mar 1

The Hidden Program Behind Every SQL Statement

#webdev #programming #database #architecture

6 min read

Athreya aka Maneshwar

Feb 27

Internal Datatypes and Record Format in SQLite

#webdev #database #architecture #programming

4 min read

Athreya aka Maneshwar

Feb 26

How the VM Actually Executes a Program in SQLite

#webdev #programming #database #architecture

3 min read

Athreya aka Maneshwar

Feb 25

How INSERT and JOIN Actually Execute in SQLite

#webdev #database #programming #architecture

4 min read

Athreya aka Maneshwar

Feb 24

Understanding the Core Opcodes in SQLite

#webdev #database #architecture #programming

5 min read

Athreya aka Maneshwar

Feb 23

Inside SQLite’s Bytecode Language

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 21

Forcing a Review Between Claude and git commit

#showdev #webdev #programming #github

2 min read

Athreya aka Maneshwar

Feb 20

Bytecode: SQLite’s Internal Programming Language

#webdev #programming #database #architecture

3 min read

Athreya aka Maneshwar

Feb 19

Virtual Database Engine in SQLite

#webdev #programming #database #architecture

2 min read

Athreya aka Maneshwar

Feb 18

Space Management: Where Bytes Are Won and Reclaimed in SQLite

#webdev #programming #database #architecture

4 min read

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

Athreya aka Maneshwar

Feb 15

Structure of a Cell in SQLite

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 14

Structure of the Storage Area in Tree Page of SQLite

#webdev #programming #database #architecture

3 min read

Athreya aka Maneshwar

Feb 13

Page Structure: From Logical Trees to Raw Bytes

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 11

Delete Operation in B+-Tree: Removing Without Destabilizing

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 10

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

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 9

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

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 8

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

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 7

Statement Subtransactions and Tree Mutation in SQLite

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 6

The Tree Interface: Where Pages Become Structure in SQLite

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 5

The Tree Module: Where Pages Turn Into Rows in SQLite

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 4

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

#webdev #programming #database #architecture

5 min read

Athreya aka Maneshwar

Feb 3

Transaction Management: Where the Pager Becomes the Database in SQLite

#webdev #programming #database #architecture

5 min read

Athreya aka Maneshwar

Feb 2

Cache Update: When Pages Start to Change in SQLite

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Feb 1

Cache Organization: How SQLite Actually Holds Pages in Memory

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Jan 31

Page Cache and Pager State: Where Concurrency Becomes Concrete

#webdev #programming #database #architecture

4 min read

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

Athreya aka Maneshwar

Jan 29

Pager Interface Functions in SQLite: The Narrow Doorway to Persistence

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Jan 28

The Pager Interface: How Higher Layers Touch Storage

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Jan 26

The Pager: Where SQLite Transactions Touch Disk Reality

#webdev #programming #database #architecture

3 min read

Athreya aka Maneshwar

Jan 25

How SQLite Turns Hardware Chaos into Correctness

#webdev #programming #database #architecture

6 min read

Athreya aka Maneshwar

Jan 23

Unlocking and Journaling in SQLite

#webdev #programming #database #architecture

4 min read

Athreya aka Maneshwar

Jan 22

Lock Management in Multithreaded SQLite Applications

#webdev #programming #database #architecture

4 min read

Hexmos

Want to connect with Athreya aka Maneshwar?