The standard architecture — chunking documents, embedding them into a vector database, and retrieving top-k results via ...

It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL ...

Learn how a single JavaScript Date() timezone mistake silently corrupts web apps and how to fix timestamp bugs in JS, Python, cron jobs, MySQL, and React SSR.

DuckDB is an in-process SQL database built for speed, simplicity, and analytics. Often called the “SQLite for analytics,” it runs directly inside your application, with no server setup, and handles ...

AI Agent for Query Resolution This project is an AI agent that answers user queries by retrieving information from a local SQL database, text documents, and real-time web searches. The agent is built ...

This tool is designed to interact with SQLite databases via command-line interface. Other than just issuing the sql staments by yourself, you can let AI generate sql statements based on your prompt.

Every building starts with an idea. But how do you get from a concept to a piece of architecture? Why do some ideas work better than others? What is a "good" design? Questions like these can make ...

I recently had a project, where I needed to create references to one collection in another collection. Referencing databases or collections is a common need with data. With document based databases, ...