# Oxla Developer Hub

## Docs

- [Key Concepts & Architecture](https://docs.oxla.com/1-introduction/1-1-key-concepts-archi/key-concept-and-architecture)
- [OLTP vs OLAP](https://docs.oxla.com/1-introduction/1-1-key-concepts-archi/oltp-olap)
- [Our Key Features](https://docs.oxla.com/1-introduction/1-1-key-concepts-archi/our-key-features)
- [Oxla vs. Other OLAP Solutions](https://docs.oxla.com/1-introduction/1-1-key-concepts-archi/oxla-vs-other-olap-solutions)
- [JAVA JDBC](https://docs.oxla.com/11-integrations/java-jdbc)
- [PHP PDO](https://docs.oxla.com/11-integrations/php-pdo)
- [Data Task Stability](https://docs.oxla.com/12-system-behaviour/data_task_stability)
- [Multi-node Deployment](https://docs.oxla.com/2-run-oxla/multi-node-deployment)
- [Run Oxla in 2 minutes](https://docs.oxla.com/2-run-oxla/run-oxla-in-2-minutes)
- [Run Oxla on Azure Blob Storage](https://docs.oxla.com/2-run-oxla/run-oxla-on-azure-blob-storage)
- [Run Oxla on Google Cloud Storage](https://docs.oxla.com/2-run-oxla/run-oxla-on-google-cloud-storage)
- [Run Oxla on S3](https://docs.oxla.com/2-run-oxla/run-oxla-on-s3)
- [Run Oxla via AWS](https://docs.oxla.com/2-run-oxla/run-oxla-via-aws)
- [SET/SHOW statement](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-10-set-show-statement/set-show)
- [COPY FROM](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-11-copy-from-statement/copy-from)
- [COPY FROM STDIN](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-11-copy-from-statement/copy-from-stdin)
- [COPY FROM with Delimiter](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-11-copy-from-statement/copy-from-with-delimiter)
- [COPY FROM with Endpoint](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-11-copy-from-statement/copy-from-with-endpoint)
- [COPY FROM with HEADER](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-11-copy-from-statement/copy-from-with-header)
- [COPY FROM with NULL](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-11-copy-from-statement/copy-from-with-null)
- [COPY TO](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-12-copy-to-statement/copy-to)
- [COPY TO STDOUT](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-12-copy-to-statement/copy-to-stdout)
- [COPY TO with Delimiter](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-12-copy-to-statement/copy-to-with-delimiter)
- [COPY TO with Endpoint](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-12-copy-to-statement/copy-to-with-endpoint)
- [COPY TO with HEADER](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-12-copy-to-statement/copy-to-with-header)
- [COPY TO with NULL](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-12-copy-to-statement/copy-to-with-null)
- [Create Table](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-2-create-table-statement/create-table)
- [Keywords](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-2-create-table-statement/keywords)
- [CREATE INDEX statement](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-3-create-index-statement/create-index)
- [SELECT statement](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-4-select-statement/select)
- [INSERT INTO statement](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-5-insert-into-statement/insert-into)
- [DROP statement](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-6-drop-statement/drop)
- [SHOW TABLES statement](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-7-show-tables-statement/show-tables)
- [DESCRIBE statement](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-8-describe-statement/describe)
- [SHOW NODES statement](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/3-1-9-show-nodes-statement/show-nodes)
- [Overview](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/sql-statement-overview)
- [SQL TABLE](https://docs.oxla.com/3-sql-reference/3-1-sql-statements/sql-table)
- [FROM](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-1-from/from)
- [JOIN](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-1-from/join)
- [LEFT JOIN](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-1-from/left-join)
- [OUTER JOIN](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-1-from/outer-join)
- [RIGHT JOIN](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-1-from/right-join)
- [WHERE](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-2-where/where)
- [GROUP BY](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-3-group-by/group-by)
- [HAVING](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-4-having/having)
- [ORDER BY](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-5-order-by/order-by)
- [LIMIT](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-6-limit/limit)
- [OFFSET](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-7-offset/offset)
- [EXCEPT](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-8-set-operations/except)
- [INTERSECT](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-8-set-operations/intersect)
- [Overview](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-8-set-operations/set-operations)
- [UNION](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/3-2-8-set-operations/union)
- [Overview](https://docs.oxla.com/3-sql-reference/3-2-sql-clauses/sql-clauses-overview)
- [Data Type Operators](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-1-operators/data-type-operator)
- [JSON Type](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-10-json-types/json-type)
- [Bool Type](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-2-bool-types/bool)
- [Date Type](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-3-date-types/date)
- [Timestamp Without Time Zone Type](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-4-timestamp-without-time-zone/timestamp-without-time-zone)
- [Timestamp with Time Zone](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-5-timestamp-with-time-zone/timestamp-with-time-zone)
- [Time Type](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-6-time-types/time)
- [Time Operators](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-6-time-types/time-operator)
- [Interval Type](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-7-interval-types/interval)
- [Text Type](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-8-text-types/text)
- [Numeric Data Type - Aliases](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-9-numeric-types/numeric-data-type-aliases)
- [Numeric Type](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/3-3-9-numeric-types/numeric-type)
- [Overview](https://docs.oxla.com/3-sql-reference/3-3-sql-data-types/data-types-overview)
- [ABS](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/abs)
- [CBRT](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/cbrt)
- [CEIL](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/ceil)
- [EXP](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/exp)
- [FLOOR](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/floor)
- [GREATEST](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/greatest)
- [LEAST](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/least)
- [LN](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/ln)
- [LOG](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/log)
- [Overview](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/numeric-functions)
- [POWER](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/power)
- [RANDOM](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/random)
- [ROUND](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/round)
- [SIGN](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/sign)
- [SIN](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/sin)
- [SQRT](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/sqrt)
- [TO_CHAR from Number](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-1-numeric-functions/to-char-from-number)
- [Overview](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-2-aggregation-functions/aggregation-functions)
- [AVG](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-2-aggregation-functions/avg)
- [BOOL_AND](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-2-aggregation-functions/bool-and)
- [BOOL_OR](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-2-aggregation-functions/bool-or)
- [COUNT](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-2-aggregation-functions/count)
- [FOR_MAX](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-2-aggregation-functions/for-max)
- [FOR_MIN](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-2-aggregation-functions/for-min)
- [MAX](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-2-aggregation-functions/max)
- [MIN](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-2-aggregation-functions/min)
- [SUM](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-2-aggregation-functions/sum)
- [CONCAT](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/concat)
- [ENDS_WITH](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/ends-with)
- [LENGTH](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/length)
- [LOWER](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/lower)
- [POSITION](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/position)
- [POSIX Regular Expressions](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/regexp-replace/posix-expression)
- [REGEXP_REPLACE](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/regexp-replace/regexp)
- [REPLACE](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/replace)
- [STARTS_WITH](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/starts-with)
- [Overview](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/string-functions)
- [STRPOS](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/strpos)
- [SUBSTR](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/substr)
- [SUBSTRING](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/substring)
- [UPPER](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-3-string-functions/upper)
- [CURRENT_TIMESTAMP](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/current-timestamp)
- [DATE_TRUNC](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/date-trunc)
- [EXTRACT](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/extract)
- [FORMAT_TIMESTAMP](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/format-timestamp)
- [Overview](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/timestamp-functions)
- [TIMESTAMP_MICROS](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/timestamp-micros)
- [TIMESTAMP_MILLIS](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/timestamp-millis)
- [TIMESTAMP_SECONDS](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/timestamp-second)
- [TIMESTAMP_TRUNC](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/timestamp-trunc)
- [TO_CHAR from Timestamp](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/to-char-from-timestamp)
- [TO_TIMESTAMP](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/to-timestamp)
- [UNIX_MICROS](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/unix-macros)
- [UNIX_MILLIS](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/unix-millis)
- [UNIX_SECONDS](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-4-timestamp-functions/unix-seconds)
- [IF Function](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-5-boolean-functions/boolean-functions)
- [IS DISTINCT FROM Operator](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-5-boolean-functions/is-distinct-from-operator)
- [IS NOT DISTINCT FROM Operator](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-5-boolean-functions/is-not-distinct-from-operator)
- [JSON_ARRAY_EXTRACT](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-6-json-functions/json-array-extract)
- [JSON_ARRAY_LENGTH](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-6-json-functions/json-array-length)
- [JSON_EXTRACT_PATH](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-6-json-functions/json-extract-path)
- [JSON_EXTRACT_PATH_TEXT](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-6-json-functions/json-extract-path-text)
- [Overview](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-6-json-functions/json-functions)
- [COALESCE](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-7-other-functions/coalesce)
- [CURRENT_DATABASE](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-7-other-functions/current-database)
- [CURRENT_SCHEMA](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-7-other-functions/current-schema)
- [HAS_SCHEMA_PRIVILEGE](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-7-other-functions/has-schema-privillege)
- [NULLIF](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-7-other-functions/nullif)
- [Overview](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-7-other-functions/other-function)
- [PG_GET_EXPR](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-7-other-functions/pg-get-expr)
- [PG_TOTAL_RELATION_SIZE](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-7-other-functions/pg-total-relation-size)
- [PG_TYPEOF](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/3-4-7-other-functions/pg-typeof)
- [Overview](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/sql-functions-overview)
- [Trigonometric Functions](https://docs.oxla.com/3-sql-reference/3-4-sql-functions/trigonometric-functions)
- [Comment Support](https://docs.oxla.com/3-sql-reference/comment-support)
- [Schema](https://docs.oxla.com/3-sql-reference/schema)
- [Overview](https://docs.oxla.com/3-sql-reference/sql-reference-overview)
- [Mutation - DELETE](https://docs.oxla.com/4-sql-mutations/del-mutation)
- [Overview](https://docs.oxla.com/4-sql-mutations/sql-mutations)
- [Mutation - UPDATE](https://docs.oxla.com/4-sql-mutations/update-mutations)
- [Error Handling](https://docs.oxla.com/5-error-handling/error-handling)
- [Differences Between Oxla vs. PostgreSQL](https://docs.oxla.com/6-oxla-vs-postgre/differences-between-oxla-vs-postgre)
- [Understanding Transactions](https://docs.oxla.com/7-transactions/understanding-transactions)
- [Public Metrics](https://docs.oxla.com/8-public-metrics/public-metrics)
- [Oxla Configuration File](https://docs.oxla.com/9-oxla-config-file/oxla-configuration-file)
- [Database Files Virtual Table](https://docs.oxla.com/database_files_virtual_table)
- [Handling Oxla Degraded State](https://docs.oxla.com/degraded_state)
- [How to Connect Oxla Cloud with Looker Studio](https://docs.oxla.com/oxla-cloud-saas/how-to-connect-oxla-cloud-with-looker)
- [How to Connect Oxla Cloud with PowerBI](https://docs.oxla.com/oxla-cloud-saas/how-to-connect-oxla-cloud-with-powerbi)
- [How to Connect Oxla Cloud with TablePlus](https://docs.oxla.com/oxla-cloud-saas/how-to-connect-oxla-cloud-with-tableplus)
- [Introduction to Oxla Cloud](https://docs.oxla.com/oxla-cloud-saas/introduction-to-oxla-cloud-saas)
- [Quickstart - Oxla SaaS](https://docs.oxla.com/oxla-cloud-saas/quickstart-oxla-saas)
- [eCommerce Dataset](https://docs.oxla.com/oxla-datasets/ecommerce-dataset)
- [Introduction](https://docs.oxla.com/oxla-datasets/introduction-datasets)
- [Social Media Dataset](https://docs.oxla.com/oxla-datasets/socialmedia-dataset)
- [Urban Mobility Dataset](https://docs.oxla.com/oxla-datasets/urbanmobility-dataset)
- [Web Traffic Dataset](https://docs.oxla.com/oxla-datasets/webtraffic-dataset)
- [pg_attrdef](https://docs.oxla.com/pg_attrdef)
- [pg_constraint](https://docs.oxla.com/pg_constraint)
- [pg_depend](https://docs.oxla.com/pg_depend)
- [pg_description](https://docs.oxla.com/pg_description)
- [pg_index](https://docs.oxla.com/pg_index)
- [pg_namespace](https://docs.oxla.com/pg_namespace)
- [pg_settings](https://docs.oxla.com/pg_settings)
- [pg_statio_user_tables](https://docs.oxla.com/pg_statio_user_tables)
- [Welcome](https://docs.oxla.com/welcome): Discover everything you need to know about Oxla right here, right now!