Creating JSON from CSV with DuckDB in One GoI recently encountered a need to transform CSV data into a JSON structure (or DTO) for a downstream application. While there are many…Jan 30Jan 30
Elevate Your Database Observability by Passing an Application Name in Connection ParametersHave you ever looked at your database logs and wondered which of your many services is responsible for a particular query or spike in…Jan 11Jan 11
Published inBazaar EngineeringExploring Vector Extension: A Journey into Efficient Similarity SearchIn the ever-evolving landscape of search relevance and recommendation systems, finding efficient and scalable methods to identify similar…Nov 29, 2024Nov 29, 2024
Published inBazaar EngineeringFear hurts productivityChange and uncertainty are prevalent in today’s fast-paced work environment, whether as a result of new technologies, changes in the…Oct 4, 20241Oct 4, 20241
Duckdb is new trino.Recently there was a need to lighten the source databases. After applying the partitioning based on business requirements, I have to drop…Aug 7, 2024Aug 7, 2024
Published inBazaar EngineeringQuerying S3 Directly from PostgreSQL: A Step-by-Step GuideEdited: Thanks to Philippe Noël for suggesting correction to install and create extension method.Aug 5, 20241Aug 5, 20241
Published inBazaar EngineeringArchival of Source DBsWhat is Archival of Source Databases?Aug 2, 2024Aug 2, 2024
Published inBazaar EngineeringThe Era of IntegrationIn today’s fast-paced technological landscape, it’s crucial to recognize that we are in the era of integration rather than building…Jul 27, 2024Jul 27, 2024
Published inBazaar EngineeringThe Blessings of Work: A Gift Often OverlookedIn our daily grind, it’s easy to forget the inherent value and blessings that come with a job. We focus on deadlines, challenges, or…May 15, 2024May 15, 2024
Published inBazaar EngineeringWhy non-deterministic code hurtsWhat is Non deterministic code?Nov 2, 2023Nov 2, 2023