Contents

• 1. Installation
  • 1.1. Requirements
  • 1.2. Installation Methods
  • 1.3. Optional Dependencies
  • 1.4. Verify Installation
• 2. Quickstart
  • 2.1. Basic Usage
  • 2.2. CRUD Operations
  • 2.3. Async Operations
  • 2.4. Next Steps
• 3. Configuration
  • 3.1. Database Configuration
  • 3.2. Environment Variables
  • 3.3. Connection Pool Configuration
  • 3.4. SSL Configuration
  • 3.5. Testing Configuration
• 4. Basic Usage
  • 4.1. Model Definition
  • 4.2. Field Types
  • 4.3. Automatic Table Creation
  • 4.4. Schema Synchronization
  • 4.5. Working with Data
• 5. WPostgreSQL Class
• 6. Connection Management
  • 6.1. Connection Managers
  • 6.2. Transactions
• 7. Table Sync
• 8. Exceptions
  • WPostgreSQLError
  • ConnectionError
  • TableSyncError
  • ValidationError
  • OperationError
  • SQLInjectionError
  • TransactionError
  • 8.1. Exception Hierarchy
  • 8.2. Usage Example
• 9. Query Builder
  • validate_identifier()
  • QueryBuilder
  • 9.1. Usage
• 10. CRUD Operations
  • 10.1. Create (Insert)
  • 10.2. Insert Multiple Records
  • 10.3. Read
  • 10.4. Update
  • 10.5. Delete
  • 10.6. Advanced Queries
• 11. Async Operations
  • 11.1. Basic Async Operations
  • 11.2. Async Pagination
  • 11.3. Async Bulk Operations
  • 11.4. Async Count
  • 11.5. Async Transactions
  • 11.6. FastAPI Integration
• 12. Transactions
  • 12.1. Basic Transaction
  • 12.2. Transaction Context Manager
  • 12.3. Transaction with Multiple Inserts
  • 12.4. Async Transactions
  • 12.5. Transaction with Rollback
• 13. Pagination
  • 13.1. Limit and Offset
  • 13.2. By Page Number
  • 13.3. With Ordering
  • 13.4. Count Total Records
  • 13.5. Async Pagination
  • 13.6. Complete Pagination Example
• 14. Bulk Operations
  • 14.1. Insert Many
  • 14.2. Large Batch Insert
  • 14.3. Update Many
  • 14.4. Delete Many
  • 14.5. Async Bulk Operations
  • 14.6. Bulk with Transactions
• 15. Relationships
  • 15.1. One-to-Many Relationship
  • 15.2. Many-to-Many Relationship
  • 15.3. One-to-One Relationship
• 16. Stress Testing
  • 16.1. Overview
  • 16.2. Running Stress Tests
  • 16.3. Presets
  • 16.4. Custom Configuration
  • 16.5. Environment Variables
  • 16.6. Docker Setup
  • 16.7. Test Operations
  • 16.8. Performance Metrics
  • 16.9. Stability Results
  • 16.10. Code Example: Manual Stress Test
  • 16.11. Test Configuration Options
  • 16.12. Success Criteria
  • 16.13. Integration with CI/CD
  • 16.14. Conclusion
• 17. Advanced Features
  • 17.1. SQL Injection Prevention
  • 17.2. Custom Field Handling with Pydantic
  • 17.3. Connection Pool Management
  • 17.4. Connection Pooling - Advanced
  • 17.5. Raw SQL Execution
  • 17.6. Logging
  • 17.7. Logging Configuration with Loguru
  • 17.8. CLI Usage
  • 17.9. Error Handling
  • 17.10. Type Hints and IDE Support
• 18. FAQ
  • 18.1. What is wpostgresql?
  • 18.2. How does it differ from SQLAlchemy?
  • 18.3. Does it support async operations?
  • 18.4. Is it production-ready?
  • 18.5. How do I handle database migrations?
  • 18.6. Can I use it with FastAPI?
  • 18.7. How do I run tests?
  • 18.8. Where can I get help?
• 19. Bibliography & Resources
  • 19.1. Official Documentation
  • 19.2. Related Libraries
  • 19.3. Articles & Tutorials
  • 19.4. Contact & Support

Indices and tables

• Index

• Module Index

• Search Page