http://qs321.pair.com?node_id=11107767


in reply to [OT] SQL "on duplicate key" custom action

If you have the choice, choose PostgreSQL. It might not matter in the beginning, but projects tend to grow in complexity and PostgreSQL is a much better fit when it comes to complex data handling tasks and keeping your data integrity intact.

Also, if you like PerlMonks, you will most likely enjoy working with the PostgreSQL community.

perl -e 'use MIME::Base64; print decode_base64("4pmsIE5ldmVyIGdvbm5hIGdpdmUgeW91IHVwCiAgTmV2ZXIgZ29ubmEgbGV0IHlvdSBkb3duLi4uIOKZqwo=");'

Replies are listed 'Best First'.
Re^2: [OT] SQL "on duplicate key" custom action
by haukex (Archbishop) on Oct 21, 2019 at 18:23 UTC
    Also, if you like PerlMonks, you will most likely enjoy working with the PostgreSQL community.

    That sounds nice :-) What's the Postgres equivalent to PerlMonks?

      There are a lot of places to look at. https://www.postgresql.org/community/ is as good a place to start as any. Especially the mailing lists (yup, those things still exist) are very helpful. The mailing lists are pretty much the equivalent of PerlMonks in my opinion

      If you need help semi-urgent or just want to hang out, #postgresql on irc.freenode.net is also a good place. Saved my bacon on a couple of occasions.

      Last, but not least, if you need commercial PostgreSQL help for a big project, PostgreSQL got you covered: https://www.postgresql.org/support/professional_support/

      perl -e 'use MIME::Base64; print decode_base64("4pmsIE5ldmVyIGdvbm5hIGdpdmUgeW91IHVwCiAgTmV2ZXIgZ29ubmEgbGV0IHlvdSBkb3duLi4uIOKZqwo=");'

      There's IRC: the #postgresql channel on libera.chat, if you like that kind of thing. It's especially like latterday perlmonks in that there are sometimes long silences, but then suddenly also intensely interesting conversations, use cases, problem cases -- and, even when silent, there is always much expertise.

      [1] https://www.postgresql.org/community/irc/

      Q> What's the Postgres equivalent to PerlMonks?

      A> EXPLAIN