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
320
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
110
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
640
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
Amazon CloudWatchで小さく始めるWebサービスのオブザーバビリティ / How to start Observability for Web Sevices with Amazon CloudWatch
sms_tech
3
180
Applied NLP with LLMs: Beyond Black-Box Monoliths
inesmontani
PRO
0
180
Vue.js、Nuxtの機能を使い、 大量のコピペコードをリファクタリングする
igayamaguchi
3
800
サーバレスで挑む IoT プロジェクトの現実解 / Real solutions for the IoT project using serverless service
genkiogasawara
1
110
Automated Tests Now and Future @ SQiP Workshop Special Lecture 2024
teyamagu
PRO
2
440
エンジニア向け会社紹介資料
caddi_eng
14
270k
Rist_Meetup_Kaggleは業務の役にたつ - ビジネスコンテンツ情報を活用する BtoB 事業編 - / rist-meetup-20241012
taro_masuda
0
260
プロダクト開発の貢献をアピールするための目標設計や認知活動 / Goal design and recognition activities to promote product development contributions.
oomatomo
5
1k
データ分析基盤のためにS3を深堀りする~アーキテクチャ設計の考え方のヒントに~
nrinetcom
PRO
1
740
LINE-ChatGPT 倫理問題を整理する全力肯定彼氏くん [LuC4]に訪れたサービス開始以来の最大の危機
o_ob
2
290
まだ間に合う! 生成AIトレンド一挙おさらい & AWSのBedrockに入門しよう
minorun365
PRO
4
140
ゼロからはじめる生成AI〜AWS認定とハンズオンで学ぶ初心者の道〜
kenichinakamura
0
130
Featured
See All Featured
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
25
1.8k
Raft: Consensus for Rubyists
vanstee
136
6.6k
Testing 201, or: Great Expectations
jmmastey
38
7k
Optimizing for Happiness
mojombo
375
69k
YesSQL, Process and Tooling at Scale
rocio
167
14k
Six Lessons from altMBA
skipperchong
26
3.4k
How GitHub (no longer) Works
holman
311
140k
Code Review Best Practice
trishagee
63
17k
Building Applications with DynamoDB
mza
90
6k
Making the Leap to Tech Lead
cromwellryan
131
8.9k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
9
630
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
43
6.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