[opencms-dev] where to store some data?

[Olli Aro]

> -----Original Message-----
> From: opencms-dev-admin at opencms.org
> [mailto:opencms-dev-admin at opencms.org]On Behalf Of tol
> Sent: 18 December 2003 00:15
> To: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] where to store some data?
>
>
> I read the chapter about Content Definitions, Backoffice Modules and
> Mastermodules! Don't  know if I understand it all, but what I understand
> sounds very very good :-))
> But now I feel very confused and thousands of questions appear - a bit
> chaotic at this time ...
> ok, some more questions:
>
> Olli Aro wrote:
>  > If it seems there is no real value presenting your data as content
> items, then I would just use my
>  > own database.
> Have you an example for this??
> All data I think about (newlettersystem,
> address, article, mediastorage, and so on) are like your shopping
> example. What a kind of data should stored in a separat database? Or is
> the important question, if I have to use the workflow, history and
> publishing for my data?
>

Yes you are right - i suppose when thinking this a bit more the value added
criteria is more the use of workflow and other opencms explorer features.

> What about the performance? If I understand it right, than all the
> objects stored in the VFS, are located in the same table. Would it
> better using different table if the amount of  documents/opbjects
> grows up?
>

I think you can still use your own tables, even if you use opencms
connection pool, as long as they are within the opencms database.

> Olli Aro wrote:
>
> >Yes. I think you can use opencms database connection pool to
> write your own
> >queries as long as your table in within the opencms database. However, I
> >have not tried it, I normally create my own pool.
> >
> Why did you create your own pool? What are the reasons for such a
> decision?
>

Two reasons really.

1) I was connecting to other database than opencms.
2) I was too lazy to read the API documentation for using the opencms
pool.;D

So no reasons deeper than that. It would be better practice to use the
opencms pool for modules really...

Olli
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.552 / Virus Database: 344 - Release Date: 15/12/2003