Re: PostgreSQL on the internet
От | Bob Pawley |
---|---|
Тема | Re: PostgreSQL on the internet |
Дата | |
Msg-id | 003601c835cb$e3831130$6401a8c0@owner обсуждение исходный текст |
Ответ на | PostgreSQL on the internet (Bob Pawley <rjpawley@shaw.ca>) |
Список | pgsql-general |
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@gmail.com> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: "PostgreSQL" <pgsql-general@postgresql.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@shaw.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/
В списке pgsql-general по дате отправления: