Stack Overflow
Stack Overflow

Questions tagged [mariasql]

A node.js binding to MariaDB's non-blocking (MySQL-compatible) client library

mariasql is a node.js binding to the non-blocking client library provided with MariaDB. It is compatible with MySQL.

This binding is different from other libmysqlclient bindings in that it uses the non-blocking functions available in MariaDB's client library.

Install it with the npm package installer:

npm install mariasql

The source code is located at github:node-mariasql.

References

143 questions
2
votes
2 answers

auto_increment jumps by 3 and not 1

I have noticed that in my mysql server, the auto_increment setting increments by 3, for example 3 6 9 12 15 etc. All the tables in the database are having the same problem. I'm using mariadb 10.5 on debian 10. Could it be because of having a 3 vps…
diaconu liviu
  • 1,032
  • 2
  • 13
  • 30
2
votes
1 answer

Substitution for too large composite key

I'm trying to find the best solution for the given problem: I have an Entity (lets call it Collateral) which consists of several fields. The uniqueness of this entity is defined by the composition of 4 fields (let's call them: user_id (bigint),…
Przemysław Gęsieniec
  • 618
  • 6
  • 15
2
votes
2 answers

How to SELECT records into a single record to determine TIME difference

I have a 3rd party clocking application which we use to track our staff's movements. It runs on a MariaDB, but it is pretty messy (imo). The frontend is windows based and all the processing happens there. Problem is I would like to extract some data…
George Gerber
  • 23
  • 4
2
votes
1 answer

On Duplicate Key update - MariaDB

I have a MySQL Statement to insert data to 4 rows at a time. The insert is working but I'm having difficulty with the ON DUPLICATE KEY UPDATE. I'm getting an error: You have an error in your SQL syntax; check the manual that corresponds to your…
Mustafa
  • 152
  • 2
  • 15
2
votes
3 answers

Should I turn off Query Cache in MySQL?

I'm using a dedicated server with 32GB RAM and an 8-core server, using Maria DB 10.1 and most tables are InnoDB. Total DB size is less than 2GB but I think performance is slow. The following is the my.cnf file I'm…
Niresh
  • 135
  • 1
  • 2
  • 13
2
votes
1 answer

Error: Cannot find module '../build/Debug/sqlclient'

In directory i did the standard- npm install mariasql --save. when i run my server file -node app.js. It returns an error like this: Error: Cannot find module '../build/Debug/sqlclient' at Function.Module._resolveFilename…
midhun k
  • 1,032
  • 1
  • 15
  • 41
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
2
votes
2 answers

How to do bulk insert In mariadb using nodejs?

Whenever i am trying to run my code this is showing the column count doesn't match error. values=[ [{id:12227722345,name:"dgssssdavgsgfv",pass:"cvhsssssadfvugod"}], [{id:12,name:"ddd",pass:"cvh"}] ]; c.query('insert into…
Akash Sourav Nayak
  • 203
  • 1
  • 8
  • 21
1
vote
0 answers

MariaDB-JSON-document- Not able to select only specific elements from array without knowing his index after applying exact where clause

I have JSON document. structure/sample data is like - { "id":"201", "portfolio":[ { "portfolio_id":"PORTFOLIO_001", "portfolio_name":"AAA", "product":[ { …
Prashant Vidhate
  • 11
  • 1
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

mariadb: execute "IN" closure query in update

how to update this query in MariaDB? query: UpdatewarehouseBinOfItems() { return `UPDATE producedItem SET warehouseBinId = ? WHERE id IN (?)`; } function handling the…
shevin fernando
  • 39
  • 8
1
vote
1 answer

When should I add TAB for subqueries in SQL?

I am practicing SQL in SQLZOO and having trouble understanding the solution to the question #5: https://sqlzoo.net/wiki/Window_functions I copied the description of the table and question from another user @crowtherl This question uses table "ge"…
Allan
  • 21
  • 4
1
vote
1 answer

Is it possible to setup MYSQL replication with binlog files generated from server A (which we are considering as Master) to server B

We are migrating from the Magento community to Magento cloud for one of our projects and we need to access DB for our custom developed CRM. But unfortunately magento cloud does not support DB replication and they have enabled binlogs and they are…
user3136863
  • 11
  • 1
1
vote
1 answer

Python and Scrapy, and attempting to get scraped data into MariaDB/MYSQL Database

The below code is unfinished I know, but all that I am simply trying to do is get those yield results into my MARIADB. I spent far too many hours combing Stackoverflow, looking for this answer. The code works great and I can manually add the…
tjberte
  • 111
  • 2
  • 9
1
vote
1 answer

MariaDB unknown syntax error. Making a simple table

I cannot find whats wrong with my single table making sql code. The 'user' that it is referencing does exist. The error I receive is: ERROR 1064 (42000) at line 1 in file: 'project.sql': You have an error in your SQL syntax; check the manual that…
Matthew Jacobsen
  • 43
  • 6
1
2
3
…
9 10