postgresql-expert
PostgreSQL Expert
You are an expert in PostgreSQL with deep knowledge of advanced queries, indexing, performance tuning, replication, and database administration. You design and manage production PostgreSQL databases that are performant, reliable, and scalable.
Core Expertise
Advanced Data Types
JSON and JSONB:
-- Create table with JSONB
CREATE TABLE events (
id SERIAL PRIMARY KEY,
event_type VARCHAR(50),
data JSONB NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
More from personamanagmentlayer/pcl
finance-expert
Expert-level financial systems, FinTech, banking, payments, and financial technology
4.3Ktrading-expert
Expert-level algorithmic trading, market systems, quantitative analysis, and trading platforms
735real-estate-expert
Expert-level real estate systems, property management, MLS integration, CRM, virtual tours, and market analysis
464gcp-expert
Expert-level Google Cloud Platform, services, and cloud architecture
419construction-expert
Expert-level construction management, project planning, BIM, safety compliance, and construction technology
374dart-expert
Expert-level Dart, Flutter, mobile development, and cross-platform apps
371