Tech watch

Databases

Storage, querying, consistency and operation of application data.

2 Nov 2026Article

.NET multi-tenancy: move a tenant without downtime — part 4/4

barretblake.devPermalink

Banner reading “Multi-Tenant .NET, Part 4: Moving Day,” with moving boxes, a guild emblem, and an illustrated portrait.

This installment explains how to move a tenant from a shared database to a dedicated one without taking the application offline or disrupting other tenants. The catalog drives the switch, while the same EF Core model and query filter serve both isolation modes.

The migration uses an initial copy, a temporary read-only window, a delta copy, and verification before cutover. The runbook waits for the cache to expire before reopening writes, preventing instances that still hold the old connection from writing to the shared database after the switch.

Multi-tenancy .NET Entity Framework Core Databases Software Architecture

BarretFound via C# Digest

2 Nov 2026Article

.NET multi-tenancy: one database per tenant — Part 3/4

barretblake.devPermalink

A hand handles colorful network cables in front of rack-mounted equipment.

With one database per tenant, EF Core no longer needs a global query filter, a TenantId column, or a tenant-specific model cache key: the tenant is selected through a connection string resolved from a catalog database.

This isolation simplifies the model but shifts complexity to operations: each migration must be applied to every database. The article also explains how IDesignTimeDbContextFactory lets dotnet ef create the context without an active request or tenant.

Multi-tenancy .NET Entity Framework Core Databases Software Architecture

BarretFound via C# Digest

28 Oct 2026Article

NocoDB: a spreadsheet interface for your databases

github.comPermalink

NocoDB provides a spreadsheet-style interface for managing tables, views, and access controls without writing code. It combines grid, gallery, form, Kanban, and calendar views with REST APIs and an SDK for programmatic access.

Deployment options range from Docker with SQLite or PostgreSQL to an automated setup with PostgreSQL, Redis, Traefik, and SSL renewal. For production evaluation, note that the repository lists a Sustainable Use License, while its standalone binaries are intended for local testing.

NocoDB No-code / low-code Databases Self-hosting

22 Oct 2026Article

Data API builder: REST, GraphQL and MCP for your databases

github.comPermalink

Data API builder generates REST and GraphQL endpoints, as well as MCP tools, from Azure databases and on-premises stores. It supports several backends, including Azure SQL, SQL Server, PostgreSQL, MySQL and Cosmos DB, and runs in a container or locally during development.

Configuration defines entities and their permissions; DAB then translates requests into SQL. This layer reduces the API code teams need to maintain, while access remains shaped by the configuration and each database’s capabilities.

MCP REST GraphQL Databases Authorization

4 Oct 2026Repository

DBX: one cross-platform client for 100+ databases

github.comPermalink

DBX is a cross-platform database client advertised at 25 MB, with support for more than 100 systems including PostgreSQL, SQLite, Redis, MongoDB, and DuckDB. The repository combines a desktop app, CLI, MCP server, and AI features, bringing several database workflows together.

Databases Developer Experience MCP

t8y2

1 Sept 2026Repository

Schedule and restore self-hosted database backups

github.comPermalink

Databasement brings scheduling, backup, and restore workflows together for databases including MySQL, PostgreSQL, MongoDB, SQLite, and Redis. Its web interface supports destinations such as S3, SFTP, Samba, and local storage, with SSH tunnels for remote environments.

Backup and restore Databases Self-hosting

David-Crty

1 Jun 2026Tool

Turn a SQL database into a no-code interface with NocoDB

nocodb.comPermalink

NocoDB adds a spreadsheet-like interface to an existing or newly created database, with Kanban, form, and gallery views. SQL and API access connect no-code editing with existing systems.

NocoDB No-code / low-code Databases SQL

16 Feb 2026Repository

Zvec: an in-process vector database

github.comPermalink

Zvec is a lightweight vector database designed to run inside an application process. Its repository presents similarity search without deploying a separate service.

Vector search Databases

18 Jul 2025Documentation

Persist TinyBase data in a SQL database

tinybase.orgPermalink

The guide lists TinyBase persisters for SQLite environments, PostgreSQL and SQL Server. It helps match an adapter to the application’s runtime and storage choice.

TinyBase Databases Local-first

22 Apr 2025Repository

CentralMind Gateway: expose a database through MCP and OpenAPI

github.comPermalink

Gateway generates an MCP or REST interface from a database connection. It provides a bridge for connecting agents to data without implementing every endpoint manually.

MCP OpenAPI REST Databases

22 Apr 2025Repository

Anyquery: query files and applications with SQL

github.comPermalink

Anyquery extends SQLite through plugins that query files and application services. It also offers an MCP connection for making those sources available to AI assistants.

SQL SQLite Databases MCP

20 Mar 2025Tool

Convex: a reactive backend with TypeScript functions

convex.devPermalink

Convex combines a database, functions, synchronization and search in one backend platform. Its reactive approach connects data to interfaces without assembling every service separately.

Convex Databases TypeScript

26 Feb 2025Tool

PeerDB: replicate PostgreSQL into data warehouses

peerdb.ioPermalink

PeerDB focuses on replication from PostgreSQL into analytical systems and queues. The site presents change data capture and its ClickHouse integration.

PostgreSQL Databases

25 Feb 2025Tool

Airbyte: connect data sources to analytics and AI workflows

airbyte.comPermalink

Airbyte presents its data movement platform and connectors. It focuses on maintaining flows between source systems, warehouses and applications that need synchronized data.

Databases Automation

20 Feb 2025Tool

WeTransform: embed data imports with mapping and validation

wetransform.comPermalink

WeTransform provides an embeddable importer with field mapping, cleaning and validation. Its SDK connects the import workflow to a SaaS application.

Automation Databases

WeTransform

12 Jan 2025Repository

ZenStack: combine data models, validation and access control

github.comPermalink

ZenStack combines a typed ORM, validation and access policies for TypeScript applications. It also provides generated CRUD services and hooks for connecting interfaces to data.

TypeScript Databases Authorization

5 Jan 2025Tool

Unstorage: one key-value API for multiple storage backends

unstorage.unjs.ioPermalink

Unstorage provides a common JavaScript interface for memory, filesystems, browsers and cloud services. Drivers can be mounted under different prefixes within one instance.

JavaScript Databases

30 Jul 2023Tool

Build an application on Postgres with Supabase

supabase.comPermalink

Supabase combines Postgres with authentication, REST APIs, functions, storage, and realtime sync. The platform provides common backend services while keeping data in a portable database.

Supabase PostgreSQL Databases

@supabase