Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Foundation - Pl\pgsql

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for Deepak Mahto Deepak Mahto
June 17, 2024
Technology
0
290

Foundation - Pl\pgsql

Webinar on Foundation - Procedural Development with PostgreSQL.

Highlight importance on development near data, PL\pgSQL Internals.

Avatar for Deepak Mahto

Deepak Mahto

June 17, 2024
Tweet

More Decks by Deepak Mahto

See All by Deepak Mahto
What's New in PostgreSQL 17 for Developer.
Avatar for Deepak Mahto deepakmahto
0
140
Accelerating PL/pgSQL Code Conversion When Migrating to Postgres
Avatar for Deepak Mahto deepakmahto
0
230
Optimizing Numeric Data Types in Oracle to PostgreSQL Migration
Avatar for Deepak Mahto deepakmahto
0
130

Other Decks in Technology

See All in Technology
OCI技術資料 : 外部接続 VPN接続 詳細
Avatar for Oracle Cloud Infrastructure ソリューション・エンジニア ocise
1
10k
論文検索を日本語でできるアプリを作ってみた
Avatar for sai-lens sailen2
0
150
Webアクセシビリティ技術と実装の実際
Avatar for tomokusaba tomokusaba
0
160
Snowflakeデータ基盤で挑むAI活用 〜4年間のDataOpsの基礎をもとに〜
Avatar for K.Mitsuhashi kaz3284
1
300
研究開発部メンバーの働き⽅ / Sansan R&D Profile
Avatar for Sansan, Inc. sansan33
PRO
4
22k
Databricksアシスタントが自分で考えて動く時代に! エージェントモード体験もくもく会
Avatar for Takaaki Yayoi taka_aki
0
250
AIエージェントで変わる開発プロセス ― レビューボトルネックからの脱却
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
2
820
Claude Codeはレガシー移行でどこまで使えるのか？
Avatar for ak2ie ak2ie
1
1.1k
Interop Tokyo 2025 ShowNet Team Memberで学んだSRv6を基礎から丁寧に
Avatar for miyukichi_ospf miyukichi_ospf
0
260
ヘルシーSRE
Avatar for Hiroki Takatsuka tk3fftk
2
200
なぜAIは組織を速くしないのか 令和の腑分け
Avatar for su8 / denchu sugino
80
52k
俺の失敗を乗り越えろ！メーカーの開発現場での失敗談と乗り越え方 ～ゆるゆるチームリーダー編～
Avatar for Satoshi Deishi spiddle
0
420

Featured

See All Featured
Discover your Explorer Soul
Avatar for Emna emna__ayadi
2
1.1k
Skip the Path - Find Your Career Trail
Avatar for Mark Kilby mkilby
0
71
From π to Pie charts
Avatar for Rasagy Sharma rasagy
0
140
The Cost Of JavaScript in 2023
Avatar for Addy Osmani addyosmani
55
9.7k
Design in an AI World
Avatar for tapps tapps
0
160
Reality Check: Gamification 10 Years Later
Avatar for Sebastian Deterding codingconduct
0
2k
Sharpening the Axe: The Primacy of Toolmaking
Avatar for Bryan Cantrill bcantrill
46
2.7k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
Avatar for Kevin Liebholz kevinliebholz
37
6.3k
The untapped power of vector embeddings
Avatar for Frank van Dijk frankvandijk
2
1.6k
Designing Experiences People Love
Avatar for Jonathan Moore moore
144
24k
Game over? The fight for quality and originality in the time of robots
Avatar for Wayne Barker wayneb77
1
130
It's Worth the Effort
Avatar for 3n 3n
188
29k

Transcript

  1. None

  2. Foundation - Pl\pgsql Loadable procedural language for the PostgreSQL database

    system.

  3. About me

  4. Why PostgreSQL https://medium.com/@fengruohang/postgres-is-eating-the-database-world-157c204dcfc4

  5. What is PL\pgSQL?

  6. Language —> Block is enclosed in Quotes https://cloud.tembo.io/

  7. PL/pgsql is a block-structured language —> Block is enclosed in

    Quotes —>Quotes Escaping

  8. Dollar Quoting $$ —> Block is enclosed in Quotes

  9. Functions in Pl\pgsql —> Block is enclosed in Quotes

  10. SQL as Language for Functions

  11. Procedural code - Volatility

  12. Procedural code - Extra Warning

  13. Plpgsql with your Favourite Code Editor.

  14. PLpgsql compilation —> Block is enclosed in Quotes

  15. Fun Demos —> Block is enclosed in Quotes

  16. My Database Courses