# Regatta ## Docs - [Client Library](https://docs.regatta.dev/drivers-and-clients/client-lib.md): The shared library that powers all Regatta drivers, providing the core API for communicating with your Regatta database. - [Connecting Applications to Regatta](https://docs.regatta.dev/drivers-and-clients/connecting-applications-to-regatta.md) - [Download Drivers & Clients](https://docs.regatta.dev/drivers-and-clients/download-drivers-and-clients.md) - [Install Your Java Client](https://docs.regatta.dev/drivers-and-clients/java/install-your-java-client.md) - [Run a Hibernate Application](https://docs.regatta.dev/drivers-and-clients/java/run-hibernate-application.md) - [Run a JDBC Application](https://docs.regatta.dev/drivers-and-clients/java/run-jdbc-application.md) - [Install Your Javascript Client](https://docs.regatta.dev/drivers-and-clients/javascript/install-your-javascript-client.md) - [Run a Node.js Application](https://docs.regatta.dev/drivers-and-clients/javascript/run-nodejs-application.md) - [Running a TypeORM Application](https://docs.regatta.dev/drivers-and-clients/javascript/run-typeorm-application.md) - [Install Your Python Client](https://docs.regatta.dev/drivers-and-clients/python/install-your-python-client.md) - [Run a Python Application](https://docs.regatta.dev/drivers-and-clients/python/run-python-application.md) - [Regatta CLI](https://docs.regatta.dev/drivers-and-clients/regatta-cli.md): A lightweight command-line tool for connecting to, managing, and querying your Regatta database clusters. - [Access the Cloud](https://docs.regatta.dev/getting-started/access-the-cloud.md) - [Creating a Cluster](https://docs.regatta.dev/getting-started/creating-a-cluster.md) - [Getting Started Using Regatta Cloud](https://docs.regatta.dev/getting-started/getting-started-using-regatta-cloud.md) - [Comparing Performance](https://docs.regatta.dev/getting-started/linear-scaling/comparing-performance/comparing-performance.md) - [MEDIUM Cluster](https://docs.regatta.dev/getting-started/linear-scaling/comparing-performance/medium-cluster.md) - [SMALL Cluster](https://docs.regatta.dev/getting-started/linear-scaling/comparing-performance/small-cluster.md) - [Creating Demo Clusters](https://docs.regatta.dev/getting-started/linear-scaling/creating-demo-environment/creating-demo-clusters.md) - [Creating the Demo Environment](https://docs.regatta.dev/getting-started/linear-scaling/creating-demo-environment/creating-demo-environment.md) - [Linear Scaling](https://docs.regatta.dev/getting-started/linear-scaling/linear-scaling.md) - [Create a Table](https://docs.regatta.dev/getting-started/regatta-basics/creating-a-table/create-a-table.md) - [Default Device Mapping](https://docs.regatta.dev/getting-started/regatta-basics/creating-a-table/default-device-mapping.md) - [Selected Device Mapping](https://docs.regatta.dev/getting-started/regatta-basics/creating-a-table/selected-device-mapping.md) - [Credentials](https://docs.regatta.dev/getting-started/regatta-basics/credentials.md) - [Delete Entry from Table](https://docs.regatta.dev/getting-started/regatta-basics/delete-entry-from-table.md) - [Drop Table](https://docs.regatta.dev/getting-started/regatta-basics/drop-table.md) - [Insert Values](https://docs.regatta.dev/getting-started/regatta-basics/insert-values.md) - [Select Values from Table](https://docs.regatta.dev/getting-started/regatta-basics/select-values-from-table.md) - [Update Entry](https://docs.regatta.dev/getting-started/regatta-basics/update-entry.md) - [Regatta Documentation](https://docs.regatta.dev/home.md): Limitless power and scale - [Backup](https://docs.regatta.dev/regatta-cloud/backup.md) - [Backup & Restore](https://docs.regatta.dev/regatta-cloud/database-backup-restore.md) - [Access the Cloud](https://docs.regatta.dev/regatta-cloud/regatta-cloud/access-the-cloud.md) - [Cluster IP](https://docs.regatta.dev/regatta-cloud/regatta-cloud/cluster-ip.md) - [Creating a Cluster](https://docs.regatta.dev/regatta-cloud/regatta-cloud/create-a-cluster.md) - [Delete Cluster](https://docs.regatta.dev/regatta-cloud/regatta-cloud/delete-cluster.md) - [Regatta Cloud](https://docs.regatta.dev/regatta-cloud/regatta-cloud/regatta-cloud.md) - [Restore](https://docs.regatta.dev/regatta-cloud/restore.md) - [Execution](https://docs.regatta.dev/self-hosted-deployment/collecting-data/execution.md) - [Installation](https://docs.regatta.dev/self-hosted-deployment/collecting-data/installation.md) - [Setup](https://docs.regatta.dev/self-hosted-deployment/collecting-data/setup.md) - [Configuration File](https://docs.regatta.dev/self-hosted-deployment/manual-deployment/configuration-file.md) - [Firewall](https://docs.regatta.dev/self-hosted-deployment/manual-deployment/firewall.md) - [Regatta Software Modules](https://docs.regatta.dev/self-hosted-deployment/manual-deployment/regatta-software-modules.md) - [Starting the System](https://docs.regatta.dev/self-hosted-deployment/manual-deployment/starting-the-system.md) - [User Setup](https://docs.regatta.dev/self-hosted-deployment/manual-deployment/user-setup.md) - [Prerequisites](https://docs.regatta.dev/self-hosted-deployment/prerequisites.md) - [Advanced Deployment Options](https://docs.regatta.dev/self-hosted-deployment/regatta-deployment-tool/advanced-deployment-options.md) - [Cluster Setup](https://docs.regatta.dev/self-hosted-deployment/regatta-deployment-tool/cluster-setup.md) - [Configuration](https://docs.regatta.dev/self-hosted-deployment/regatta-deployment-tool/configuration.md) - [Installation](https://docs.regatta.dev/self-hosted-deployment/regatta-deployment-tool/installation.md) - [Database Limitations](https://docs.regatta.dev/sql/appendices/database-limitations.md) - [Identifiers Limitations](https://docs.regatta.dev/sql/appendices/indentifiers-limitations.md) - [Reserved Words](https://docs.regatta.dev/sql/appendices/reserved-words.md) - [Boolean types](https://docs.regatta.dev/sql/data-types/boolean-types.md) - [Character types](https://docs.regatta.dev/sql/data-types/character-types.md) - [Date/Time types](https://docs.regatta.dev/sql/data-types/date-time-types.md) - [Introduction](https://docs.regatta.dev/sql/data-types/introduction.md) - [Approximate numeric data type](https://docs.regatta.dev/sql/data-types/numeric-types/approximate-numeric-data-type.md) - [Exact numeric data type](https://docs.regatta.dev/sql/data-types/numeric-types/exact-numeric-data-type.md) - [ROW IDs](https://docs.regatta.dev/sql/data-types/row-ids.md) - [Type Conversion](https://docs.regatta.dev/sql/data-types/type-conversion/type-conversion.md) - [Type conversion table](https://docs.regatta.dev/sql/data-types/type-conversion/type-conversion-table.md) - [ALTER TABLE](https://docs.regatta.dev/sql/ddl-commands/alter-table.md) - [CREATE TABLE](https://docs.regatta.dev/sql/ddl-commands/create-table.md) - [DROP TABLE](https://docs.regatta.dev/sql/ddl-commands/drop-table.md) - [DELETE](https://docs.regatta.dev/sql/dml-commands/delete.md) - [INSERT](https://docs.regatta.dev/sql/dml-commands/insert.md) - [UPDATE](https://docs.regatta.dev/sql/dml-commands/update.md) - [EXPLAIN](https://docs.regatta.dev/sql/dql/explain.md) - [SELECT](https://docs.regatta.dev/sql/dql/select.md) - [General notes](https://docs.regatta.dev/sql/hints/general-notes.md) - [Hint - Join direction](https://docs.regatta.dev/sql/hints/join-hints/join-direction.md) - [Hint - Join distribution method](https://docs.regatta.dev/sql/hints/join-hints/join-distribution.md) - [Join hints](https://docs.regatta.dev/sql/hints/join-hints/join-hints.md) - [Hint - Join method](https://docs.regatta.dev/sql/hints/join-hints/join-method.md) - [Hint - Cardinality](https://docs.regatta.dev/sql/hints/other-hints/hint-cardinality.md) - [Hint - INDEX](https://docs.regatta.dev/sql/hints/other-hints/hint-index.md) - [Other hints](https://docs.regatta.dev/sql/hints/other-hints/other-hints.md) - [Overview](https://docs.regatta.dev/sql/hints/overview.md) - [Hint for parallelism of distributed operations](https://docs.regatta.dev/sql/hints/parallelism/hints-for-parallelism.md) - [Hint - Join distribution](https://docs.regatta.dev/sql/hints/parallelism/join-distribution.md) - [Hint - Distributed Sorting](https://docs.regatta.dev/sql/hints/parallelism/sorting.md) - [Introduction](https://docs.regatta.dev/sql/introduction.md) - [ALTER USER](https://docs.regatta.dev/sql/managing-users/alter-user.md) - [CREATE USER](https://docs.regatta.dev/sql/managing-users/create-user.md) - [DROP USER](https://docs.regatta.dev/sql/managing-users/drop-user.md) - [Aggregate Functions](https://docs.regatta.dev/sql/sql-functions-and-operators/aggregate-functions/aggregate-functions.md) - [Examples](https://docs.regatta.dev/sql/sql-functions-and-operators/aggregate-functions/examples.md) - [Comparison Functions and Operators](https://docs.regatta.dev/sql/sql-functions-and-operators/comparison-function.md) - [CASE](https://docs.regatta.dev/sql/sql-functions-and-operators/conditional-expressions/case.md) - [CAST](https://docs.regatta.dev/sql/sql-functions-and-operators/convert-function/cast.md) - [Date and Time Formatting Functions](https://docs.regatta.dev/sql/sql-functions-and-operators/convert-function/date-time-format-functions.md) - [Date/Time Functions and Operators](https://docs.regatta.dev/sql/sql-functions-and-operators/date-time-functions-operators/date-time-functions-operators.md) - [Mathematical Functions](https://docs.regatta.dev/sql/sql-functions-and-operators/maths-functions-operators/maths-functions.md) - [Mathematical Functions and Operators](https://docs.regatta.dev/sql/sql-functions-and-operators/maths-functions-operators/maths-functions-operators.md) - [Mathematical Operators](https://docs.regatta.dev/sql/sql-functions-and-operators/maths-functions-operators/maths-operators.md) - [SQL Functions and Operators](https://docs.regatta.dev/sql/sql-functions-and-operators/sql-functions-and-operators.md) - [String Functions and Operators](https://docs.regatta.dev/sql/sql-functions-and-operators/string-functions-operators.md) - [IN and NOT IN](https://docs.regatta.dev/sql/sql-functions-and-operators/subquery-expressions/not-in/not-in.md) - [Subquery Expressions](https://docs.regatta.dev/sql/sql-functions-and-operators/subquery-expressions/subquery-expressions.md) - [SQL Syntax Conventions](https://docs.regatta.dev/sql/sql-syntax-convention.md) - [Database Catalog Data](https://docs.regatta.dev/sql/system-monitoring/database-catalog/database-catalog.md) - [SHOW COLUMNS](https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-columns.md) - [SHOW CONSTRAINTS](https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints.md) - [SHOW INDEXES](https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-index.md) - [SHOW INDEX DEVICES](https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-index-devices.md) - [SHOW TABLE DEVICES](https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-table-devices.md) - [SHOW TABLES](https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-tables.md) - [SHOW USERS](https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-users.md) - [Dynamic System Data](https://docs.regatta.dev/sql/system-monitoring/dynamic-system/dynamic-system.md) - [SHOW DATABASE METRICS](https://docs.regatta.dev/sql/system-monitoring/dynamic-system/show-database-metric.md) - [SHOW DEVICE METRICS](https://docs.regatta.dev/sql/system-monitoring/dynamic-system/show-device-metrics.md) - [SHOW METRIC DESCRIPTION](https://docs.regatta.dev/sql/system-monitoring/dynamic-system/show-metric-description.md) - [SHOW MODULE METRICS](https://docs.regatta.dev/sql/system-monitoring/dynamic-system/show-module-metrics.md) - [SHOW SYSTEM VIEWS](https://docs.regatta.dev/sql/system-monitoring/show-system-views.md) - [SHOW DEVICES](https://docs.regatta.dev/sql/system-monitoring/system-catalog/show-devices.md) - [SHOW MODULES](https://docs.regatta.dev/sql/system-monitoring/system-catalog/show-modules.md) - [SHOW NODES](https://docs.regatta.dev/sql/system-monitoring/system-catalog/show-nodes.md) - [The SYSTEM Command](https://docs.regatta.dev/sql/system-monitoring/system-management/system-command.md) - [SYSTEM SHUTDOWN](https://docs.regatta.dev/sql/system-monitoring/system-management/system-shutdown.md) - [SHOW SYSTEM STATE](https://docs.regatta.dev/sql/system-monitoring/system-management/system-state.md) - [Using System Monitoring Views](https://docs.regatta.dev/sql/system-monitoring/system-monitoring-views/system-monitoring-views.md) - [SET TRANSACTION](https://docs.regatta.dev/sql/tcl-commands/set-transaction.md) - [Transaction Control Language Commands](https://docs.regatta.dev/sql/tcl-commands/tcl-commands.md) - [Closing remarks](https://docs.regatta.dev/tuning-performance/closing-remarks.md) - [Distributing Indexes](https://docs.regatta.dev/tuning-performance/distributing-indexes.md) - [Distributing Tables](https://docs.regatta.dev/tuning-performance/distributing-tables.md) - [Data distribution of an index](https://docs.regatta.dev/tuning-performance/introduction/data-distribution-index.md) - [Data distribution of a table](https://docs.regatta.dev/tuning-performance/introduction/data-distribution-table.md) - [Introduction](https://docs.regatta.dev/tuning-performance/introduction/introduction.md) - [How a SQL statement executes](https://docs.regatta.dev/tuning-performance/introduction/sql-statement.md) - [Structure of a Regatta cluster](https://docs.regatta.dev/tuning-performance/introduction/structure-regatta-cluster.md) - [Other Index Consideration](https://docs.regatta.dev/tuning-performance/other-index.md) - [Other Limitations](https://docs.regatta.dev/tuning-performance/other-limitations.md) ## OpenAPI Specs - [openapi](https://docs.regatta.dev/api-reference/openapi.json)