Adding MySQL to NodeBB

[xaoseric]

I did some looking around on the npm packages site (always a scary thought), found a couple MySQL packages that provide orm style interaction. Below are the packages I am thinking we could use to integrate mysql.

http://bookshelfjs.org - Bookshelf would provide the orm: Models
http://knexjs.org - sql builder
https://www.npmjs.org/package/mysql - the MySQL package itself

Does anyone know of better packages? Using Knex, and Bookshelf looks like we could do object oriented sql interaction.

[xaoseric]

In terms of Scaling, with MySQL, we could allow MySQL clusters to be used :).

Edit: I have commented the necessary files that should get us started on adding MySQL. I have also submitted a pull request. Knex, and Bookshelf are being used as they provide ORM interfaces to interact with SQL based databases.

[julian]

I noticed you have a MySQL integration PR open with the main repo right now -- is it actually usable?

[xaoseric]

@julian said:

I noticed you have a MySQL integration PR open with the main repo right now -- is it actually usable?

It will be :), doesn't break anything as of right now . First step to geting it integraded is adding the module for it.

Edit: In the long run, it will allow people more comfertable with mysql to use NodeBB .

[bentael]

technically, it does break if someone tries to use it