Possible to use mysql database?



  • I'm looking to use nodebb to run debates and will eventually require integration with our customer database - mysql. This would also allow us to develop integration with our favoured cms. I know the word "mysql" is anathema round here but is this possible? It would surely open nodebb up to a much larger market.


  • Plugin & Theme Dev

    Possible, of cause but it'd be heavy effort and a step into the wrong (in my opinion) direction.
    But you asked whether it's possible...

    So... You'd need to implement an appropriate to one of the available (redis, mongodb, leveldb) interfaces: https://github.com/NodeBB/NodeBB/tree/master/src/database
    I guess with sth. like https://github.com/mysql/mysql-js it shouldn't be too hard to do so.
    But still much work to do (and to maintain) and I doubt that any of the devs around here is willing to do this (at least without 🎁).

    @babaggeii said:

    It would surely open nodebb up to a much larger market.

    I doubt that it'd get much larger since those who insist in SQL-database types are mostly those who are afraid of new (and better in many cases) technology such as node.js.



  • Thanks for the reply. That is as I thought - this isn't necessarily about being afraid of the new, but about not having the expertise in place to take advantage of it. It does make it harder for us to use nodebb for our business as we need to factor higher developmermt and maintenance costs. It may well put it beyond our means.


  • Admin

    We've had good success scaling a large/active forum on mongodb, so if that's what you're worried about (ie. high costs associated with Redis + RAM) then it's an option. Otherwise, if anybody is willing to write a MySQL adapter I'll be more than willing to help when you get stuck.

    p.s. "somebody" might be in the process of writing a PostgreSQL adapter. I'm not going to divulge any details until next week because I'd be promising somebody else's promise. Let's see what happens come Monday 😉



  • @psychobunny the main issue is integration with our current systems. Postgres would go a long way to solving that! We're several months from going live though, so I'll follow the development avidly.


  • Admin

    Sounds good 🙂



  • @psychobunny I think we should focus on secodary database. I read the docs and it said still on development.
    I think this option is better than mySQL because of incredible performance of redis.



  • It is probabbly completely out of date, but can be worth a fast look:

    https://github.com/pasindud/nodebb



  • @José-Ángel-Rey-Liñares "version": "0.1.0",

    Yepp, exceptionally out of date.


 

Suggested Topics

| |