Обсуждение: [GENERAL] Database of articles, LaTeX code and pictures

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.

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