News for hackers. Stuff that matters.
Re:Why favor PostgreSQL over MariaDB/MySQL? by threeseed on Tuesday September 05, 2017 @02:57AM (#15173046)
ElasticSearch is open source and free.

And nothing is stopping you running it on a single node like PostgreSQL. It's also better in every aspect as a search engine.

Re:Why favor PostgreSQL over MariaDB/MySQL? by arkh on Tuesday September 05, 2017 @03:32AM (#15173177)
It is also: another server to handle, another view of your data you have to manage, another point of failure and another security entry-point.

If you don't need all the functionality of ES you can go a long way with the Postgres fulltext search. Once you scale enough or if search is your core business ditch it and deploy a better solution like Elastic Search.

Re:Why favor PostgreSQL over MariaDB/MySQL? by taneem on Tuesday September 05, 2017 @12:21PM (#15176646)
Exactly. When getting started initially, it can be a huge time savings to get your basic full text experience running in Postgres directly, if that's already your main storage DB. Setting up ES is not at all trivial for the average developer and can waste a lot of precious time too early in a product's lifecycle.
Re:Why favor PostgreSQL over MariaDB/MySQL? by riku_iki on Tuesday September 05, 2017 @06:22PM (#15179577)
Also ElasticSearch updates will not be in the same transactions as your DB data updates, which can create some mess.