pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBook recommendations
2+ messages / 2 participants
[nested] [flat]
* Book recommendations
@ 2008-03-23 09:00 Mikel Lindsaar <raasdnil@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Mikel Lindsaar @ 2008-03-23 09:00 UTC (permalink / raw)
To: pgsql-admin
SELECT book.title, book.author, book.feedback
FROM postgresql_admin_community
JOIN books ON book.subject ILIKE '%postgres%'
JOIN readings ON readings.reader_id = postgresql_admin_community.id
WHERE
postgres_admin_community.user_experience_level = 'I have spent years
around databases, but never really 'in' them. I could write SQL if I
had to, I set up my fair share of simple DBs that backed website
content management systems and the like. I also spent about a year a
university going through basic relational DB design and theory so I
have a fairly solid grounding in keying, indices, relationships etc.
All of my exposure to databases up until a few months ago was MySQL,
then SqlServer. Now that I have a fairly serious postgresql
installation happening, I am finding myself fairly deep and looking at
non trivial issues like seriously playing with the explain analyze
command, working out the best configs and making sure the backups work
and are regular.
I have done this so far by reading a lot of the Postgres manual and
every website I can find, and the system is working quite well for
now. But I want to take the next step.'
LIMIT 10
ORDER BY book.popularity
Regards
Mikel
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Book recommendations
@ 2008-03-23 09:37 Hannes Dorbath <light@theendofthetunnel.de>
parent: Mikel Lindsaar <raasdnil@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Hannes Dorbath @ 2008-03-23 09:37 UTC (permalink / raw)
To: Mikel Lindsaar <raasdnil@gmail.com>
Mikel Lindsaar wrote:
> I have done this so far by reading a lot of the Postgres manual and
> every website I can find.
Books usually just recycle that information. PostgreSQL's manual is
really good today. Add Greg Smith's PostgreSQL Performance Pitstop, a
few other sites and you have everything you need.
If you like to learn more about SQL or database modeling, look for a
book on these specific topics.
--
Best regards,
Hannes Dorbath
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-03-23 09:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-23 09:00 Book recommendations Mikel Lindsaar <raasdnil@gmail.com>
2008-03-23 09:37 ` Hannes Dorbath <light@theendofthetunnel.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox