mxql
v1.0.5
Published
Easier SQL queries.
Downloads
14
Readme
MXQL
An extremly small library that makes queries easier (at least for me).
Installation
npm install mxql
Usage
Import
import MXQL from "mxql";
Query
const config = {
host: "database_host",
user: "database_user",
password: "database_password",
database: "database_name"
}
const db = new MXQL(config)
const result = await db.query("SELECT * FROM table WHERE condition = ?", ["value"]);
console.log(result) // Logs rows and fields based on the condition.
QueryBuilder
Alternatively you can use the QueryBuilder to execute queries:
import { QueryBuilder } from "mxql";
const config = {
host: "database_host",
user: "database_user",
password: "database_password",
database: "database_name"
}
const qb = new QueryBuilder(config)
const result = await qb.select("*").from("table").where("condition = ?").values("value").run()
console.log(result) // Logs rows and fields based on the condition.
[!WARNING] The QueryBuilder is experimental and I have barely made any functions for it yet.
Features
The main feature is to make queries simpler because I find the standard mysql library query syntax unnecessarily annoying to use. That is also the reason I made this library in the first place. I know that it's nothing special but it makes life a little easier for me. There are more features planned though.
[!NOTE] This library was only made to improve my coding experience. Feel free to test it out or suggest changes but don't expect it to be anything special.