Lib
#database
2entries tagged “database”.
OLAP Design with DuckDB, Parquet and Polars
Dimensional modeling for an analytical workload, why DuckDB rewards a different schema shape than a transactional database, where Parquet fits as the storage layer, and how to wire it all together in a Python project alongside Polars.
SQL Server: Schema Discovery Without Admin Access
Querying sys.* catalog views to map schemas, tables, columns and datatypes; getting row counts without a full scan; and using SET STATISTICS as a stand-in for an execution plan you cannot open in SSMS.