Advanced Playground Usage¶

Postgres¶

If you want to use Postgres instead of SQLite, you need to create a database first.

Install Postgres¶

Create database¶

By default the playground expects a local database to exist with the following credentials:

user: "piccolo"
password: "piccolo"
host: "localhost"  # or 127.0.0.1
database: "piccolo_playground"
port: 5432

You can create a database using pgAdmin.

If you want to use different credentials, you can pass them into the playground command (use piccolo playground run --help for details).

Connecting¶

When you have the database setup, you can connect to it as follows:

piccolo playground run --engine=postgres

iPython¶

The playground is built on top of iPython. We provide sensible defaults out of the box for syntax highlighting etc. However, to use your own custom iPython profile (located in ~/.ipython), do the following:

piccolo playground run --ipython_profile

See the iPython docs for more information.