PostgreSQL Review

We keep the logic in the database and we only need to constructs need crawlers that feed the database with more text to process.

Valuable Features

  • Stored Procedures
  • Full Text Search

One of our products crawls information from different web sites and then detects if some keywords are there based on a business logic. The business logic was programmed in Stored Procedures using Full Text Search to detect keywords that we wanted in the extracted text. Doing it this way, we keep the logic in the database and we only need to constructs need crawlers that feed the database with more text to process.

Improvements to My Organization

The Full Text Search functionality saved us a lot of time because we didn’t need to program that ourselves.

Room for Improvement

We don’t have any real database expert in the company, we are mostly developers. So I wouldn’t know if something would need improvement or we just haven’t learn how to use it properly yet.

However, less advanced programmers may have a bit of a learning curve. Also, it will make a difference with your database only once you get past the basic levels.

Use of Solution

I've used it for over three years.

Deployment Issues

We've had no issues with the deployment.

Stability Issues

Very stable product.

Scalability Issues

There have been no issues with the stability.

Customer Service and Technical Support

Haven’t try it yet. We solve our problems ourselves for the moment.

Initial Setup

Straightforward, however, we are all advanced programmers so the learning curve might have been easier for us.

Implementation Team

In-house. There is a lot of good information on the web and stackoverflow.

Pricing, Setup Cost and Licensing

PostgreSQL is free, so great ROI!

Other Solutions Considered

We compared it to MySQL, Oracle and we though PostgreSQL Full Text Search functionality was the best for what we needed.

Other Advice

At basic levels the database won’t do much difference, focus first in learning how to build queries properly, create index, etc.

An image of our product achieved with Full Text Search.

Which version of this solution are you currently using?

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More PostgreSQL reviews from users
...who work at a Comms Service Provider
...who compared it with MySQL
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: June 2021.
512,711 professionals have used our research since 2012.
Add a Comment
ITCS user