Explains the new virtual generated columns feature in PostgreSQL 18, detailing its syntax, behavior, and current limitations.
Introduces CARTE, a foundation model for tabular data, explaining its architecture, pretraining on knowledge graphs, and results.
Discusses why SQL's SELECT..FROM syntax order isn't a flaw to be 'fixed' by FROM..SELECT, comparing it to logical execution order and language design.
Explains how DynamoDB's design ensures scalable performance, contrasting it with the scaling challenges of relational databases.
Explains the internal workings of SQL databases, covering data structures like tables, indexes, rows, and pages for both storage and querying.
A database expert reviews their 2018 speaking engagements and blog output, focusing on Columnstore Indexes, Graph Databases, and Batch Execution Mode.
A guide to best practices for database schema migrations, focusing on tools like Flyway and Hibernate for evolving applications.
Explores how relational databases like PostgreSQL can adopt benefits from NoSQL, such as schemaless flexibility and JSON document storage.
A critical review of Martin Fowler's 'Patterns of Enterprise Application Architecture', assessing its relevance and dated patterns.
A technical guide on reducing SQL database size by normalizing repeated data like IPs and User Agents into separate relational tables.
Argues that PostgreSQL's advanced features and data guarantees make it a superior choice over NoSQL databases for many applications.
