
Product
Introducing Scala and Kotlin Support in Socket
Socket now supports Scala and Kotlin, bringing AI-powered threat detection to JVM projects with easy manifest generation and fast, accurate scans.
mysql2-json-sql
Advanced tools
The idea is migrating from nosql db to relational db without any changes, using json as query and result
MySQL2 wrapper for Node.js with json interface. Supports prepared transactional
npm install mysql2-json-sql
// Include mysql2-json
// for example: schema test_db contains table test
const mysql = require('mysql2-json-sql');
const db = mysql({
host: 'localhost',
user: 'test',
password: '',
database: 'test_db',
waitForConnections: true,
connectionLimit: 5,
queueLimit: 0
});
// use table manually
const test = db.test_db.table('test');
// or load all tables automatically
const tables = await db.test_db.tables();
// after loading table we can use 3 type of code
// #1 get data from table directly
test.find({_id:12},(err,result)=>{
console.log(result);
})
// #2 get data from tables
tables.test.find({_id:12},(err,result)=>{
console.log(result);
})
// #3 get data from db
db.test_db.test.find({_id:12},(err,result)=>{
console.log(result);
})
response
[{
"_id":12, "name": "test"
}]
var data = { _id:13, name: 'world'};
db.test_db.test.insert(data, function (err, newDoc) { // Callback is optional
// newDoc is the newly inserted document, including its _id
// newDoc has no key called notToBeSaved since its value was undefined
});
we can do bulk-insert data also
db.test_db.test.insert([{ _id: 14, name: 'hello' }, { _id: 15, name:'word' }], function (err, newDocs) {
// Two documents were inserted in the database
// newDocs is an array with these documents, augmented with their _id
});
// Finding all planets in the solar system
db.test_db.test.find({ name: 'world' }, function (err, docs) {
// docs is an array containing documents Mars, Earth, Jupiter
// If no document is found, docs is equal to []
});
FAQs
The idea is migrating from nosql db to relational db without any changes, using json as query and result
The npm package mysql2-json-sql receives a total of 0 weekly downloads. As such, mysql2-json-sql popularity was classified as not popular.
We found that mysql2-json-sql demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Product
Socket now supports Scala and Kotlin, bringing AI-powered threat detection to JVM projects with easy manifest generation and fast, accurate scans.
Application Security
/Security News
Socket CEO Feross Aboukhadijeh and a16z partner Joel de la Garza discuss vibe coding, AI-driven software development, and how the rise of LLMs, despite their risks, still points toward a more secure and innovative future.
Research
/Security News
Threat actors hijacked Toptal’s GitHub org, publishing npm packages with malicious payloads that steal tokens and attempt to wipe victim systems.