From: | jdwatson1(at)gmail(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | BLOB & Searching |
Date: | 2006-06-12 21:44:34 |
Message-ID: | 1150148674.553123.218370@f6g2000cwb.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am not 100% sure what the best solution would be, so I was hoping
someone could point me in the right direction.
I usually develop in MS tools, such as .net, ASP, SQL Server etc...,
but I really want to expand my skillset and learn as much about
Postgres
as possible.
What I need to do, is design a DB that will index and store
approximately 300 word docs, each with a size no more that 1MB. They
need to be able to seacrh the word documents for keyword/phrases to be
able to identify which one to use.
So, I need to write 2 web interfaces. A front end and a back end. Front
end for the users who will search for their documents, and a backend
for an admin person to upload new/ammended documents to the DB to be
searchable.
NOW..... I could do this in the usual MS tools that I work with using
BLOB's and the built in Full-text searching that comes with SQL Server,
but i don't have these to work with. I am working with PostGres & JSP
pages
What I was hoping someone could help me out with was identifying the
best possible solution to use.
1. How can I store the word doc's in the DB, would it be best to use a
BLOB data type?
2. Does Postgres support full text searching of a word document once it
is loaded into the BLOB column & how would this work? Would I have to
unload each BLOB object, convert it back to text to search, or does
Postgres have the ability to complete the full-text search of a BLOB,
like MSSQL Server & Oracle do?
3. Is there a way to export the Word Doc From the BLOB colum and dump
it into a PDF format (I guess I am asking if someone has seen or
written a PDF generator script/storedProc for Postgres)?
If someone could help me out, it would be greatly appreciated.
cheers,
James
From | Date | Subject | |
---|---|---|---|
Next Message | Milen Kulev | 2006-06-12 22:02:42 | Partitioning... |
Previous Message | Jim C. Nasby | 2006-06-12 20:44:51 | Re: Disk corruption detection |