Database tutorial - IT technology blog
Posted inDatabase

Apache HBase: Wide-Column NoSQL Database for Sparse Data at Billion-Record Scale

Apache HBase is a wide-column NoSQL database built on Hadoop HDFS, purpose-built for storing and querying billions of sparse records with high write throughput. This guide covers the HBase data model, practical setup in Java and Python, how to design row keys that avoid hotspots, and a clear comparison against Cassandra and Cloud Bigtable to help you choose the right tool for your scale.
Programming tutorial - IT technology blog
Posted inProgramming

SQLModel in FastAPI: Building Type-Safe APIs Without the Pydantic + SQLAlchemy Boilerplate

SQLModel unifies SQLAlchemy ORM and Pydantic validation in a single class definition, eliminating the need to maintain synchronized database and API schemas. After six months in production, it has consistently reduced model code by around 40% with no loss in type safety. This guide covers the complete workflow: quick setup, the Base/Table/Read class pattern, relationships, Alembic migrations, async support, and the production gotchas worth knowing before you hit them.