We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Viva, the NoSQL Postgres !

00:00
subtitles
off
playback rate
1
subtitles
off
English (auto-generated)
playback rate
0.25
0.5
0.75
1
1.25
1.5
1.75
2
quality
576p
8
 Cite
 Share
 Download Purchase
No logo availablePGCon - PostgreSQL Conference for Users and Developers
 Korotkov, Alexander Bartunov, Oleg

Formal Metadata

Title
Viva, the NoSQL Postgres !
Subtitle
Jsonpath - a query language for json
Title of Series
Number of Parts
35
Author
License
CC Attribution 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
PostgreSQL is the first relational database which recognized the need of non-atomic data types to support developers of applications from science to Web. Jsonb in Postgres is the attractive feature for modern application developers, who want to work with json documents without sacrificing a strong consistency and ability to use all the power of proven relational technology. Finally, SQL world has recognized the NoSQL and released the new SQL-2016 standard, which includes specification of SQL/JSON data model and path language, as well as SQL commands for storing, publishing and querying JSON data. We will present the implementation of jsonpath, the path language for querying json in PostgreSQL and discuss possible extensions, such as new indexing mode for non-atomic data, which allows to index only specified parts, for example, those parts of jsonb which matches given jsonpath[s] to opclass.
00:00
Drawing
00:49
Computer animation
02:14
DrawingComputer animation
03:55
Computer animation
05:07
Computer animation
06:28
Computer animation
07:27
Computer animation
08:52
Computer animation
13:24
Computer animation
14:49
Computer animation
15:43
Computer animation
17:39
Computer animation
18:44
Computer animation
20:03
Computer animation
21:13
Computer animation
23:02
Computer animation
24:09
Computer animation
24:55
Computer animation
25:45
Computer animation
26:59
Computer animation
27:52
Computer animation
30:05
Computer animation
30:46
Computer animation
31:23
Computer animation
32:40
Computer animation
34:20
Computer animation
35:07
Computer animation
36:00
Computer animation
37:38
Computer animation
38:18
Computer animation
42:11
Computer animation
43:55
Meeting/Interview
44:47
Computer animation
45:25
Computer animation
46:04
Computer animation
46:44
Computer animation
Transcript: English(auto-generated)