Connect with C/C++
On this page
You can connect to your SingleStore database from C/C++ based applications using the MariaDB Connector (C/C++) (LGPLv2.
Note
As of MariaDB Connector/C++ version 1.rewriteBatchedStatements=true may not work as expected.
Refer to MariaDB Connector/C and Connector/C++ for more information.
Examples
Update the connection configuration of your SingleStore Helios deployment before running the code.
-
endpoint: IP address or hostname of the SingleStore deployment. -
database: Name of the SingleStore database to connect with. -
username: Username of the SingleStore database user with which to connect to SingleStore. -
password: Password of the SingleStore database user.
Example: Connect using C++
This example creates a table in SingleStore, inserts data into the table, and queries the data using C++.
Note
The following commands may require sudo access (root privileges).
-
Install the required dependencies.
This example uses a Debian-based Linux OS. apt-get install cmake libmariadb-dev libssl-dev -
Download and install the MariaDB C++ connector.
-
Clone the connector repository.
git clone https://github.com/mariadb-corporation/mariadb-connector-cpp.gitcd mariadb-connector-cpp -
Build and install the connector.
cmake .makemake installThe
mariadbapplibrary is installed in the/usr/local/libdirectory. -
Add a symbolic link for
libmariadbcpp..so ln -s /usr/local/lib/mariadb/libmariadbcpp.so /usr/local/libldconfig
-
-
Add the following code to a s2example.
cpp file. Update the connection configuration of your SingleStore deployment in the code. #include <mariadb/conncpp.hpp>#include <iostream>int main() {try {// Connection detailsconst std::string url = "tcp://<endpoint>:3306/<database>";const std::string user = "<username>";const std::string password = "<password>";// Connectsql::Driver* driver = sql::mariadb::get_driver_instance();sql::SQLString connection_url(url);sql::Properties properties({{"user", user}, {"password", password}});std::unique_ptr<sql::Connection> conn(driver->connect(connection_url, properties));std::unique_ptr<sql::Statement> stmt(conn->createStatement());// Create operationstmt->execute("CREATE TABLE IF NOT EXISTS Stock (ID INT PRIMARY KEY,Code VARCHAR(10),Quantity INT)");// Insert operationstmt->execute("INSERT INTO Stock (ID, Code, Quantity) VALUES (3, 'cdq3', 25)");stmt->execute("INSERT INTO Stock (ID, Code, Quantity) VALUES (1, 'xvf1', 40)");stmt->execute("INSERT INTO Stock (ID, Code, Quantity) VALUES (2, 'gwl2', 15)");// Read operationstd::unique_ptr<sql::ResultSet> res(stmt->executeQuery("SELECT * FROM Stock ORDER BY ID"));// Display resultswhile (res->next()) {std::cout << "ID: " << res->getInt("ID")<< ", Code: " << res->getString("Code")<< ", Quantity: " << res->getInt("Quantity") << std::endl;}} catch (sql::SQLException &e) {std::cerr << "SQL Exception: " << e.what() << std::endl;return 1;}return 0;} -
Run the following command to compile the code.
Run this command in the same directory as s2example. cpp (or append the path to the file). g++ s2example.cpp -o singlestore_mariadb \-I/usr/local/include/mariadb \-L/usr/local/lib/mariadb \-lmariadbcpp -
Run the code.
Run the following command in the same directory as the singlestore_ mariadb file generated in the previous step. ./singlestore_mariadb./singlestore_mariadb ID: 1, Code: xvf1, Quantity: 40 ID: 2, Code: gwl2, Quantity: 15 ID: 3, Code: cdq3, Quantity: 25
Example: Connect with C
This example creates a table in SingleStore, inserts data into the table, and queries the data using C.
Note
The following commands may require sudo access (root privileges).
-
Install the MariaDB C connector.
This example uses a Debian-based Linux OS. apt-get install libmariadb-dev -
Add the following code to a s2example.
c file. #include <stdio.h>#include <stdlib.h>#include <mariadb/mysql.h>int main() {// Connection parameters -- REPLACE these with your actual valuesconst char *host = "<endpoint>";const char *user = "<username>";const char *pass = "<password>";const char *database = "<database>";unsigned int port = 3306;MYSQL *conn = mysql_init(NULL);// Connect to SingleStoreif (!mysql_real_connect(conn, host, user, pass, database, port, NULL, 0)) {fprintf(stderr, "Connection error: %s\n", mysql_error(conn));mysql_close(conn);return 1;}// Create a tableconst char *create_table_sql = "CREATE TABLE IF NOT EXISTS Inventory (ID INT PRIMARY KEY,Code VARCHAR(4),Quantity INT)";if (mysql_query(conn, create_table_sql)) {fprintf(stderr, "Create table error: %s\n", mysql_error(conn));mysql_close(conn);return 1;}// Insert dataconst char *insert1 = "INSERT INTO Inventory (ID, Code, Quantity) VALUES (3, 'cdq3', 25)";const char *insert2 = "INSERT INTO Inventory (ID, Code, Quantity) VALUES (1, 'xvf1', 40)";const char *insert3 = "INSERT INTO Inventory (ID, Code, Quantity) VALUES (2, 'gwl2', 15)";if (mysql_query(conn, insert1) || mysql_query(conn, insert2) || mysql_query(conn, insert3)) {fprintf(stderr, "Insert error: %s\n", mysql_error(conn));mysql_close(conn);return 1;}// Perform SELECT queryif (mysql_query(conn, "SELECT * FROM Inventory")) {fprintf(stderr, "SELECT error: %s\n", mysql_error(conn));mysql_close(conn);return 1;}MYSQL_RES *result = mysql_store_result(conn);if (result == NULL) {fprintf(stderr, "Result error: %s\n", mysql_error(conn));mysql_close(conn);return 1;}// Print resultsMYSQL_ROW row;printf("ID\tCode\tQuantity\n");while ((row = mysql_fetch_row(result))) {printf("%s\t%s\t%s\n", row[0], row[1], row[2]);}// Clean upmysql_free_result(result);mysql_close(conn);return 0;} -
Compile the code.
Run this command in the same directory as s2example. c (or append the path to the file). gcc s2example.c -o singlestore_mariadb -lmariadb -
Run the code.
Run the following command in the same directory as the singlestore_ mariadb file generated in the previous step. ./singlestore_mariadbID Code Quantity 3 cdq3 25 1 xvf1 40 2 gwl2 15
Last modified: August 11, 2025