Powering AG Grid and DevExtreme at scale

JDBC engine that automatically generates optimized SQL
for sorting, filtering, pagination and aggregations
on very large datasets.

Data Grids & Charts Ready

Native server-side support for DevExtreme grids and charts, as well as AG Grid, with high-performance data loading and aggregation.

SQL-Native Data Engine

Optimized SQL generation across PostgreSQL, MySQL, Oracle, SQL Server and more — filters, sorting, grouping and aggregations pushed to the database.

Built for Massive Datasets

Designed to handle millions of rows efficiently with server-side querying, pagination and on-demand loading.

Works With Your Stack

Works with modern Java frameworks and relational or analytical databases.

JAVA Frameworks

Spring Boot

Quarkus

Micronaut

Databases

PostgreSQL

MySQL

SQL Server

How It Works

Three simple steps to blazing fast data grids

Parse UI Data Requests

Picnic parses requests from data grids and charts (DevExtreme, AG Grid) automatically.

Generate Optimized SQL

SQL is generated with proper WHERE, ORDER BY, GROUP BY, and LIMIT clauses for your database.

Return Ready-to-Render Data

Results are returned in the exact format expected by your grid or chart components.

Quick Start

From UI interaction to optimized SQL in minutes.

<dependency>
    <groupId>com.picnic</groupId>
    <artifactId>picnic-core</artifactId>
    <version>1.0.0</version>
</dependency>

Frequently Asked Questions

Picnic supports PostgreSQL, MySQL, Oracle, and SQL Server out of the box. Each dialect is optimized for the specific database features and syntax.

Picnic translates DevExtreme and AG Grid filter expressions into optimized SQL WHERE clauses. It supports all standard operators including AND, OR, NOT, LIKE, IN, BETWEEN, and custom filter functions.

Yes! Picnic is designed to integrate seamlessly with Spring Boot. Simply add the dependency and configure your DataSource. We provide auto-configuration for common setups.

Picnic generates highly optimized SQL that pushes all filtering, sorting, and pagination to the database. This typically results in 30-60x performance improvements compared to in-memory processing.

Yes. Picnic supports DevExtreme charts and aggregated data use cases, making it ideal for dashboards, reporting and data visualization.

See all questions

Ready to Scale
Your Data Visualizations?

From data grids to charts, Picnic handles the backend complexity so you can focus on insights.