Base

The best place to start, of course.

Installing better-mysql

First, we need to install better-mysql. This is not that hard. You need NodeJS, you can download that here.

If you have NodeJS (and NPM, this will be in the installation), run this command at your projectfolder:

npm i -s better-mysql

Logging in to the account

Next, we have to login to the account of the mysql databases. Do that with the host, username and password.

For all the examples we use db4free.net. As they website says: This is experimental. So, don't use it for real projects!

Make a file in your projectfolder with the extention .js, like bot.js, server.js or index.js.

const mysql = require("better-mysql");
let client = new mysql.client({
    host: "db4free.net",
    user: "YOURUSERNAME",
    pass: "YOURPASSWORD123"
)};

Let's look at the code: In the first line we load the module and set it in a contant variable called mysql. A constant variable can't be chanced, so it can't do any harm later. In line two we make the client. The module returns a object. Later the mysql server will also be in there, but for now you only have the client. The client is a class. That means that you can have more mysql connections at the same time. Each connection doesn't interfere with a other and all the instances haves the same functions. The functions are on the variabel client. In line three we give up the host. This chould be a string. This example is with db4free.net. In line four we give up the username. You can use user and usernameand it chould be a string. In line five we give up the password. You can use passand passwordand it chould be a string. And line six is just a end of the start.

Queues

By default, the queues are on. There isn't a option to fully disable queues, but you can set the interval time very low. You can set the queue to very low with the option queue in the client constructor. If you want to chance the default interval, what is 500 ms, you can do that with the option queueInterval. Here are some examples.

Setting the interval to 1000ms

const mysql = require("better-mysql");
let client = new mysql.client({
    // Loging in
    host: "db4free.net",
    user: "YOURUSERNAME",
    pass: "YOURPASSWORD123",
    
    // Queue
    queueInterval: 1000
)};

Turning the queue off

const mysql = require("better-mysql");
let client = new mysql.client({
    // Loging in
    host: "db4free.net",
    user: "YOURUSERNAME",
    pass: "YOURPASSWORD123",
    
    // Queue
    queue: false
)};

See the databases

To make/connect to a table, we have to use a database. But it can come in handy if you want to see the databases before we connect to a database. That can be done by those two lines of code:

Main example

let databases = await client.getDatabases();
console.log(databases);

Compact

console.log(await client.getDatabases());

As you can see, there are two examples: The main example and the compact example. The two examples uses the same code and calling the same function.

But the main example is storing the databases in a variable and then logging the variable, and the compact example is logging the return of the function.

Both examples are using async and await, becouse we have to get a connection to the database. But, if you don't want to or don't know how to use async, you can also use .then! Here is a example of using .then.

client.getDatabases().then(databases => {
    console.log(databases);
});

Selecting a database

Now, let's select a database!

Making a database

There are some issues with making a database. In the next version those issues are fixed. Sorry for this!

Loading a database

If you already have a database, you can load it, so you can make/use tables! The database we are going to load is called example. There are two ways, with await and with .then.

Await example

let database = await client.loadDatabase("example");
// Use the variable "database" for using/creating a table.

.then example

client.loadDatabase("example").then(database => {
    // Use the variable "database" for using/creating a table.
});

Renaming a database

If you want to rename a database, you can do that too! Just use the client.renameDatabasefunction! Here is an example. The database called exxample will be renamed to example.

Await example

await client.renameDatabase("exxample", "example");
// Done!

.then example

client.renameDatabase("exxample", "example").then(() => {
    // Done!
});

Deleting a database

You can delete a database with the client.deleteDatabase function! Here is an example where the database example will be deleted.

Await example

await client.deleteDatabase("example");
// Done!

.then example

client.deleteDatabase("example").then(() => {
    // Done!
});