I completely agree with Thomas. If the world journal has the same meaning I give to it I suggest the OP to give a look to Open Journal System: http://pkp.sfu.ca/?q=ojs Maybe it goes further than the OP wants. I never used it wiht Postgres , because my customers wanted to use MySQL :-( But it supports postgres. Il 10/04/2011 7.37, John R Pierce ha scritto: > On 04/09/11 10:24 PM, tomas@xxxxxxxxxx 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. > > -- ================================================== dott. Ivano Mario Luberti Archimede Informatica societa' cooperativa a r. l. Sede Operativa Via Gereschi 36 - 56126- Pisa tel.: +39-050- 580959 tel/fax: +39-050-9711344 web: www.archicoop.it ================================================== -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
