1. Getting Started
1. Getting Started
This chapter is a starting point for readers new to databases and for developers coming from another DBMS. It introduces how Machbase DBMS 8.7.0 stores data, then walks through the basic SQL workflow by inserting and querying one event.
You can read the overview before installing a database. To run the example, you need a running
DBMS server and its SQL client, machsql. The prerequisites in
10-Minute Quick Start explain how to prepare the server and connection.
What You Will Learn
- Understand the roles of tables, rows, columns, and SQL.
- Distinguish historical records from current state.
- Identify Machbase table types for measurements, events, and reference data.
- Connect to the server, create a LOG table, and insert and query data.
- Compare event time with server arrival time and choose your next learning path.
Reading Order
| Section | What you can do afterward |
|---|---|
| Machbase DBMS Overview | Explain the purpose of a time-series database and the roles of its table types. |
| 10-Minute Quick Start | Connect, insert and query data, and clean up the practice table. |
| Basic Command Cheatsheet | Distinguish shell commands from SQL and find common commands. |
| Choose the Next Document | Find the documents relevant to your data, development tasks, and operations. |
The example uses a small SQL INSERT so you can inspect the result directly. For continuous,
high-volume ingestion and error handling, continue with
Data Input and Export.
Last updated on