Results for “database”

Create a backup and restore plan for a [database] used by [app]. Include backup frequency, retention, off-site storage, encryption, an automated backup script, a restore test procedure, and monitoring for failed backups.

Set up a [Supabase/Firebase] backend for [app]. Include the data model, authentication, row-level security or security rules so users only access their own data, example queries from the client, and storage for user uploads.

Outline and code a simple RAG prototype in Python that answers questions from [documents]. Cover loading and chunking documents, creating embeddings, storing them in [vector store], retrieving relevant chunks, building the prompt, and citing sources in answers.

Review this PostgreSQL schema. Check normalisation, data types, constraints, foreign keys, indexes for likely queries ([queries]), naming consistency, and future scaling issues. Suggest improvements with migration SQL. Schema: [paste schema]

Act as a data analyst. Database: [PostgreSQL / BigQuery / Snowflake / MySQL] Tables: [users(id, created_at), events(user_id, event_name, created_at), orders(...)] Questions: [monthly cohort retention, weekly active users, sign-up to purchase funnel] Write the queries with CTEs and comments, explain each step, and desc…

Act as a cloud infrastructure engineer. Cloud: [AWS / GCP / Azure] Resources needed: [e.g. VPC, database, container service, storage bucket] Environments: [details] Write Terraform with a sensible module structure, variables and outputs, remote state configuration, tagging, and comments. Explain the plan/apply workflo…

You are a performance-focused backend engineer. App and slow parts: [details] Data freshness requirements: [details] Stack: [details] Recommend what to cache and where (HTTP, application, database query), cache keys, TTLs, invalidation strategy, cache-aside vs write-through, protecting against cache stampedes, and cod…

Act as a senior Next.js developer. Next.js version and router: [e.g. 15, App Router] Page: [purpose] Data source: [API/database] Styling: [Tailwind / CSS modules] Write the page using server components where appropriate, a client component for interactivity, loading and error UI, metadata for SEO, caching/revalidation…

You are a Node.js backend engineer focused on security. Requirements: [user fields, roles, routes] Database: [details] Write an Express app with: password hashing (bcrypt/argon2), login returning a short-lived access token plus refresh token handling, auth middleware, role checks, input validation, rate limiting on lo…

You are a database performance expert. Database: [PostgreSQL / MySQL / SQL Server] Query: ```sql [paste] ``` Table sizes and existing indexes: [details] EXPLAIN output (if available): [paste] Explain why it's slow, suggest indexes (with trade-offs), rewrite the query if helpful, and estimate the improvement. Mention h…

Act as a QA-minded backend engineer. Framework and test tool: [e.g. Jest + Supertest, pytest + httpx, PHPUnit] Endpoints: [list with expected behaviour] Auth: [method] Database setup: [test DB, fixtures] Write integration tests covering success cases, validation errors, auth failures and not-found cases, with setup/te…

Act as a backend developer. Framework/tool: [Laravel, Django, Rails, Prisma, Alembic, raw SQL] Database: [PostgreSQL/MySQL] Change needed: [e.g. add column, rename table, split a field] Table size: [rows] Write the up and down migration, any data backfill, how to deploy it safely without downtime (e.g. expand-and-cont…