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
380
やるぞ!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
850
生成AIコーディングとの向き合い方、AIと共創するという考え方 / How to deal with generative AI coding and the concept of co-creating with AI
seike460
PRO
1
420
地方のPHPerもクラウドを使う理由 ~コストの最適化とチームに向き合う~ / Why even local PHPers use the cloud ~optimize costs and face the team
seike460
PRO
0
71
OpenTelemetryで始めるベンダーフリーなobservability / Vendor-free observability starting with OpenTelemetry
seike460
PRO
0
190
AIコーディングの本質は“コード“ではなく“構造“だった / The essence of AI coding is not “code” but "structure
seike460
PRO
2
1.2k
OpenTelemetryを活用したObservability入門 / Introduction to Observability with OpenTelemetry
seike460
PRO
1
740
Amazon Q Developer Proで効率化するAPI開発入門
seike460
PRO
0
390
実行委員長が振り返るBacklogWorldの裏側と運営Backlog術 / The chairperson of the executive committee looks back on the backstage of BacklogWorld and the art of managing Backlog.
seike460
PRO
0
12
Amazon Aurora DSQLパフォーマンスチェック / Amazon Aurora DSQL Performance Check
seike460
PRO
0
22
Other Decks in Programming
See All in Programming
MCPでVibe Working。そして、結局はContext Eng(略)/ Working with Vibe on MCP And Context Eng
rkaga
5
2.2k
テストコードはもう書かない:JetBrains AI Assistantに委ねる非同期処理のテスト自動設計・生成
makun
0
250
「手軽で便利」に潜む罠。 Popover API を WCAG 2.2の視点で安全に使うには
taitotnk
0
840
Ruby Parser progress report 2025
yui_knk
1
430
250830 IaCの選定~AWS SAMのLambdaをECSに乗り換えたときの備忘録~
east_takumi
0
390
基礎から学ぶ大画面対応(Learning Large-Screen Support from the Ground Up)
tomoya0x00
0
410
ソフトウェアテスト徹底指南書の紹介
goyoki
1
150
MCPとデザインシステムに立脚したデザインと実装の融合
yukukotani
4
1.4k
テストカバレッジ100%を10年続けて得られた学びと品質
mottyzzz
2
570
MCPで実現するAIエージェント駆動のNext.jsアプリデバッグ手法
nyatinte
7
1.1k
Compose Multiplatform × AI で作る、次世代アプリ開発支援ツールの設計と実装
thagikura
0
140
実用的なGOCACHEPROG実装をするために / golang.tokyo #40
mazrean
1
250
Featured
See All Featured
Code Review Best Practice
trishagee
70
19k
Statistics for Hackers
jakevdp
799
220k
Building Better People: How to give real-time feedback that sticks.
wjessup
368
19k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
8
920
Facilitating Awesome Meetings
lara
55
6.5k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
30
9.6k
Six Lessons from altMBA
skipperchong
28
4k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
61k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
252
21k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
50k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
29
1.9k
The World Runs on Bad Software
bkeepers
PRO
70
11k
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/