3 ms·

Some awesome quality-of-life improvements here as well. The random function now takes min, max parameters SELECT random(1, 10) AS random_number;

clarkbw 2y ago
It's never available on homebrew the same day so we all worked hard to make it available the same day on Neon. If you want to try out the JSON_TABLE and MERGE RETURNING features you can spin up a free instance quickly. https://neon.tech/blog/postgres-17 https://neon.tech/blog/postgres-17 (note that not all extensions are available yet, that takes some time still)
- dewey 2y ago
  How is your hosted managed Postgres platform an alternative to Homebrew (Installing PG on your local Mac)? There's also many Homebrew formulas that have PG 17 already like (https://github.com/petere/homebrew-postgresql/commit/2faf43804e109c43a946f1be7fbb3802359d3f07 https://github.com/petere/homebrew-postgresql/commit/2faf438...).
  - clarkbw 2y ago
    oh, i see I'm getting downvoted; this isn't a sales pitch for my "managed postgres platform". every year a new postgres release occurs and i want to try out some of the features i have to find a way to get it. usually nobody has it available. here's the list of homebrew options I see right now: brew formulae | grep postgresql@ postgresql@10 postgresql@11 postgresql@12 postgresql@13 postgresql@14 postgresql@15 postgresql@16 maybe you're seeing otherwise but i updated a min ago and 17 isn't there yet. even searching for 'postgres' on homebrew doesn't reveal any options for 17. i don't know where you've found those but it doesn't seem easily available. and i'm not suggesting you use a cloud service as an alternative to homebrew or local development. neon is pure postgres, the local service is the same as whats in the cloud. but right now there isn't an easy local version and i wanted everyone else to be able to try it quickly.

3 ms·

Some awesome quality-of-life improvements here as well. The random function now takes min, max parameters SELECT random(1, 10) AS random_number;

by clarkbw 2y ago

clarkbw 2y ago
It's never available on homebrew the same day so we all worked hard to make it available the same day on Neon. If you want to try out the JSON_TABLE and MERGE RETURNING features you can spin up a free instance quickly. https://neon.tech/blog/postgres-17 https://neon.tech/blog/postgres-17 (note that not all extensions are available yet, that takes some time still)
- dewey 2y ago
  How is your hosted managed Postgres platform an alternative to Homebrew (Installing PG on your local Mac)? There's also many Homebrew formulas that have PG 17 already like (https://github.com/petere/homebrew-postgresql/commit/2faf43804e109c43a946f1be7fbb3802359d3f07 https://github.com/petere/homebrew-postgresql/commit/2faf438...).
  - clarkbw 2y ago
    oh, i see I'm getting downvoted; this isn't a sales pitch for my "managed postgres platform". every year a new postgres release occurs and i want to try out some of the features i have to find a way to get it. usually nobody has it available. here's the list of homebrew options I see right now: brew formulae | grep postgresql@ postgresql@10 postgresql@11 postgresql@12 postgresql@13 postgresql@14 postgresql@15 postgresql@16 maybe you're seeing otherwise but i updated a min ago and 17 isn't there yet. even searching for 'postgres' on homebrew doesn't reveal any options for 17. i don't know where you've found those but it doesn't seem easily available. and i'm not suggesting you use a cloud service as an alternative to homebrew or local development. neon is pure postgres, the local service is the same as whats in the cloud. but right now there isn't an easy local version and i wanted everyone else to be able to try it quickly.