//SQLite example
//using Node.js
//npm install sqlite3
// Connect to the database
const sqlite3 = require('sqlite3');
let db = new sqlite3.Database('DatabaseName.db', (err) => {
if (err) {
return console.error(err);
}
});
let sql = `
SELECT
Language, Percentage
FROM countrylanguage
WHERE
CountryCode = ? AND
Percentage > ?`;
let stmt = db.prepare(sql);
db.serialize(() => {
// SQL query execution
stmt.each(["RUS", 0.5], (_, row) => {
console.log(row.Language + ": " +
row.Percentage);
});
});
stmt.finalize();
db.close();