@mistersql I am one of the maintainers of https://github.com/okfn-brasil/querido-diario/. We scrape hundreds of PDF files of the official acts of Brazilian cities and convert them to text, so we can search the content more easily. They are already using some way for full-text search, but I will try to do a side-project to search the data using POstgreSQL (to learn more and also to try to get some specific types of information).