Content

Postgres Naming Scheme with Npgsql and Entity Framework

Transform PascalCase names for better compatibility in relational tables and columns.

Nov 2019

The Best Data Type for Currency in Databases

Use integers instead of decimals.

Jun 2019

Fuzzy Full-Text Search in PostgreSQL

Use Postgres FTS utilities to implement fuzzy matching without other extensions.

Feb 2019

SQL, NoSQL, ACID and the CAP Theorem

Fundamentals of database design and implementation with ACID and CAP.

Dec 2011