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
330
The beauty that is PostgreSQL
Shrayas Rajagopal
July 25, 2015
Tweet
Share
More Decks by Shrayas Rajagopal
See All by Shrayas Rajagopal
Embrace the Grind
shrayasr
0
97
The programmers guide to timestamps and timezones - PyCon India 2023
shrayasr
0
140
A gentle introduction to types
shrayasr
1
140
Python, Imap & Gmail
shrayasr
2
230
Hylang - A Python powered Lisp AND a Lisp powered Python
shrayasr
2
730
My journey with the world of Open Source
shrayasr
1
200
Introduction to SQLAlchemy ORMs
shrayasr
1
270
Intro to Mac OSX
shrayasr
2
180
Android, A premiere
shrayasr
1
120
Other Decks in Technology
See All in Technology
増え続ける脆弱性に立ち向かう: 事前対策と優先度づけによる 持続可能な脆弱性管理 / Confronting the Rise of Vulnerabilities: Sustainable Management Through Proactive Measures and Prioritization
nttcom
1
210
AI駆動開発 with MixLeap Study【大阪支部 #3】
lycorptech_jp
PRO
0
270
スプリントレビューを効果的にするために
miholovesq
9
1.7k
Turn Your Community into a Fundraising Catalyst for Black Philanthropy Month
auctria
PRO
0
190
大規模イベントを支える ABEMA の アーキテクチャ 変遷 2025
nagapad
5
500
私とAWSとの関わりの歩み~意志あるところに道は開けるかも?~
nagisa53
1
130
なぜAI時代に 「イベント」を中心に考えるのか? / Why focus on "events" in the age of AI?
ytake
2
800
Shadow DOM & Security - Exploring the boundary between light and shadow
masatokinugawa
0
760
手動からの解放!!Strands Agents で実現する総合テスト自動化
ideaws
3
390
機械学習を「社会実装」するということ 2025年夏版 / Social Implementation of Machine Learning July 2025 Version
moepy_stats
1
1.4k
【CEDEC2025】LLMを活用したゲーム開発支援と、生成AIの利活用を進める組織的な取り組み
cygames
PRO
1
1.6k
ML Pipelineの開発と運用を OpenTelemetryで繋ぐ @ OpenTelemetry Meetup 2025-07
getty708
0
320
Featured
See All Featured
Reflections from 52 weeks, 52 projects
jeffersonlam
351
21k
4 Signs Your Business is Dying
shpigford
184
22k
Build The Right Thing And Hit Your Dates
maggiecrowley
37
2.8k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
60k
Facilitating Awesome Meetings
lara
54
6.5k
What's in a price? How to price your products and services
michaelherold
246
12k
How to Ace a Technical Interview
jacobian
278
23k
Fantastic passwords and where to find them - at NoRuKo
philnash
51
3.3k
Product Roadmaps are Hard
iamctodd
PRO
54
11k
The Language of Interfaces
destraynor
158
25k
Embracing the Ebb and Flow
colly
86
4.8k
RailsConf 2023
tenderlove
30
1.2k
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