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
370
やるぞ!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
なぜ適用するか、移行して理解するClean Architecture 〜構造を超えて設計を継承する〜 / Why Apply, Migrate and Understand Clean Architecture - Inherit Design Beyond Structure
seike460
PRO
3
790
生成AIコーディングとの向き合い方、AIと共創するという考え方 / How to deal with generative AI coding and the concept of co-creating with AI
seike460
PRO
1
390
地方のPHPerもクラウドを使う理由 ~コストの最適化とチームに向き合う~ / Why even local PHPers use the cloud ~optimize costs and face the team
seike460
PRO
0
64
OpenTelemetryで始めるベンダーフリーなobservability / Vendor-free observability starting with OpenTelemetry
seike460
PRO
0
170
AIコーディングの本質は“コード“ではなく“構造“だった / The essence of AI coding is not “code” but "structure
seike460
PRO
2
1.1k
OpenTelemetryを活用したObservability入門 / Introduction to Observability with OpenTelemetry
seike460
PRO
1
660
Amazon Q Developer Proで効率化するAPI開発入門
seike460
PRO
0
330
実行委員長が振り返るBacklogWorldの裏側と運営Backlog術 / The chairperson of the executive committee looks back on the backstage of BacklogWorld and the art of managing Backlog.
seike460
PRO
0
4
Amazon Aurora DSQLパフォーマンスチェック / Amazon Aurora DSQL Performance Check
seike460
PRO
0
15
Other Decks in Programming
See All in Programming
PipeCDのプラグイン化で目指すところ
warashi
1
300
Model Pollution
hschwentner
1
160
システム成長を止めない!本番無停止テーブル移行の全貌
sakawe_ee
1
360
RailsGirls IZUMO スポンサーLT
16bitidol
0
200
Goで作る、開発・CI環境
sin392
0
260
Porting a visionOS App to Android XR
akkeylab
0
680
코딩 에이전트 체크리스트: Claude Code ver.
nacyot
0
930
AIともっと楽するE2Eテスト
myohei
8
3k
AI時代の『改訂新版 良いコード/悪いコードで学ぶ設計入門』 / ai-good-code-bad-code
minodriven
23
9.6k
ふつうの技術スタックでアート作品を作ってみる
akira888
1
1.3k
Modern Angular with Signals and Signal Store:New Rules for Your Architecture @enterJS Advanced Angular Day 2025
manfredsteyer
PRO
0
270
効率的な開発手段として VRTを活用する
ishkawa
0
160
Featured
See All Featured
A Modern Web Designer's Workflow
chriscoyier
695
190k
Build The Right Thing And Hit Your Dates
maggiecrowley
37
2.8k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
53
2.9k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
10
970
Producing Creativity
orderedlist
PRO
346
40k
The Cult of Friendly URLs
andyhume
79
6.5k
Done Done
chrislema
184
16k
RailsConf 2023
tenderlove
30
1.1k
4 Signs Your Business is Dying
shpigford
184
22k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
507
140k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
50k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
50
5.5k
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/