Microsoft Azure vs. PostgreSQL

Actually, migrating to Microsoft Azure is a good solution for almost any situation, especially when all components of your network are ready to become cloud-based. The only drawback I personally encounter frequently is that older software packages cannot always be easily picked up and moved to Microsoft Azure in an optimal manner.

Incentivized

Based on my experience, PostgreSQL is exactly what I imagine when thinking of a relational database: it is fast for querying and intuitive (if the underlying relations have been well written) and its writes are also efficient. Of course you need to know that a relational database is what you need, for example I would not recommend it if you have a lot of unstructured data that have no way to create a relation from and if you need to run heavy aggregations over your data, as it is not where PostgreSQL would shine.

Incentivized

• Azure simply provides end to end life cycle. Starting from the development to automated deployment, you will find [a] bunch of options. Custom hook-points allow [integration] on-premise resources as well.
• Excellent documentation around all the services make it really easy for any novice. Overall support by [the] community and Azure Technical team is exceptional.
• BOT Services, Computer Vision services, ML frameworks provide excellent results as compare to similar services provided by other giants in the same space.
• Azure data services provide excellent support to ingest data from different sources, ETL, and consumption of data for BI purpose.

Incentivized

• The stability it offers, its speed of response and its resource management is excellent even in complex database environments and with low-resource machines.
• The large amount of resources it has in addition to the many own and third-party tools that are compatible that make productivity greatly increase.
• The adaptability in various environments, whether distributed or not, [is a] complete set of configuration options which allows to greatly customize the work configuration according to the needs that are required.
• The excellent handling of referential and transactional integrity, its internal security scheme, the ease with which we can create backups are some of the strengths that can be mentioned.

Incentivized

• In our experience, Azure Kubernetes Survice was difficult to set up, which is why we used Kubernetes on top of VMs.
• Azure REST API is a bit difficult to use, which made it difficult for us to automate our interactions with Azure.
• Azure's Web UI does a good job of showing metrics on individual VMs, but it would be great if there was a way to show certain metrics from multiple VMs on one dashboard. For example, hard drive usage on our database VMs.

Incentivized

• The query syntax for JSON fields is unwieldy when you start getting into complex queries with many joins.
• I wish there was a distinction (a flag) you could set for automated scripts vs working in the psql CLI, which would provide an 'Are you sure you want to do X?' type prompt if your query is likely to affect more than a certain number of rows. Especially on updates/deletes. Setting the flag in the headless(scripted) flow would disable the prompt.
• Better documentation around JSON and Array aggregation, with more examples of how the data is transformed.

Incentivized

We have been very satisfied with Windows Azure and now a lot of our business depends on it as more teams are now deploying their applications into Azure. Our next step is to have our Infrastructure team move their resources to Azure. It will take awhile for that to happen but we are positive that it will.

Incentivized

As a needed software for day to day development activities

Incentivized

Microsoft Azure's overall usability has been better than expected. Often times vendors promise the world, only to leave you with a run-down town. Not the case with our experience. From an implementation perspective, all went perfect, and from the user-facing experience we have had no technical issues, just some learning curve issues that are more about "why" than "how"

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

It has proven to be unreliable in our production environment and services become unavailable without proper notification to system administrators

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

Support is easy with all the knowledge base articles available for free on the web. Plus, if you have a preferred status you can leverage their concierge support to get rapid response. Sometimes they’ll bounce you around a lot to get you to the right person, but they are quite responsive (especially when you are paying for the service). Many of the older Microsoft skills are also transferable from old-school on-prem to Azure-based virtual interfaces.

Incentivized

There are several companies that you can contract for technical support, like EnterpriseDB or Percona, both first level in expertise and commitment to the software.

But we do not have contracts with them, we have done all the way from googling to forums, and never have a problem that we cannot resolve or pass around. And for dozens of projects and more than 15 years now.

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

As I have mentioned before the issue with my Oracle Mismatch Version issues that have put a delay on moving one of my platforms will justify my 7 rating.

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

Incentivized

I feel that Microsoft Azure typically outperforms Google Cloud Platform in hybrid cloud capabilities, integration aspects, and, primarily, security compliance features. Azure offered superior integration with Microsoft's enterprise software ecosystem, and it's second to none in my opinion. This made it the natural choice for most, especially if heavily invested in Windows, Office 365, or Active Directory deployments. We chose Azure over GCP because we simply needed Windows workload support as a strong driver, more access to global regions, and let's not forget that most tech teams in an organization are Microsoft Certified, which makes skillset transfer from on-prem to cloud a minimal learning curve over shifting to a different provider.

In my experience using all of these products over many years, PostgreSQL is better than any of them in reliability, performance, productivity, cost, scalability and interoperability across operating systems.

Incentivized

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

Incentivized

• Times and growth went into it. By balancing on-premises maintenance with continuous cloud improvements, we’ve budgeted and planned endlessly increased capacity.
• In today’s world of cyber-crime, clients can put even more faith in what they’ve heard. We built an innovative single-sign-on hub for all users. Also, other business platforms use Azure application gateways, reducing worker switching time and increasing productivity.
• Its step can automate to improve the investment. In addition, we can integrate our organization’s credentials into an authorization for other systems.

• A robust and reliable platform reduces the risk of data loss and confusion.
• Using an almost free product is economical. No license fees = minimal ownership cost.
• Efficiency is high due to quickness and excellent resource management.
• PostgreSQL helps us achieve our goals, and there are no time-consuming management tasks.