Skip to content
generated from antfu/starter-ts

An powerful in-memory pagination / sort / search / filter engine, with first-class type-safety, with an elegant & DX-focused API

License

Notifications You must be signed in to change notification settings

ChronicStone/array-ql

Repository files navigation

Array-Query

npm version npm downloads bundle JSDocs License

Query JavaScript arrays with ORM-like syntax, benefiting from excellent type-safety & developer experience.

Key Features:

  • 🛠 Type-safe Querying: Design your queries with strong typing (typed sort / search / filter keys & output)
  • 📄 Pagination: Easily paginate through large datasets with built-in support.
  • 🔎 Full-text Search: Perform comprehensive searches across multiple fields in your data.
  • 🧭 Advanced Filtering: Apply complex filters with various match modes for precise data retrieval. Supports logical grouping, nested conditions, and array matching.
  • 🔢 Flexible Sorting: Order results based on any field, with support for multiple sort criteria.
  • 🚀 Lightweight and Fast: Queries stay super fast, even with large datasets.
  • 🧩 Zero Dependencies: Completely self-contained with no external dependencies, ensuring a small bundle cost

INSTALLATION

// npm
npm install @chronicstone/array-query

// yarn
yarn add @chronicstone/array-query

// pnpm
pnpm add @chronicstone/array-query

// bun
bun add @chronicstone/array-query

USAGE EXAMPLE

import { query } from '@chronicstone/array-query'

const users = [
  { id: 1, fullName: 'John Doe', email: '[email protected]', age: 30, status: 'active', roles: ['admin'], createdAt: '2023-01-01' },
  { id: 2, fullName: 'Jane Smith', email: '[email protected]', age: 28, status: 'inactive', roles: ['user'], createdAt: '2023-02-15' },
  { id: 3, fullName: 'Bob Johnson', email: '[email protected]', age: 35, status: 'active', roles: ['user', 'manager'], createdAt: '2023-03-20' },
  // ... more users
]

const { totalRows, totalPages, rows } = query(users, {
  // Pagination
  page: 1,
  limit: 10,

  // Sorting
  sort: [
    { key: 'age', dir: 'desc' },
    { key: 'fullName', dir: 'asc' }
  ],

  // Searching
  search: {
    value: 'john',
    keys: ['fullName', 'email']
  },

  // Filtering
  filter: [
    { key: 'status', matchMode: 'equals', value: 'active' },
    { key: 'age', matchMode: 'greaterThan', value: 25 },
  ]
})

This example demonstrates pagination, multi-field sorting, full-text searching, and complex filtering with nested conditions and array field matching.

License

MIT License © 2023-PRESENT Cyprien THAO