5 articles tagged with: #Database

A Guide to Creating DRY Database Models with Timestamps and Base Models.

Stop repeating id and timestamp fields in your SQLModel models. Learn to use mixins and a base model to write cleaner, more maintainable code for your FastAPI application.

A practical guide to building CRUD APIs with FastAPI and SQLModel.

Learn to connect FastAPI to SQL databases using SQLModel. This guide covers creating models, managing sessions, and building a complete CRUD API with practical examples.

How to Organize and Load FastAPI Settings from a .env File Using Pydantic v2

Learn how to centralize your FastAPI configuration using Pydantic Settings and a .env file. This post covers setup, usage, and best practices for managing environment variables and secrets in a maintainable way.

A Guide to Resilient Database Connections with Neon and SQLAlchemy

Compare SQLAlchemy's QueuePool and NullPool for connecting FastAPI to serverless databases like Neon. Learn why NullPool with an external pooler is the recommended and more scalable strategy for production.

Leveraging Full Text Search and Trigram Tokenization for Efficient Name Matching

This article explains how to use SQLite's FTS5 module with the trigram tokenizer to perform efficient full-text searches, particularly for matching similar names in a large database. It covers setting up the virtual table, normalizing names, bulk inserting data, and executing searches that handle close but not exact matches