# Databases · Tech watch [Canonical source]() Storage, querying, consistency and operation of application data. ## [.NET multi-tenancy: move a tenant without downtime — part 4/4]() 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. 2026-11-02 · [Markdown]() · [Original resource]() ## [.NET multi-tenancy: one database per tenant — Part 3/4]() 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. 2026-11-02 · [Markdown]() · [Original resource]() ## [NocoDB: a spreadsheet interface for your databases]() 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. 2026-10-28 · [Markdown]() · [Original resource]() ## [Data API builder: REST, GraphQL and MCP for your databases]() 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. 2026-10-22 · [Markdown]() · [Original resource]() ## [DBX: one cross-platform client for 100+ databases]() 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. 2026-10-04 · [Markdown]() · [Original resource]() ## [Schedule and restore self-hosted database backups]() 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. 2026-09-01 · [Markdown]() · [Original resource]() ## [Turn a SQL database into a no-code interface with NocoDB]() 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. 2026-06-01 · [Markdown]() · [Original resource]() ## [Zvec: an in-process vector database]() Zvec is a lightweight vector database designed to run inside an application process. Its repository presents similarity search without deploying a separate service. 2026-02-16 · [Markdown]() · [Original resource]() ## [Persist TinyBase data in a SQL database]() 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. 2025-07-18 · [Markdown]() · [Original resource]() ## [CentralMind Gateway: expose a database through MCP and OpenAPI]() 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. 2025-04-22 · [Markdown]() · [Original resource]() ## [Anyquery: query files and applications with SQL]() 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. 2025-04-22 · [Markdown]() · [Original resource]() ## [Convex: a reactive backend with TypeScript functions]() Convex combines a database, functions, synchronization and search in one backend platform. Its reactive approach connects data to interfaces without assembling every service separately. 2025-03-20 · [Markdown]() · [Original resource]() ## [PeerDB: replicate PostgreSQL into data warehouses]() PeerDB focuses on replication from PostgreSQL into analytical systems and queues. The site presents change data capture and its ClickHouse integration. 2025-02-26 · [Markdown]() · [Original resource]() ## [Airbyte: connect data sources to analytics and AI workflows]() Airbyte presents its data movement platform and connectors. It focuses on maintaining flows between source systems, warehouses and applications that need synchronized data. 2025-02-25 · [Markdown]() · [Original resource]() ## [WeTransform: embed data imports with mapping and validation]() WeTransform provides an embeddable importer with field mapping, cleaning and validation. Its SDK connects the import workflow to a SaaS application. 2025-02-20 · [Markdown]() · [Original resource]() ## [ZenStack: combine data models, validation and access control]() 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. 2025-01-12 · [Markdown]() · [Original resource]() ## [Unstorage: one key-value API for multiple storage backends]() Unstorage provides a common JavaScript interface for memory, filesystems, browsers and cloud services. Drivers can be mounted under different prefixes within one instance. 2025-01-05 · [Markdown]() · [Original resource]() ## [Build an application on Postgres with Supabase]() 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. 2023-07-30 · [Markdown]() · [Original resource]()