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
やるぞ!DBaaS x サーバーレスPHP / Let's do it! DBaaS x Se...
Search
shiro seike
PRO
January 13, 2024
Programming
0
360
やるぞ!DBaaS x サーバーレスPHP / Let's do it! DBaaS x Serverless PHP
PHPカンファレンス北海道2024
https://phpcon.hokkaido.jp/
shiro seike
PRO
January 13, 2024
Tweet
Share
More Decks by shiro seike
See All by shiro seike
生成AIコーディングとの向き合い方、AIと共創するという考え方 / How to deal with generative AI coding and the concept of co-creating with AI
seike460
PRO
1
250
地方のPHPerもクラウドを使う理由 ~コストの最適化とチームに向き合う~ / Why even local PHPers use the cloud ~optimize costs and face the team
seike460
PRO
0
62
OpenTelemetryで始めるベンダーフリーなobservability / Vendor-free observability starting with OpenTelemetry
seike460
PRO
0
160
AIコーディングの本質は“コード“ではなく“構造“だった / The essence of AI coding is not “code” but "structure
seike460
PRO
2
940
OpenTelemetryを活用したObservability入門 / Introduction to Observability with OpenTelemetry
seike460
PRO
1
620
Amazon Q Developer Proで効率化するAPI開発入門
seike460
PRO
0
280
Amazon Aurora DSQLパフォーマンスチェック / Amazon Aurora DSQL Performance Check
seike460
PRO
0
7
(再)ひとり技術広報からの脱却 / Re:Breaking away from one-man technical public relations
seike460
PRO
1
220
Amazon Q Developer Proで 効率化するAPI開発 / Streamline API Development with Amazon Q Developer Pro
seike460
PRO
0
6
Other Decks in Programming
See All in Programming
Bytecode Manipulation 으로 생산성 높이기
bigstark
1
330
LINEヤフー データグループ紹介
lycorp_recruit_jp
0
520
Cursor Meetup Tokyo ゲノミクスとCursor: 進化と制約のあいだ
koido
2
1k
A comprehensive view of refactoring
marabesi
0
450
単体テストの始め方/作り方
toms74209200
0
440
Cursor AI Agentと伴走する アプリケーションの高速リプレイス
daisuketakeda
1
110
Rails産でないDBを Railsに引っ越すHACK - Omotesando.rb #110
lnit
1
160
Go Modules: From Basics to Beyond / Go Modulesの基本とその先へ
kuro_kurorrr
0
120
Practical Tips and Tricks for Working with Compose Multiplatform Previews (mDevCamp 2025)
stewemetal
0
120
Javaに鉄道指向プログラミング (Railway Oriented Pro gramming) のエッセンスを取り入れる/Bringing the Essence of Railway-Oriented Programming to Java
cocet33000
2
550
Beyond Portability: Live Migration for Evolving WebAssembly Workloads
chikuwait
0
360
Parallel::Pipesの紹介
skaji
2
910
Featured
See All Featured
YesSQL, Process and Tooling at Scale
rocio
172
14k
The Straight Up "How To Draw Better" Workshop
denniskardys
233
140k
Designing Experiences People Love
moore
142
24k
Bootstrapping a Software Product
garrettdimon
PRO
307
110k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
667
120k
Stop Working from a Prison Cell
hatefulcrawdad
269
20k
Unsuck your backbone
ammeep
671
58k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
PRO
181
53k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.7k
Docker and Python
trallard
44
3.4k
Agile that works and the tools we love
rasmusluckow
329
21k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
123
52k
Transcript
DBaaS x PHP PHP 2024 2 0 24 . 1
. 12 @seike 4 60 1
自己 @seike 46 0 - - @seike 46 0 -
AWS Community Builder Serverless - Fusic - / 門 - / - 月 PHP - PHP 2024 LT (Now ) - PHP 大 2024 LT - PHPerKaigi 20 2 4 LT - PHP 小 田 2024 - PHP 香 2024 - PHP 2024 2
3 DBaaS PHP
4 ?
言 自 Cloud Native Computing Foundation 文 CNCF Serverless Whitepaper
v 1 . 0 https://github.com/cncf/wg-serverless/tree/master/whitepapers/serverless-overview 5
自 6
FaaS 7 FaaS(Function as a Service) 心 AWS AWS Lambda
Azure Azure Functions GCP Google Cloud Functions Google Cloud Run AWS Lamnda PHP 行
用 用 用 8
9
自 CI/CD 自 非 10
立 用 11
心 非 50 0 100 0 req/sec 心 用 非
大 12
13
14 PHP
15 Bref
Bref PHP AWS Lambda Laravel Symfony 人
CLI 16
Bref AWS Laravel AWS Lambda Laravel 用 高 17
Developer Community PR 18 service: app-php-serverless provider: name: aws region:
ap-northeast- 1 plugins: - ./vendor/bref/bref functions: api: handler: index.php description: '' runtime: php- 83 -fpm timeout: 2 8 events: - httpApi: '*' # Exclude files from deployment package: patterns: - '!node_modules/**' - '!tests/**'
PHP Fusic 用 ・ 19
AWS Lambda in production with Bref PHP Lovers Meetup vol.
0 ~ <?php 2 0 23 . 7 . 10 @seike 4 60 2 0 Bref 方 見 https://speakerdeck.com/seike 46 0 /aws-lambda-in-production-with-bref
21 PHP
22 DBaaS
23 Supabase
supabase っPostgreSQL supabase PostgreSQL っ っ Google GitHub Facebook っ
自 API SQL RESTful API 自 PostgREST 用 っ 行 っ 一 自 行 っ GitHub 用 -> EC 2 24
supabase っPostgreSQL supabase PostgreSQL っ 自 API SQL RESTful API
自 PostgREST 用 25
Client OSS Client OSS Composer PostgREST PostgreSQL 用 RESTful API
自 生 26 $ composer require supabase/postgrest-php
Client 生 -> ORM 用 用 用 ORM
from 行 select insert update delete match like in 行 order limit 27
金 Free 2 用 人目 $25 金 用 28
29
30 DBaaS x PHP
31
Laravel x Bref 32 っServerless Framework $ npm install -g
serverless $ serverless config credentials --provider aws --key " key" --secret " secret" っLaravel $ composer create-project laravel/laravel phpcondo っBref $ composer require bref/bref bref/laravel-bridge update-with-dependencies っ $ serverless deploy
Laravel x Bref 33 ID
Laravel x Bref 34
Laravel Breeze 用 35 っServerless Framework $ composer require laravel/breeze
dev $ php artisan breeze:install
36 php js css Image AWS Lambda
Serverless Lift 37 っserverless-lift $ serverless plugin install -n serverless-lift
Serverless Lift 38
Serverless Lift 39 Public HTML API 風 ID ID ID
Laravel x Supabase 40 っ.env ?sslmode=require DB_CONNECTION=pgsql DATABASE_URL=postgresql://postgres:[YOUR-PASSWORD]@db.[YOUR-PROJECT- REF].supabase.co: 54
3 2 /postgres?sslmode=require っphp/conf.d/php.ini Bref PostgreSQL extension=pdo_pgsql っmigration $ php artisan migrate
Laravel Breeze Supabase 用 41 ID ID
42
43 DBaaS x PHP
自己 @seike 46 0 - - @seike 46 0 -
AWS Community Builder Serverless - Fusic - / 門 - / - 月 PHP 2024 - PHP 2024 LT (Done ) - PHP 大 2024 LT - PHPerKaigi 20 2 4 LT - PHP 小 田 2024 - PHP 香 2024 - PHP 2024 44
Thank You We are Hiring ! https://recruit.fusic.co.jp/