Tacnode in 10 minutes

This article provides quick steps to help you understand how to create a Warehouse, obtain connection information, and create a database for data writing and querying.

1. Prerequisites

1. Register a Tacnode account

To access the Tacnode registration page, visit Tacnode Signup. New users can register using their email address.

2. Install the psql terminal

Refer to the client installation method provided by the PostgreSQL official website to install PSQL.

2. Activate the service

1. Create Data Cloud

The Data Cloud is where you manage database storage and computing service resources. All operations on your data must be completed in Data Cloud. For more information, refer to Data Cloud.

Log in to Tacnode to access the Tacnode WEB interface. Then, open the Data Cloud management page to create a new Data Cloud. Subsequent operations can be completed in the corresponding Data Cloud Center.

2. Create Warehouse

Warehouse is Tacnode's computing module. It handles all database DDL, DML, and other operations. Create a Warehouse before performing SQL operations. For more information, refer to Warehouse(/docs/guides/platform/warehouse).

Enter the Warehouse management page and click "+Warehouse" to create a new Warehouse in the following two ways:

• Visit Data Cloud to open the Data Cloud management page, click Data Cloud to enter Data Cloud Center > Warehouse.
• Visit https://<cloud_regionid>-app.tacnode.io and go directly to Data Cloud Center > Warehouse.
  • <cloud_regionid> is the identifier of the cloud platform region and is consistent with the cloud platform. For more information, refer to Regions Supported by Tacnode. Tacnode Regions.

3. Connect to Warehouse

Warehouse enables VPC network access by default. Use public network access in this case.

On the Warehouse details page, click the network link and enable public network access to obtain the public domain name and port of Warehouse and the psql connection.

psql connection: psql -U <Account> -d postgres -h <Host> -p 5432

• <Account>: Tacnode Account
• <Host>: Warehouse public network connection domain name

4. Create Objects

Create a database

Use CREATE DATABASE to create a tac_test database:

CREATE DATABASE tac_test;

Switch to the tac_test database you just created using the following command.

postgres=# \c tac_test
You are now connected to database "tac_test" as user "judy".
tac_test=#

Create a table

Use CREATE TABLE to create the cars table:

CREATE TABLE cars (
  brand VARCHAR(255),
  model VARCHAR(255),
  year INT
);

The execution results are as follows:

tac_test=# CREATE TABLE cars (
  brand VARCHAR(255),
  model VARCHAR(255),
  year INT
);
CREATE TABLE
tac_test=# \d cars
                       Table "public.cars"
 Column |          Type          | Collation | Nullable | Default
--------+------------------------+-----------+----------+---------
 brand  | character varying(255) |           |          |
 model  | character varying(255) |           |          |
 year   | integer                |           |          |
 
tac_test=#

5. Writing and Querying

Writing Data

Use INSERT INTO to write data to the cars table:

INSERT INTO cars (brand, model, year)
VALUES ('Ford', 'Mustang', 1964);

The execution results are as follows:

tac_test=# INSERT INTO cars (brand, model, year)
VALUES ('Ford', 'Mustang', 1964);
INSERT 0 1

Query Analysis

Use SELECT to query the result of the data just written.

SELECT * FROM cars;

The execution results are as follows:

tac_test=# select * from cars;
 brand |  model  | year
-------+---------+------
 Ford  | Mustang | 1964
(1 row)

Update Data

Use UPDATE to update the existing data.

UPDATE cars
SET model = 'NEWMustang'
WHERE brand = 'Ford';

The execution results are as follows:

tac_test=# UPDATE cars
SET model = 'NEWMustang'
WHERE brand = 'Ford';
UPDATE 1
tac_test=# select * from cars;
 brand |   model    | year
-------+------------+------
 Ford  | NEWMustang | 1964
(1 row)
 
tac_test=#