Create data-container

Overview

In order to Spawn a database to work against, you'll need to create a Data Container. A Data Container is created from a Data Image.

Lifetime

You can specify a lifetime for a Data Container via the lifetime flag. This will automatically delete your Data Container after the time specified, in time duration format (number followed by a unit suffix. Valid units are "h", "m", "s").

If no value is provided, your Data Container will have an unlimited lifetime, and will only be deleted if you explicitly request it.

You can update Data Containers after creation to alter their lifetime

Command

$ spawnctl create data-container --image <ImageName[:Tag]_Or_ImageID> --lifetime <LifetimeDurationString>

Tutorial

In this tutorial we will create a Data Image and then use it to create a Data Container.

As a prerequisite you should've followed the instructions to install spawnctl

1. Create a file development.yaml with your Data Image specifications.

   sourceType: empty
   name: dev
   engine: postgresql
   version: 11.0
   

   In this case we want to create a PostgreSQL Data Image that is completely empty and is named dev.

2. Run the following command to create a Data Image.

   $ spawnctl create data-image -f ./development.yaml
   Data image 'dev' created!
   

3. You can verify your Data Image by running the following command.

   $ spawnctl get data-images
   NAME  IMAGE ID  ENGINE      STATUS  MESSAGE  CREATED
   dev   10001     PostgreSQL  2       Created  2 minutes ago
   

4. Create a Data Container from the newly created Data Image.

   $ spawnctl create data-container --image dev --lifetime 1h30m
   Data container 'dev-rambbomj' created!
   -> Host=instances.spawn.cc;Port=53223;User ID=<some_user_id>;Password=<some_password>;
   

5. You can verify your Data Container was properly created by running the following command.

   $ spawnctl get data-containers
   NAME          CONTAINER ID  REVISION  STATUS  MESSAGE  ENGINE      CREATED       EXPIRES AT
   dev-rambbomj  10001         rev.0     2       Running  PostgreSQL  1 minute ago  1 hour from now
   

6. You should now be able to connect to your database and execute queries.

   In this example we connect to the PostgreSQL Data Container (database) using psql.

   $ psql -h instances.spawn.cc -p 53223 -U <some_user_id>
   Password for user <some_user_id>:
   psql (10.5, server 11.0 (Debian 11.0-1.pgdg90+2))
   
   SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
   Type "help" for help.
   
   <some_user_id>=# CREATE TABLE customers(id INT);
   CREATE TABLE
   <some_user_id>=# \dt
               List of relations
   Schema |   Name    | Type  |      Owner
   --------+-----------+-------+------------------
   public | customers | table | <some_user_id>
   (1 row)