Re: [Exist-open] How to index the files without uploading them in eXist DB

[Craig B. <cra...@ma...>]

Do your PostgreSQL tables have those line and chapter numbers?  If so, why not query them directly using full text search:

https://www.postgresql.org/docs/current/textsearch.html

and avoid eXist altogether?

That assumes that word search is the only feature of eXist you're interested in, which may not be the case.  

> On Mar 26, 2024, at 4:41 AM, Dr. VANDANA JHA <vjv...@gm...> wrote:
> 
> Dear Support Team,
> 
> I have a repository of TEI-XML files stored in PostgreSQL and my requirement is to index this file so that it can be queried for the line number and chapter number of a particular word in the document.
> 
> I guess, I can populate that same repository contents in eXist-DB and then index it. But as this PostgreSQL repository is a small part of a big project and due to other more important requirement, I have to keep this repository.
> 
> So my question is, 
> Is it possible to set somewhere path to this PostgreSQL repository in eXist-DB and then use these stored file and directory structure in eXist-DB to index/work with them? So here I want to skip the process of storing these files again in eXist-DB. This will serve two purpose for me. First the data will not be duplicated at two places so it will save the effort in data consistency. Second, this data will be updated may be later and always I want the data to be read from my postgreSQL and eXist DB should be doing read only task and not write into these files so it will be perfect for me, if by setting path, it reads from the original repository itself.
> 
> Any help in this regard, will be really appreciated.
> 
> Thanks & Regards,Dr. Vandana Jha
>  Data Exploitation Methods (DEM),
> Scientific Computing Center (SCC),
> Karlsruhe Institute of Technology (KIT)
> 
> Hermann-von-Helmholtz-Platz 1
> 76344 Eggenstein-Leopoldshafen
> Karlsruhe, Germany.
> E-mail: van...@ki...
> http://www.scc.kit.edu
> 
> _______________________________________________
> Exist-open mailing list
> Exi...@li...
> https://lists.sourceforge.net/lists/listinfo/exist-open

________________________________________
Craig A. Berry

"... getting out of a sonnet is much more
 difficult than getting in."
                 Brad Leithauser