Alternatives to ElephantSQL logo

Alternatives to ElephantSQL

Heroku, Amazon RDS for PostgreSQL, Heroku Postgres, Google Cloud SQL for PostgreSQL, and Azure Database for PostgreSQL are the most popular alternatives and competitors to ElephantSQL.
9
40
+ 1
10

What is ElephantSQL and what are its top alternatives?

ElephantSQL hosts PostgreSQL on Amazon EC2 in multiple regions and availability zones. The servers are continuously transferring the Write-Ahead-Log (the transaction log) to S3 for maximum reliability.
ElephantSQL is a tool in the PostgreSQL as a Service category of a tech stack.

Top Alternatives to ElephantSQL

  • Heroku

    Heroku

    Heroku is a cloud application platform – a new way of building and deploying web apps. Heroku lets app developers spend 100% of their time on their application code, not managing servers, deployment, ongoing operations, or scaling. ...

  • Amazon RDS for PostgreSQL

    Amazon RDS for PostgreSQL

    Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and back-ups for disaster recovery. With just a few clicks in the AWS Management Console, you can deploy a PostgreSQL database with automatically configured database parameters for optimal performance. Amazon RDS for PostgreSQL database instances can be provisioned with either standard storage or Provisioned IOPS storage. Once provisioned, you can scale from 10GB to 3TB of storage and from 1,000 IOPS to 30,000 IOPS. ...

  • Heroku Postgres

    Heroku Postgres

    Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management. ...

  • Google Cloud SQL for PostgreSQL

    Google Cloud SQL for PostgreSQL

    Cloud SQL offers high performance, scalability, and convenience. Hosted on Google Cloud Platform, Cloud SQL provides a database infrastructure for applications running anywhere. ...

  • Azure Database for PostgreSQL

    Azure Database for PostgreSQL

    Azure Database for PostgreSQL provides a managed database service for app development and deployment that allows you to stand up a PostgreSQL database in minutes and scale on the fly – on the cloud you trust most. ...

  • Database Labs

    Database Labs

    We manage an optimized Postgres image. You focus on your core app, not on becoming a database administrator. ...

  • PaaS DB PostgreSQL

    PaaS DB PostgreSQL

    A simple product to get an operational database without any pain about server management, security settings and upgrading. We provide resources to instanciate your database (PostgreSQL 9.4). Our goal is to propose this service with an hourly billing. ...

ElephantSQL alternatives & related posts

related Heroku posts

Russel Werner
Lead Engineer at StackShare · | 29 upvotes · 1.3M views

StackShare Feed is built entirely with React, Glamorous, and Apollo. One of our objectives with the public launch of the Feed was to enable a Server-side rendered (SSR) experience for our organic search traffic. When you visit the StackShare Feed, and you aren't logged in, you are delivered the Trending feed experience. We use an in-house Node.js rendering microservice to generate this HTML. This microservice needs to run and serve requests independent of our Rails web app. Up until recently, we had a mono-repo with our Rails and React code living happily together and all served from the same web process. In order to deploy our SSR app into a Heroku environment, we needed to split out our front-end application into a separate repo in GitHub. The driving factor in this decision was mostly due to limitations imposed by Heroku specifically with how processes can't communicate with each other. A new SSR app was created in Heroku and linked directly to the frontend repo so it stays in-sync with changes.

Related to this, we need a way to "deploy" our frontend changes to various server environments without building & releasing the entire Ruby application. We built a hybrid Amazon S3 Amazon CloudFront solution to host our Webpack bundles. A new CircleCI script builds the bundles and uploads them to S3. The final step in our rollout is to update some keys in Redis so our Rails app knows which bundles to serve. The result of these efforts were significant. Our frontend team now moves independently of our backend team, our build & release process takes only a few minutes, we are now using an edge CDN to serve JS assets, and we have pre-rendered React pages!

#StackDecisionsLaunch #SSR #Microservices #FrontEndRepoSplit

See more
Simon Reymann
Senior Fullstack Developer at QUANTUSflow Software GmbH · | 27 upvotes · 1.8M views

