OrionORM.jl

Easy ORM for Julia.

Package Features

• Models: conversion, instantiation;
• CRUD functions;
• Database connection using .env file;
• MySQL Support;
• Relationships.

Index

• API
• Relationship
• • Introduction
  • Creating Models with Relationships
  • Querying with the "include" Parameter
  • Internal Workflow
  • Example Tests
  • Conclusion
• OrionORM.jl
• Package Features
• Bulk Operations
• • 1. Batch Insert Query Builder
  • 2. createMany – Chunked, Transactional Inserts
  • 3. createManyAndReturn – Insert & Fetch
  • 4. updateManyAndReturn – Bulk Update & Fetch
  • 5. Performance Tips
• Configuration & Best Practices
• • 1. Environment Variables
  • 2. Logging
  • 3. Connection Pool Tuning
  • 4. Security & Secrets Management
  • 5. SQL Injection Prevention
• Error Handling & Troubleshooting
• • 1. Debugging SQL
  • 2. Handling commands out of sync
  • 3. Transaction Rollback
• Examples & FAQ
• • 1. Multiple Includes
  • 2. Raw SQL Fallback
  • 3. Composite Primary Keys
  • 4. FAQ
• Query Builder Reference
• • 1. Introduction
  • 2. Basic Query Structure
  • 3. Filtering with where
  • 4. Selecting Specific Columns
  • 5. Sorting and Pagination
  • 6. Including Related Models
  • 7. Example: Combined Query
• Quickstart
• • How to config ORM.jl
  • How to perform queries
• Transactions & Connection Management
• • 1. Connection Pooling
  • 2. executeQuery APIs
  • 3. Best Practices
  • 4. Example: Atomic Transfer
  • 5. Troubleshooting