(Apologies if this question is better suited to Software Development or DBA!)
I'm planning a system to store and view a library of 10-50k documents and am trying to work out the best option for storing them. The data will only be written once so I'm focusing on read performance.
Most users will be searching for documents by date and/or location, but I'm planning on adding various user-editable searchable tag fields to each document. I'd like to offer full text search too. Further down the line I'd like to be able to run named-entity extraction on the documents so I'll need to store the results of that.
I'm currently considering running MongoDB or Cassandra for fast access alongside Elasticsearch for the greatest search flexibility but I'm wondering if that is going to be too much hassle and I should just use PostgreSQL or a similar relational database (my data is pretty uniformly strucured) that offers text searching.