Re: nooby Q: temp tables good for web apps?

Поиск
Список
Период
Сортировка
Искать
От
Kenneth Tilton
Тема
Re: nooby Q: temp tables good for web apps?
Дата
Msg-id
49DBFA16.4000803@gmail.com
Ответ на
Список
Дерево обсуждения
nooby Q: temp tables good for web apps? Kenneth Tilton <kentilton@gmail.com>
Re: nooby Q: temp tables good for web apps? Tom Lane <tgl@sss.pgh.pa.us>
Re: nooby Q: temp tables good for web apps? Kenneth Tilton <kentilton@gmail.com>
Re: nooby Q: temp tables good for web apps? Greg Smith <gsmith@gregsmith.com>
Re: nooby Q: temp tables good for web apps? Kenneth Tilton <kentilton@gmail.com>
Re: nooby Q: temp tables good for web apps? Scott Marlowe <scott.marlowe@gmail.com>
Re: nooby Q: temp tables good for web apps? Kenneth Tilton <kentilton@gmail.com>
Re: nooby Q: temp tables good for web apps? Scott Marlowe <scott.marlowe@gmail.com>
Re: nooby Q: temp tables good for web apps? Kenneth Tilton <kentilton@gmail.com>
Re: nooby Q: temp tables good for web apps? Erik Jones <ejones@engineyard.com>
Re: nooby Q: temp tables good for web apps? John Cheng <jlcheng@ymail.com>
Re: nooby Q: temp tables good for web apps? Greg Smith <gsmith@gregsmith.com>
Re: nooby Q: temp tables good for web apps? Scott Marlowe <scott.marlowe@gmail.com>


Scott Marlowe wrote:
> You can use a different method if you need a table available to the
> same session.  Create a schema based on the session id, and put your
> temp tables there, only don't call them temp tables.  You'll either
> need to make sure you always clean up your temp schema your session
> created or come up with a daemon that comes along every hour or so and
> kills off old schemas that aren't in use anymore.

I am LMAO because Lisp (my server-side lang) does this to noobs, too: 
three (at least) ways to do everything. Well, if all things are equal 
dropping one schema and not kludging up mangled table names has a lot of 
appeal. Thx.

ken

В списке pgsql-general по дате отправления
От: John Cheng
Дата:
От: Scott Marlowe
Дата:
FAQ