v1.6.29

What's Changed

• Performance Optimizations for queryWithRequest Flow by @roncodes in #179
• Feature/performance optimizations by @roncodes in #180
• v1.6.29 ~ fix company resolution within sms verification code by @roncodes in #178

New Features

• Improved API performance with two-layer caching system (Redis + ETag validation) for user and organization data
• Reduced bandwidth usage with automatic HTTP 304 Not Modified responses via new ValidateETag middleware
• Faster page loads with intelligent cache invalidation that updates immediately when data changes
• New UserCacheService class for centralized cache management across the application
• Image resizing support for dynamic image dimensions via URL parameters
• Added ApiModelCache class - Provides intelligent Redis-based caching for API query results with automatic invalidation
• Added HasApiModelCache trait - Enables models to cache query results with a single method call

Performance Improvements

• Optimized form data syncing to eliminate N+1 query problems, reducing database queries from N to 2 for relationship syncing
• Implemented cache stampede prevention to handle high concurrent load efficiently
• Added cache versioning system for automatic invalidation when data changes

Developer Experience

• Added X-Cache-Status header to API responses for easy cache debugging (HIT/MISS visibility)
• Automatic multi-tenant cache key generation for company-scoped data isolation
• Graceful fallback to direct queries when cache is unavailable

Full Changelog: v1.6.28...v1.6.29

v1.6.28

What's Changed

• v1.6.28 ~ Added ability to send verification SMS via org alpha numeri… by @roncodes in #177

Full Changelog: v1.6.27...v1.6.28

v1.6.27

What's Changed

• feat: Comprehensive API Performance Optimization (99.4% improvement) by @roncodes in #176

Full Changelog: v1.6.26...v1.6.27

v1.6.26

What's Changed

• Fix: Support computed columns in aggregate functions by @roncodes in #173
• Fix: Complete support for computed columns in aggregates by @roncodes in #174
• Add comprehensive SQL function support to ComputedColumnValidator by @roncodes in #175
• v1.6.26 by @roncodes in #172

Full Changelog: v1.6.25...v1.6.26

v1.6.25

Fleetbase Core API v1.6.25 Release Notes

This release of the Fleetbase Core API introduces a powerful new scheduling module, support for computed columns in the query builder, and several key improvements and bug fixes. These updates provide a more robust and extensible platform for developers building on Fleetbase.

✨ What's New

Core Scheduling Module

A comprehensive, polymorphic, and reusable scheduling system has been integrated into the core API. This module provides the foundation for a wide range of scheduling applications, from driver and vehicle scheduling in FleetOps to delivery window management in Storefront.

Key Features:

• Polymorphic Architecture: Schedule any entity type within the Fleetbase ecosystem.
• Pluggable Constraint System: Define custom rules and constraints for scheduling.
• Event-Driven: A rich set of events for extending and customizing scheduling workflows.
• Recurring Patterns: Support for recurring schedules using RRULE.
• Multi-Timezone Support: Manage schedules across different timezones.

Computed Columns in Query Builder

The query builder now supports computed columns, allowing for more complex and powerful data queries. This feature includes:

• Secure Expression Validation: A new ComputedColumnValidator ensures the security and integrity of computed column expressions.
• Whitelist-Based Validation: A whitelist of allowed SQL functions and operators prevents malicious code injection.
• Column Reference Resolution: The system can now resolve column references within computed expressions.
• Validation Endpoint: A new API endpoint (/reports/validate-computed-column) allows for real-time validation of computed column expressions.

🚀 Improvements and Fixes

• String Literal Handling: The computed column validator now correctly handles string literals, preventing them from being misinterpreted as column names.
• Query Results: Computed columns are now correctly included in query results and metadata.
• Table Prefixes: A bug that caused table prefixes to be incorrectly added to string literals in computed columns has been fixed.
• JSON Column Search: The search scope has been updated to properly support searching within JSON columns.

🧑‍💻 Developer Notes

• The new scheduling module is accessible via a set of new API endpoints under /int/v1/schedules.
• The computed_columns property can now be included in the query configuration for reports.
• The ComputedColumnValidator service can be used to validate computed column expressions before they are executed.

📝 Merged Pull Requests

• #168: feat: Add Core Scheduling Module
• #169: feat: Add computed columns support to query builder
• #171: feat: Add computed column validation endpoint

Full Changelog: v1.6.24...v1.6.25

v1.6.24

What's Changed

• v1.6.24 ~ critical hotfix on validation implementation and ran linter by @roncodes in #167

Full Changelog: v1.6.23...v1.6.24

v1.6.23

What's Changed

• v1.6.23 ~ by @roncodes in #166

Full Changelog: v1.6.22...v1.6.23

v1.6.22

What's Changed

• v1.6.22 by @roncodes in #165

Full Changelog: v1.6.21...v1.6.22

v1.6.21

What's Changed

• v1.6.21 ~ hotfix role creation, make test mail synchronous by @roncodes in #164

Full Changelog: v1.6.20...v1.6.21

v1.6.20

What's Changed

• v1.6.20 ~ minor improvements and features by @roncodes in #162

Full Changelog: v1.6.19...v1.6.20