SQL

Doltgres is a full-featured SQL database, akin to Postgres or MySQL.

Doltgres implements the Postgres SQL dialect. You connect to Doltgres using a Postgres client. The goal is for Doltgres to be a drop in replacement for Postgres.

Doltgres has databases and tables as you'd expect. Doltgres implements all Postgres data types. Doltgres supports secondary indexes. Doltgres supports foreign key and check constraints. Doltgres supports views, triggers, and procedures. Doltgres implements users and grants for permissions.

This section of the documentation will explain Doltgres's flavor of these standard SQL concepts. Perhaps more importantly, this section will also explain how these concepts interact with Doltgres's version control features.

Concepts will be tackled in the following order:

1. Databases

2. Schema

3. Tables

4. Primary Keys

5. Types

6. Indexes

7. Views

8. Constraints

9. Triggers

10. Procedures

11. Users/Grants

12. Transactions

13. System Variables