From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: searchable database |
Date: | 2011-04-10 05:37:57 |
Message-ID: | 4DA14235.9040006@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/09/11 10:24 PM, tomas(at)tuxteam(dot)de wrote:
>> We have more than thousand electronic journals. I want to make a searchable
>> > database for easy access. Is there any light wight database available for
>> > that. Please provide me the details for the same.
> Your question is just too general to make a meaningful answer possible.
> The only answer I might offer is -- "yes, you might use a data base for
> that", and "yes, PostgreSQL might be useful for that", but I know that's
> just too general to be helpful.
I believe what the OP wants is a "document management system"...
http://en.wikipedia.org/wiki/Document_management_system
postgres is a general purpose database engine, and has many features
which could be very useful for a document management system,. such an
application likely would use a database like postgres as its back end,
but you need an application. It didn't sound like the OP is prepared
to write such a thing.
google lists quite a few open source packages like this.
http://www.google.com/search?q=open-source+document-management-system+postgresql
(ig
of course, open source projects like these vary widely in quality and
usability. I'd suggest to the OP they review the available packages,
pick a few possible candidates, and setup trial installs, adding a few
dozen documents to them to see how well they work for them.. Seems
like a lot of them are Java/Tomcat Web applications that use Postgres,
MySQL, and other database servers. Without having tried any of them and
just glancing at google results, I see OpenKM, Xinco DMS, and Alfresco
What are 'electronic journals', anyways? are these basically document
files? do they have some internal structure, like a collection of
articles, or is each journal a single entity? one really simple
approach is to convert your journals to blog entries with a blogging
package like s9y or wordpress, or a more sophisticated web CMS like
Plone or Drupal, and use a combination of tags and search to find content.
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2011-04-10 10:08:50 | Re: Handling bytea field in partition trigger function |
Previous Message | tomas | 2011-04-10 05:24:21 | Re: searchable database |