We invite you to the mtap "New features of PostgreSQL 11"

We invite you to the mtap "New features of PostgreSQL 11"
 
 
Friends, a little more than a month ago ended with a commitefest and it became clear what new opportunities we will enjoy PostgreSQL's fall release. We have already started talking about INCLUDE-indices , the built-in web search , improvements in casting .
 
 
And now, together with Raiffeisenbank, migrated to PostgreSQL a number of systems, we decided to conduct an open Mitap on new features in PostgeSQL 11.
 
 
We are waiting for you on May 23 at 6 pm in the Nagatinsky office of Raiffeisenbank at Moscow, Andropov Avenue 1? building 2.
 

 
The entrance is free. ...
+ 0 -

Digest of news from the world of PostgreSQL. Issue number 6

Digest of news from the world of PostgreSQL. Issue number 6 We continue to acquaint you with the most interesting news on PostgreSQL. [/i]
 
 

Releases


 
PostgreSQL 11 Beta
 
The release command PostgreSQL was determined with the release date of the beta version: May 2? 2018.
 
 
PostgreSQL 10.4 was released
 
 
Unlike version 10.? which was unplanned (it was necessary to immediately close important security holes), this version was released in accordance with graph .
 
In the new version many corrections ...[/h]
+ 0 -

noBackend, or How to survive in the era of fat clients

noBackend, or How to survive in the era of fat clientsThe title of the article should not be taken literally:
backend has not gone anywhere
, simply the focus of development - especially at the initial stage of the development of a new project - is strongly shifted towards "
client part
". There is a great temptation to take something understandable for data storage and already "bound" REST API, to give up PHP /Python /Ruby /Java /etc as much as possible, to write 80% of the code "on the client side", minimally worrying about the "server side" ".
 
 
This article is based on the report
Nikolay Samokhvalov
, which, in turn, summarized the experience ...
+ 0 -

DevConf: promising databases for highload

DevConf 2018 already next week! Last year Yury Nasretdinov conducted an interesting survey of promising data storage systems for highload. Video with the report is available at page of the report . And for habra-readers I offer a brief retelling.
 
 
DevConf: promising databases for highload In the beginning I'll tell you how to approach the choice of technology for a highload project.
 
 
 
First of all, there must be an understanding of how it works. Not only strong, but also weak points.
 
Knowing how to monitor and backup. Without good tools for this, this technology is early to use in production.
 
Sooner or later the systems ...
+ 0 -

What's new in PostgreSQL 11: improvements in casting

What's new in PostgreSQL 11: improvements in casting  
 
Continuing the theme of the new features of the upcoming release of PostgreSQL 11 (the previous posts: Times , two , tree ), I would like to tell you about one small but important change. Change this applies to casting some types in others. And, of course, it concerns JSONB, because in PostgresPro we love it very much! patch c0cbe00f :
 
 
commit c0cbe00fee6d0a5e0ec72c6d68a035e674edc4cc
 
Author: Teodor Sigaev
 
Date: Thu Mar ???:33:??? ...
+ 0 -

What's new in PostgreSQL 11: JSONB-transforms &lt;{short}&gt; &lt;{full}&gt; <div class="post__text post__text-html js-mediator-article"> <img src="https://habrastorage.org/webt/e7/5c/sk/e75csk69u0f_aymdeeopysub2bk.jpeg" alt=""><br>   <br>   In

<{full}>
What's new in PostgreSQL 11: JSONB-transforms        
    
 In previous posts you could read about  INCLUDE-indices  and  built-in web search  . These features will appear in PostgreSQL 1? whose release, I will remind, is planned in October. Today I would like to continue to review the new features of the upcoming release, telling about  JSONB-Transforms  for PL /Python languages ​​(        
    
 In previous posts you could read about  INCLUDE-indices  and  built-in web search  . These features will appear in PostgreSQL 1? whose release, I will remind, is planned in October. Today I would like to continue to review the new features of the upcoming release, telling about  JSONB-Transforms  for PL /Python languages ​​(  
 
In previous posts you could read about
INCLUDE-indices
and
built-in web search
. These features will appear in PostgreSQL 1? whose release, I will remind, is planned in October. Today I would like to continue to review the new features of the upcoming release, telling about JSONB-Transforms for PL /Python languages ​​( <{short}>   In previous posts you could read about INCLUDE-indices and built-in web search . These features will appear in PostgreSQL 1? whose release, I will remind, is planned in October. Today I would like to continue to review the new features of the upcoming release, telling about JSONB-Transforms for PL /Python languages ​​(   In previous posts you could read about INCLUDE-indices and built-in web search . These features will appear in PostgreSQL 1? whose release, I will remind, is planned in October. Today I would like to continue to review the new features of the ...
+ 0 -

Digest of news from the world of PostgreSQL. Issue number 5

Digest of news from the world of PostgreSQL. Issue number 5  
 

Feature freeze


 
This, of course, is the main event for the community. The fact that the recently ended comitfest has not passed is not included in the version of PostgreSQL 11.
 
 
That they froze on feature freeze
 
This is our summary of the most important patches.
 
Summary summary, and articles about PostgreSQL 11 have already started appearing. And then - more.
 
 
Waiting for PostgreSQL 11 - Transforms for jsonb to PL /Python and to PL /Perl
 
Depeche , that is Hubert 'depesz' Lubaszewski, ...[/h]
+ 0 -

What's new in PostgreSQL 11: built-in web search

What's new in PostgreSQL 11: built-in web search  
 
Continuing with theme of interesting possibilities of the forthcoming release of PostgreSQL 1? I would like to tell about new built-in function websearch_to_tsquery . The corresponding patch developed by Victor Drobny and Dmitry Ivanov, with corrections from Fedor Sigayev. Let's figure out what is implemented in this patch. full-text search has been in PostgreSQL for a long time, and it works very well. What else could I add?
 
 
Imagine that you are doing an online store based on PostgreSQL and you need a search for products...
+ 0 -

DevConf: Uber transition from PostgreSQL to MySQL

May 1? 2018 in Digital October will take place DevConf 2018 . And we decided to retell some interesting reports from last year's conference. There was a report with a somewhat holistic title: " " What the political instructor is silent аbout: to the discussion about the transition of Uber from PostgreSQL to MySQL " In it, the developer of MySQL Alexey Kopytov considered the differences between InnoDb and PostgreSQL at the lowest level, including the organization of data, memory and replicas. We bring to your attention a brief retelling of the report.
 
 
DevConf: Uber transition from PostgreSQL to MySQL
 
[h3] ...[/h]
+ 0 -

What was frozen on the feature freeze

What was frozen on the feature freeze
 
 
April 8 ended komitfest 2018-03 . Those patches that are not zakomichcheni on it (and the 3 previous komitfestah) will not fall into the release of PostgreSQL 11: there was a freeze of functionality (feature freeze). It's time to sum up.
 
 
The main news of the last komitfest (and version 11 respectively):
 
a hefty set of patches for partitioning.
 
JIT-compilation is devoted to only one patch, but this is a step in the direction that in the future will surely develop intensively.
 
"Covering" indices (INCLUDE-indices). This topic is already actively discussed and continues in development.
 
A s...
+ 0 -