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

815
604
+ 1
40
Amazon SQS

2.3K
2K
+ 1
171
Add tool

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

Amazon RDS for PostgreSQL and Amazon SQS are two different AWS services with distinct functionalities. In this comparison, we will focus on highlighting the key differences between these two services.

  1. Data Storage vs Message Queueing: The primary difference between Amazon RDS for PostgreSQL and Amazon SQS lies in their core functionalities. RDS for PostgreSQL is a managed relational database service that provides storage and retrieval of structured data, while SQS is a fully managed message queuing service that enables decoupling of components in distributed systems.

  2. Data Persistence vs Data Transmission: Another major difference is in how these services handle data. RDS for PostgreSQL provides durable storage for data and allows users to write, read, and modify the data directly. On the other hand, SQS enables message transmission between different components, allowing for asynchronous and reliable communication.

  3. Structured Data vs Unstructured Messages: RDS for PostgreSQL focuses on storing and retrieving structured data in a tabular format, making it ideal for transactional and analytical workloads. In contrast, SQS handles unstructured messages, allowing developers to pass messages between systems without the need for tight coupling.

  4. Database Management vs Event-driven Communication: RDS for PostgreSQL provides a managed database environment, taking care of backups, patching, and scalability. It is suitable for scenarios where data consistency and database management are critical. SQS, on the other hand, facilitates event-driven communication between distributed systems, making it ideal for asynchronous and loosely coupled architectures.

  5. Real-time Data Access vs Delayed Processing: With RDS for PostgreSQL, data can be accessed and modified in real-time, ensuring immediate consistency for applications relying on up-to-date data. In contrast, SQS operates asynchronously, allowing for delayed message processing and reducing dependencies between different components.

  6. Scaling Constraints: When it comes to scaling, RDS for PostgreSQL provides vertical scaling where users can increase the compute and storage capacity of a database instance. In contrast, SQS offers horizontal scalability, allowing users to handle increased message traffic by adding more message queues or leveraging features like message sharding.

In summary, Amazon RDS for PostgreSQL focuses on data storage and retrieval, providing a managed relational database service. On the other hand, Amazon SQS enables asynchronous and reliable message transmission, facilitating decoupling and event-driven communication in distributed systems.

Advice on Amazon RDS for PostgreSQL and Amazon SQS
Pulkit Sapra
Needs advice
on
Amazon SQSAmazon SQSKubernetesKubernetes
and
RabbitMQRabbitMQ

Hi! I am creating a scraping system in Django, which involves long running tasks between 1 minute & 1 Day. As I am new to Message Brokers and Task Queues, I need advice on which architecture to use for my system. ( Amazon SQS, RabbitMQ, or Celery). The system should be autoscalable using Kubernetes(K8) based on the number of pending tasks in the queue.

See more
Replies (1)
Anis Zehani
Recommends
on
KafkaKafka

Hello, i highly recommend Apache Kafka, to me it's the best. You can deploy it in cluster mode inside K8S, thus you can have a Highly available system (also auto scalable).

Good luck

See more
Meili Triantafyllidi
Software engineer at Digital Science · | 6 upvotes · 489.3K views
Needs advice
on
Amazon SQSAmazon SQSRabbitMQRabbitMQ
and
ZeroMQZeroMQ

Hi, we are in a ZMQ set up in a push/pull pattern, and we currently start to have more traffic and cases that the service is unavailable or stuck. We want to: * Not loose messages in services outages * Safely restart service without losing messages (ZeroMQ seems to need to close the socket in the receiver before restart manually)

Do you have experience with this setup with ZeroMQ? Would you suggest RabbitMQ or Amazon SQS (we are in AWS setup) instead? Something else?

Thank you for your time

See more
Replies (2)
Shishir Pandey
Recommends
on
RabbitMQRabbitMQ

ZeroMQ is fast but you need to build build reliability yourself. There are a number of patterns described in the zeromq guide. I have used RabbitMQ before which gives lot of functionality out of the box, you can probably use the worker queues example from the tutorial, it can also persists messages in the queue.

I haven't used Amazon SQS before. Another tool you could use is Kafka.

See more
Kevin Deyne
Principal Software Engineer at Accurate Background · | 5 upvotes · 224.8K views
Recommends
on
RabbitMQRabbitMQ

Both would do the trick, but there are some nuances. We work with both.

From the sound of it, your main focus is "not losing messages". In that case, I would go with RabbitMQ with a high availability policy (ha-mode=all) and a main/retry/error queue pattern.

Push messages to an exchange, which sends them to the main queue. If an error occurs, push the errored out message to the retry exchange, which forwards it to the retry queue. Give the retry queue a x-message-ttl and set the main exchange as a dead-letter-exchange. If your message has been retried several times, push it to the error exchange, where the message can remain until someone has time to look at it.

This is a very useful and resilient pattern that allows you to never lose messages. With the high availability policy, you make sure that if one of your rabbitmq nodes dies, another can take over and messages are already mirrored to it.

