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.

Command

$ spawnctl create data-container --image <ImageID>

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
   

   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
   Waiting for data image creation.......
   Creating data image...........
   Data image '10001' 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 10001
   Waiting for data container creation....
   Creating data container.....
   Data container '10001' 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
   dev-cp5rye3n  10001         rev.0     2       Running  PostgreSQL  1 minute ago
   

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)