# Perspective

> Perspective is an open-source, WebAssembly-powered data grid, pivot table and charting component for large, real-time and streaming datasets — in the browser, Python, Jupyter, Node.js and Rust.

Perspective is Apache-2.0 licensed and a member project of the OpenJS Foundation. npm packages are published under `@perspective-dev/*` (formerly `@finos/perspective*`); the Python package is `perspective-python`; the Rust crate is `perspective`.


## Overview

- [What is Perspective](https://perspective-dev.github.io/guide/perspective.md)

## Use cases

- [Real-time dashboards over WebSocket](https://perspective-dev.github.io/guide/use_cases/real_time_dashboard.md)
- [Streaming pivot tables](https://perspective-dev.github.io/guide/use_cases/streaming_pivot_table.md)
- [Visualizing millions of rows in the browser](https://perspective-dev.github.io/guide/use_cases/large_datasets.md)
- [Trading blotters, order books and market data](https://perspective-dev.github.io/guide/use_cases/market_data.md)
- [Interactive pivot tables and charts in Jupyter](https://perspective-dev.github.io/guide/use_cases/jupyter.md)
- [A UI for DuckDB, ClickHouse and PostgreSQL](https://perspective-dev.github.io/guide/use_cases/database_ui.md)
- [Case study: a multi-billion row tick history in a browser tab with DuckLake and DuckDB-WASM](https://perspective-dev.github.io/guide/use_cases/ducklake.md)
- [Embedded analytics in a web application](https://perspective-dev.github.io/guide/use_cases/embedded_analytics.md)
- [LLM and agent-driven analytics](https://perspective-dev.github.io/guide/use_cases/agent.md)

## Concepts

- [Data Architecture](https://perspective-dev.github.io/guide/explanation/architecture.md)
- [Client-only](https://perspective-dev.github.io/guide/explanation/architecture/client_only.md)
- [Client/Server replicated](https://perspective-dev.github.io/guide/explanation/architecture/client_server.md)
- [Server only](https://perspective-dev.github.io/guide/explanation/architecture/server_only.md)
- [Virtual Servers](https://perspective-dev.github.io/guide/explanation/virtual_servers.md)
- [Table](https://perspective-dev.github.io/guide/explanation/table.md)
- [Schema and column types](https://perspective-dev.github.io/guide/explanation/table/schema.md)
- [Loading data](https://perspective-dev.github.io/guide/explanation/table/loading_data.md)
- [Construct an empty Table from a schema](https://perspective-dev.github.io/guide/explanation/table/constructing_schema.md)
- [index, limit and page_to_disk options](https://perspective-dev.github.io/guide/explanation/table/options.md)
- [update() and remove() streaming methods](https://perspective-dev.github.io/guide/explanation/table/update_and_remove.md)
- [clear() and replace() start-over methods](https://perspective-dev.github.io/guide/explanation/table/clear_and_replace.md)
- [View](https://perspective-dev.github.io/guide/explanation/view.md)
- [Querying data](https://perspective-dev.github.io/guide/explanation/view/querying.md)
- [Grouping and Pivots](https://perspective-dev.github.io/guide/explanation/view/config/grouping_and_pivots.md)
- [Selection and Ordering](https://perspective-dev.github.io/guide/explanation/view/config/selection_and_ordering.md)
- [expressions](https://perspective-dev.github.io/guide/explanation/view/config/expressions.md)
- [Window Columns](https://perspective-dev.github.io/guide/explanation/view/config/windows.md)
- [Advanced View Operations](https://perspective-dev.github.io/guide/explanation/view/advanced.md)
- [Join](https://perspective-dev.github.io/guide/explanation/join.md)
- [Join Types](https://perspective-dev.github.io/guide/explanation/join/join_types.md)
- [Join Options](https://perspective-dev.github.io/guide/explanation/join/options.md)
- [Reactivity and Constraints](https://perspective-dev.github.io/guide/explanation/join/reactivity.md)

## JavaScript

- [Installation and Module Structure](https://perspective-dev.github.io/guide/how_to/javascript/installation.md)
- [Importing with or without a bundler](https://perspective-dev.github.io/guide/how_to/javascript/importing.md)
- [perspective data engine library](https://perspective-dev.github.io/guide/how_to/javascript/worker.md)
- [Serializing data](https://perspective-dev.github.io/guide/how_to/javascript/serializing.md)
- [Cleaning up resources](https://perspective-dev.github.io/guide/how_to/javascript/deleting.md)
- [Hosting a WebSocketServer in Node.js](https://perspective-dev.github.io/guide/how_to/javascript/nodejs_server.md)
- [Customizing perspective.worker()](https://perspective-dev.github.io/guide/how_to/javascript/custom_worker.md)
- [Joining Tables](https://perspective-dev.github.io/guide/how_to/javascript/join.md)
- [perspective-viewer Custom Element library](https://perspective-dev.github.io/guide/how_to/javascript/viewer.md)
- [Loading data](https://perspective-dev.github.io/guide/how_to/javascript/loading_data.md)
- [Theming](https://perspective-dev.github.io/guide/how_to/javascript/theming.md)
- [Saving and restoring UI state](https://perspective-dev.github.io/guide/how_to/javascript/save_restore.md)
- [Listening for events](https://perspective-dev.github.io/guide/how_to/javascript/events.md)
- [Plugin render limits](https://perspective-dev.github.io/guide/how_to/javascript/plugin_settings.md)
- [Map tile sources](https://perspective-dev.github.io/guide/how_to/javascript/map_tile_sources.md)
- [Configuring the LLM agent](https://perspective-dev.github.io/guide/how_to/javascript/agent.md)
- [Virtual Servers](https://perspective-dev.github.io/guide/how_to/javascript/virtual_server.md)
- [DuckDB](https://perspective-dev.github.io/guide/how_to/javascript/virtual_server/duckdb.md)
- [ClickHouse](https://perspective-dev.github.io/guide/how_to/javascript/virtual_server/clickhouse.md)
- [Custom](https://perspective-dev.github.io/guide/how_to/javascript/virtual_server/custom.md)
- [React Component](https://perspective-dev.github.io/guide/how_to/javascript/react.md)

## Python

- [Overview](https://perspective-dev.github.io/guide/explanation/python.md)
- [Installation](https://perspective-dev.github.io/guide/how_to/python/installation.md)
- [Loading data into a Table](https://perspective-dev.github.io/guide/how_to/python/table.md)
- [pandas, polars and pyarrow integration](https://perspective-dev.github.io/guide/how_to/python/table_data.md)
- [Callbacks and events](https://perspective-dev.github.io/guide/how_to/python/callbacks.md)
- [Multithreading](https://perspective-dev.github.io/guide/how_to/python/multithreading.md)
- [Hosting a WebSocket server](https://perspective-dev.github.io/guide/how_to/python/websocket.md)
- [Joining Tables](https://perspective-dev.github.io/guide/how_to/python/join.md)
- [PerspectiveWidget for JupyterLab](https://perspective-dev.github.io/guide/how_to/python/jupyterlab.md)
- [Virtual Servers](https://perspective-dev.github.io/guide/how_to/python/virtual_server.md)
- [DuckDB](https://perspective-dev.github.io/guide/how_to/python/virtual_server/duckdb.md)
- [ClickHouse](https://perspective-dev.github.io/guide/how_to/python/virtual_server/clickhouse.md)
- [Polars](https://perspective-dev.github.io/guide/how_to/python/virtual_server/polars.md)
- [PostgreSQL](https://perspective-dev.github.io/guide/how_to/python/virtual_server/postgres.md)
- [Custom](https://perspective-dev.github.io/guide/how_to/python/virtual_server/custom.md)

## Rust

- [Getting Started](https://perspective-dev.github.io/guide/how_to/rust.md)

## Integrations

- [FastAPI and Starlette](https://perspective-dev.github.io/guide/integrations/fastapi.md)
- [Next.js, Vue, Svelte and Angular](https://perspective-dev.github.io/guide/integrations/frameworks.md)
- [Kafka and other message queues](https://perspective-dev.github.io/guide/integrations/kafka.md)

## Tutorials

- [A tornado server in Python](https://perspective-dev.github.io/guide/tutorials/python/tornado.md)

## API Reference

- [API Reference](https://perspective-dev.github.io/guide/api_reference.md)

## Reference

- [Benchmarks](https://perspective-dev.github.io/guide/benchmarks.md)
- [Glossary](https://perspective-dev.github.io/guide/glossary.md)
- [FAQ](https://perspective-dev.github.io/guide/FAQ.md)

## Examples

- [Example gallery](https://perspective-dev.github.io/gallery/index.html): live examples, each with its full viewer configuration as JSON

## Optional

- [Full guide as one document](https://perspective-dev.github.io/llms-full.txt)
- [Source code](https://github.com/perspective-dev/perspective)
- [Changelog](https://github.com/perspective-dev/perspective/blob/master/CHANGELOG.md)