
Security News
Official Go SDK for MCP in Development, Stable Release Expected in August
The official Go SDK for the Model Context Protocol is in development, with a stable, production-ready release expected by August 2025.
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 34 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 0 open source maintainers 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.
Security News
The official Go SDK for the Model Context Protocol is in development, with a stable, production-ready release expected by August 2025.
Security News
New research reveals that LLMs often fake understanding, passing benchmarks but failing to apply concepts or stay internally consistent.
Security News
Django has updated its security policies to reject AI-generated vulnerability reports that include fabricated or unverifiable content.