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
310
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
100
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
630
My journey with the world of Open Source
shrayasr
1
190
Introduction to SQLAlchemy ORMs
shrayasr
1
250
Intro to Mac OSX
shrayasr
2
170
Android, A premiere
shrayasr
1
110
SeeQuaL
shrayasr
1
160
Other Decks in Technology
See All in Technology
リクルート新人研修2024 テキスト生成AI活用
recruitengineers
PRO
10
420
エンジニア視点で見る、 組織で運用されるデザインシステムにするには
shunya078
1
160
技術力あげたい
hisaichi5518
2
2.8k
waitany と waitall を作った話
mrkn
0
110
目標設定と習慣化で今よりも一歩生産性を上げる
sansantech
PRO
7
2.3k
Bidirectional Quadratic Voting Leveraging Issue-Based Matching
kentaro
2
170
OCI コスト管理
ocise
1
110
Our Journey from in-House CD System to Open Source
ffjlabo
0
100
Datadogの便利な使い方 - 意外と知らない?CoScreenとCloudcraft
taijihagino
PRO
1
600
Envoy External AuthZとgRPC Extensionを利用した「頑張らない」Microservices認証認可基盤
andoshin11
0
140
日経電子版から始まった内製開発の現在地と向き合っている課題/inhouse
nishiuma
0
230
LLMに日本語テキストを学習させる意義
ksaito
13
3.4k
Featured
See All Featured
Build The Right Thing And Hit Your Dates
maggiecrowley
29
2.2k
Designing Experiences People Love
moore
138
23k
No one is an island. Learnings from fostering a developers community.
thoeni
18
2.9k
Put a Button on it: Removing Barriers to Going Fast.
kastner
58
3.4k
The Cult of Friendly URLs
andyhume
76
5.9k
A Modern Web Designer's Workflow
chriscoyier
690
190k
Fireside Chat
paigeccino
31
2.9k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
22
580
Side Projects
sachag
451
42k
Why Our Code Smells
bkeepers
PRO
333
56k
ParisWeb 2013: Learning to Love: Crash Course in Emotional UX Design
dotmariusz
109
6.9k
StorybookのUI Testing Handbookを読んだ
zakiyama
25
5k
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