1. 7

Folks!

Does anybody know of a simple provider that lets me:

  • Pick a database (MariaDB, Postgres, Mongo, whatever)
  • Pick a topology for resiliency/backups/read-followers, whatever
  • Point my application to the thing
  • Optionally provide shell/Web access to manage my database.

The only options I see are either:

  • Amazon/Google who have a bajillion more options than I care about (and want to spin up whole machies)
  • Shitty web hosts (Hostgator, etc.) that have a sideline in barebones PHP databases with exploits and blogs built in.

Any suggestions?

  1.  

  2. 5

    I’ve never used them before, but it sounds like Compose.io would fit the bill.

    1. 1

      Nifty, will take a look.

    2. 5

      Amazon RDS is fantastic. Don’t discount it as an option. Especially with their reserved instance pricing.

      1. 4

        You dismissed amazon and Google for being too complicated, and they are, but it’s worth learning those systems, especially if the alternative is a raw db connection over the public Internet.

        1. 2

          There are times where a raw db connection over the internet (or via VPN or secure sockets) is exactly what I’m looking for.

          The problem I’m trying to solve is as-spec'ced; if I wanted a learning exercise in Amazon and Google, I would’ve asked for a link to the AWS/Compute Engine documentation.

        2. 3

          This is not a direct answer but Heroku’s add-on’s might be a good starting point:

          https://elements.heroku.com/addons

          Also, a convoluted solution would be to create a free Heroku application, install a Heroku PostgreSQL add-on, and use its URL (has CLI integration, backup support, multiple followers, enforces SSL connections only). However, you are probably better off using AWS since I think it would be cheaper.

          1. 4

            Building on this, Heroku Postgres might be a better option:

            https://www.heroku.com/postgres

            1. 1

              And thank you to you folks as well!

          2. 3

            The various options for this tend to be database specific, so pick which database you want, then go looking.

            For Postgres, Heroku is well regarded. For RethinkDB, Compose is good.

            1. 2

              I would use Google Cloud SQL, but i also have a friend who’s happy with ClearDB in production (SaaS).