Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Feature Requests
  3. MariaDB Addon

MariaDB Addon

Scheduled Pinned Locked Moved Feature Requests
3 Posts 2 Posters 600 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • njN Offline
      njN Offline
      nj
      wrote on last edited by nj
      #1

      Some apps like ERPNext are only optimized for MariaDB and use MariaDB specific features. Slowly MariaDB is getting incompatible with MySQL by adding features like custom sequences not available in MySQL.

      From a Cloudron dev’s POV, adding MariaDB as an addon is a trivial task because MySQL is already there. Please add MariaDB as an addon. Thank you!

      Founder / Coder • My Apps

      girishG 1 Reply Last reply
      6
      • njN nj

        Some apps like ERPNext are only optimized for MariaDB and use MariaDB specific features. Slowly MariaDB is getting incompatible with MySQL by adding features like custom sequences not available in MySQL.

        From a Cloudron dev’s POV, adding MariaDB as an addon is a trivial task because MySQL is already there. Please add MariaDB as an addon. Thank you!

        girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #2

        @nj Thanks for all the hard work on ERPNext - https://forum.cloudron.io/topic/1228/erpnext-cost-effective-erp-solution/ (for others to follow). My understanding is that the app will still need to be an "admin" is it? With the flexibility to create multiple databases.

        We had phabricator which wanted similar support. MySQL addon supports this via multipleDatabases flag . Is this enough ?

        njN 1 Reply Last reply
        1
        • girishG girish

          @nj Thanks for all the hard work on ERPNext - https://forum.cloudron.io/topic/1228/erpnext-cost-effective-erp-solution/ (for others to follow). My understanding is that the app will still need to be an "admin" is it? With the flexibility to create multiple databases.

          We had phabricator which wanted similar support. MySQL addon supports this via multipleDatabases flag . Is this enough ?

          njN Offline
          njN Offline
          nj
          wrote on last edited by nj
          #3

          @girish I have figured out a solution that doesn’t require admin permissions to ERPNext. It’s just that they use MariaDB specific commands here and there. That’s why MySQL addon is not useful at all.

          Multiple databases works kinda fine but needs patching the source because ERPNext likes to use the same value for db-user and db-name; in fact there’s no way to give it the db-user. The name of the database is itself is considered username.

          While building this addon, I would recommend setting the user’s name and database the same - ie. without prepending the same string with ‘db’ or ‘user’

          Multiple databases isn’t required as ERPNext doesn’t work really well as a multi-site ERP anyway.

          Founder / Coder • My Apps

          1 Reply Last reply
          2
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • Bookmarks
            • Search