ClickHouse Application Development Approach

Scenario

ClickHouse enables you to perform common service operations by executing SQL statements. The SQL operations involved in sample codes include creating a database, creating a table, inserting data into a table, querying table data, and deleting a table.

Sample codes are described in the following sequence:

1. Setting properties
2. Establishing a connection
3. Creating a database
4. Creating a table
5. Inserting data into a table
6. Querying data
7. Deleting a table

Development Approach

As an independent Database Management System (DBMS), ClickHouse allows you to use SQL to perform common operations. The development program example uses the clickhouse-jdbc API for description. The development process consists of the following parts:

• Setting properties: Set the parameter properties for connecting to a ClickHouse service instance.
• Setting up a connection: Set up a connection to the ClickHouse service instance.
• Creating a database: Create a ClickHouse database.
• Creating a table: Create a table in the ClickHouse database.
• Inserting data: Insert data into the ClickHouse table.
• Querying data: Query data in the ClickHouse table.
• Deleting a table: Delete the ClickHouse table.