Security and API Fixes in Open Source: 3 Pull Requests
A Cypher injection in LightRAG, a wrong enum value in the OpenAI Python SDK and hardcoded decimals in Coinbase AgentKit: three PRs, how each ended, and why.
#databases
Posts
Memoryze: A Spaced Repetition App with React and Supabase
How I built Memoryze in one night: the SM-2 algorithm, Supabase auth and row level security, a 3D card flip in Framer Motion, and two bugs I still need to fix.
Python Context Managers: Resource Management with with
A practical guide to Python context managers: __enter__ and __exit__, contextlib.contextmanager, ExitStack, async with, FastAPI lifespan, locks and common bugs.
Database Connection Pooling: SQLAlchemy and PgBouncer
Database connection pooling for PostgreSQL: SQLAlchemy 2 async pool settings, sizing limits per process, leaks, timeouts and PgBouncer transaction mode.
Elasticsearch Full-Text Search in Production
Full-text search with Elasticsearch 8/9 and the Python client: strict mappings, language analyzers, zero-downtime reindexing with aliases, shards, pagination.
MongoDB Schema Design with Python and Async PyMongo
MongoDB schema design in practice: embed or reference, schema validation, ESR index ordering, aggregation and transactions, with Python's async PyMongo API.
SQLAlchemy 2.0 with MySQL: Async ORM, N+1 and Alembic
SQLAlchemy 2.0 with MySQL and PostgreSQL: typed Mapped models, async sessions, eager loading against N+1 queries, Alembic migrations and connection pool tuning.
Redis Caching and Session Management in Python
Redis caching and session management with redis-py asyncio: cache-aside with stampede protection, server-side sessions, Streams, locks and eviction policies.
Building a REST API with FastAPI, Pydantic v2 and Async
A practical FastAPI REST API guide: Pydantic v2 schemas, Annotated dependencies, async SQLAlchemy, testing and a lean Docker setup, with code that runs.
Blockchain Data Analysis in Python: Indexer, The Graph, Dune
On-chain data with Python: event subscriptions in web3.py, a small SQLAlchemy 2 indexer, The Graph and Dune APIs, and Telegram alerts for large transfers.
