SereneDB Environment

SereneDB provides a number of functions and PRAGMA options to retrieve information on the running SereneDB instance and its environment.

Version

The version() function returns the version number of SereneDB.

Using a PRAGMA:

Platform

The platform information consists of the operating system, system architecture, and, optionally, the compiler. To retrieve the platform, use the following PRAGMA:

The platform string combines the operating system and architecture — for example osx_arm64 on macOS with Apple Silicon, windows_amd64 on Windows on AMD64, or linux_arm64 on Ubuntu Linux on ARM64.

Meta Table Functions

SereneDB has the following built-in table functions to obtain metadata about available catalog objects:

• duckdb_columns(): columns
• duckdb_constraints(): constraints
• duckdb_databases(): lists the databases that are accessible from within the current SereneDB process
• duckdb_dependencies(): dependencies between objects
• duckdb_extensions(): extensions
• duckdb_functions(): functions
• duckdb_indexes(): secondary indexes
• duckdb_keywords(): SereneDB's keywords and reserved words
• duckdb_optimizers(): the available optimization rules in the SereneDB instance
• duckdb_schemas(): schemas
• duckdb_sequences(): sequences
• duckdb_settings(): settings
• duckdb_tables(): base tables
• duckdb_temporary_files(): the temporary files SereneDB has written to disk, to offload data from memory
• duckdb_types(): data types
• duckdb_views(): views