backend

SQL queries don't start with SELECT

SQL queries don't start with SELECT

Julia Evans

The DuckDB Local UI – DuckDB

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, Gabor Szarnyas

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.

by: Ethan McCue

GitHub - electric-sql/pglite: Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno from https://electric-sql.com

Embeddable Postgres with real-time, reactive bindings. - electric-sql/pglite

electric-sql

GitHub - sabledb-io/sabledb: Ultra fast, persistent database supporting Redis API

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

sabledb-io

Postgres is Enough

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

cpursley

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

Skip the API, Ship Your Database · The Fly Blog

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

How Supabase became this generation’s database - Basedash

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

Securing your PostgreSQL DB with Roles & Privileges

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.

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

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.

List of most used Key-Value stores and databases | The Mythical Engineer

Blog about Software Engineering

themythicalengineer

GitHub - nalgeon/sqlean: The ultimate set of SQLite extensions

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

nalgeon

GitHub - centerofci/mathesar: Web application providing an intuitive user experience to databases.

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