Re: Database of articles, LaTeX code and pictures

On 1/11/2017 2:47 PM, philolilou wrote:
> Hello everyone,
>
> i wish to build a place where to store articles (with picture) and
> that can be accessed easily later by researching.
>
> Articles i wish to store, are actually articles of magazine, or some
> internet interesting articles.
>
> For the articles of magazines, i thought scan all interesting pages,
> make OCR (letter recognition) on them, eventually convert them into
> LaTeX formated code, and insert all into PGSQL database.
>
> Once this made, a php driven website will make reseaches in the PGSQL
> database.
>
> For this application, i want make researches the following way:
>
> -> i give a word, or a topic and database will search in plain text
> through all the documents and give results based of the accuracy and
> so the amount of the times that word or topic appears in the article
>
> -> by keywords: i specify keywords in the search and i get all the
> articles matching these keywords
>
> Once search made, and results found, a simple clic does deliver the
> pdf of the searched article or view it in the navigator as final
> document rendered (like the original article).
>
>
> Questions:
>
> 1. Is this possible to make with Postgresql? (store LaTeX code and
> images, browse the text of the code + keywords, and retrieve all of
> this to a LaTeX program for compile it again)
>
> 2. If the answer of question 1 is yes, how can i structure database
> for can use search in the latex code?
>
>
> Thanks for your help.

sounds like a wiki or blog to me rather than a sql database. perhaps the
wiki/blog articles are stored in a sql database, but thats an
implementation detail.

--
john r pierce, recycling bits in santa cruz