Viewing
Categories: Coding & Development
31 prompts
Advanced
Python Vectorization & Profiling
Profile this Python function on a 10M-row CSV. Suggest vectorized ops and show before/after time using timeit. Code: [paste].
Coding & Development
Profile this Python function on a 10M-row CSV. Suggest vectorized ops and show before/after time using timeit. Code: [paste].
Advanced
Complex SQL Query Optimization
Optimize this SQL query for a 500M row table. Show execution plan, suggest indexes, and provide refactored query with explain...
Coding & Development
Optimize this SQL query for a 500M row table. Show execution plan, suggest indexes, and provide refactored query with explain analysis.
Advanced
Docker Compose Setup
Generate a Docker Compose file for a Node.js app with PostgreSQL, Redis, and nginx reverse proxy. Include environment variables and...
Coding & Development
Generate a Docker Compose file for a Node.js app with PostgreSQL, Redis, and nginx reverse proxy. Include environment variables and health checks.
Intermediate
Comprehensive Unit Test Suite
Write 10 Jest test cases for this React component covering happy path, edge cases, and error handling. Include mocks and...
Coding & Development
Write 10 Jest test cases for this React component covering happy path, edge cases, and error handling. Include mocks and snapshots.
Intermediate
API Documentation Generator
Generate comprehensive API documentation for [endpoint list]. Include: description, parameters (with type & constraints), response schemas, error codes, example requests.
Coding & Development
Generate comprehensive API documentation for [endpoint list]. Include: description, parameters (with type & constraints), response schemas, error codes, example requests.
Expert
System Design Review
Review this system architecture for [use case]. Identify bottlenecks, suggest improvements, provide alternative approaches with trade-offs.
Coding & Development
Review this system architecture for [use case]. Identify bottlenecks, suggest improvements, provide alternative approaches with trade-offs.
Intermediate
Hypothesis-Driven Debugging
Bug: function returns empty on large arrays. Give 3 hypotheses, then request one snippet of instrumented logs. After I paste...
Coding & Development
Bug: function returns empty on large arrays. Give 3 hypotheses, then request one snippet of instrumented logs. After I paste logs, propose fix. Code: [paste].
Intermediate
Minimal Reproducible Example
Create a minimal Python repro for this pandas merge bug. Pin versions, add a failing test, then show fixed version.
Coding & Development
Create a minimal Python repro for this pandas merge bug. Pin versions, add a failing test, then show fixed version.
Intermediate
FastAPI Endpoint Generation
Given this JSON schema, generate a FastAPI endpoint with validation, 2 sad-path tests, and OpenAPI doc. Schema: [json].
Coding & Development
Given this JSON schema, generate a FastAPI endpoint with validation, 2 sad-path tests, and OpenAPI doc. Schema: [json].
Intermediate
Refactor Node.js for O(n) Complexity
Refactor this Node.js function for readability and O(n) complexity. Keep same I/O. Add JSDoc and 2 unit tests (Jest). Code:...
Coding & Development
Refactor this Node.js function for readability and O(n) complexity. Keep same I/O. Add JSDoc and 2 unit tests (Jest). Code: [paste].