### SQL Support Sample

### Note

This sample use PostgreSQL and drop all of its data once run in order to be runnable multiple times.

Sample of how to fully use Zest™ SQL support : SQL Library, SQL EntityStore and SQL Index/Query.

Browse Source

Here are the steps needed to setup the database using the `psql` utility command:

    user@host $ psql postgres
    postgres=# CREATE USER jdbc_test_login WITH PASSWORD 'password';
    CREATE ROLE
    postgres=# CREATE DATABASE jdbc_test_db;
    CREATE DATABASE
    postgres=# GRANT ALL PRIVILEGES ON DATABASE jdbc_test_db TO jdbc_test_login;
    GRANT
    postgres=# \q
    user@host $  psql -d jdbc_test_db</strong>
    postgres=# CREATE EXTENSION ltree;
    CREATE EXTENSION
    postgres=# \q
    user@host $

A gradle task `runSample` is defined in this module as a shortcut to run the example. See Build System.