backend

python nodejs laravel php api postgres docker joplin open api database go test driven development redis self hosting scraping security storage software architecture tooling graphql serverless

5/23/2025

• Announcing a new IDE for PostgreSQL in VS Code from Microsoft | Microsoft Community Hub

  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

  postgres

3/16/2025

• Life Altering Postgresql Patterns

  by: Ethan McCue

  postgres

8/25/2024

• Postgres as a search engine

  Build a retrieval system with semantic, full-text, and fuzzy search in Postgres to be used as a backbone in RAG pipelines.

  postgres database

8/17/2024

• Just use Postgres

  by: Ethan McCue

  postgres database

5/16/2024

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

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

  Muhammad-Magdi

  postgres

5/10/2024

• The API database architecture - Stop writing HTTP-GET endpoints

  The API database architecture - Stop writing HTTP-GET endpoints

  Fabian Zeindl

  api postgres

5/9/2024

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

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

  pgmq

  postgres

2/6/2024

• Postgres is Enough

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

  cpursley

  postgres database

12/18/2023

• Providing HTML Content Using Htmx — PostgREST 12.0.0 documentation

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

  postgres database

8/14/2023

• How Supabase became this generation’s database - Basedash

  Basedash is the AI-native Business Intelligence Platform. Generate beautiful charts and dashboards using natural language.

  postgres database

8/12/2023

• Securing your PostgreSQL DB with Roles & Privileges

  Learnings from securing a PostgreSQL database used by multiple backends, services, and roles.

  Romario López

  postgres database

8/6/2023

• Parametric SQL testing with pgTAP — find my way from toy examples to practical application | by Anastasia Lebedeva | Medium

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

  anastasia-lebedeva

  postgres database

7/13/2023

• Create an advanced search engine with PostgreSQL

  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.

  postgres database

12/28/2022

• A poor man's API

  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

  api postgres