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.3.x.x of Prisma/DB proxies and libraries.

Contents

1. Home
2. Changelog
3. Getting Started (Proxies)
   1. Quick Start
   2. Configuration Options
   3. Sample Docker Scripts
   4. Supported Clients
   5. Docker Images
4. Getting Started (Libraries)
5. Metasyntax Used
6. Language Structure
   1. Literal Values
   2. Schema Object Names
   3. Expression Syntax
7. Data Types
8. Encryption Schemes
   1. Support Matrix
9. Data Definition Statements
   1. CREATE TABLE
   2. CREATE INDEX
   3. ALTER TABLE
   4. DROP TABLE
   5. SHOW TABLES
   6. SHOW COLUMNS
10. Data Manipulation Statements
    1. SELECT
    2. INSERT
    3. UPDATE
    4. DELETE
11. Native Commands
    1. EXPORT SETTINGS
    2. UPDATE KEYS
    3. ENCRYPT
    4. DECRYPT
    5. SAVE OPETREE
    6. REBALANCE OPETREE
    7. REGISTER USER