PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.
N/A
PrestaShop
Score7.6 out of 10
N/A
PrestaShop is a free, open source e-commerce solution available under the Open Software License and officially launched in August 2007. The software is written in PHP and based on the Smarty template engine and is currently used by 165,000 shops worldwide. The PrestaShop group was founded in Paris, with a second Headquarters opened in Miami in 2011. PrestaShop is translated into 63 languages, with English, French, Portuguese, German, Spanish, Italian, Dutch, Polish and Russian having full…
PostgreSQL is best used for structured data, and best when following relational database design principles. I would not use PostgreSQL for large unstructured data such as video, images, sound files, xml documents, web-pages, especially if these files have their own highly variable, internal structure.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
This is a great system for small and medium businesses dealing from 1 product to 100,000 products. It is elegant to use and very stable. The system may not be great for converting into a marketplace and the handling of > 1million products. The system is also not suitable for services selling like events, registrations, subscriptions and ticket bookings etc.
The PayPal button modality was integrated with the PrestaShop system, which helped our clients to complete payments digitally in just a few seconds, this integrated button allowed to streamline many transactions.
Performing inventory reviews and modifying the PrestaShop catalog was one of the things that I liked the most, I could make changes to the catalog, make changes to the conditions of the products in the catalog and all those changes were reflected on my website in a instant, no need to wait some time.
The PrestaShop system created a digital invoice for each client who made the advance payment of a property, which made it even easier to complete the property negotiation. Customers came to our company with the digital invoice for the advance payment and it was easy to identify the property that was paid, thanks to the digital invoice.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Since we use PrestaShop OpenSource there is only community support. What we found is that many other users fight with the same problems and there seems no solution or input from the PrestaShop developers' side.
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Although the competition between the different databases is increasingly aggressive in the sense that they provide many improvements, new functionalities, compatibility with complementary components or environments, in some cases it requires that it be followed within the same family of applications that performs the company that develops it and that is not all bad, but being able to adapt or configure different programs, applications or other environments developed by third parties apart is what gives PostgreSQL a certain advantage and this diversification in the components that can be joined with it, is the reason why it is a great option to choose.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
It's a no-brainer for e-commerce stores. BigCommerce and Magento both far out-distanced PrestaShop in every major category. If you're just getting into e-commerce, I would highly recommend either BigCommerce or Magento. Their online documentation and support far outweigh any advantages you'd have over going with an open source software like PrestaShop.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
It slowed down our Hosting service. Our website took a long time to fully load on our clients' devices due to the high consumption of the integration with the PrestaShop service.
It provided us with a fast billing service, where our clients obtained invoices in PDF mode for the electronic payments they made for the properties. These digital invoices helped us to recognize the property they wanted faster and streamlined the negotiation process.
The templates that had an optimized design, were too expensive, this caused that our catalog design was very simple and did not capture the interest of customers.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
