5 ms·
Postgres 9.5 feature rundown
- redka 11y agoI'd say that jsonb_set is far too interesting to not get mentioned here.
- fiatjaf 11y agoIs it out? "There’s a few updates to JSONB. The one I’m most excited about is making JSONB output in psql read much more legibly." This is good, but there's a link to other much more useful JSONB functions: https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.5#JSONB-modifying_operators_and_functions https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9....
- atsaloli 11y agoAlmost. RC1 is out. The blog post said 9.5 will be out next year (January?) http://www.postgresql.org/ http://www.postgresql.org/
- ak4g 11y agoBarring release blockers discovered in RC1, yes, early January. http://www.postgresql.org/message-id/20706.1450460549@sss.pgh.pa.us http://www.postgresql.org/message-id/20706.1450460549@sss.pg...
- iyn 11y agoSince this is RC1 and stable version will be released pretty soon, when do you think Amazon RDS will support 9.5 (currently it supports 9.4.1)? Amazon didn't publish anything about that as far as I know, so this is more of a question about historical trends.
- wtbob 11y agoI'll just add my voice to the chorus praising PostgreSQL. It's handled everything I've ever asked it to, and cheerfully. I'm a bit sad that at my current job our problem set is much better suited for a distributed key-value store; I miss postgres, but it really is the wrong tool for this particular problem.
- mkobit 11y agoFull list of "What's new in PostgreSQL 9.5" - https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5 https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_... A lot of goodies around JSONB additions. In 9.4, there wasn't much support for updates to JSONB values, but now there will be some support for document-esque operations: - jsonb || jsonb (concatenate / overwrite) : combine 2 jsonb objects and if there's overlap, values are replaced at the highest level - jsonb - text / int (remove key / array element) : remove key or an array element - jsonb #- text[] / int (remove key / array element in path) : remove key/array at path - jsonb_set function : update value at path
- rosser 11y agoI have some concerns that overwriting keys at the highest level is always the correct behavior for "concatenating" JSONb documents. If you want to merge two keys, rather than overwrite one, you'll need to handle that at the application level.
- kristaps 11y agoPerforming operations in the app is always an option, but it's often faster/simpler to do it in the DB, if it supports what you need. This feature is just one of these potential nice-to-haves.
- 1123581321 11y agoWhat kind of job market exists for people whose deepest area of knowledge is Postgres? Edit: I'm thinking of more DBA type work and assisting with/contributing to drivers/wrappers.
- rosser 11y agoI've primarily been a Postgres DBA for the last decade or so, and have never had trouble finding work. As Postgres grows in popularity, people who know what they're doing with it are in increasing demand. EDIT: I'm currently looking.
- samstave 11y agoStart marketing yourself as "data engineering" and your prospects will widen.
- samstave 11y agoThe job market is pretty big. Think of any "big data" company -- but moreso - think of anyone who is using Amazon Redshift for BI... But really any company who can say they have "a data pipeline" will be a good candidate. If you have very deep Postgres knowledge, then make sure you have strong ability to ferry data in and out of the DB esp. on AWS. There are so many people who are looking to move data into and out of Redshift, RDS or other standalone systems. Any company who uses the term ETL will Also - there will be a good number of people who want to migrate, at least in testing, from Postgres to Aurora (mysql based - but instance-less) -- so this will be a good skill.
- assface 11y agoInternal development or just usage/administration?