Our whole DevOps stack consists of the following tools:

  • GitHub (incl. GitHub Pages/Markdown for Documentation, GettingStarted and HowTo's) for collaborative review and code management tool
  • Respectively Git as revision control system
  • SourceTree as Git GUI
  • Visual Studio Code as IDE
  • CircleCI for continuous integration (automatize development process)
  • Prettier / TSLint / ESLint as code linter
  • SonarQube as quality gate
  • Docker as container management (incl. Docker Compose for multi-container application management)
  • VirtualBox for operating system simulation tests
  • Kubernetes as cluster management for docker containers
  • Heroku for deploying in test environments
  • nginx as web server (preferably used as facade server in production environment)
  • SSLMate (using OpenSSL) for certificate management
  • Amazon EC2 (incl. Amazon S3) for deploying in stage (production-like) and production environments
  • PostgreSQL as preferred database system
  • Redis as preferred in-memory database/store (great for caching)

The main reason we have chosen Kubernetes over Docker Swarm is related to the following artifacts:

  • Key features: Easy and flexible installation, Clear dashboard, Great scaling operations, Monitoring is an integral part, Great load balancing concepts, Monitors the condition and ensures compensation in the event of failure.
  • Applications: An application can be deployed using a combination of pods, deployments, and services (or micro-services).
  • Functionality: Kubernetes as a complex installation and setup process, but it not as limited as Docker Swarm.
  • Monitoring: It supports multiple versions of logging and monitoring when the services are deployed within the cluster (Elasticsearch/Kibana (ELK), Heapster/Grafana, Sysdig cloud integration).
  • Scalability: All-in-one framework for distributed systems.
  • Other Benefits: Kubernetes is backed by the Cloud Native Computing Foundation (CNCF), huge community among container orchestration tools, it is an open source and modular tool that works with any OS.
See more
Amazon RDS for PostgreSQL logo

Amazon RDS for PostgreSQL

633
436
39
Set up, operate, and scale PostgreSQL deployments in the cloud
633
436
+ 1
39

related Amazon RDS for PostgreSQL posts

I could spin up an Amazon EC2 instance and install PostgreSQL myself, review latest configuration best practices, sort Amazon EBS storage for data, set up a snapshot process etc.

Alternatively I could use Amazon RDS, Amazon RDS for PostgreSQL or Heroku Postgres and have most of that work handled for me, by a team of world experts...

See more
Heroku Postgres logo

Heroku Postgres

317
232
37
Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL
317
232
+ 1
37

related Heroku Postgres posts

I could spin up an Amazon EC2 instance and install PostgreSQL myself, review latest configuration best practices, sort Amazon EBS storage for data, set up a snapshot process etc.

Alternatively I could use Amazon RDS, Amazon RDS for PostgreSQL or Heroku Postgres and have most of that work handled for me, by a team of world experts...

See more
Tim Nolet
Founder, Engineer & Dishwasher at Checkly · | 10 upvotes · 123.5K views

PostgreSQL Heroku Heroku Postgres Node.js Knex.js

Last week we rolled out a simple patch that decimated the response time of a Postgres query crucial to Checkly. It quite literally went from an average of ~100ms with peaks to 1 second to a steady 1ms to 10ms.

However, that patch was just the last step of a longer journey:

  1. I looked at what API endpoints were using which queries and how their response time grew over time. Specifically the customer facing API endpoints that are directly responsible for rendering the first dashboard page of the product are crucial.

  2. I looked at the Heroku metrics such as those reported by heroku pg:outlier and cross references that with "slowest response time" statistics.

  3. I reproduced the production situation as best as possible on a local development machine and test my hypothesis that an composite index on a uuid field and a timestampz field would reduce response times.

This method secured the victory and we rolled out a new index last week. Response times plummeted. Read the full story in the blog post.

See more
Google Cloud SQL for PostgreSQL logo

Google Cloud SQL for PostgreSQL

95
71
0
Fully-managed database service- set up, maintain, manage, and administer your relational PostgreSQL databases in the cloud
95
71
+ 1
0
PROS OF GOOGLE CLOUD SQL FOR POSTGRESQL
    No pros available
    CONS OF GOOGLE CLOUD SQL FOR POSTGRESQL
      No cons available

      related Google Cloud SQL for PostgreSQL posts

      Azure Database for PostgreSQL logo

      Azure Database for PostgreSQL

      30
      54
      0
      Managed PostgreSQL database service for app developers
      30
      54
      + 1
      0
      PROS OF AZURE DATABASE FOR POSTGRESQL
        No pros available
        CONS OF AZURE DATABASE FOR POSTGRESQL
          No cons available

          related Azure Database for PostgreSQL posts

          Database Labs logo

          Database Labs

          6
          11
          2
          Deploy a cloud Postgres server in 1 minute.
          6
          11
          + 1
          2

          related Database Labs posts

          PaaS DB PostgreSQL logo

          PaaS DB PostgreSQL

          1
          8
          0
          Get a managed database ready to use
          1
          8
          + 1
          0
          PROS OF PAAS DB POSTGRESQL
            No pros available
            CONS OF PAAS DB POSTGRESQL
              No cons available

              related PaaS DB PostgreSQL posts