Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
The beauty that is PostgreSQL
Search
Shrayas Rajagopal
July 25, 2015
Technology
2
300
The beauty that is PostgreSQL
Shrayas Rajagopal
July 25, 2015
Tweet
Share
More Decks by Shrayas Rajagopal
See All by Shrayas Rajagopal
The programmers guide to timestamps and timezones - PyCon India 2023
shrayasr
0
82
A gentle introduction to types
shrayasr
1
130
Python, Imap & Gmail
shrayasr
2
210
Hylang - A Python powered Lisp AND a Lisp powered Python
shrayasr
2
580
My journey with the world of Open Source
shrayasr
1
190
Introduction to SQLAlchemy ORMs
shrayasr
1
250
Intro to Mac OSX
shrayasr
2
160
Android, A premiere
shrayasr
1
110
SeeQuaL
shrayasr
1
140
Other Decks in Technology
See All in Technology
コンテナセキュリティの基本と脅威への対策
kyohmizu
3
680
カオナビの利用実績をアウトカムへつなげる旅 / example-of-data-management-startup-in-kaonavi
kaonavi
0
120
オブザーバビリティの Primary Signals
onk
PRO
0
540
PHPカンファレンス小田原2024
ysknsid25
3
660
Next'24 事例セッションの紹介とクラウド資格を活用したキャリア形成について語りMuscle
yasumuusan
1
310
PHP"オレ"カンファレンスの告知
ysknsid25
0
350
20240416_devopsdaystokyo
kzkmaeda
1
180
Signals Unleashed: The Full Guide
rainerhahnekamp
0
360
テストプロセスで大事にしていること #jasstnano
makky_tyuyan
0
110
2024/4/26 コンピュータ歴史博物館解説告知
toshi_atsumi
0
190
キャラクター制御のためのプロンプト術 for LINE Bot
uezo
0
520
NLP2024 参加報告LT ~RAGの生成評価と懇親戦略~ / nlp2024_attendee_presentation_LT_masuda
taro_masuda
1
190
Featured
See All Featured
Thoughts on Productivity
jonyablonski
57
3.8k
RailsConf 2023
tenderlove
2
530
The MySQL Ecosystem @ GitHub 2015
samlambert
242
12k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
321
20k
Side Projects
sachag
451
41k
The Art of Programming - Codeland 2020
erikaheidi
41
12k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
501
140k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
39
4.4k
It's Worth the Effort
3n
180
27k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
356
22k
Writing Fast Ruby
sferik
620
60k
Why You Should Never Use an ORM
jnunemaker
PRO
50
8.6k
Transcript
JULY 2015 select * from meetups where name = ‘chennaipy’
The beauty that is PostgreSQL
The beauty that is PostgreSQL PART 1
Shrayas Karthik
Shrayas Karthik
“ World’s most advanced open source database
2
INSERT statements 1
JSON support 2
Application
UI
API UI
DATA API UI
DATA API UI
API UI Structured Unstructured
API UI Structured Unstructured
API UI Unstructured Structured
API UI Data Data
History
9.2
9.2 JSON
9.2 JSON TEXT Format
9.2 JSON TEXT Format OK
9.2 JSON TEXT Format OK row_to_json array_to_json
9.2 JSON TEXT Format row_to_json array_to_json
9.4
9.4 JSONB
9.4 JSONB BINARY Format
9.4 JSONB BINARY Format row_to_jsonb array_to_jsonb ++
Demo
{ "notificationType": "Bounce", "bounce": { "bounceType": "", "bounceSubType": "", "bouncedRecipients":
[ { "emailAddress": "" } ], "timestamp": "", "feedbackId": "" }, "mail": { "timestamp": "", "messageId": "", "source": "", "sourceArn": "", "sendingAccountId": "", "destination": [] } } Bounce
{ "notificationType": "Delivery", "mail": { "timestamp": "", "messageId": "", "source":
"", "sourceArn": "", "sendingAccountId": "", "destination": [] }, "delivery": { "timestamp": "", "recipients": [], "processingTimeMillis": 546, "reportingMTA": "", "smtpResponse": "" } } Delivery
Conclusion
JAI HO PostgreSQL
TRY IT.
Le Fin @shrayasr @argvk