DB Basics with DuckDB and some Nuances
An exploration of database engineering terminology gaps, the differences between ETL and ELT compute paradigms, and the SELECT * query performance nuances in analytical engines like DuckDB.
I’m Dominick Ryan. As a Senior Systems and Data Engineer, I build reliable data transformations and cloud-native infrastructure. NextValData is my curated repository of academic and technical documentation—a personal archive shared in the hope that it helps others, while being just self-serving enough.
An exploration of database engineering terminology gaps, the differences between ETL and ELT compute paradigms, and the SELECT * query performance nuances in analytical engines like DuckDB.
An analysis of vector databases like Milvus, Qdrant, and Pinecone, and how they manage semantic infrastructure in a resource-constrained cloud.
An exploration of explicit lazy imports in Python 3.15 via PEP 810 to optimize startup performance and parse overhead.