The Modern .NET Show

From .NET to DuckDB: Unleashing the Database Evolution with Giorgi Dalakishvili

Mar 22, 2024
Database evolution expert Giorgi Dalakishvili discusses the benefits of using Postgres SQL in .NET applications, handling unique constraints and database errors. He explores the efficiency of DuckDB for data analysis, emphasizing its speed and user-friendly interface. The conversation also covers WebAssembly integration for browser-based database connectivity and the future of in-browser development tools.
Ask episode
AI Snips
Chapters
Transcript
Episode notes
INSIGHT

Use Postgres Arrays And Ranges To Simplify Schemas

  • Postgres array and range types remove awkward schema workarounds for common problems.
  • Use arrays for small lists (e.g., tags) and range types to enforce non-overlapping time or quantity intervals at the DB level.
ADVICE

Handle DB Errors Semantically With EntityFramework.Exceptions

  • Convert DB-specific DBUpdateExceptions into semantic exceptions with EntityFramework.Exceptions.
  • Giorgi's library maps provider error codes to exceptions like UniqueConstraintException so your code remains DB-agnostic.
INSIGHT

Use Postgres JSONB For Efficient Semi Structured Data

  • Postgres supports JSONB with indexing and functions so you can store and query semi-structured data efficiently.
  • You can index JSONB paths and filter inside the DB rather than pulling blobs and parsing them in application code.
Get the Snipd Podcast app to discover more snips from this episode
Get the app