13 ms·

I've been using PostgreSQL for about 15 years, and it's a rare week when I don't discover a feature that makes my life (and that of my clients) easier and bette

by reuven 15y ago

I've been using PostgreSQL for about 15 years, and it's a rare week when I don't discover a feature that makes my life (and that of my clients) easier and better in some way. The software is rock solid, the feature set both broad and deep, and the community is generous in many different ways. It's really a pleasure to use this database, and to see that a growing number of people are starting to use it.

re_todd 15y ago
I used it about 2 years before realizing it had regular expressions, which have made some of my queries so much easier. http://www.postgresql.org/docs/9.0/static/functions-matching.html http://www.postgresql.org/docs/9.0/static/functions-matching...
techscruggs 15y ago
Wow, I have to ask, what do you think are some of the best resources to pull on for postgres knowledge are? and do you blog/tweet about your postgres work? if so, where?
- reuven 15y ago
  Do I blog or tweet about it? Oh, I really, really should. (And I enjoy doing so when I do.) I used to blog a bit, but consulting + family + my (oh-so-dragged-out) PhD work tend to eat into my time. But yeah, I really should. Maybe your comment will push me back into occasional blogging on technical subjects. Fortunately, there are some amazing resources out there. The pgsql-general e-mail list has oodles of helpful people, and great questions (and answers!). Get it in digest format, or prepare to have your inbox inundated with PostgreSQL goodness. But I've learned a ton just from reading messages on that list. There are some great PostgreSQL-related blogs, as well. Many are on the "Planet PostgreSQL" aggregator, at http://planet.postgresql.org/ http://planet.postgresql.org/ . Between those blogs and the e-mail list, you'll have lots of good stuff to read. Finally, Packt published two books about PostgreSQL 9.x in the last year, both of which are excellent. One is an administrative cookbook, and the other is a high-performance guide. Definitely worth reading (and re-reading). I'm in Israel, where MySQL is the open-source database king, and where people have barely heard of PostgreSQL. But I get about a call a month from someone who needs help with their PostgreSQL usage or configuration, and besides the nice feeling of having become the local go-to guy on the subject, it's also fascinating for me to see just how many serious places are using PostgreSQL -- but under the radar, without fanfare. They know that it's a great database, but no one else knows that they know.
  - techscruggs 15y ago
    Thanks! I have and love the two Packt books. I'll check out the rest. If end up blogging, let me know. I'm @techscruggs
  - jeltz 15y ago
    Also I can highly recommend the #postgresql IRC channel at freenode. The people there are helpful and polite.

by reuven 15y ago

re_todd 15y ago

I used it about 2 years before realizing it had regular expressions, which have made some of my queries so much easier. http://www.postgresql.org/docs/9.0/static/functions-matching.html http://www.postgresql.org/docs/9.0/static/functions-matching...

techscruggs 15y ago

Wow, I have to ask, what do you think are some of the best resources to pull on for postgres knowledge are? and do you blog/tweet about your postgres work? if so, where?

reuven 15y ago
Do I blog or tweet about it? Oh, I really, really should. (And I enjoy doing so when I do.) I used to blog a bit, but consulting + family + my (oh-so-dragged-out) PhD work tend to eat into my time. But yeah, I really should. Maybe your comment will push me back into occasional blogging on technical subjects. Fortunately, there are some amazing resources out there. The pgsql-general e-mail list has oodles of helpful people, and great questions (and answers!). Get it in digest format, or prepare to have your inbox inundated with PostgreSQL goodness. But I've learned a ton just from reading messages on that list. There are some great PostgreSQL-related blogs, as well. Many are on the "Planet PostgreSQL" aggregator, at http://planet.postgresql.org/ http://planet.postgresql.org/ . Between those blogs and the e-mail list, you'll have lots of good stuff to read. Finally, Packt published two books about PostgreSQL 9.x in the last year, both of which are excellent. One is an administrative cookbook, and the other is a high-performance guide. Definitely worth reading (and re-reading). I'm in Israel, where MySQL is the open-source database king, and where people have barely heard of PostgreSQL. But I get about a call a month from someone who needs help with their PostgreSQL usage or configuration, and besides the nice feeling of having become the local go-to guy on the subject, it's also fascinating for me to see just how many serious places are using PostgreSQL -- but under the radar, without fanfare. They know that it's a great database, but no one else knows that they know.
- techscruggs 15y ago
  Thanks! I have and love the two Packt books. I'll check out the rest. If end up blogging, let me know. I'm @techscruggs
- jeltz 15y ago
  Also I can highly recommend the #postgresql IRC channel at freenode. The people there are helpful and polite.