Home

Welcome to the PrismaDB wiki! This wiki aims to help you understand and use the Prisma/DB proxy.

Supported SQL queries and commands are described in this wiki, together with its explanation and examples. Any other valid SQL queries will be executed at the actual database directly without passing through the transformative core encryption module.

The current version of this wiki is compatible with version 0.2.8.171 of the core module.

Contents

1. Home
2. Metasyntax Used
3. Language Structure
   1. Literal Values
   2. Schema Object Names
   3. Expression Syntax
4. Data Types
5. Encryption Schemes
6. Data Definition Statements
   1. CREATE TABLE
   2. ALTER TABLE
7. Data Manipulation Statements
   1. SELECT
   2. INSERT
   3. UPDATE
   4. DELETE
8. Native Commands
   1. EXPORT SETTINGS
   2. UPDATE KEYS
   3. ENCRYPT
   4. DECRYPT
   5. REGISTER USER