PostgreSQL 10 Beta 1 was recently released

New version of one of the most popular database management system 
05 July 2017   1730
PostgreSQL

An object-relational database management system with an emphasis on extensibility and standards compliance.

Beta release of PostgreSQL 10 contains previews of all of the features which will be available in the final release of version 10, but some details can change. Developers ask users to begin testing their applications with this latest release.

Main Features

The new version has some good features that will allow users to both scale out and scale up their PostgreSQL infrastructure:

  • Logical Replication: built-in option for replicating specific tables or using replication to upgrade
  • Native Table Partitioning: range and list partitioning as native database objects
  • Additional Query Parallelism: including index scans, bitmap scans, and merge joins
  • Quorum Commit for Synchronous Replication: ensure against loss of multiple nodes

Also, users will be able to test:

  • SCRAM Authentication, for more secure password-based access
  • Multi-host "failover", connecting to the first available in a list of hosts
  • target_session_attrs parameter, so a client can request a read/write host

Additional Features

Many other new features and improvements have been added to PostgreSQL 10.  All of them require testing. Among them are:

  • Crash-safe and replicable Hash Indexes
  • Multi-column Correlation Statistics
  • New "monitoring" roles for permission grants
  • Latch Wait times in pg_stat_activity
  • XMLTABLE query expression
  • Restrictive Policies for Row Level Security
  • Full Text Search support for JSON and JSONB
  • Compression support for pg_receivewal
  • ICU collation support
  • Push Down Aggregates to foreign servers
  • Transition Tables in trigger execution

Further, developers have contributed performance improvements in the SUM() function, character encoding conversion, expression evaluation, grouping sets, and joins against unique columns. Analytics queries against large numbers of rows should be up to 40% faster. Please test if these are faster for you and report back.

See the Release Notes for a complete list of new and changed features.

The final release planned in late 2017.  

Ruby/RoR News Digest 9-15.11

The delegation challenge of Ruby 2.7, feedback about writing own Ruby book, testing at scale at Stripe podcast and even more
15 November 2019   133

Greetings! I hope your week went great! Here's new "gemmy" programming news digest.

Learn how to handle attachmens in Action Text in Rails 6, download large Heroku Postgres backup, check the update of Tomo and more.

Guides

  • Handling Attachments in Action Text in Rails 6 

Second part of the Action Text tutorial that focuses on blocking files by type, how files are rendered, and previewing PDFs.

  • Downloading Large Heroku Postgres Backups

Learn how to download big Heroke postgres backups in a proper and convenient way.

Articles

  • The Delegation Challenge of Ruby 2.7 

This is a somewhat odd situation where a change to arguments changes delegation so things are handled differently in Ruby 2.6, 2.7, and 3.0. It’s a tough nut to crack and a great example of language design related edge cases.

  • Feedback About Writing A Technical Ruby Book 

Author’s experience writing a book about programming.

Updates

  • Tomo

A "friendly" command-line tool for deploying Rails apps

  • Strings::Case

This solution allows you to convert strings between different cases

  • Reek

It will detect your code's smell, whatever that means

  • Invisible Captcha

Spam protector for Rails apps

Video

  • Testing Active Job in Ruby on Rails

Podcast

  • Discussing Testing at Scale at Stripe

In 48 minute interview, Nelson Elhage who spent 7 years at Stripe spearheading developer productivity initiatives, shares what he learnt and digs into why Stripe created the Sorbet Ruby type checker.