# Ajay Dandge

> Personal blog about software engineering, tools, and building things.

## Blog Posts

- [Optimizing Mobile PageSpeed Insights: How I Reached 99 on Performance](https://ajaydandge.dev/blog/optimizing-mobile-pagespeed-insights-how-i-reached-99-on-performance.md): A practical breakdown of how deferring analytics scripts, code-splitting client components, and updating transpilation targets boosted this blog's Mobile PageSpeed score from 85 to 99/100.
- [Deploying Claude Usage: SQLite, Postgres, or MySQL — and Google Sign-In](https://ajaydandge.dev/blog/deploying-claude-usage-sqlite-postgres-or-mysql-and-google-sign-in.md): The follow-up to building Claude Usage: making it deployable — splitting a session's history into per-turn timestamps, running on PostgreSQL or MySQL as well as SQLite, and adding Google sign-in alongside Microsoft Entra ID.
- [Building Claude Usage: Per-Person Cost Tracking on a Shared Claude Account](https://ajaydandge.dev/blog/building-claude-usage-per-person-cost-tracking.md): A plugin, a FastAPI and SQLite server, and a dashboard that track per-person token usage and cost when a team shares Claude accounts.
- [Using Claude Code with Non-Anthropic Models via LiteLLM](https://ajaydandge.dev/blog/using-claude-code-with-non-anthropic-models-via-litellm.md): Setting up Claude Code to use non-Anthropic models, including free ones on OpenRouter, by running a local LiteLLM proxy in front of it.
- [Burrow Adds a Read-Only Guard and Agent Skills](https://ajaydandge.dev/blog/burrow-adds-read-only-guard-and-agent-skills.md): Three additions to burrow: per-profile read-only access that blocks write statements at the client level, a non-interactive config set command for scripting, and skill installation across multiple coding agents via the Agent Skills standard.
- [Burrow Adds MySQL, Secure Passwords, and a Claude Code Skill](https://ajaydandge.dev/blog/burrow-adds-mysql-secure-passwords-and-claude-code-skill.md): Burrow now supports MySQL alongside PostgreSQL, stores passwords securely outside config.toml, and ships a proper installer for the Claude Code skill.
- [Burrow Now Supports Direct Connections](https://ajaydandge.dev/blog/burrow-now-supports-direct-connections.md): A small addition to burrow: profiles can now connect to PostgreSQL directly, without an SSH tunnel.
- [The OS Knows the Timezone, Not Your Language](https://ajaydandge.dev/blog/the-os-knows-the-timezone-not-your-language.md): The OS knows the timezone, not the language. Everything else — ambiguous strings, broken queries, wrong date partitions — follows from that.
- [How I Understand LLMs](https://ajaydandge.dev/blog/how-i-understand-llms.md): A practical mental model of how large language models work — from tokens and probabilities to inference, context windows, and why they hallucinate.
- [Building Burrow: A CLI for Querying Databases Behind a Bastion](https://ajaydandge.dev/blog/building-burrow-cli-for-querying-databases-behind-bastion.md): How I built a developer CLI that tunnels through a bastion host over SSH to query a PostgreSQL database — and the small decisions that made it feel right.
- [OAuth vs OpenID Connect: Stop Mixing Them Up](https://ajaydandge.dev/blog/oauth-vs-openid-connect.md): OAuth is about authorization (what an app can do), while OpenID Connect is about authentication (who the user is).
- [Building User Interface for Querying ChromaDB](https://ajaydandge.dev/blog/building-ui-for-querying-chromadb.md): Building a lightweight web interface for exploring and querying ChromaDB collections using Ollama-powered embedding models.
- [What CORS Is, What CORS Is Not](https://ajaydandge.dev/blog/what-cors-is-what-cors-is-not.md): CORS is often misunderstood as a security mechanism, but it's really just a browser behavior filter. This post clears up common myths and explains what CORS actually does—and doesn't do.
- [Multi-Account Git Setup with SSH and Commit Signing](https://ajaydandge.dev/blog/multi-account-git-config.md): A guide to setting up multiple Git accounts (e.g., work and personal) across different hosting providers like GitHub and GitLab using SSH keys, directory-based Git configuration, and commit signing