2022 Developer Survey is open! Take survey.

Questions tagged [javascript]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
26 views

Can you run PL/Python or PL/v8 code from the database itself?

It it possible to run code that is stored in the database, on the database. For example, I'd like a trigger to execute a function whose Javascript code is stored in the same database. (Normally, ...
user avatar
  • 133
0 votes
0 answers
45 views

Generate report by cross join between two tables

I wanted to generate report between two tables by using CROSS JOIN. Below shows the details of table. Table 1: kod_jawatan jawatan_id jawatan_kod jawatan_nama Table 2: tpermohonan mohon_id ...
user avatar
  • 1
0 votes
1 answer
366 views

Best way for processing over 150 million rows MySql

I wrote a function on nodejs to SELECT 150 million records, process the data and UPDATE those same 150 million records using UPDATE 'table' SET value1='somevalue' WHERE idRo2 = 1; Single Update for ...
user avatar
-1 votes
1 answer
26 views

How to get applied stored procedure for inserted row in mysql php query [closed]

$query = "CREATE PROCEDURE IF NOT EXISTS Insertion(IN firstname varchar(40),IN lastname varchar(40),IN email varchar(40),IN department varchar(40),IN doj date,IN basicpay int(11)) BEGIN ...
user avatar
1 vote
1 answer
2k views

Not authorized on test to execute command

Here is my code: mongoose.connect(consts.database, { useNewUrlParser: true, useUnifiedTopology: true, sslCA: consts.databaseCert, }); //... const user = await db.userModel.findOne({ ...
user avatar
  • 131
0 votes
0 answers
47 views

Non RAM based in-browser database solutions?

I want to decentralize my databases and upload it to Sia Skynet to give the users the ability to search on front-end. It is important to be able to deal with large amounts of data, but the RAM-based ...
user avatar
  • 109
0 votes
1 answer
132 views

How to parse MongoDB int32 in node.js

I am using MongoDB for a discord bot I am working on, and I want to retrieve a user's balance. My current code is function findBalance(id){ MongoClient.connect(url, function(err, db) { if (err) throw ...
user avatar
1 vote
1 answer
2k views

Trouble connecting to local MongoDB server through app.js

I'm a newbie to MongoDB, and I just set up MongoDB within my Ubuntu terminal with mongod and mongo commands running in separate terminals. However, I can't get my app.js that would launch a website to ...
user avatar
0 votes
1 answer
47 views

Migrating timezone timestamps

I am trying to migrate this node library https://github.com/LocalSEOGuide/lighthouse-reporter from Postgres to MySQL and getting an error error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '...
user avatar
  • 101