PostgreSQL vs. Progress MarkLogic

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

In an area where it will be built once and maintained, it shines. If you aim to use CI, temporary environments, or anything else, it is not very effective. Licensing is almost impossible on boxes that are to be created on the fly.

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

• Indexing is a major strength of MarkLogic. The out-of-the-box configuration is set up to handle a combination of text and fielded data. The indexing is also highly configurable. Those configuration options are at the heart of a lot of our high-volume, high-performance applications.
• The industrial strength transactions and security are also a strength, particularly when we are dealing with user-created intellectual property.
• The engineering support is a strength. They are big enough to have a really strong support and engineering staff, but small enough so that a medium-sized customer has access to it. They are very responsive to questions and problem reports.
• The ability to move easily among XML and JSON is a strength.

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

• How to do complete data profiling on documents loaded in Marklogic database?
• Customers need a tools which can be customized to suit their data profiling needs but currently the tools which MarkLogic provides fall short on this requirement.
• Unit testing framework which is using only XQuery as the language is lacking some features.

Incentivized

As a needed software for day to day development activities

Incentivized

Our firm has consultants for a number of technologies/disciplines. While I am capable and experienced in other areas, my preference is always to work on engagements with MarkLogic. As an architect and developer, I get far more flexibility and performance from one product instead of cobbling together a stack of several products to provide a capability that MarkLogic has rolled into one great product.

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

Very little about it can be done better or with greater ease. Even things that seem difficult aren't really that bad. There's multiple ways to accomplish any admin task. MarkLogic requires a fraction of administrative effort that you see with enterprise RDBMS like Oracle. MarkLogic is continually improving the tools to simplify cluster configuration and maintenance.

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

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

There's always room for improvement. Some problems get solved faster than others, of course. MarkLogic's direct support is very responsive and professional. If they can't help immediately, they always have good feedback and are eager to receive information and details to work to replicate the problem. They are quick to escalate major support issues and production show-stopping problems. In addition to MarkLogic's direct support, there are several employees who are very active among the community and many questions and common issues get quick attention from helpful responses to email and StackOverflow questions.

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

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

In comparison to both Mongo and HBase, MarkLogic wins in terms of integration to other systems, while loosing in terms of pricing. In terms of documentation all will be in same range putting MarkLogic a bit forward.

Incentivized

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

Incentivized

• 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.

• It took longer than expected to develop our application and get the level of consistent performance necessary. As a result, profit was flat for a couple of years but the benefits are really starting to kick in.

Incentivized