How to choose correct database system?

Thanks for the important information you just shared. After reading all the comments I can clearly see that the Elixir community is heavily inclined towards Postgresql. I, being new to Elixir and Postgresql, have no idea why. But I trust your advice and have started trying out Postgresql with Phoenix. And here the first problem appears. I want to use full text search. I went through your blog post but didn’t succeed to make it work. The schema complains invalid or unknown type :tsvector for field. I have done the indexing for full text search following the official postgresql documentation page. It would be great if you can help me out with some sample code or point me to some other place on internet where I can get some more details about how to do full text search in postgresql + Phoenix?