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.

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…

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…

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…

Act as a DevOps engineer. App: [language/framework and version] Services needed: [database, cache, queue] Ports: [list] Environment variables: [names only] Goal: [local dev / production] Create: 1. A multi-stage Dockerfile (small image, non-root user, cached dependencies) 2. A .dockerignore 3. docker-compose.yml with…

Act as a senior backend developer. Framework: [e.g. Express, FastAPI, Laravel, Django REST, Spring Boot] Database/ORM: [e.g. PostgreSQL + Prisma] Endpoint: [METHOD /path] What it does: [description] Request body/params: [fields and rules] Auth: [public / logged-in user / admin] Write: 1. The route/controller code 2. I…

Act as a performance engineer. Language: [language] What the code does: [description] Typical input size: [e.g. 1M rows, 10k requests/min] Current speed/problem: [e.g. takes 40 seconds, high memory] Please: 1. Identify the bottlenecks and explain the current time and space complexity 2. Propose optimisations (better a…

Act as a SQL expert. Database: [MySQL / PostgreSQL / SQLite / SQL Server] Tables: [table_name](column1 type, column2 type, ...) [table_name](...) What I want: [describe the result in plain English, e.g. "top 10 customers by total spend in 2025, with their order count"] Please: 1. Write the query with clear aliases and…