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
95
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
610
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
150
Other Decks in Technology
See All in Technology
GoとアクターモデルでES+CQRSを実践! / proto_actor_es_cqrs
ytake
1
160
データベース研修 分析向けSQL入門【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
110
What if...? 처음부터 다시 LLM 어플리케이션을 개발한다면
huffon
0
1k
AOAI Dev Day - Opening Session
yoshidashingo
2
470
サービスの持続的な成長と技術負債について
siva_official
PRO
10
4.4k
データ分析を支える技術 生成AI再入門
ishikawa_satoru
0
380
Azure OpenAI Service Dev Day / LLMでできる!使える!生成AIエージェント
masahiro_nishimi
3
810
年間一億円削減した時系列データベースのアーキテクチャ改善~不確実性の高いプロジェクトへの挑戦~
lycorptech_jp
PRO
3
2.9k
テストケースの自動生成に生成AIの導入を試みた話と生成AIによる今後の期待
shift_evolve
0
190
RAGのサービスをリリースして1年3ヶ月が経ちました
segavvy
4
960
DDDにおける認可の扱いとKotlinにおける実装パターン / authorization-for-ddd-and-kotlin-implement-pattern
urmot
4
390
AIアシスタントの活用で品質の向上と開発ワークフローのスピードアップ
nagix
1
210
Featured
See All Featured
Optimizing for Happiness
mojombo
373
69k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
29
2.5k
Mobile First: as difficult as doing things right
swwweet
219
8.8k
Debugging Ruby Performance
tmm1
71
11k
Why Our Code Smells
bkeepers
PRO
332
56k
The Pragmatic Product Professional
lauravandoore
29
6.1k
Design by the Numbers
sachag
277
18k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
121
18k
Being A Developer After 40
akosma
72
580k
Product Roadmaps are Hard
iamctodd
PRO
48
10k
Building Effective Engineering Teams - LeadDev
addyosmani
47
2.2k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
226
52k
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