Search Postgresql Archives

Re: PostgreSQL on the internet

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.marlowe@xxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "PostgreSQL" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Monday, December 03, 2007 8:35 AM
Subject: Re:  PostgreSQL on the internet


On Dec 3, 2007 9:33 AM, Bob Pawley <rjpawley@xxxxxxx> 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/


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux