SQL Reference
ClapDB SQL for Relational Query
ClapDB Support Relational Query with SQL commands. You can use SQL commands to query data from ClapDB.
Support Data Types
check this Data Types for supported data types.
ClapDB support some new modern datatypes that was not supported by traditional databases, such as int128
, uint16
, uint32
, uint64
, uint128
.
Materialized View / Join
- ClapDB Free / Pro doesn’t support Materialized View.
- ClapDB Free / Pro doesn’t support Join.
you can double check postgres compatible for the compatibility with PostgreSQL.
Mathematical Functions and Operators
check the PostgreSQL mathematical functions for supported mathematical functions and operators.