backend

SQL queries don't start with SELECT

Julia Evans

The DuckDB team and MotherDuck are excited to announce the release of a local UI for DuckDB shipped as part of the ui extension.

Jeff Raymakers and Gabor Szarnyas

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

electric-sql

Ultra fast, persistent database supporting Valkey API - sabledb-io/sabledb

sabledb-io

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

The best code is the code unwritten. Avoid building a complex API layer by sharing your database between services.

Redis as a Database I’ve been using Redis a lot in the past few years (and even wrote a post about misusing it), mostly as a cache layer between the App and its Database. For some period of time I …

Tzafrir Ben Ami

An introduction to how modern SQL databases are adapting to fit into the serverless and edge computing world.

Yiming Cao

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

Atlas is a language-agnostic tool for managing and migrating database schemas using modern DevOps principles. It enables developers to automate schema changes through both declarative (schema-as-code) and versioned migration workflows, supporting inputs like HCL, SQL, and ORM models. Key features include automatic migration planning, schema diffs, linting, testing, and CI/CD for databases to ensure a reliable and scalable approach to database schema changes.

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.

Blog about Software Engineering

themythicalengineer

The ultimate set of SQLite extensions. Contribute to nalgeon/sqlean development by creating an account on GitHub.

nalgeon

An intuitive spreadsheet-like interface that lets users of all technical skill levels view, edit, query, and collaborate on Postgres data directly—100% open source and self hosted, with native Post...

mathesar-foundation