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
Embrace the Grind
shrayasr
0
93
The programmers guide to timestamps and timezones - PyCon India 2023
shrayasr
0
130
A gentle introduction to types
shrayasr
1
140
Python, Imap & Gmail
shrayasr
2
220
Hylang - A Python powered Lisp AND a Lisp powered Python
shrayasr
2
720
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
Rubyで作る論理回路シミュレータの設計の話 - Kashiwa.rb #12
kozy4324
1
310
從四件事帶你見識見識 事件驅動架構設計 (EDA)
line_developers_tw
PRO
0
110
Snowflake Intelligenceで実現できるノーコードAI活用
takumimukaiyama
1
240
Tenstorrent 開発者プログラム
tenstorrent_japan
0
310
「規約、知識、オペレーション」から考える中規模以上の開発組織のCursorルールの 考え方・育て方 / Cursor Rules for Coding Styles, Domain Knowledges and Operations
yuitosato
6
1.8k
Contract One Engineering Unit 紹介資料
sansan33
PRO
0
6.4k
Nonaka Sensei
kawaguti
PRO
4
710
産業機械をElixirで制御する
kikuyuta
0
170
Copilot Agentを普段使いしてわかった、バックエンド開発で使えるTips
ykagano
1
1.2k
Cloud Native Scalability for Internal Developer Platforms
hhiroshell
2
460
IIWレポートからみるID業界で話題のMCP
fujie
0
380
API の仕様から紐解く「MCP 入門」 ~MCP の「コンテキスト」って何だ?~
cdataj
0
160
Featured
See All Featured
Visualization
eitanlees
146
16k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
281
13k
How to Ace a Technical Interview
jacobian
276
23k
[RailsConf 2023] Rails as a piece of cake
palkan
55
5.6k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
161
15k
Measuring & Analyzing Core Web Vitals
bluesmoon
7
480
RailsConf 2023
tenderlove
30
1.1k
Building Applications with DynamoDB
mza
95
6.4k
Optimising Largest Contentful Paint
csswizardry
37
3.3k
YesSQL, Process and Tooling at Scale
rocio
172
14k
Unsuck your backbone
ammeep
671
58k
How to Think Like a Performance Engineer
csswizardry
24
1.7k
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