Amazon RDS for PostgreSQL vs Amazon SQS

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL

404
183
+ 1
37
Amazon SQS
Amazon SQS

1K
496
+ 1
126
Add tool

Amazon RDS for PostgreSQL vs Amazon SQS: What are the differences?

Developers describe Amazon RDS for PostgreSQL as "* Set up, operate, and scale PostgreSQL deployments in the cloud". 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. On the other hand, *Amazon SQS** is detailed as "Fully managed message queuing service". Transmit any volume of data, at any level of throughput, without losing messages or requiring other services to be always available. With SQS, you can offload the administrative burden of operating and scaling a highly available messaging cluster, while paying a low price for only what you use.

Amazon RDS for PostgreSQL belongs to "PostgreSQL as a Service" category of the tech stack, while Amazon SQS can be primarily classified under "Message Queue".

Some of the features offered by Amazon RDS for PostgreSQL are:

  • Monitoring and Metrics –Amazon RDS provides Amazon CloudWatch metrics for you DB Instance deployments at no additional charge.
  • DB Event Notifications –Amazon RDS provides Amazon SNS notifications via email or SMS for your DB Instance deployments.
  • Automatic Software Patching – Amazon RDS will make sure that the PostgreSQL software powering your deployment stays up-to-date with the latest patches.

On the other hand, Amazon SQS provides the following key features:

  • A queue can be created in any region.
  • The message payload can contain up to 256KB of text in any format. Each 64KB ‘chunk’ of payload is billed as 1 request. For example, a single API call with a 256KB payload will be billed as four requests.
  • Messages can be sent, received or deleted in batches of up to 10 messages or 256KB. Batches cost the same amount as single messages, meaning SQS can be even more cost effective for customers that use batching.

"Easy setup, backup, monitoring" is the top reason why over 22 developers like Amazon RDS for PostgreSQL, while over 45 developers mention "Easy to use, reliable" as the leading cause for choosing Amazon SQS.

According to the StackShare community, Amazon SQS has a broader approval, being mentioned in 381 company stacks & 101 developers stacks; compared to Amazon RDS for PostgreSQL, which is listed in 164 company stacks and 27 developer stacks.

No Stats
- No public GitHub repository available -
- No public GitHub repository available -

What is 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.

What is Amazon SQS?

Transmit any volume of data, at any level of throughput, without losing messages or requiring other services to be always available. With SQS, you can offload the administrative burden of operating and scaling a highly available messaging cluster, while paying a low price for only what you use.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Amazon RDS for PostgreSQL?
Why do developers choose Amazon SQS?

Sign up to add, upvote and see more prosMake informed product decisions

    Be the first to leave a con
    What companies use Amazon RDS for PostgreSQL?
    What companies use Amazon SQS?

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Amazon RDS for PostgreSQL?
    What tools integrate with Amazon SQS?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to Amazon RDS for PostgreSQL and Amazon SQS?
    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
    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 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.
    ElephantSQL
    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.
    Database Labs
    We manage an optimized Postgres image. You focus on your core app, not on becoming a database administrator.
    See all alternatives
    Decisions about Amazon RDS for PostgreSQL and Amazon SQS
    FWScience
    FWScience
    Amazon DynamoDB
    Amazon DynamoDB
    Amazon RDS for PostgreSQL
    Amazon RDS for PostgreSQL

    We use Amazon RDS for PostgreSQL because RDS and Amazon DynamoDB are two distinct database systems. DynamoDB is NoSQL DB whereas RDS is a relational database on the cloud. The pricing will mainly differ in the type of application you are using and your requirements. For some applications, both DynamoDB and RDS, can serve well, for some it might not. I do not think DynamoDB is cheaper. Right now we are helping Companies in Silicon Valley and in Southern California go SERVERLESS - drastically lowering costs if you are interested in hearing how we go about it.

    See more
    Amazon RDS
    Amazon RDS
    Heroku Postgres
    Heroku Postgres
    Amazon RDS for PostgreSQL
    Amazon RDS for PostgreSQL
    Amazon EBS
    Amazon EBS
    PostgreSQL
    PostgreSQL
    Amazon EC2
    Amazon EC2

    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
    Interest over time
    Reviews of Amazon RDS for PostgreSQL and Amazon SQS
    No reviews found
    How developers use Amazon RDS for PostgreSQL and Amazon SQS
    Avatar of Karma
    Karma uses Amazon SQSAmazon SQS

    In the beginning we thought we wanted to start using something like RabbitMQ or maybe Kafka or maybe ActiveMQ. Back then we only had a few developers and no ops people. That has changed now, but we didn't really look forward to setting up a queuing cluster and making sure that all works.

    What we did instead was we looked at what services Amazon offers to see if we can use those to build our own messaging system within those services. That's basically what we did. We wrote some clients in Ruby that can basically do the entire orchestration for us, and we run all our messaging on both SNS and SQS. Basically what you can do in Amazon services is you can use Amazon Simple Notification Service, so SNS, for creating topics and you can use queues to subscribe to these topics. That's basically all you need for a messaging system. You don't have to worry about scalability at all. That's what really appealed to us.

    Avatar of Brandon Adams
    Brandon Adams uses Amazon SQSAmazon SQS

    This isn't exactly low-latency (10s to 100s of milliseconds), but it has good throughput and a simple API. There is good reliability, and there is no configuration necessary to get up and running. A hosted queue is important when trying to move fast.

    Avatar of Simple Merchant
    Simple Merchant uses Amazon SQSAmazon SQS

    SQS is the bridge between our new Lambda services and our incumbent Rails applications. Extremely easy to use when you're already using other AWS infrastructure.

    Avatar of Olo
    Olo uses Amazon SQSAmazon SQS

    Primary message queue. Enqueueing operations revert to a local file-system-based queue when SQS is unavailable.

    Avatar of IndiTip
    IndiTip uses Amazon SQSAmazon SQS

    I can't afford to lose data if Dynamo throttles my writes, so everything goes into a message queue first.

    Avatar of Mark Walle
    Mark Walle uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

    Using PostGIS to serve GeoJSON data for the Leaflet front-end.

    Avatar of Tinkhaven
    Tinkhaven uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

    Main relational DB engine

    Avatar of Solcast
    Solcast uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

    Store and query data

    How much does Amazon RDS for PostgreSQL cost?
    How much does Amazon SQS cost?
    Pricing unavailable