KO | EN

GitLite

Minimalist Open Source Repository Search Engine

gitlite — search

#dsh #dsh-plugin #developer-tools #ai-agent #claude-code #codex #typescript #ai-agents #deepseek-harness #mcp #cli #rust

sqlpp11-connector-mysql

★ 132 Open GitHub ↗

A C++ wrapper for mysql meant to be used in combination with sqlpp11.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

sqlpp11-connector-mysql
=======================

A C++ wrapper for mysql meant to be used in combination with sqlpp11 (https://github.com/rbock/sqlpp11).

```diff
!If you are using the sqlpp11 version 0.61 or later:
!The mariadb/mysql connector is included in the sqlpp11 library directly and
!you do not need this repository.
```

Status:
-------
Branch / Compiler | clang,  gcc | MSVC
------------------| ------------|--------
master | [![Build Status](https://travis-ci.org/rbock/sqlpp11-connector-mysql.svg?branch=master)](https://travis-ci.org/rbock/sqlpp11-connector-mysql?branch=master) | [![Build status](https://ci.appveyor.com/api/projects/status/8yo0sbopv63kb2t7/branch/master?svg=true)](https://ci.appveyor.com/project/rbock/sqlpp11-connector-mysql/branch/master)
develop | [![Build Status](https://travis-ci.org/rbock/sqlpp11-connector-mysql.svg?branch=develop)](https://travis-ci.org/rbock/sqlpp11-connector-mysql?branch=develop) | [![Build status](https://ci.appveyor.com/api/projects/status/8yo0sbopv63kb2t7/branch/develop?svg=true)](https://ci.appveyor.com/project/rbock/sqlpp11-connector-mysql/branch/develop) |

License Hint:
-------------
The code is distributed under BSD License, but if you build the library, then the binary will be linked dynamically to mysqlclient, which is published under GPL or commercial license as of this writing. The resulting binary might therefore fall under GPL. To avoid this, an option to link against the equivalent MariaDB connector (under LGPL) is provided: see the build instructions below.

Sample Code:
------------
See for instance test/SampleTest.cpp

```C++
#include "TabSample.h"
#include <sqlpp11/sqlpp11.h>
#include <sqlpp11/mysql/mysql.h>

namespace mysql = sqlpp::mysql;
int main()
{
	auto config = std::make_shared<mysql::connection_config>();
 	config->user = "root";
 	config->database = "sqlpp_mysql";
	config->debug = true;
	mysql::connection db(config);

TabSample tab;
	for(const auto& row : db.run(sqlpp::select(all_of(tab)).from(tab).unconditionally()))
	{
		std::cerr << "row.alpha: " << row.alpha << ", row.beta: " << row.beta << ", row.gamma: " << row.gamma <<  std::endl;
	};
  return 0;
}
```

Requirements:
-------------
__Compiler:__
sqlpp11-connector-mysql makes use of C++11 and requires a recent compiler and STL. The following compilers are known to compile the test programs:

* clang-3.4 on Ubuntu-12.4 (requires thread_local)
  * g++-4.8 on Ubuntu-12.4
  * MSVC 2015 Update 2 on appveyor
  * AppleClang 8 (Xcode 8 and upwards, since prior versions do not support `thread_local`)

__C++ SQL Layer:__
sqlpp11-connector-mysql is meant to be used with sqlpp11 (https://github.com/rbock/sqlpp11).

__mysqlclient:__
libmysqlclient version 5.5 and up (or the respective mariadb version)

__date library by Howard Hinnant:__
https://github.com/howardhinnant/date

Build instructions:
-------------------
Download and unpack the latest release or clone the repository. Inside the directory run the following commands:

```bash
mkdir build
cd build
cmake ..
cmake --build . --target install
```

In order to customize the build process, you can add the following options to the cmake command above:

* CMAKE_INSTALL_PREFIX: path to the install folder
* CMAKE_PREFIX_PATH: if sqlpp11 and/or date library are installed in non-system prefix, provide their prefixes as a semicolon-separated list
* USE_MARIADB (default OFF): force the use of the MariaDB connector instead of the GPL'd MySQL connector
* ENABLE_TESTS (default ON): build unit tests

For example:

```bash
cmake -DCMAKE_INSTALL_PREFIX=/opt/sqlpp11_mariadb -DUSE_MARIADB=1 ..
```

sqlpp11-connector-mysql

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README