Showing 18 notes
Build a production-grade personalized search engine entirely within Postgres using BM25 retrieval and vector-based reranking, no external infrastructure required.
pgTAP is a suite of database functions that make it easy to write TAP-emitting unit tests in psql scripts or xUnit-style test functions. The TAP output is suitable for harvesting, analysis, and reporting by a TAP harness, such as those used in Perl applications.
A high performance job queue for PostgreSQL, written in Node.js
We are excited to announce the public preview of the brand-new PostgreSQL extension for Visual Studio Code (VS Code), designed to simplify PostgreSQL database management and development workflows. With this extension, you can now manage database objects, draft queries with intelligent assistance from context-aware IntelliSense and our ‘@pgsql’ GitHub Copilot agent—all without ever leaving your favorite code editor. Addressing Developer Challenges Many of you face hurdles in managing time effectively, with 41% of developers struggling with task-switching, according to the 2024 StackOverflow Developer Survey. Additionally, the 2024 Stripe Developer Coefficient Report reveals that developers spend up to 50% of their time debugging...
by: Ethan McCue
Build a retrieval system with semantic, full-text, and fuzzy search in Postgres to be used as a backbone in RAG pipelines.
by: Ethan McCue
Embeddable Postgres with real-time, reactive bindings. - electric-sql/pglite
Postgres Message Queue (PGMQ) JavaScript Client Library - Muhammad-Magdi/pgmq-js
The API database architecture - Stop writing HTTP-GET endpoints
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. - pgmq/pgmq
Postgres is Enough . GitHub Gist: instantly share code, notes, and snippets.
author, Laurence Isla,. This how-to shows a way to return HTML content and use the htmx library to handle the AJAX requests. Htmx expects an HTML response and uses it to replace an element inside the DOM (see the htmx introduction in the docs). Preparatory Configuration: We will make a to-do app ...
Basedash is the AI-native Business Intelligence Platform. Generate beautiful charts and dashboards using natural language.
Learnings from securing a PostgreSQL database used by multiple backends, services, and roles.
GitHub Gist: instantly share code, notes, and snippets.
PostgreSQL provides the necessary building blocks for you to combine and create your own search engine for full-text search. Let's see how far we can take it.
Creating a full-fledged API requires resources, both time and money. You need to think about the model, the design, the REST principles, etc., without writing a single line of code. Most of the time, you don’t know whether it’s worth it: you’d like to offer a Minimum Viable Product and iterate from there. I want to show how you can achieve it without writing a single line of code. The solution The main requirement of the solution is to use the PostgreSQL database. It’s
Showing 18 notes