Astra DB vs. PostgreSQL

We use Astra DB to improve our management systems. Storing data has become hassle-free and quite simple. When launching a Cassandra-based cloud application, Astra DB is exactly what you need. In addition to the standard training programs and videos, the extended support and training require significant additional effort to activate and cover which I feel is a bit more tedious task.

Incentivized

PostgreSQL is ideal for handling databases that contain large volumes of information due to its efficiency, speed and above all because of the good management it makes of our resources, it also behaves very well in distributed environments of high demand, if you want a database of stable data and excellent performance PostgreSQL is one of the best.

Incentivized

• We need to be able to process a lot of data (our biggest clients process hundreds of milions of transactions every month). However, it is not only the amount of data, it is also an unpredictable patterns with spikes occuring at different points of time - something athat Astra is great at.
• Our processing needs to be extremaly fast. Some of our clients use our enrichment in a synchronous way, meaning that any delay in processing is holding up the whole transaction lifecycle and can have a major impact on the client. Astra is very fast.
• A close collaboration with GCP makes our life very easy. All of our technology sits in Google Cloud, so having Astra in there makes it a no-brainer solution for us.

Incentivized

• Advanced spatial capabilities by using PostGIS extension
• Very fast data processing and support of native ANSI SQL language syntax allows maintaining capability and scalability of database
• Fast data aggregation, even by SQL or stored routines/functions
• Well documented, free for use, great community. A lot of examples, and for this reason - lesser threshold for junior developers to start with

Incentivized

• Astra DB might be difficult to understand for people who are unfamiliar with Apache Cassandra. Improving the initial experience for newcomers, as well as offering better documentation and lessons, might be advantageous.
• The Astra DB ecosystem may be enhanced by expanding the ecosystem of plugins, integrations, and community-contributed solutions.

Incentivized

• The performance of PostgreSQL has been enhanced through the years, but always is better to have as much performance as we can.
• The replication services could be done directly within the database, and more easily.
• The Object Orientation of the Database could be extended, and albeit it manages inheritance of tables, and accepts XML and JSON as primary types, it would be wonderful if one could attach methods more easily to tables (to make them more like classes), and instances (rows for example).

Incentivized

As a needed software for day to day development activities

Incentivized

It's a great product but suffers with counters. This isn't a deal breaker but lets down what is otherwise a good all round solution

Incentivized

Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.

Incentivized

PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.

Incentivized

The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.

Incentivized

Their response time is fast, in case you do not contact them during business hours, they give a very good follow-up to your case. They also facilitate video calls if necessary for debugging.

Incentivized

AWS, Heroku, and Digital Ocean all provide Postgres-as-a-service, where you pretty much never need to administrate it yourself but they do it for you. The Postgres community also has developed awesome and reasonably priced extensions, such as Citus DB and CockroachDB in case you need additional support for running it. If you need documentation, Postgres's docs are super thorough and their official forms are active.

Incentivized

The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.

Incentivized

The online documentation of the PostgreSQL product is elaborate and takes users step by step.

Incentivized

We also (briefly) considered building in-house. We wanted to avoid complex "Frankenstein" architectures. Combining Pinecone with another NoSQL datastore like DynamoDB would have increased complexity. A single-managed platform (Astra DB) enabled architectural simplicity and strong reliability, allowing Maester’s development team to prioritize high-value, customer-facing features

Incentivized

In this case, Postgres is preferred because it handles large data sets and requires fewer hardware resources than its competitor, MySQL. Compared to PostgreSQL, Microsoft products are excellent, but the installation process for MS SQL is lengthy. PostgreSQL has an advantage over its competitors in that it can adapt or configure third-party programs, applications, or settings.

We are well aware of the Cassandra architecture and familiar with the open source tooling that Datastax provides the industry (K8sSandra / Stargate) to scale Cassandra on Kubernetes.

Having prior knowledge of Cassandra / Kubernetes means we know that under the hood Astra is built on infinitely scalable technologies. We trust that the foundations that Astra is built on will scale so we know Astra will scale.

Incentivized

The DB is reliable, scalable, easy to use and resolves most DB needs

Incentivized

• Database growth planning is less of a concern with Astra, as it scales automatically.
• Currently, they lack fine-grained security at the table level. I suspect that will change over time.
• If your load has peaks and valleys; Astra enables only paying for Reads/Writes; thus you do not need to pay for large servers to support peaks in load.

Incentivized

• Easy to administer so our DevOps team has only ever used minimal time to setup, tune, and maintain.
• Easy to interface with so our Engineering team has only ever used minimal time to query or modify the database. Getting the data is straightforward, what we do with it is the bigger concern.
• It's free. You can't beat that.

Incentivized