Hacker News Re-Imagined

Custom SQL functions for data analytics in PostgreSQL

  • 120 points
  • 11 days ago

  • @carlotasoto
  • Created a post

Custom SQL functions for data analytics in PostgreSQL


@djbusby 11 days

Replying to @carlotasoto 🎙

Not specifically about these functions but in general PG makes it pretty easy to build custom functions and data-types. I one of those who doesn't want to put too much business logic in my DB but for those cases where it really makes sense to get into your lower level language and do all the magic it afford on your data - it's a killer feature. Can't do custom extensions in RDS last I looked tho

Reply


@BeefWellington 11 days

Replying to @carlotasoto 🎙

It is a pet peeve of mine when people offer code samples that require horizontal scrolling even when full-screened on a 1440p monitor (let alone 1080p).

Either don't use arbitrarily size-restricted code blocks, or manually format your code so it's legible in the window size you've chosen.

Reply


About Us

site design / logo © 2022 Box Piper