Postgres as a search engine

Build a hybrid search engine with semantic, full-text, and fuzzy search – all within Postgres

GitHub Community is built to support all GitHub users on their educational journey, via Discussions. It is a resource hub, learning portal, and inspiration station, all in one. Regardless of how big or small your challenge is, all resources and information will be accessible in a true open source fashion.

This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits.

A New Shine for .NET 9, AI Coming to the Tech Stack

How does a developer find a new tool to add to their stack? There’s no single answer, but most will tell you that technical content is part of that journey. Certainly, documentation is crucial to developer experience. But more often than not, the first piece of content they’ll discover is a helpful resource returned as search results or shared from another dev. Your goal is simple: be that resource.

Common Causes of Memory Leaks in JavaScript

Identify and fix common JavaScript memory leaks (Node.js and Deno.js)

Don’t forget that being a great developer takes soft skills in addition to technical ones. Here are some tips!

In this article, I'm going to talk about some of my favorite tips and tricks about my favorite IDE, VS Code. Although I'm writing this on a Mac, many of these concepts will port to Windows, so you may have to replace COMMAND key, WIN key, etc.

tl;dr

• Postgres + pgvector for simplified embedding storage
• Colocate data for easy querying and consistency
• Fast and cost-effective solution
• Knowledge graphs in Postgres
• Hybrid search is tricky but possible

Announcement: System.Data.SqlClient package is now deprecated