backend

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.

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...

JoshMSFT

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

Postgres Message Queue (PGMQ) JavaScript Client Library - Muhammad-Magdi/pgmq-js

Muhammad-Magdi

The API database architecture - Stop writing HTTP-GET endpoints

Fabian Zeindl

A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. - pgmq/pgmq

pgmq

Postgres is Enough . GitHub Gist: instantly share code, notes, and snippets.

cpursley

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.

Romario López

GitHub Gist: instantly share code, notes, and snippets.

anastasia-lebedeva

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

Per-route authorization