The MySQL X DevAPI is an application-level interface used by clients and connectors built on top of the X Protocol. It specifies a common set of CRUD-style and SQL functions/methods to work with both document store collections and relational tables, a common expression language to establish query properties such as criteria, projections, aliases, and additional database management features for handling things like transactions, indexes, etc.
Questions tagged [mysql-x-devapi]
64 questions
5
votes
3 answers
How to configure MySQL document store on AWS RDS
I am new to AWS RDS & MySQL document store.
I have created one lambda (NodeJS 4.3) & one RDS MySQL instance which is having default port 3306. I have enabled X Plugin as mentioned in this documentation via MySQL shell and its successfully installed…
Shri.harry
- 287
- 1
- 2
- 15
3
votes
0 answers
Cannot install php mysql_xdevapi extension
I need to install some composer packages, but all of those require php mysql_xdevapi extension.
I'm trying to install following these instructions, but PECL gives me this error:
/tmp/pear/temp/pear-build-rootkr7lTy/mysql_xdevapi-8.0.21/libtool: line…
Aurora
- 53
- 2
2
votes
1 answer
How to get raw SQL query from MySQL X DevAPI SQL CRUD functions?
I am using MySQL X DevAPI. That is working fine for relational tables.
// Working with Relational Tables
var mysqlx = require('@mysql/xdevapi');
var myTable;
// Connect to server using a connection URL
mysqlx
.getSession({
user: 'user',
…
Alok
- 7,734
- 8
- 55
- 100
1
vote
1 answer
How to get rows as array of JSON object instead of array of array in MySQL X DevAPI select query?
I am using MySQL X DevAPI for relational tables in MySQL.
// Working with Relational Tables
var mysqlx = require('@mysql/xdevapi');
var myTable;
// Connect to server using a connection URL
mysqlx
.getSession({
user: 'user',
password:…
Alok
- 7,734
- 8
- 55
- 100
1
vote
2 answers
DATE_ADD() is not working in MySQL XDev API with Node.js
In MySQL shell I am able to run
select * from meeting where startTime > date_add(now(), interval 2 day);
This same command is not working using MySQL XDev API
var meetingRows = (await sqldb.getTable('meeting').select().where('startTime >…
Alok
- 7,734
- 8
- 55
- 100
1
vote
1 answer
Manual Insert into MySQLx Collection
I have a large amount of JSON data that needs to be inserted into a MySQLx Collection table. The current Node implementation keeps crashing when I attempt to load my JSON data in, and I suspect it's because I'm inserting too much at once through the…
Joel Nation
- 115
- 7
1
vote
1 answer
How to check mysql session/connection status with driver 8.0.XX C++ API
In my C++ code, I am using MySQL driver 8.0.xx and using xdevapi because of the costly approach of establishing a connection to the database for each client request, I am using a pool of database connections.
mysqlx documentation 2.2.3 Connecting to…
Mohsen
- 59
- 1
- 8
1
vote
1 answer
How to get value by field name in MYSQL xdevapi 8.0 connector c++
For connector c++ 1.1, in this example, it's quite easy to get values by specifying the column name (or alias name).
But when I upgraded to version 8.0 xdevapi, I found this feature is no longer supported.
#include
using…
LQsLLDB
- 35
- 1
- 4
1
vote
1 answer
Using Mysql xdevapi
I am trying to work with Mysql as a document store using xdevapi, but it is written in JavaScript and I am using TypeScript,so I found mysqlx a type definition for xdevapi and I don't know if it is a good one. Is there any better alternative
Houcem Eddine
- 91
- 1
- 8
1
vote
0 answers
mysqlx xdevapi cmake undefined reference compilation error
I am trying to import mysql connector to my c++ project but I am getting errors at the linking stage. This is my
CMakeLists.txt:
add_executable(app
src/main.cpp
)
add_library(mysql STATIC IMPORTED)
set_property(TARGET mysql PROPERTY
…
christk
- 834
- 11
- 23
1
vote
0 answers
xdevapi for MySQL using c++ connector linker issues
I am new and was trying to learn xdevapi for MySQL. i wanted to use it with C++ code on my windows device. but i am having a hard time running sample code. and i am getting a lot of linker errors. there is not much online about these building…
Arshdeep Singh
- 29
- 4
1
vote
1 answer
C++ XDevAPI multiple .values
I am using Xcode, MySQL and XDevAPI.
I have the following table on the database
create table TABLE(ID INT, VALUE_01 INT, VALUE_02 INT, VALUE_03 INT);
I have the following values on code the code:
Table table(session, "TABLE");
int id;
set…
Nuno
- 117
- 4
1
vote
1 answer
Filter using date field in mysql Document store(Nosql) in C#
How can i filter a date field in document store table (NoSQL) in c#.
i need to filter created ate greater than particular time.
the date is storing as string values in nosql.
I had only found the below mentioned code to filter in C#…
Mahesh
- 33
- 5
1
vote
1 answer
Cannot install php extension 'mysql_xdevapi' on mac
When I run pecl install mysql_xdevapi in the terminal I get the following error:
configure: error: protobuf not found, please install it in system, consider use of --with-protobuf or setting MYSQL_XDEVAPI_PROTOBUF_ROOT
I then installed 'protobuf'…
doefom
- 66
- 9
1
vote
0 answers
How to download and install mysqlx plugin into MySQL?
I would like to use mysqlx/xdevapi.h in C++ and for this must be installed MySQL X Plugin in MySQL.
I tried:
mysql> INSTALL PLUGIN mysqlx SONAME 'mysqlx.so';
I got this message :
ERROR 1126 (HY000): Can't open shared library…
Amateur
- 43
- 6