Run Large PlanetScale Queries in Laravel With DB::olap()

Analytical workloads such as multi-tenant aggregations and monthly financial rollups can overwhelm traditional transactional (OLTP) tables. PlanetScale's integrated columnar analytics engine allows developers to query millions of rows in seconds without burdening the transactional cluster.

Using the DB::olap() Wrapper

In modern Laravel setups, routing analytical queries to the analytical node is as simple as chaining through the query builder:

use Illuminate\Support\Facades\DB;

$monthlyRevenue = DB::olap('planetscale')
    ->table('invoices')
    ->selectRaw('DATE_FORMAT(created_at, "%Y-%m") as month, SUM(amount) as total')
    ->where('status', 'paid')
    ->groupBy('month')
    ->get();

This approach keeps analytical query memory isolated, ensuring zero latency spikes for front-facing user transactions.