Thoughts on "Love Your Database"

Поиск
Список
Период
Сортировка
От Guyren Howe
Тема Thoughts on "Love Your Database"
Дата
Msg-id 1FBC08AC-771E-4231-96A6-36B02130EFC8@gmail.com
обсуждение исходный текст
Ответы Re: Thoughts on "Love Your Database"  ("dandl" <david@andl.org>)
Re: Thoughts on "Love Your Database"  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
Re: Thoughts on "Love Your Database"  (Chris Travers <chris.travers@gmail.com>)
Re: Thoughts on "Love Your Database"  (Bill Moran <wmoran@potentialtech.com>)
Re: Thoughts on "Love Your Database"  (Szymon Lipiński <mabewlun@gmail.com>)
Re: Thoughts on "Love Your Database"  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Thoughts on "Love Your Database"  (Will McCormick <wmccormick@gmail.com>)
Re: Thoughts on "Love Your Database"  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Re: Thoughts on "Love Your Database"  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Thoughts on "Love Your Database"  (Vincent Veyron <vv.lists@wanadoo.fr>)
Re: Thoughts on "Love Your Database"  (Marc Mamin <M.Mamin@intershop.de>)
Список pgsql-general
I've long been frustrated with how most web developers I meet have no idea how to use an SQL database properly. I think
I'mgoing to write a book called Love Your Database, aimed at web developers, that explains how to make their apps
betterby leveraging the power of SQL in general, and Postgres in particular. 

I'm thinking of a section on features of SQL most folks don't know about (CTEs are *way* to hell at the top of that
list,but also EXCEPT/INTERSECT and window functions), but much of the book would be about how to do things server side.
Benchmarksshowing how much faster this can be, but mostly techniques — stored procedures/triggers/rules, views. 

I asked a colleague about the advice I often hear stated but seldom justified, that one shouldn't put business rules in
thedatabase. He offered that server-side code can be hard to debug. 

I'm sure many here would love to see such a book published, maybe some talks on the topic given.


What might I cover that I haven't mentioned? What are the usual objections to server-side code and how can they be met?
When*are* they justified and what should the criteria be to put code in Postgres? Any other thoughts? Any other
websitesor books on the topic I might consult? 

TIA

В списке pgsql-general по дате отправления:

Предыдущее
От: "drum.lucas@gmail.com"
Дата:
Сообщение: Re: Function PostgreSQL 9.2
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Function PostgreSQL 9.2