Re: PostgreSQL on the internet

Basically, the database will be used to build up an engineering document
called a P&ID which traditionally comes in the form of a drawing. From the
database I'll create a drwawing which the user can, if he wants, convert
into a DXF file for use in AutoCad or Bentley drawing systems.

The database will also be used to transfer information to other engineering
databases yet to be completed.

Bob

----- Original Message -----
From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Sent: Monday, December 03, 2007 8:35 AM
Subject: Re: [GENERAL] PostgreSQL on the internet

> On Dec 3, 2007 9:33 AM, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
>>
>> Hi
>>
>> I am kicking around the idea of using PostgreSQL as a web based service.
>> Access to the site will be through a separate application/interface.
>>
>> The user's interface will install the database on entry to the website.
>> When
>> the user exits the site, the database will be dumped to the user's
>> computer
>> and eliminated from the website. It seems to me that it is possible to
>> make
>> this dump and restore invisible, or mostly invisible, to the user.
>
> You mean, I suppose, that you'll create a db on your server for the
> user, and load schema / data into that? Then dump it out to the user
> when they're ready to go, and drop the db on your end?
>
> Seems pretty easily doable to me.
>
>> Can someone tell me what criteria I need to look at in order to determine
>> how many clients can be using the website, each with their own database,
>> at
>> one time??
>
> How much memory your db server has, how big the db will be, what kind
> of load it will have, how the db is tuned, etc... I'd try it out
> after building a simple test case db and see how the system behaves
> with say 1, 2, 4, 10, 20 etc users. Get a feel for it.
>
> I think a bit more information from you on exactly what you're
> planning to do would help to determine an upper limit on how many
> users you can handle.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/