# the vector


> architecture over syntax. a personal archive documenting the shift from writing code to directing intent.


This file provides an index of all content on the vector
 for AI agents and LLMs.
For full content, see: https://thevector.dev/llms-full.txt
For structured data, see: https://thevector.dev/api/posts

## Articles

- [Why is "Mode" Missing from Your SQL Toolbox?](https://thevector.dev/blog/why-is-mode-missing-from-your-sql-toolbox) | by kdkunamneni | beginner | 4 min read | Tags: SQL, PostgreSQL, Redshift, Statistics, Healthcare, Data Analysis
  Calculating Mean and Median in SQL? Easy. But try finding the Mode (the most frequent value) and the database goes silent. Here's why MODE() never made it into standard SQL, and how to work around it.

- [Cursor Commands vs Rules: When to Use What](https://thevector.dev/blog/cursor-commands-vs-rules-when-to-use-what) | by Sai Sreekar Siddula | beginner | 4 min read | Tags: Cursor, AI, Productivity, Developer Tools
  Understanding the difference between Cursor commands and rules — and when to use each — will make you significantly more productive with AI-assisted coding.

- [Building Type-Safe APIs with Next.js 15 and Drizzle ORM](https://thevector.dev/blog/building-type-safe-apis-with-nextjs) | by Sreekar Siddula | intermediate | 8 min read | Tags: Next.js, TypeScript, Databases
  Learn how to build fully type-safe API routes in Next.js 15 using Drizzle ORM, from schema definition to runtime validation.

- [Rust for JavaScript Developers: A Practical Introduction](https://thevector.dev/blog/rust-for-javascript-developers) | by Alex Dev | beginner | 12 min read | Tags: Rust, Web Dev
  A hands-on guide to learning Rust, written specifically for developers coming from the JavaScript/TypeScript ecosystem.

- [Docker Compose Patterns for Local Development](https://thevector.dev/blog/docker-compose-for-local-development) | by Sreekar Siddula | beginner | 6 min read | Tags: DevOps, Web Dev
  Stop fighting environment setup. Learn Docker Compose patterns that make local development reproducible and painless.

## API Endpoints

- All posts (JSON): https://thevector.dev/api/posts
- Single post (JSON): https://thevector.dev/api/posts/{slug}
- Full content (text): https://thevector.dev/llms-full.txt
- RSS Feed: https://thevector.dev/feed.xml