# KX Product Documentation — Full Reference # Placed at: https://code.kx.com/llms-full.txt # Updated: 2026-09-09 > code.kx.com is the official documentation hub for all KX products, including KDB-X (next-generation kdb+ ecosystem), kdb+/q (high-performance time-series database and vector programming language), PyKX (Python interface to kdb+), KDB.AI (vector database for AI), kdb Insights SDK (cloud-native microservices platform), kdb Insights Enterprise (managed enterprise deployment), KX Dashboards (visualization platform), KX Analyst, KX Developer, VS Code Extension, KX Delta Platform, KX Refinery, Feedhandlers, and Accelerators. Portfolio-wide licensing, support, and lifecycle content now lives on its own unversioned site at /licensing/. --- ## KDB-X KDB-X is the next generation of the kdb+ ecosystem, designed for real-time, data-intensive, and AI-driven applications at scale. It is built on kdb+ and powered by the array-based functional language q. KDB-X extends kdb+ with built-in AI libraries, modules (Parquet, SQL, Object Storage, REST Server, GPU, cuVS), a Python interface, MCP server integration, and managed services — the containerized DB Service and an embedded KDB.AI service. ### Getting Started - [KDB-X Home](https://code.kx.com/kdb-x/index.html): Documentation home page. - [About KDB-X](https://code.kx.com/kdb-x/get_started/kdb-x-get-started.html): What KDB-X is and how it differs from kdb+. - [Install KDB-X](https://code.kx.com/kdb-x/get_started/kdb-x-install.html): Installation steps. - [Install KDB-X Python](https://code.kx.com/kdb-x/get_started/kdb-x-python-install.html): Python interface install. - [Brief Introduction to q and KDB-X](https://code.kx.com/kdb-x/learn/brief-introduction.html): Conceptual overview. - [Tutorials Index](https://code.kx.com/kdb-x/learn/tutorials_and_examples.html): Tutorials and worked examples. - [Q for Mortals (KDB-X edition)](https://code.kx.com/kdb-x/learn/q4m/index.html): Full textbook embedded in docs. ### How-To Guides - [Guides Overview](https://code.kx.com/kdb-x/learn/overview.html) - [Use the q Terminal (REPL)](https://code.kx.com/kdb-x/how_to/general_guidance/use-the-q-terminal.html) - [Data Structures Overview](https://code.kx.com/kdb-x/how_to/basics/data_structures/overview.html) - [Work with Lists](https://code.kx.com/kdb-x/how_to/basics/data_structures/lists.html) - [Work with Dictionaries](https://code.kx.com/kdb-x/how_to/basics/data_structures/dictionaries.html) - [Work with Tables](https://code.kx.com/kdb-x/how_to/basics/data_structures/tables.html) - [Work with Keyed Tables](https://code.kx.com/kdb-x/how_to/basics/data_structures/keyed-tables.html) - [Work with Files](https://code.kx.com/kdb-x/how_to/basics/work-with-files.html) - [Work with Functions](https://code.kx.com/kdb-x/how_to/basics/work-with-functions.html) - [Control Execution](https://code.kx.com/kdb-x/how_to/basics/control-execution.html) - [Debug](https://code.kx.com/kdb-x/how_to/basics/debug.html) - [Query Data with qSQL](https://code.kx.com/kdb-x/how_to/querying/query-data-using-qSQL.html) - [Sort Query Results](https://code.kx.com/kdb-x/how_to/querying/sort.html) - [Aggregations and Filtering](https://code.kx.com/kdb-x/how_to/querying/agg.html) - [Join Data](https://code.kx.com/kdb-x/how_to/querying/join.html) - [Pivot and Unpivot a Table](https://code.kx.com/kdb-x/how_to/querying/pivot.html) - [Listening Port](https://code.kx.com/kdb-x/how_to/io_and_communication/listening-port.html) - [Deferred Response](https://code.kx.com/kdb-x/how_to/io_and_communication/deferred-response.html) - [Async Callbacks](https://code.kx.com/kdb-x/how_to/io_and_communication/callbacks.html) - [SSL/TLS](https://code.kx.com/kdb-x/how_to/io_and_communication/ssl.html) - [HTTP](https://code.kx.com/kdb-x/how_to/io_and_communication/http.html) - [WebSockets](https://code.kx.com/kdb-x/how_to/io_and_communication/websockets.html) - [Subscribe to a Data Feed](https://code.kx.com/kdb-x/how_to/io_and_communication/subscribe-to-a-data-feed.html) - [Tables in the Filesystem](https://code.kx.com/kdb-x/how_to/interact_with_databases/tables_in_filesystem.html) - [Splayed Tables](https://code.kx.com/kdb-x/how_to/interact_with_databases/splayed-tables.html) - [Partitioned Tables](https://code.kx.com/kdb-x/how_to/interact_with_databases/partition.html) - [Segmented Databases](https://code.kx.com/kdb-x/how_to/interact_with_databases/segment.html) - [Data-At-Rest Encryption](https://code.kx.com/kdb-x/how_to/interact_with_databases/dare.html) - [File Compression](https://code.kx.com/kdb-x/how_to/interact_with_databases/file-compression.html) - [Streaming Architecture (KDB-X Tick)](https://code.kx.com/kdb-x/how_to/manage_streaming_data/architecture.html) - [Gateway Design](https://code.kx.com/kdb-x/how_to/manage_streaming_data/gateway-design/index.html) - [Query Routing](https://code.kx.com/kdb-x/how_to/manage_streaming_data/query-routing/index.html) - [Disaster Recovery](https://code.kx.com/kdb-x/how_to/manage_streaming_data/disaster-recovery/index.html) - [Parallel Processing](https://code.kx.com/kdb-x/how_to/performance/parallel-processing.html) - [Performance Tips](https://code.kx.com/kdb-x/how_to/performance/performance.html) - [KDB-X Python Overview](https://code.kx.com/kdb-x/learn/kdb-x-python-overview.html) ### Reference - [Reference Card for KDB-X and q](https://code.kx.com/kdb-x/ref/index.html) - [By Topic](https://code.kx.com/kdb-x/ref/by-topic.html) - [Datatypes](https://code.kx.com/kdb-x/ref/datatypes.html) - [Syntax](https://code.kx.com/kdb-x/ref/syntax.html) - [Iteration Overview](https://code.kx.com/kdb-x/ref/iteration.html) - [Iterators](https://code.kx.com/kdb-x/ref/iterators.html) - [Maps](https://code.kx.com/kdb-x/ref/maps.html) - [Accumulators](https://code.kx.com/kdb-x/ref/accumulators.html) - [qSQL Queries](https://code.kx.com/kdb-x/ref/qsql.html) - [Functional qSQL](https://code.kx.com/kdb-x/ref/funsql.html) - [Joins](https://code.kx.com/kdb-x/ref/joins.html) - [Namespaces (.h, .j, .m, .Q, .z)](https://code.kx.com/kdb-x/ref/namespaces.html) - [System Commands](https://code.kx.com/kdb-x/ref/syscmds.html) - [Command-Line Options](https://code.kx.com/kdb-x/ref/cmdline.html) - [Errors](https://code.kx.com/kdb-x/ref/errors.html) - [Temporal Data](https://code.kx.com/kdb-x/ref/temporal-data.html) - [Multithreaded Primitives](https://code.kx.com/kdb-x/ref/mt-primitives.html) - [C API for KDB-X](https://code.kx.com/kdb-x/ref/languages/capiref.html) - [C# Interface](https://code.kx.com/kdb-x/ref/languages/csharp.html) - [Java Interface](https://code.kx.com/kdb-x/ref/languages/java.html) - [R Interface](https://code.kx.com/kdb-x/ref/languages/r.html) - [Rust Interface](https://code.kx.com/kdb-x/ref/languages/rust.html) - [FFI](https://code.kx.com/kdb-x/ref/languages/ffi.html) - [Glossary](https://code.kx.com/kdb-x/ref/glossary.html): KDB-X and q terminology. ### AI Libraries (Built-in) - [AI Libraries Overview](https://code.kx.com/kdb-x/ref/ai-libs/ai-libraries-overview.html) - [Flat (Brute Force) Vector Index](https://code.kx.com/kdb-x/ref/ai-libs/flat-index-parameters.html) - [HNSW Vector Index](https://code.kx.com/kdb-x/ref/ai-libs/hnsw-index-parameters.html) - [IVF Vector Index](https://code.kx.com/kdb-x/ref/ai-libs/ivf-index-parameters.html) - [IVFPQ Vector Index](https://code.kx.com/kdb-x/ref/ai-libs/ivfpq-index-parameters.html) - [BM25 Text Search Index](https://code.kx.com/kdb-x/ref/ai-libs/bm25-index-parameters.html) - [Fuzzy Matching](https://code.kx.com/kdb-x/ref/ai-libs/fuzzy-index-parameters.html) - [Hybrid Search](https://code.kx.com/kdb-x/ref/ai-libs/hybrid-index-parameters.html) - [Time Series Search (TSS)](https://code.kx.com/kdb-x/ref/ai-libs/tss-index-parameters.html) - [Dynamic Time Warping (DTW)](https://code.kx.com/kdb-x/ref/ai-libs/dtw-index-parameters.html) - [Anomaly Detection](https://code.kx.com/kdb-x/ref/ai-libs/anomaly-parameters.html) ### Modules - [Modules Overview](https://code.kx.com/kdb-x/modules/module-index.html) - [Module Framework](https://code.kx.com/kdb-x/modules/module-framework/overview.html) - [Parquet Module](https://code.kx.com/kdb-x/modules/parquet/overview.html): Read/write Parquet files. - [SQL Module](https://code.kx.com/kdb-x/modules/sql/introduction.html): ANSI SQL support. - [Object Storage Module](https://code.kx.com/kdb-x/modules/objstor/overview.html): S3/cloud object storage. - [REST Server Module](https://code.kx.com/kdb-x/modules/rest-server/overview.html): Expose KDB-X as a REST API. - [Kurl Module](https://code.kx.com/kdb-x/modules/kurl/introduction.html): HTTP client for q. - [Logging Module](https://code.kx.com/kdb-x/modules/logging/overview.html) - [BLAS Module](https://code.kx.com/kdb-x/modules/blas/overview.html): Linear algebra. - [PCRE2 Module](https://code.kx.com/kdb-x/modules/pcre2/overview.html): Advanced regex. - [DBmaint Module](https://code.kx.com/kdb-x/modules/dbmaint/overview.html): Database maintenance utilities. - [Datagen Module](https://code.kx.com/kdb-x/modules/datagen/overview.html): Test data generation. - [Fusionx Module](https://code.kx.com/kdb-x/modules/fusionx.html): Data fusion utilities. - [AX Module](https://code.kx.com/kdb-x/modules/ax/overview.html): Analytics extension module. - [Expat Module](https://code.kx.com/kdb-x/modules/expat/overview.html): XML parsing. - [Printf Module](https://code.kx.com/kdb-x/modules/printf/overview.html): C-style formatted output. - [TAQ Module](https://code.kx.com/kdb-x/modules/taq/overview.html): Trade-and-quote financial data utilities. - [GPU Module](https://code.kx.com/kdb-x/modules/gpu/introduction.html): GPU-accelerated compute for KDB-X. - [GPU Quickstart](https://code.kx.com/kdb-x/modules/gpu/quickstart/quickstart.html), [Examples](https://code.kx.com/kdb-x/modules/gpu/examples.html), [Reference](https://code.kx.com/kdb-x/modules/gpu/reference.html) - [NVIDIA cuVS Module](https://code.kx.com/kdb-x/modules/cuvs/introduction.html): GPU-accelerated vector search built on NVIDIA cuVS. - [cuVS Quickstart](https://code.kx.com/kdb-x/modules/cuvs/quickstart/quickstart.html), [Examples](https://code.kx.com/kdb-x/modules/cuvs/examples.html), [Reference](https://code.kx.com/kdb-x/modules/cuvs/reference.html) ### Extensions and Integrations - [Extensions Overview](https://code.kx.com/kdb-x/integrations/integrations-index.html): Formerly "Integrations" in the site navigation; the /integrations/ URLs are unchanged. - [MCP Server](https://code.kx.com/kdb-x/integrations/mcp-server.html): Model Context Protocol for AI agents. - [PG Wire / Postgres SQL Interface](https://code.kx.com/kdb-x/integrations/pgwire/introduction.html): Connect Postgres-compatible BI and SQL tools. - [PG Wire Quickstart](https://code.kx.com/kdb-x/integrations/pgwire/quickstart.html), [Reference](https://code.kx.com/kdb-x/integrations/pgwire/reference.html), [Examples](https://code.kx.com/kdb-x/integrations/pgwire/examples.html) - [KX Dashboards Visualization](https://code.kx.com/kdb-x/integrations/dashboards.html): Connect KX Dashboards to KDB-X. ### Services *(New section)* - [DB Service Overview](https://code.kx.com/kdb-x/services/db-service/introduction.html): Containerized time-series database service for KDB-X, distributed via Docker Compose. - [DB Service Quickstart](https://code.kx.com/kdb-x/services/db-service/quickstart.html): Stand up the service and load first data. - [DB Service Data Import](https://code.kx.com/kdb-x/services/db-service/import.html): Batch, inline, and database-based ingestion; how import jobs are processed. - [DB Service Query](https://code.kx.com/kdb-x/services/db-service/query.html): Query via the Python client, q, and the REST API. - [DB Service Table Management](https://code.kx.com/kdb-x/services/db-service/manage-tables.html): Table definition and the design choices affecting data organization and query performance. - [KDB.AI Service in KDB-X](https://code.kx.com/kdb-x/services/kdb.ai-introduction.html): Concepts, architecture, supported operations, and limitations of the embedded KDB.AI service. ### Releases - [KDB-X Roadmap](https://code.kx.com/kdb-x/releases/kdb-x-roadmap.html) - [Release Notes](https://code.kx.com/kdb-x/releases/release-notes-latest.html) - [Telemetry](https://code.kx.com/kdb-x/releases/telemetry.html): Opt-in usage telemetry. - [Migrate from PyKX to KDB-X Python](https://code.kx.com/kdb-x/releases/kdb-x-python-migration-from-pykx.html) --- ## kdb+ and q kdb+ is a high-performance cross-platform historical time-series columnar database, an in-memory compute engine, a realtime streaming processor, and the q vector programming language. ### Getting Started - [Overview](https://code.kx.com/q): Product home. - [Install kdb+](https://code.kx.com/q/learn/install/) - [Licensing](https://code.kx.com/q/learn/licensing/) - [Learn Overview](https://code.kx.com/q/learn/) - [Mountain Tour](https://code.kx.com/q/learn/tour/): Rapid q tour. - [Q for Quants](https://code.kx.com/q/learn/brief-introduction/) - [Q for Mortals 3](https://code.kx.com/q4m3/): Full online textbook. - [Starting kdb+](https://code.kx.com/q/learn/startingkdb/): Structured intro — language, IPC, tables, HDB, RDB. ### Language Reference - [Reference Card](https://code.kx.com/q/ref/) - [Basics by Topic](https://code.kx.com/q/basics/by-topic/) - [Syntax](https://code.kx.com/q/basics/syntax/) - [Datatypes](https://code.kx.com/q/basics/datatypes/) - [Function Notation](https://code.kx.com/q/basics/function-notation/) - [Iteration Overview](https://code.kx.com/q/basics/iteration/) - [Iterators](https://code.kx.com/q/ref/iterators/) - [Implicit Iteration](https://code.kx.com/q/basics/implicit-iteration/) - [Maps](https://code.kx.com/q/ref/maps/) - [Accumulators](https://code.kx.com/q/ref/accumulators/) - [Dictionaries and Tables](https://code.kx.com/q/basics/dictsandtables/) - [Enumerations](https://code.kx.com/q/basics/enumerations/) - [qSQL Queries](https://code.kx.com/q/basics/qsql/) - [Functional qSQL](https://code.kx.com/q/basics/funsql/) - [Joins](https://code.kx.com/q/basics/joins/) - [Pattern Matching](https://code.kx.com/q/basics/pattern/) - [Parse Trees](https://code.kx.com/q/basics/parsetrees/) - [Regular Expressions](https://code.kx.com/q/basics/regex/) - [System Commands](https://code.kx.com/q/basics/syscmds/) - [Command-Line Options](https://code.kx.com/q/basics/cmdline/) - [Internal Functions](https://code.kx.com/q/basics/internal/) - [Namespaces](https://code.kx.com/q/basics/namespaces/) - [.h (Markup)](https://code.kx.com/q/ref/doth/) - [.j (JSON)](https://code.kx.com/q/ref/dotj/) - [.Q (Utilities)](https://code.kx.com/q/ref/dotq/) - [.z (Environment & Callbacks)](https://code.kx.com/q/ref/dotz/) - [Connection Handles](https://code.kx.com/q/basics/handles/) - [Precision](https://code.kx.com/q/basics/precision/) - [Temporal Data](https://code.kx.com/q/kb/temporal-data/) - [Comparison](https://code.kx.com/q/basics/comparison/) - [Mathematics](https://code.kx.com/q/basics/math/) - [Glossary](https://code.kx.com/q/basics/glossary/) - [Errors](https://code.kx.com/q/basics/errors/) ### Database - [Tables in the Filesystem](https://code.kx.com/q/database/) - [Serializing Objects](https://code.kx.com/q/database/object/) - [Splayed Tables](https://code.kx.com/q/kb/splayed-tables/) - [Partitioned Tables](https://code.kx.com/q/kb/partition/) - [Segmented Databases](https://code.kx.com/q/database/segment/) - [Multiple Partitions](https://code.kx.com/q/wp/multi-partitioned-dbs/) - [Loading from Large Files](https://code.kx.com/q/kb/loading-from-large-files/) - [Foreign Keys](https://code.kx.com/q/wp/foreign-keys/) - [Linking Columns](https://code.kx.com/q/kb/linking-columns/) - [Data Management](https://code.kx.com/q/wp/data-management/) - [Data-At-Rest Encryption](https://code.kx.com/q/kb/dare/) - [File Compression](https://code.kx.com/q/kb/file-compression/) - [Query Optimization](https://code.kx.com/q/wp/columnar-database/) - [Query Scaling](https://code.kx.com/q/wp/query-scaling/) - [Compacting HDB sym](https://code.kx.com/q/kb/compacting-hdb-sym/) ### Developing - [IPC Overview](https://code.kx.com/q/basics/ipc/) - [Listening Port](https://code.kx.com/q/basics/listening-port/) - [Deferred Response](https://code.kx.com/q/kb/deferred-response/) - [Async Callbacks](https://code.kx.com/q/kb/callbacks/) - [Named Pipes](https://code.kx.com/q/kb/named-pipes/) - [Socket Sharding](https://code.kx.com/q/wp/socket-sharding/) - [SSL/TLS](https://code.kx.com/q/kb/ssl/) - [HTTP](https://code.kx.com/q/kb/http/) - [WebSockets](https://code.kx.com/q/kb/websockets/) - [Code Profiler](https://code.kx.com/q/kb/profiler/) - [Debugging](https://code.kx.com/q/basics/debug/) - [Unit Tests](https://code.kx.com/q/kb/unit-tests/) - [Monitor & Control (.z callbacks)](https://code.kx.com/q/kb/using-dotz/) - [Pivoting Tables](https://code.kx.com/q/kb/pivoting-tables/) - [Timezones](https://code.kx.com/q/kb/timezones/) - [Multithreaded Primitives](https://code.kx.com/q/kb/mt-primitives/) - [Parallel Processing (peach)](https://code.kx.com/q/basics/peach/) - [Multi-threading](https://code.kx.com/q/wp/multi-thread/) - [Performance Tips](https://code.kx.com/q/kb/performance-tips/) - [Linux Production Notes](https://code.kx.com/q/kb/linux-production/) - [CPU Affinity](https://code.kx.com/q/kb/cpu-affinity/) - [Log Files](https://code.kx.com/q/kb/logging/) ### Streaming Architecture - [Architecture Overview](https://code.kx.com/q/architecture/) - [Tickerplant (tick.q)](https://code.kx.com/q/architecture/tickq/) - [Pub/Sub (u.q)](https://code.kx.com/q/architecture/uq/) - [Realtime Database (r.q)](https://code.kx.com/q/architecture/rq/) - [TP Log and Data Recovery](https://code.kx.com/q/wp/data-recovery/) - [Realtime Engines](https://code.kx.com/q/wp/rt-tick/) - [Gateway Design](https://code.kx.com/q/wp/gateway-design/) - [Query Routing](https://code.kx.com/q/wp/query-routing/) - [Load Balancing](https://code.kx.com/q/kb/load-balancing/) - [Disaster Recovery](https://code.kx.com/q/wp/disaster-recovery/) - [Order Book](https://code.kx.com/q/wp/order-book/) - [RDB Intraday Writedown](https://code.kx.com/q/wp/intraday-writedown/) ### Interfaces - [All Interfaces](https://code.kx.com/q/interfaces/) - [C API Reference](https://code.kx.com/q/interfaces/capiref/) - [C API White Paper](https://code.kx.com/q/wp/capi/) - [Extend q with C/C++](https://code.kx.com/q/interfaces/using-c-functions/) - [C# Interface](https://code.kx.com/q/interfaces/csharp/) - [FFI](https://code.kx.com/q/interfaces/ffi/) - [Java Interface](https://code.kx.com/q/interfaces/java/) - [Python Interface](https://code.kx.com/q/interfaces/python/) - [R Interface](https://code.kx.com/q/interfaces/r/) - [Rust Interface](https://code.kx.com/q/interfaces/rust/) - [Scala Interface](https://code.kx.com/q/interfaces/scala-client-for-q/) - [Bloomberg Interface](https://code.kx.com/q/interfaces/q-client-for-bloomberg/) - [Excel Interface](https://code.kx.com/q/interfaces/excel-client-for-q/) - [ODBC Client](https://code.kx.com/q/interfaces/q-client-for-odbc/) - [ODBC3 Server](https://code.kx.com/q/interfaces/q-server-for-odbc3/) - [FIX Messaging](https://code.kx.com/q/wp/fix-messaging/) - [Solace Pub/Sub](https://code.kx.com/q/wp/solace/) - [Machine Learning](https://code.kx.com/q/ml/) - [Open Source / GitHub](https://code.kx.com/q/github/) ### Cloud - [Cloud Overview](https://code.kx.com/q/cloud/) - [AWS Reference Architecture](https://code.kx.com/q/cloud/aws/) - [Migrating HDB to AWS EC2](https://code.kx.com/q/cloud/aws/migration/) - [AWS EBS](https://code.kx.com/q/cloud/aws/app-a-ebs/) - [AWS EFS/NFS](https://code.kx.com/q/cloud/aws/app-b-efs-nfs/) - [AWS FSx for Lustre](https://code.kx.com/q/cloud/aws/lustre/) - [AWS Lambda](https://code.kx.com/q/cloud/aws-lambda/) - [Azure Reference Architecture](https://code.kx.com/q/cloud/azure/architecture/) - [GCP Reference Architecture](https://code.kx.com/q/cloud/gcpm/architecture/) - [Auto Scaling](https://code.kx.com/q/cloud/autoscale/) ### Release Notes - [All Versions](https://code.kx.com/q/releases/) - [Changes in 4.1](https://code.kx.com/q/releases/ChangesIn4.1/) - [Changes in 4.0](https://code.kx.com/q/releases/ChangesIn4.0/) - [Changes in 3.6](https://code.kx.com/q/releases/ChangesIn3.6/) --- ## PyKX (v4.1) PyKX is a Python-first interface to kdb+ and q. It lets Python developers access kdb+'s speed for data processing and storage, and allows q developers to use Python's data science ecosystem. PyKX documentation is served from unversioned "latest" paths, which currently resolve to /pykx/4.1/. The 4.x line added subprocess execution, a console/context API, module reimporting, and a beta PyTorch integration. PyKX is also distributed as KDB-X Python; see the KDB-X migration guide. ### Getting Started - [Install PyKX](https://code.kx.com/pykx/getting-started/installing.html) - [Quickstart](https://code.kx.com/pykx/getting-started/quickstart.html) - [What is PyKX?](https://code.kx.com/pykx/getting-started/what_is_pykx.html) - [Objects Overview](https://code.kx.com/pykx/learn/objects.html) ### User Guide - [Configuration](https://code.kx.com/pykx/user-guide/configuration.html) - [Modes of Operation](https://code.kx.com/pykx/user-guide/advanced/modes.html): Licensed vs unlicensed. - [Creating Objects](https://code.kx.com/pykx/user-guide/fundamentals/creating.html) - [Using Objects](https://code.kx.com/pykx/user-guide/fundamentals/evaluating.html) - [Indexing Objects](https://code.kx.com/pykx/user-guide/fundamentals/indexing.html) - [Data Conversion](https://code.kx.com/pykx/user-guide/fundamentals/conversion_considerations.html) - [Nulls and Infinities](https://code.kx.com/pykx/user-guide/fundamentals/nulls_and_infinities.html) - [Temporal Data Conversion](https://code.kx.com/pykx/user-guide/fundamentals/temporal.html) - [Text Handling](https://code.kx.com/pykx/user-guide/fundamentals/text.html) - [Query Introduction](https://code.kx.com/pykx/user-guide/fundamentals/query/index.html) - [Query with Python](https://code.kx.com/pykx/user-guide/fundamentals/query/pyquery.html) - [Query with SQL](https://code.kx.com/pykx/user-guide/fundamentals/query/sql.html) - [Query with q](https://code.kx.com/pykx/user-guide/fundamentals/query/qquery.html) - [Query Performance](https://code.kx.com/pykx/user-guide/fundamentals/query/perf.html) - [IPC Communication](https://code.kx.com/pykx/user-guide/advanced/ipc.html) - [Generate Databases](https://code.kx.com/pykx/user-guide/advanced/database/db_gen.html) - [Load Databases](https://code.kx.com/pykx/user-guide/advanced/database/db_loading.html) - [Manage Databases](https://code.kx.com/pykx/user-guide/advanced/database/db_mgmt.html) - [Real-time Streaming](https://code.kx.com/pykx/user-guide/advanced/streaming/index.html) - [Streaming: Basic Setup](https://code.kx.com/pykx/user-guide/advanced/streaming/basic.html) - [Streaming: Complex Pipelines](https://code.kx.com/pykx/user-guide/advanced/streaming/complex.html) - [Publish Data](https://code.kx.com/pykx/user-guide/advanced/streaming/publish.html) - [Subscribe to Data](https://code.kx.com/pykx/user-guide/advanced/streaming/subscribe.html) - [Real-time Analytics](https://code.kx.com/pykx/user-guide/advanced/streaming/rta.html) - [Build Custom APIs](https://code.kx.com/pykx/user-guide/advanced/streaming/custom_apis.html) - [Streaming Gateways](https://code.kx.com/pykx/user-guide/advanced/streaming/gateways.html) - [Attributes](https://code.kx.com/pykx/user-guide/advanced/attributes.html) - [Compress and Encrypt](https://code.kx.com/pykx/user-guide/advanced/compress-encrypt.html) - [Import q Functions](https://code.kx.com/pykx/user-guide/advanced/context_interface.html) - [Remote Functions](https://code.kx.com/pykx/user-guide/advanced/remote-functions.html) - [Threading](https://code.kx.com/pykx/user-guide/advanced/threading.html) - [Subprocess Execution](https://code.kx.com/pykx/user-guide/advanced/subprocess.html): Run PyKX in an isolated subprocess. *(New)* - [License Management](https://code.kx.com/pykx/user-guide/advanced/license.html) *(New)* - [Performance Tuning](https://code.kx.com/pykx/user-guide/advanced/performance.html) *(New)* - [Serialization Details](https://code.kx.com/pykx/user-guide/advanced/serialization.html) *(New)* - [Pandas-like API](https://code.kx.com/pykx/user-guide/advanced/Pandas_API.html) - [NumPy Integration](https://code.kx.com/pykx/user-guide/advanced/numpy.html) - [Streamlit Integration](https://code.kx.com/pykx/user-guide/advanced/streamlit.html) ### Beta Features - [Beta Features Overview](https://code.kx.com/pykx/beta-features/index.html) *(New)* - [PyTorch Integration](https://code.kx.com/pykx/beta-features/torch.html): Experimental PyTorch tensor interop. *(New)* ### PyKX Under q - [Introduction](https://code.kx.com/pykx/pykx-under-q/intro.html): Embed Python inside a q process. - [API](https://code.kx.com/pykx/pykx-under-q/api.html) *(New)* - [Upgrade Guide](https://code.kx.com/pykx/pykx-under-q/upgrade.html) *(New)* ### API Reference - [q Functions and Operators](https://code.kx.com/pykx/api/pykx-execution/q.html) - [Execution Classes](https://code.kx.com/pykx/api/pykx-execution/embedded_q.html) - [Console API](https://code.kx.com/pykx/api/pykx-execution/console.html) *(New)* - [Context Class (ctx)](https://code.kx.com/pykx/api/pykx-execution/ctx.html) *(New)* - [IPC API](https://code.kx.com/pykx/api/ipc.html): SyncQConnection, AsyncQConnection. - [Database Management API](https://code.kx.com/pykx/api/db.html) - [Real-time Capture API](https://code.kx.com/pykx/api/tick.html) - [Query API](https://code.kx.com/pykx/api/query.html) - [File I/O API](https://code.kx.com/pykx/api/pykx-save-load/fileio.html) - [Columns API](https://code.kx.com/pykx/api/columns.html) *(New)* - [Compress API](https://code.kx.com/pykx/api/compress.html) *(New)* - [Module Reimporting](https://code.kx.com/pykx/api/reimporting.html) *(New)* - [Module API](https://code.kx.com/pykx/api/module.html) *(New)* - [Data Generation](https://code.kx.com/pykx/api/random.html) - [Schema Generation](https://code.kx.com/pykx/api/schema.html) - [Streamlit API](https://code.kx.com/pykx/api/streamlit.html) - [Serialize/Deserialize API](https://code.kx.com/pykx/api/serialize.html) - [Remote Execution API](https://code.kx.com/pykx/api/remote.html) - [System Command Wrappers](https://code.kx.com/pykx/api/system.html) - [Utility Functions](https://code.kx.com/pykx/api/util.html) - [License Management API](https://code.kx.com/pykx/api/license.html) - [Python to PyKX Conversion (toq)](https://code.kx.com/pykx/api/pykx-q-data/toq.html) - [Wrappers](https://code.kx.com/pykx/api/pykx-q-data/wrappers.html) - [PyKX to Python Conversions](https://code.kx.com/pykx/api/pykx-q-data/type_conversions.html) - [Register Custom Conversions](https://code.kx.com/pykx/api/pykx-q-data/register.html) *(New)* - [Exceptions](https://code.kx.com/pykx/api/exceptions.html) ### Examples & Tutorials - [Interface Overview](https://code.kx.com/pykx/examples/interface-overview.html) - [Charting](https://code.kx.com/pykx/examples/charting.html) - [Database Management](https://code.kx.com/pykx/examples/db-management.html) - [Jupyter Integration](https://code.kx.com/pykx/examples/jupyter-integration.html) - [Asynchronous Queries](https://code.kx.com/pykx/examples/AsynchronousQueries/async_querying.html) - [Compress and Encrypt Walkthrough](https://code.kx.com/pykx/examples/compress_and_encrypt/readme.html) - [IPC Examples](https://code.kx.com/pykx/examples/ipc/index.html) - [Server Example](https://code.kx.com/pykx/examples/server/server.html) - [Streaming Example](https://code.kx.com/pykx/examples/streaming/index.html) - [Subscriber Example](https://code.kx.com/pykx/examples/subscriber/readme.html) - [Threaded Execution](https://code.kx.com/pykx/examples/threaded_execution/threading.html) ### Releases & Help - [Changelog](https://code.kx.com/pykx/release-notes/changelog.html) - [Under q Changelog](https://code.kx.com/pykx/release-notes/underq-changelog.html) *(New)* - [Deprecations](https://code.kx.com/pykx/release-notes/deprecations.html) - [3.x to 4.x Upgrade Guide](https://code.kx.com/pykx/upgrades/3040.html) *(New)* - [2.x to 3.x Upgrade Guide](https://code.kx.com/pykx/upgrades/2030.html) - [Glossary](https://code.kx.com/pykx/extras/glossary.html) *(New)* - [FAQ](https://code.kx.com/pykx/help/faq.html) - [Troubleshooting](https://code.kx.com/pykx/help/troubleshooting.html) - [Known Issues](https://code.kx.com/pykx/help/issues.html) - [Support](https://code.kx.com/pykx/help/support.html) - [Contributors](https://code.kx.com/pykx/contributors.html) - [License](https://code.kx.com/pykx/license.html) - [Blogs](https://code.kx.com/pykx/blogs.html) --- ## KDB.AI KDB.AI is a knowledge-based vector database and search engine for building scalable AI applications using real-time data. ### Getting Started - [Overview](https://code.kx.com/kdbai/latest/index.html) - [Prerequisites](https://code.kx.com/kdbai/latest/gettingStarted/pre-requisites.html) - [Server Setup](https://code.kx.com/kdbai/latest/gettingStarted/kdb-ai-server-setup.html) - [Self-Managed Deployment](https://code.kx.com/kdbai/latest/gettingStarted/self-managed.html): Run KDB.AI Server in your own environment. *(New)* - [Quickstart](https://code.kx.com/kdbai/latest/gettingStarted/quickstart.html) - [Versioning and Upgrade](https://code.kx.com/kdbai/latest/versioning.html) ### Core Concepts - [Authentication and Authorization](https://code.kx.com/kdbai/latest/reference/authentication.html): Static authentication and OAuth 2.0 / JWT access control. *(New)* - [Database](https://code.kx.com/kdbai/latest/reference/database.html) - [Tables](https://code.kx.com/kdbai/latest/reference/table.html) - [Data Types](https://code.kx.com/kdbai/latest/reference/supported-types.html) - [Indexes](https://code.kx.com/kdbai/latest/reference/index.html) - [Similarity Metrics](https://code.kx.com/kdbai/latest/reference/metrics.html) - [Hybrid Search](https://code.kx.com/kdbai/latest/reference/hybrid.html) - [Transformed TSS](https://code.kx.com/kdbai/latest/reference/transformed-tss.html) - [Non-Transformed TSS](https://code.kx.com/kdbai/latest/reference/non-transformed-tss.html) - [Dynamic Time Warping](https://code.kx.com/kdbai/latest/reference/dynamic-time-warping.html) - [Filters](https://code.kx.com/kdbai/latest/reference/filters.html) - [Partitioning](https://code.kx.com/kdbai/latest/reference/partition.html) - [Reranking](https://code.kx.com/kdbai/latest/reference/reranking.html) - [Parallel Processing](https://code.kx.com/kdbai/latest/reference/multithreading.html) - [Authentication & Authorization](https://code.kx.com/kdbai/latest/reference/authentication.html) - [Glossary](https://code.kx.com/kdbai/latest/reference/glossary.html) ### How-To Guides - [Use Databases](https://code.kx.com/kdbai/latest/use/database.html) - [Manage Tables](https://code.kx.com/kdbai/latest/use/manage-tables.html) - [Ingest Data](https://code.kx.com/kdbai/latest/use/ingestion.html) - [Query Data](https://code.kx.com/kdbai/latest/use/query.html) - [Delete Data](https://code.kx.com/kdbai/latest/use/delete-data.html) - [Use Indexes](https://code.kx.com/kdbai/latest/use/supported-indexes.html) - [Similarity Search](https://code.kx.com/kdbai/latest/use/search.html) - [Hybrid Search](https://code.kx.com/kdbai/latest/use/hybrid-search.html) - [Transformed TSS Search](https://code.kx.com/kdbai/latest/use/transformed-tss.html) - [Non-Transformed TSS Search](https://code.kx.com/kdbai/latest/use/non-transformed-tss.html) - [DTW Search](https://code.kx.com/kdbai/latest/use/dynamic-time-warping-dtw.html) - [Customize Filters](https://code.kx.com/kdbai/latest/use/filter.html) - [Fuzzy Filters](https://code.kx.com/kdbai/latest/use/fuzzy-filters.html): Approximate string matching. *(New)* - [Partition Data](https://code.kx.com/kdbai/latest/use/partitioning.html) - [Rerank Results](https://code.kx.com/kdbai/latest/use/rerank.html) - [Get System Usage Info](https://code.kx.com/kdbai/latest/use/get-system-usage-info.html) *(New)* - [Static Authentication Setup](https://code.kx.com/kdbai/latest/use/set-up-static-authentication.html) - [OAuth 2.0 Setup](https://code.kx.com/kdbai/latest/use/set-up-oauth2-authentication.html) - [Microsoft Entra ID OAuth Setup](https://code.kx.com/kdbai/latest/use/entra_id_oauth_setup_guide.html) *(New)* ### API Reference - [Python API](https://code.kx.com/kdbai/latest/reference/python-client.html) - [q API](https://code.kx.com/kdbai/latest/reference/qAPI.html) - [REST API](https://code.kx.com/kdbai/latest/reference/rest-api.html) - [Naming and Reserved Words](https://code.kx.com/kdbai/latest/reference/naming-convention-reserved-words.html) ### Integrations - [All Integrations](https://code.kx.com/kdbai/latest/integrations/allintegrations.html) - [kdb+ Integration](https://code.kx.com/kdbai/latest/integrations/kdb.html) - [OpenAI Integration](https://code.kx.com/kdbai/latest/integrations/openai.html) - [LangChain Integration](https://code.kx.com/kdbai/latest/integrations/langchain.html) - [LlamaIndex Integration](https://code.kx.com/kdbai/latest/integrations/llamaindex.html) - [Vector IO Integration](https://code.kx.com/kdbai/latest/integrations/vector-io.html) - [Azure AI Integration](https://code.kx.com/kdbai/latest/integrations/azureml.html) - [Azure AI Upgrade Guide](https://code.kx.com/kdbai/latest/integrations/azureml-upgrade.html) *(New)* - [Hugging Face Integration](https://code.kx.com/kdbai/latest/integrations/hugging-face.html) - [Unstructured.io Integration](https://code.kx.com/kdbai/latest/integrations/unstructured-io.html) - [NVIDIA cuVS / CAGRA Integration](https://code.kx.com/kdbai/latest/integrations/nvidia-cuvs-cagra.html): GPU-accelerated vector search. *(New)* - [MCP Server](https://code.kx.com/kdbai/latest/integrations/mcp-server.html) - [GitHub Samples](https://github.com/KxSystems/kdbai-samples/) ### Releases & Support - [Latest Release Notes](https://code.kx.com/kdbai/latest/releaseNotes/release-notes-latest.html) - [Previous Release Notes](https://code.kx.com/kdbai/latest/releaseNotes/release-notes-previous.html) - [Known Issues](https://code.kx.com/kdbai/latest/support/known-issues.html) - [FAQs and Troubleshooting](https://code.kx.com/kdbai/latest/support/FAQ-troubleshooting.html) --- ## kdb Insights SDK (v1.19) kdb Insights SDK is a cloud-native, SQL-enabled kdb platform composed of kdb Insights Core, Stream Processor, Database microservice, and Reliable Transport. Full PyKX support is included. 1.19 is the current published version; 1.20 exists only as a draft tree. ### kdb Insights Core - [Core Overview](https://code.kx.com/insights/1.19/core/index.html): Cloud-enabled kdb+ with SQL, object storage, packaging, logging, and REST. - [Install Core](https://code.kx.com/insights/1.19/core/install.html) - [SQL Overview](https://code.kx.com/insights/1.19/core/sql.html) - [SQL Operators](https://code.kx.com/insights/1.19/core/sql/operators.html) - [SQL Functions](https://code.kx.com/insights/1.19/core/sql/functions.html) - [SQL Select Statements](https://code.kx.com/insights/1.19/core/sql/select.html) - [ANSI SQL Compliance](https://code.kx.com/insights/1.19/core/sql/sql-compliance.html) - [Postgres SQL Interface (pgwire)](https://code.kx.com/insights/1.19/core/pgwire.html) - [Object Storage Overview](https://code.kx.com/insights/1.19/core/objstor/main.html) - [REST Client (kurl)](https://code.kx.com/insights/1.19/core/kurl/kurl.html) - [REST Server](https://code.kx.com/insights/1.19/core/rest-server/rest-server.html) - [Google BigQuery Integration](https://code.kx.com/insights/1.19/core/big-query/intro.html) - [Packaging (qpacker)](https://code.kx.com/insights/1.19/core/qpacker/qpacker.html) - [Logging (qlog)](https://code.kx.com/insights/1.19/core/qlog/overview.html) - [Core Release Notes](https://code.kx.com/insights/1.19/core/release-notes/latest.html) ### Database Microservice - [Database Overview](https://code.kx.com/insights/1.19/microservices/database/index.html) - [Data Configuration Overview](https://code.kx.com/insights/1.19/microservices/database/configuration/index.html) - [Assembly: Schema](https://code.kx.com/insights/1.19/microservices/database/configuration/assembly/schema.html) - [Assembly: Storage](https://code.kx.com/insights/1.19/microservices/database/configuration/assembly/storage.html) - [User Defined Analytics (UDAs)](https://code.kx.com/insights/1.19/microservices/database/configuration/uda/uda-overview-introduction.html) - [Storage Tiering](https://code.kx.com/insights/1.19/microservices/database/storage/tiers.html) - [Object Storage](https://code.kx.com/insights/1.19/microservices/database/storage/object-storage.html) - [Backup and Restore](https://code.kx.com/insights/1.19/microservices/database/storage/backup.html) - [Delete Rows](https://code.kx.com/insights/1.19/microservices/database/storage/delete.html) - [Initial Import](https://code.kx.com/insights/1.19/microservices/database/import/initial-import.html) - [Batch Ingest](https://code.kx.com/insights/1.19/microservices/database/import/batch-ingest.html) - [Data Query Overview](https://code.kx.com/insights/1.19/microservices/database/query/index.html) - [Query Methods](https://code.kx.com/insights/1.19/microservices/database/query/query-methods.html) - [REST vs QIPC](https://code.kx.com/insights/1.19/microservices/database/query/rest-vs-qipc.html) - [SQL Querying](https://code.kx.com/insights/1.19/microservices/database/query/sql.html) - [Queuing, Retries, Timeouts](https://code.kx.com/insights/1.19/microservices/database/query/queueing.html) - [Query Scaling](https://code.kx.com/insights/1.19/microservices/database/configuration/advanced/query-scaling.html) - [Deploy: Docker](https://code.kx.com/insights/1.19/microservices/database/deploy/docker.html) - [Deploy: Kubernetes](https://code.kx.com/insights/1.19/microservices/database/deploy/kubernetes/database-rt.html) ### Stream Processor - [Stream Processor Overview](https://code.kx.com/insights/1.19/microservices/stream-processor/index.html) - [Writing Pipelines](https://code.kx.com/insights/1.19/microservices/stream-processor/writing.html) - [Running Pipelines](https://code.kx.com/insights/1.19/microservices/stream-processor/running.html) - [Configuration](https://code.kx.com/insights/1.19/microservices/stream-processor/configuration.html) - [Kafka Ingestion](https://code.kx.com/insights/1.19/microservices/stream-processor/examples/kafka/index.html) - [Batch S3 Ingestion](https://code.kx.com/insights/1.19/microservices/stream-processor/examples/batch-s3-ingest.html) - [Stateful Operators](https://code.kx.com/insights/1.19/microservices/stream-processor/examples/stateful-operators.html) - [Windowing on Event Time](https://code.kx.com/insights/1.19/microservices/stream-processor/examples/window-sliding.html) - [Checkpoints and Recovery](https://code.kx.com/insights/1.19/microservices/stream-processor/concepts/checkpoints-and-recovery.html) - [Scaling](https://code.kx.com/insights/1.19/microservices/stream-processor/concepts/scaling.html) - [Machine Learning](https://code.kx.com/insights/1.19/microservices/machine-learning/index.html) ### Reliable Transport - [RT Overview](https://code.kx.com/insights/1.19/microservices/rt/index.html): Guaranteed message delivery. - [Publishers](https://code.kx.com/insights/1.19/microservices/rt/publishers.html) - [Subscribers](https://code.kx.com/insights/1.19/microservices/rt/subscribers.html) - [C SDK](https://code.kx.com/insights/1.19/microservices/rt/sdks/c-sdk.html) - [Java SDK](https://code.kx.com/insights/1.19/microservices/rt/sdks/java-sdk.html) - [Python SDK](https://code.kx.com/insights/1.19/microservices/rt/sdks/python-sdk.html) - [q SDK (rt.qpk)](https://code.kx.com/insights/1.19/microservices/rt/sdks/rt-qpk.html) - [C# SDK](https://code.kx.com/insights/1.19/microservices/rt/sdks/csharp-sdk.html) - [RT Configuration](https://code.kx.com/insights/1.19/microservices/rt/configuration.html) - [RT Monitoring](https://code.kx.com/insights/1.19/microservices/rt/monitoring.html) ### APIs - [APIs Overview](https://code.kx.com/insights/1.19/api/index.html) - [Database Query APIs: Get Data](https://code.kx.com/insights/1.19/api/database/query/get-data.html) - [Database Query API: QSQL](https://code.kx.com/insights/1.19/api/database/query/qsql.html) - [Database Query API: SQL](https://code.kx.com/insights/1.19/api/database/query/sql.html) - [Database REST API Overview](https://code.kx.com/insights/1.19/api/database/rest/index.html) - [Stream Processor API](https://code.kx.com/insights/1.19/api/stream-processor/index.html) - [Stream Processor Operators](https://code.kx.com/insights/1.19/api/stream-processor/operators.html) - [Stream Processor Readers](https://code.kx.com/insights/1.19/api/stream-processor/readers.html) - [Stream Processor Writers](https://code.kx.com/insights/1.19/api/stream-processor/writers.html) - [kdb Insights Python API](https://code.kx.com/insights/1.19/api/python/index.html): Publish, subscribe, and query from Python. Replaces the former /api/kxi-python/ pages, which no longer exist. - [WebSocket Streaming API](https://code.kx.com/insights/1.19/api/streaming/web-socket/overview.html) - [ML Analytics API](https://code.kx.com/insights/1.19/api/machine-learning/q/analytics/api/index.html) - [ML Model Registry](https://code.kx.com/insights/1.19/api/machine-learning/q/registry/index.html) - [SDK Release Notes](https://code.kx.com/insights/1.19/microservices/release-notes/latest.html) --- ## kdb Insights Enterprise (v1.19) kdb Insights Enterprise is a fully managed deployment of kdb Insights on Kubernetes (managed cloud or on-prem), with a web UI, CLI, packaging system, and enterprise security. 1.19 is the current published version; 1.20 exists only as a draft tree. ### Getting Started - [Enterprise Home](https://code.kx.com/insights/1.19/enterprise/index.html) - [About kdb Insights Enterprise](https://code.kx.com/insights/1.19/enterprise/about/overview.html) - [Interfaces Overview](https://code.kx.com/insights/1.19/enterprise/about/interfaces.html) - [Deployment Options](https://code.kx.com/insights/1.19/enterprise/getting-started/index.html) - [Architecture](https://code.kx.com/insights/1.19/enterprise/architecture.html) - [7-day Free Trial](https://code.kx.com/insights/1.19/enterprise/free-trial/index.html) - [Free Trial Tour](https://code.kx.com/insights/1.19/enterprise/free-trial/tour.html) ### Deployment - [Deploy on GCP (Terraform)](https://code.kx.com/insights/1.19/enterprise/infrastructure/standalone/kxi-terraform-gcp.html) - [Deploy on AWS (Terraform)](https://code.kx.com/insights/1.19/enterprise/infrastructure/standalone/kxi-terraform-aws.html) - [Deploy on Azure (Terraform)](https://code.kx.com/insights/1.19/enterprise/infrastructure/standalone/kxi-terraform-azure.html) - [On-Prem K8s Prerequisites](https://code.kx.com/insights/1.19/enterprise/onprem/prerequisites-k8s.html) - [OpenShift On-Prem](https://code.kx.com/insights/1.19/enterprise/onprem/prerequisites.html) - [Installing Enterprise](https://code.kx.com/insights/1.19/enterprise/installation/insights.html) - [Upgrading Enterprise](https://code.kx.com/insights/1.19/enterprise/installation/upgrading.html) - [Air-gapped Environments](https://code.kx.com/insights/1.19/enterprise/installation/air-gapped-environments.html) ### Web Interface - [Web Interface Guide](https://code.kx.com/insights/1.19/enterprise/user-interface/index.html) - [Databases (UI)](https://code.kx.com/insights/1.19/enterprise/database/configuration/ui/createdatabase.html) - [Pipeline Import Wizard](https://code.kx.com/insights/1.19/enterprise/ingest/wizard.html) - [Pipeline Operators](https://code.kx.com/insights/1.19/enterprise/ingest/pipeline/operators/index.html) - [Readers](https://code.kx.com/insights/1.19/enterprise/ingest/pipeline/operators/readers.html) - [Decoders](https://code.kx.com/insights/1.19/enterprise/ingest/pipeline/operators/decoders.html) - [Writers](https://code.kx.com/insights/1.19/enterprise/ingest/pipeline/operators/writers.html) - [Query Window](https://code.kx.com/insights/1.19/enterprise/analysis/index.html) - [Scratchpad Development](https://code.kx.com/insights/1.19/enterprise/analysis/scratchpad-dev.html): q and Python scratchpads on one page. *(New — supersedes the separate q-dev and python-dev pages, which are still published under 1.19)* - [Scratchpad (q)](https://code.kx.com/insights/1.19/enterprise/analysis/q-dev.html) - [Scratchpad (Python)](https://code.kx.com/insights/1.19/enterprise/analysis/python-dev.html) - [Views and Visualization](https://code.kx.com/insights/1.19/enterprise/visualization/index.html) ### Configuration & Security - [Install Configuration](https://code.kx.com/insights/1.19/enterprise/configuration/index.html) - [User Access](https://code.kx.com/insights/1.19/enterprise/configuration/security.html) - [Authentication](https://code.kx.com/insights/1.19/enterprise/security/authentication.html) - [Manage Users](https://code.kx.com/insights/1.19/enterprise/security/managing-users.html) - [Manage Groups](https://code.kx.com/insights/1.19/enterprise/security/managing-groups.html) - [Encryption in Transit](https://code.kx.com/insights/1.19/enterprise/security/encryption-in-transit.html) - [Encryption at Rest](https://code.kx.com/insights/1.19/enterprise/security/encryption-at-rest.html) - [Entitlements](https://code.kx.com/insights/1.19/enterprise/entitlements/index.html) - [Data Entitlements](https://code.kx.com/insights/1.19/enterprise/entitlements/data-entitlements.html) - [Row-Level Entitlements](https://code.kx.com/insights/1.19/enterprise/entitlements/row-level-entitlements.html) - [Microsoft Entra ID Integration](https://code.kx.com/insights/1.19/enterprise/azure-marketplace/azure-active-directory.html) ### Packaging - [Package Overview](https://code.kx.com/insights/1.19/enterprise/packaging/index.html) - [Create Package](https://code.kx.com/insights/1.19/enterprise/packaging/package-create.html) - [Deploy Package](https://code.kx.com/insights/1.19/enterprise/packaging/package-deploy.html) - [Upload Package](https://code.kx.com/insights/1.19/enterprise/packaging/package-upload.html) - [Convert Assembly to Package](https://code.kx.com/insights/1.19/enterprise/packaging/package-convert.html) ### Query & Data - [Query Overview](https://code.kx.com/insights/1.19/enterprise/database/query/index.html) - [Query Methods](https://code.kx.com/insights/1.19/enterprise/database/query/query-methods.html) - [Query APIs](https://code.kx.com/insights/1.19/enterprise/analysis/queryapi.html) - [SQL Query Support](https://code.kx.com/insights/1.19/enterprise/database/query/sql.html) - [Storage Manager Troubleshooting](https://code.kx.com/insights/1.19/enterprise/database/storage/troubleshooting.html): Diagnose storage manager issues. *(New)* - [Query Best Practices](https://code.kx.com/insights/1.19/enterprise/database/best-practices/query.html): Writing efficient queries against the database. *(New)* - [Power BI Connector](https://code.kx.com/insights/1.19/enterprise/integrations/powerbi/powerbi-import.html) - [Ingest and Transform Overview](https://code.kx.com/insights/1.19/enterprise/ingest/index.html) - [Kafka Ingest](https://code.kx.com/insights/1.19/enterprise/ingest/examples/kafka/ingest.html) - [S3 Batch Ingest](https://code.kx.com/insights/1.19/enterprise/ingest/examples/s3/index.html) - [KDB-X Workloads](https://code.kx.com/insights/1.19/enterprise/workloads/index.html) - [Develop with KDB-X Workloads](https://code.kx.com/insights/1.19/enterprise/workloads/development.html) ### Monitoring & Operations - [Monitoring Overview](https://code.kx.com/insights/1.19/enterprise/monitoring/index.html) - [Deploy Prometheus](https://code.kx.com/insights/1.19/enterprise/monitoring/metrics.html) - [Grafana Reference](https://code.kx.com/insights/1.19/enterprise/monitoring/dashboards-reference.html) - [Alerts Reference](https://code.kx.com/insights/1.19/enterprise/monitoring/alerts-reference.html) - [Backup and Restore](https://code.kx.com/insights/1.19/enterprise/cli/backup-and-restore.html) ### Reference & Releases - [CLI Reference](https://code.kx.com/insights/1.19/enterprise/kxi-cli/cli.html) - [Glossary](https://code.kx.com/insights/1.19/enterprise/glossary.html) - [Enterprise Release Notes (Latest)](https://code.kx.com/insights/1.19/enterprise/release-notes/latest.html) - [Enterprise Release Notes (Previous)](https://code.kx.com/insights/1.19/enterprise/release-notes/previous.html) - [Troubleshooting](https://code.kx.com/insights/1.19/enterprise/troubleshooting/diagnostics.html) --- ## KX Dashboards KX Dashboards is a visualization and dashboarding platform for building interactive, real-time applications over kdb+, kdb Insights, and other data sources. The product has its own versioned site under /dashboards/; 2.23 is the current release. ### Getting Started - [Welcome](https://code.kx.com/dashboards/welcome.html) - [Install](https://code.kx.com/dashboards/get-started/install.html) - [Deploy](https://code.kx.com/dashboards/get-started/deploy.html) - [Docker Deploy](https://code.kx.com/dashboards/get-started/docker-deploy.html) - [Kubernetes Deploy](https://code.kx.com/dashboards/get-started/kubernetes-deploy.html) - [Open a Dashboard](https://code.kx.com/dashboards/get-started/open.html) ### Learn - [About](https://code.kx.com/dashboards/learn/about.html) - [Workspace](https://code.kx.com/dashboards/learn/workspace.html) - [Components Introduction](https://code.kx.com/dashboards/learn/components-intro.html) - [Data Sources](https://code.kx.com/dashboards/learn/datasources-learn.html) - [Actions](https://code.kx.com/dashboards/learn/actions-learn.html) - [Chat Agent](https://code.kx.com/dashboards/learn/chat-agent-learn.html) - [Templates](https://code.kx.com/dashboards/learn/templates-learn.html) - [Viewstates](https://code.kx.com/dashboards/learn/viewstates-learn.html) - [Demos](https://code.kx.com/dashboards/learn/demos.html) ### How-To Guides - [Data Sources](https://code.kx.com/dashboards/how-to/datasources.html) - [Actions](https://code.kx.com/dashboards/how-to/action.html) - [Chat Agent](https://code.kx.com/dashboards/how-to/chat-agent.html) - [Global Properties](https://code.kx.com/dashboards/how-to/global-properties.html) - [Highlight Rules](https://code.kx.com/dashboards/how-to/highlightrules.html) - [Hierarchical Rules](https://code.kx.com/dashboards/how-to/hierarchical-rules.html) - [Integrate kdb Insights SDK](https://code.kx.com/dashboards/how-to/integrate-insights-sdk.html) - [Performance Monitoring](https://code.kx.com/dashboards/how-to/performance-monitoring.html) - [Publish](https://code.kx.com/dashboards/how-to/publish.html) - [Templates](https://code.kx.com/dashboards/how-to/template.html) - [Viewstate Parameters](https://code.kx.com/dashboards/how-to/viewstateparameters.html) - [Themes: Logo](https://code.kx.com/dashboards/how-to/themes/logochange.html) - [Themes: Palette](https://code.kx.com/dashboards/how-to/themes/palette.html) - [Themes: Style](https://code.kx.com/dashboards/how-to/themes/style.html) ### Components (selected) - [About Components](https://code.kx.com/dashboards/how-to/components/about-components.html) - [Data Grid](https://code.kx.com/dashboards/how-to/components/datagrid.html) - [Chart GL](https://code.kx.com/dashboards/how-to/components/chartgl.html) - [Financial Chart](https://code.kx.com/dashboards/how-to/components/financialchart.html) - [Map](https://code.kx.com/dashboards/how-to/components/map.html) - [Graph](https://code.kx.com/dashboards/how-to/components/graph.html) - [Pivot Grid](https://code.kx.com/dashboards/how-to/components/pivotgrid.html) - [Form Builder](https://code.kx.com/dashboards/how-to/components/formbuilder.html) - [Visual Query Builder](https://code.kx.com/dashboards/how-to/components/visualquerybuilder.html) - [Code Editor](https://code.kx.com/dashboards/how-to/components/codeeditor.html) - (full component list: 3dchart, accordion, actiontracker, analystvisual, bipartite, bitmap, blobdownload, breadcrumbs, button, canvascharts, configmanager, contour, datafilter, dataform, datepicker, daterangepicker, dropdownlist, editablelist, flexpanel, gauge, layout, navigationmenu, offlinemaps, overlaypanel, pager, piechart, playback, quadmap, radarchart, rangeslider, reportmanager, sankey, selectioncontrols, serverstatus, sunburst, tabcontrol, text, textinput, textspeech, trade, treemap, treeview, upload, vegachart, video) ### Reference - [API Introduction](https://code.kx.com/dashboards/reference/api/apiintro.html) - [Basic API](https://code.kx.com/dashboards/reference/api/apibasic.html) - [Data Source API](https://code.kx.com/dashboards/reference/api/apidatasource.html) - [Deploy API](https://code.kx.com/dashboards/reference/api/apideploy.html) - [Viewstates API](https://code.kx.com/dashboards/reference/api/apiviewstates.html) - [Component Interface](https://code.kx.com/dashboards/reference/api/componentinterface.html) - [Messages](https://code.kx.com/dashboards/reference/api/messages.html) - [Template Helpers: Array/Comparison/Date/Math/Misc/Number/String/Util](https://code.kx.com/dashboards/reference/templates/helper-array.html) ### Releases & Support - [Latest Release Notes](https://code.kx.com/dashboards/releases/latest.html) - [Previous Release Notes](https://code.kx.com/dashboards/releases/previous.html) - [Upgrade Guide](https://code.kx.com/dashboards/releases/upgrade.html) - [EULA](https://code.kx.com/dashboards/support/eula.html) - [Support](https://code.kx.com/dashboards/support/support.html) --- ## KX Tools ### KX Developer - [KX Developer Overview](https://code.kx.com/developer/): Free graphical IDE for kdb+/q development. - [KX Developer Libraries](https://code.kx.com/developer/libraries/): Pre-installed libraries. ### KX Analyst - [KX Analyst Overview](https://code.kx.com/analyst/): Analytics and data exploration tool built on kdb+. ### VS Code Extension - [VS Code Extension](https://code.kx.com/vscode/index.html): kdb+ language support, query execution, and connection management for Visual Studio Code. - [Install](https://code.kx.com/vscode/get-started/install.html) - [KDB-X Install](https://code.kx.com/vscode/get-started/kdbx-install.html) - [REPL](https://code.kx.com/vscode/get-started/repl.html) - [KX Notebooks](https://code.kx.com/vscode/guides/kx-notebooks.html) - [Connections Overview](https://code.kx.com/vscode/guides/connections/introduction.html) - [Latest Release Notes](https://code.kx.com/vscode/release/latest.html) ### KX Delta Platform - [Delta Platform](https://code.kx.com/platform/): Event-driven streaming and analytics platform. - [Quick Start](https://code.kx.com/platform/quick_start/) - [KDB-X Modules on Delta Platform](https://code.kx.com/platform/latest/kdbx_modules.html): Parquet, Object Storage, SQL, Kurl, REST Server, GPU, and cuVS inside Platform kdb sessions. *(New)* - [PyKX Integration](https://code.kx.com/platform/pykx_integration/) - [Kafka Integration](https://code.kx.com/platform/kafka/) - [Latest Release (5.0.0)](https://code.kx.com/platform/release_5_0_0/) - [Security](https://code.kx.com/platform/security/) ### KX Refinery - [KX Refinery](https://code.kx.com/refinery/index.html): Data quality and transformation product. - [Architecture](https://code.kx.com/refinery/architecture.html) - [Admin Guide](https://code.kx.com/refinery/admin-guide/index.html) - [CLI Reference](https://code.kx.com/refinery/cli/index.html) - [Server API Guide](https://code.kx.com/refinery/server-api-guide/index.html) - [C# / Java Client APIs](https://code.kx.com/refinery/client-api-guides/c-sharp/index.html) - [Latest Release Notes (5.16.0)](https://code.kx.com/refinery/release-notes/5.16.0-release-notes.html) ### Accelerators - [Accelerators Overview](https://code.kx.com/accelerators/index.html): Pre-built domain accelerators for finance, manufacturing, and other industries. - [Getting Started](https://code.kx.com/accelerators/gettingStarted.html) - [Bloomberg BPIPE Accelerator](https://code.kx.com/accelerators/bbg-bpipe-introduction.html) - [Bloomberg Equities EA](https://code.kx.com/accelerators/bbg-eqea-introduction.html) - [ICE Equities EA](https://code.kx.com/accelerators/ice-eqea-introduction.html) - [ICE Fixed Income](https://code.kx.com/accelerators/ice-fi-introduction.html) - [ICE Order Book](https://code.kx.com/accelerators/ice-ob-introduction.html) - [FSI Library](https://code.kx.com/accelerators/fsi-intro.html) - [Release Notes Overview](https://code.kx.com/accelerators/release/release-notes-overview.html) --- ## Feedhandlers Standalone market-data feedhandler documentation, each deployable in Enterprise, Microservices, or Standalone modes. - [Feedhandlers Home](https://code.kx.com/feedhandlers/index.html): Index of all KX feed handlers. - [Bloomberg BPIPE Feedhandler](https://code.kx.com/feedhandlers/bbg-bpipe-fh/index.html) - [Bloomberg BPIPE Feedhandler: Enterprise Deployment](https://code.kx.com/feedhandlers/bbg-bpipe-fh/enterprise.html) - [Bloomberg BPIPE Feedhandler: Microservices Deployment](https://code.kx.com/feedhandlers/bbg-bpipe-fh/microservices.html) - [Bloomberg BPIPE Feedhandler: Standalone Deployment](https://code.kx.com/feedhandlers/bbg-bpipe-fh/standalone.html) - [Bloomberg BPIPE Feedhandler Release Notes](https://code.kx.com/feedhandlers/bbg-bpipe-fh/bpipe-release-notes.html) - [FIX Feedhandler](https://code.kx.com/feedhandlers/fix-feedhandler/index.html) - [FIX Feedhandler: Enterprise Deployment](https://code.kx.com/feedhandlers/fix-feedhandler/enterprise.html) - [FIX Feedhandler: Microservices Deployment](https://code.kx.com/feedhandlers/fix-feedhandler/microservices.html) - [FIX Feedhandler: Standalone Deployment](https://code.kx.com/feedhandlers/fix-feedhandler/standalone.html) - [FIX Feedhandler Release Notes](https://code.kx.com/feedhandlers/fix-feedhandler/fix-release-notes.html) - [ICE Consolidated Feedhandler](https://code.kx.com/feedhandlers/ice-consolidated-fh/index.html) - [ICE Consolidated Feedhandler: Enterprise Deployment](https://code.kx.com/feedhandlers/ice-consolidated-fh/enterprise.html) - [ICE Consolidated Feedhandler: Microservices Deployment](https://code.kx.com/feedhandlers/ice-consolidated-fh/microservices.html) - [ICE Consolidated Feedhandler: Standalone Deployment](https://code.kx.com/feedhandlers/ice-consolidated-fh/standalone.html) - [ICE Consolidated Feedhandler Release Notes](https://code.kx.com/feedhandlers/ice-consolidated-fh/ice-release-notes.html) --- ## Product Licensing *(Moved site)* Portfolio-wide licensing, product support, and product lifecycle content. This used to be published inside the kdb Insights docs under `/insights/licensing/`, where every release branch (1.18, 1.19, main) carried its own copy and the three had drifted apart. It is now a single **unversioned** site at `/licensing/`, so a licence term changes in one place. None of the content is Insights-specific: license installation covers six products, the usage restrictions are about KDB-X Community Edition, and the lifecycle table spans the whole portfolio. Old `/insights/licensing/*.html` and `/insights//licensing/*.html` URLs are superseded by the paths below. - [KX Licensing Overview](https://code.kx.com/licensing/index.html): License types (trial, commercial, proof-of-concept), the definition of production versus non-production use, and reporting requirements. All KX products require a license. - [License Installation](https://code.kx.com/licensing/installing.html): Per-product install instructions for KDB-X, kdb+, kdb Insights, kdb Insights Enterprise, PyKX, and KDB.AI. - [RAM Capacity Reporting](https://code.kx.com/licensing/ram.html): Requirements for self-managed customers to audit and report provisioned RAM, with example scripts for physical hosts, named VMs, Docker, Kubernetes, and FinSpace. - [Users Reporting](https://code.kx.com/licensing/users.html): How named users are counted in physical, virtual, and orchestrated environments. - [Cores Reporting](https://code.kx.com/licensing/cores.html): How licensed cores are counted on Unix, Windows, and macOS, and in Docker and Kubernetes, accounting for threads per core and cores per socket. - [Cores and RAM Fair Usage Policy](https://code.kx.com/licensing/core-ram-fair-usage.html): Fair usage limits for CPU cores and system RAM, and the distinction between system memory and GPU VRAM — GPU memory may supplement but never replace required system RAM. - [Usage Restrictions](https://code.kx.com/licensing/usage-restrictions.html): Per-product restrictions. KDB-X Community Edition is free for personal and commercial projects subject to end-user limits: 16GB RAM for q, a single instance, 4 secondary threads and 16 connections per process, and 24 CPU cores across all instances. - [Product Support](https://code.kx.com/licensing/product-support.html): Support routes for free-trial users (Developer Center, Academy, forum, Slack, GitHub) and for commercial licenses (KX Support Portal per product). - [Product Lifecycle](https://code.kx.com/licensing/product-lifecycle.html): How end-of-support dates are calculated. Semantic versioning throughout; 12 months of standard support from GA for most products, with kdb+, KDB-X Python, and PyKX on their own terms. --- ## Support & Community - [KX Academy / Learning Hub](https://learninghub.kx.com/) - [KX Support Portal](https://kx.com/software-support) - [KX Slack Community](https://kx.com/slack) - [KX Developer Center](https://developer.kx.com/) - [KX GitHub](https://github.com/KxSystems)