PostgreSQL: a great product that is easy to setup and easy to maintain!
February 12, 2018

PostgreSQL: a great product that is easy to setup and easy to maintain!

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

Currently, PostgreSQL is being used as an email texting mining tool, where I load a flat file email archive into postgresql and then auto-generate keys, which I can then use to find certain keywords.
  • PostgreSQL's file size is a plus: the fact that installing it on both a Windows and Linux system is easy and fast (even on a moderate connection) is helpful from an admin perspective.
  • Going off of that, it's very quick! It loads and creates tables quickly and provides a very similar interface to other implementations of SQL.
  • Using it as an Email Search system is unconventional (just a tad), but makes for a great back-end when you need to test-deploy a concept.
  • Its operations syntax is not like any other implementation, which means that along with installing it, you will need to pick up on how to create tables, etc.
  • In connection with the above point, attempting to essentially re-learn a set of commands is NOT a good idea. Especially since SQL has been around a long time at this point.
  • Which I think is why it's not widely adopted (in my opinion): Its syntax is very different (and obtuse). Plus, implementations such as SQlLite3 have beaten Post to the punch in the mobile market.
  • PostgreSQL's speed is a massive boon to our environment: we can query the email we load in, and retrieve results almost immediately.
For one thing, PostgreSQL is open source: which means that 1.) a million eyes catches more issues than a thousand (or TEN thousand) eyes. and 2.) there are no complicated licensing structures to fight through
The use case I am using it for - I have recommended to several entities: it's a good way to quickly get information out of an MBOX file format (which contains a lot of unstructured data).