Optimizing SQLite - Building SaaS #210
A developer shares their process of optimizing SQLite database configuration for their SaaS application after migrating from Postgres.
A developer shares their process of optimizing SQLite database configuration for their SaaS application after migrating from Postgres.
A guide to getting started with the psql command-line interface for PostgreSQL, covering essential utility commands and configuration tips.
Explains a performance issue with ToListAsync/ToArrayAsync in EF Core when querying large data columns and recommends using synchronous versions.
Performance comparison between ToArrayAsync and ToListAsync methods in Entity Framework 8, using benchmarks to analyze memory and speed.
Explores the future of PostgreSQL, focusing on the power of extensions like pg_stat_statements, Citus, and pg_search to add new capabilities.
A tutorial on connecting to and querying SQL databases using the R programming language, including driver setup and error handling.
Exploring Go middleware, request context, and database usage with the standard library, continuing a series on building web apps.
Explores techniques for implementing idempotent 'get or create' operations in PostgreSQL, covering race conditions, concurrency, and constraint handling.
Explains the limitations of physical and logical replication in Postgres and introduces EDB Postgres Distributed as a solution for production-grade needs.
Explains the new UUID v7 (GUID) generation in .NET 9, highlighting its sortable timestamp structure and usage.
Explores database durability without write-ahead logs, contrasting in-memory and disk-based approaches to build intuition for WAL design.
A developer reflects on SQL's relevance after a colleague's unfamiliarity with it, questioning if it's becoming a niche skill in modern tech stacks.
Explains how to compare dates by ignoring the time component in PostgreSQL queries, using the DATE() function.
A tutorial on building a simple database with MVCC to implement and understand the five major SQL transaction isolation levels in 400 lines of code.
A tutorial on setting up a Next.js application with Prisma ORM and SQLite database, covering initial setup and migrations.
Explores three types of data change events in Change Data Capture (CDC): Full, Delta, and Id-only events, detailing their structure and use cases.
Explains Oracle-specific SQL techniques for retrieving the top 1 row per group, covering KEEP syntax, ANY_VALUE(), and object/JSON workarounds.
An introduction to ANSI SQL, covering its standardized syntax, key concepts like DDL, DML, joins, CTEs, and its importance for database interoperability.
Explains how to automatically maintain 'updated_at' timestamps in PostgreSQL using DEFAULT values, offering a simpler alternative to triggers.
Explains how to automatically manage 'updated_at' timestamps in PostgreSQL using DEFAULT values, offering a simpler alternative to triggers.