Stack Overflow
Stack Overflow

Questions tagged [mariadb-connect-engine]

A MariaDB storage engine for connecting to other databases / data sources (Binary, JSON, SQLite, etc.)

42 questions
5
votes
2 answers

Hide meta object data in mariaDB when using nodejs

I'm logging the result of some certain query and it's working fine, but I have noticed there are too much metadata are logged as well, how can I disable these metadata from being logged in? screenshot const pool = mariadb.createPool({ …
user15281199
4
votes
3 answers

Maria DB recommended RAM,disk,core capacity?

I am not able to find maria DB recommended RAM,disk,number of Core capacity. We are setting up initial level and very minimum data volume. So just i need maria DB recommended capacity. Appreciate your help!!!
user2848031
  • 187
  • 12
  • 36
  • 69
3
votes
1 answer

sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:mariadb.mariadbconnector

I have a simple python script packaged using pyinstaller and when I tried to run I am getting this error sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:mariadb.mariadbconnector although I already have mariadbconnector…
Fancy
  • 135
  • 12
3
votes
1 answer

MariaDB non-blocking with EPOLL

I have single threaded server written in C that accepts TCP/UDP connections based on EPOLL and supports plugins for the multitude of protocol layers we need to support. That bit is fine. Due to the single threaded nature, I wanted to implement a…
dave.zap
  • 491
  • 4
  • 13
2
votes
0 answers

Geospatial using maria db

I need to select all points that is within 30 KM radius as a circle from a specific latitude/longitude using maria db. For example: latitude = 46.8167 longitude = 6.9333
midhun k
  • 1,032
  • 1
  • 15
  • 41
1
vote
1 answer

The error message "libsqora.so.11.1: file not found" in the context of connecting to Oracle from MariaDB

I'm having trouble resolving an issue. The OS is CentOS, and the version of MariaDB is 10.4. UnixODBC is installed and configured properly with odbc.ini and odbcinit.ini. When I try connecting using 'isql -v orcl scott tiger', it successfully…
dae-hee Kim.
  • 23
  • 6
1
vote
0 answers

Loop import XML files

I'm using MariaDB to import some files in XML. Here is a snippet of the code I'm using: CREATE TABLE invoices ( InvoiceNumber VARCHAR(20), InvoiceStatus CHAR (1), InvoiceDate CHAR (10), Period CHAR (2) ) ; DROP TABLE if EXISTS…
Bruno
  • 88
  • 5
1
vote
2 answers

MariaDB - Inserting Values doesn't affect any rows

I want to insert given values from my docker app-service to the MariaDB-service. The connection has been established because I can execute SELECT * FROM via the MariaDB.connection.cursor. First of all I create the connection: def get_conn() ->…
Lukas Scholz
  • 55
  • 5
1
vote
1 answer

Create trigger in MariaDB

We're currently looking to port from Oracle into MariaDb, but are struggling to recreate old triggers. Specifically, we're currently trying to execute: CREATE DEFINER=`admin`@`%` TRIGGER SET_AUTHOR_EVENT_ID BEFORE INSERT ON author_event FOR EACH ROW…
Phil S
  • 123
  • 8
1
vote
0 answers

Recovering Win10 from restore point deletes data but database and table remains in MariaDB

I put MariaDB in ProgramData on Windows 10, create a system restore point, create a database in MariaDB, fill the database and roll back to the restore point, the database remains, but all the tables are empty, they open with an error table doesn't…
Boris novikov
  • 11
  • 1
1
vote
0 answers

How To Force CMake / G++ / LD To Link Shared Object Against Another Shared Object

I need to create a shared object (.so) that is linked against another shared object (my code uses functions / symbols exported by that shared object). No matter what I try, CMake / G++ / LD refuse to include the shared object in the linking…
Mark Schlachter
  • 21
  • 1
  • 3
1
vote
2 answers

python database request not updating

I am pulling data from a database in a python script which works on start up but does not update when I change the value within the database. The script initially connects to the database then selects all the contents where id is equal to 1 (this…
user2669997
1
vote
2 answers

Accessing to a MariaDB Galera Cluster on Ubuntu 16.04 from SpringBoot app

I've installed a MariaDB Galera Cluster on Ubuntu 16.04 in 2 nodes. Here the info from node1: root@localhost:~# sudo more…
en Peris
  • 1,537
  • 12
  • 31
  • 63
1
vote
1 answer

MariaDB CONNECT engine to read external file

I would like to read an external file into MariaDB using the CONNECT engine. However, when trying to read from the file, I get an error message: MariaDB [test]> create table test ( name varchar(100), team varchar(100) ) engine=CONNECT table_type=CSV…
divingTobi
  • 2,044
  • 10
  • 25
1
vote
1 answer

Maria DB Can't drop table with ENGINE=CONNECT without root

As in topic I can create and drop table in Maria DB as root, but I can't drop table as normal user. It happens only when tabel engine is connect. As root: MariaDB [(none)]> GRANT ALL PRIVILEGES ON test_database.* To 'user'@'localhost' IDENTIFIED BY…
rpeczykowski
  • 165
  • 1
  • 1
  • 9
1
2 3