This is not really possible with SQS, because SQS is a lot more focused on throughput and scaling. Combined with SNS it can do interesting things like deduplication of messages and such. That said, one thing core to its design is that messages have a maximum retention time. The idea is that a message that has stayed in an SQS queue for a while serves no more purpose after a while, so it gets removed - so as to not block up any listener resources for a long time. You can also set up a DLQ here, but these similarly do not hold onto messages forever. Since you seem to depend on messages surviving at all cost, I would suggest that the scaling/throughput benefit of SQS does not outweigh the difference in approach to messages there.

See more
MITHIRIDI PRASANTH
Software Engineer at LightMetrics · | 4 upvotes · 296.3K views
Needs advice
on
Amazon MQAmazon MQ
and
Amazon SQSAmazon SQS
in

I want to schedule a message. Amazon SQS provides a delay of 15 minutes, but I want it in some hours.

Example: Let's say a Message1 is consumed by a consumer A but somehow it failed inside the consumer. I would want to put it in a queue and retry after 4hrs. Can I do this in Amazon MQ? I have seen in some Amazon MQ videos saying scheduling messages can be done. But, I'm not sure how.

See more
Replies (1)
Andres Paredes
Lead Senior Software Engineer at InTouch Technology · | 1 upvotes · 225.1K views
Recommends
on
Amazon SQSAmazon SQS

Mithiridi, I believe you are talking about two different things. 1. If you need to process messages with delays of more 15m or at specific times, it's not a good idea to use queues, independently of tool SQM, Rabbit or Amazon MQ. you should considerer another approach using a scheduled job. 2. For dead queues and policy retries RabbitMQ, for example, doesn't support your use case. https://medium.com/@kiennguyen88/rabbitmq-delay-retry-schedule-with-dead-letter-exchange-31fb25a440fc I'm not sure if that is possible SNS/SQS support, they have a maximum delay for delivery (maxDelayTarget) in seconds but it's not clear the number. You can check this out: https://docs.aws.amazon.com/sns/latest/dg/sns-message-delivery-retries.html

See more

Considering moving part of our PostgreSQL database infrastructure to the cloud, however, not quite sure between AWS, Heroku, Azure and Google cloud. Things to consider: The main reason is for backing up and centralize all our data in the cloud. With that in mind the main elements are: -Pricing for storage. -Small team. -No need for high throughput. -Support for docker swarm and Kubernetes.

See more
Replies (2)
David Weinberg

Good balance between easy to manage, pricing, docs and features.

See more
Max Musing
Founder & CEO at BaseDash · | 1 upvotes · 50K views

DigitalOcean's offering is pretty solid. Easy to scale, great UI, automatic daily backups, decent pricing.

See more
Manage your open source components, licenses, and vulnerabilities
Learn More
Pros of Amazon RDS for PostgreSQL
Pros of Amazon SQS
  • 25
    Easy setup, backup, monitoring
  • 13
    Geospatial support
  • 2
    Master-master replication using Multi-AZ instance
  • 62
    Easy to use, reliable
  • 40
    Low cost
  • 28
    Simple
  • 14
    Doesn't need to maintain it
  • 8
    It is Serverless
  • 4
    Has a max message size (currently 256K)
  • 3
    Triggers Lambda
  • 3
    Easy to configure with Terraform
  • 3
    Delayed delivery upto 15 mins only
  • 3
    Delayed delivery upto 12 hours
  • 1
    JMS compliant
  • 1
    Support for retry and dead letter queue
  • 1
    D

Sign up to add or upvote prosMake informed product decisions

Cons of Amazon RDS for PostgreSQL
Cons of Amazon SQS
    Be the first to leave a con
    • 2
      Has a max message size (currently 256K)
    • 2
      Proprietary
    • 2
      Difficult to configure
    • 1
      Has a maximum 15 minutes of delayed messages only

    Sign up to add or upvote consMake informed product decisions

    No Stats
    45
    4.2K

    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.

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

    What companies use Amazon RDS for PostgreSQL?
    What companies use Amazon SQS?
    Manage your open source components, licenses, and vulnerabilities
    Learn More

    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

    Blog Posts

    DockerAmazon EC2Scala+8
    6
    2798
    GitHubPythonReact+42
    49
    41066
    GitHubPythonNode.js+47
    55
    73008
    GitGitHubSlack+30
    27
    18891
    GitHubDockerAmazon EC2+23
    12
    6686
    What are some alternatives to Amazon RDS for PostgreSQL and Amazon SQS?
    MySQL
    The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
    PostgreSQL
    PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
    MongoDB
    MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
    Redis
    Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache, and message broker. Redis provides data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes, and streams.
    Amazon S3
    Amazon Simple Storage Service provides a fully redundant data storage infrastructure for storing and retrieving any amount of data, at any time, from anywhere on the web
    See all alternatives