Articles by Nidhi Sharma

Learn how to use MariaDB to persist AI agent memory, including conversation context, preferences, task state, structured storage, retrieval, and updates between requests.

Learn how AlloyDB Lakehouse Federation connects PostgreSQL operational data with BigQuery analytics, including setup considerations, query design, filtering, and workload boundaries.

Learn how to query Apache Iceberg data from AlloyDB, including workload design, SQL query patterns, permissions, performance, and data freshness considerations.

Learn how Percona Search for MongoDB uses mongot and Lucene-based indexes to add full-text search to MongoDB collections.

Learn how to diagnose MongoDB replica set memory pressure by analyzing working sets, WiredTiger cache metrics, filesystem cache, and differences between members.

Learn how Vercel's Data Cache migration to Runtime Cache changes Next.js cache billing, included allowances, and read/write cost calculations.

Learn how to update Next.js after the November 2026 security release and review cache isolation, Edge routes, response handling, and image optimization risks.

Learn how to systematically review AI agent-generated pull requests for scope, code quality, test coverage, security risks, and deployment readiness.

Learn how to design an AI coding agent that inspects repositories, validates code changes, analyzes Git diffs, and explains implementation decisions with evidence.

Learn how SurrealDB 4.0 replaces RocksDB with SurrealKV, including automatic data migration, storage configuration changes, backups, and operational considerations.

Learn how Kotlin Multiplatform code is exposed to Swift and how to handle common issues with type mapping, naming, nullability, and errors.

Learn how the Web Locks API coordinates same-origin browser tabs to prevent lost updates in localStorage and multi-step IndexedDB workflows.

Learn how to enable the Node.js Permission Model, limit filesystem and child-process access, and apply least-privilege configuration safely.

Learn how to use Swift Testing parameterized tests and traits to cover multiple inputs, validation rules, and test execution behavior with less duplicated code.

Learn how to inventory dependencies across GitHub repositories, review open-source license data, and automate license checks with GitHub tools and CI/CD.

Learn how to configure and run dbt source freshness checks to detect stale warehouse data before it affects dashboards and downstream models.

Learn how to profile DuckDB queries against Parquet files with EXPLAIN ANALYZE, interpret execution plans, find bottlenecks, and test targeted SQL optimizations.

Learn how Nix Flakes define reproducible development environments, pin dependencies with flake.lock, and keep local, team, and CI toolchains consistent.

Learn how SQLite WAL mode and checkpointing work, why WAL files grow, and how active readers and checkpoint modes affect disk usage.

Learn how to use MongoDB Change Streams in Node.js and persist resume tokens to recover from disconnects while handling duplicate event processing safely.

Learn how NATS JetStream durable consumers resume Go message processing after restarts using acknowledgments, redelivery, and idempotent handler design.

Learn how to select Azure regions for data residency, assess service-specific data handling, and plan compliance, backups, resilience, and deployment controls.

Learn how to control package dependencies in GitHub using dependency review, Dependabot, registry permissions, repository rules, and CI/CD policy checks.