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!
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