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
840
生成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
720
Amazon Q Developer Proで効率化するAPI開発入門
seike460
PRO
0
380
実行委員長が振り返るBacklogWorldの裏側と運営Backlog術 / The chairperson of the executive committee looks back on the backstage of BacklogWorld and the art of managing Backlog.
seike460
PRO
0
10
Amazon Aurora DSQLパフォーマンスチェック / Amazon Aurora DSQL Performance Check
seike460
PRO
0
20
Other Decks in Programming
See All in Programming
コーディングは技術者(エンジニア)の嗜みでして / Learning the System Development Mindset from Rock Lady
mackey0225
2
630
🔨 小さなビルドシステムを作る
momeemt
2
620
Vue・React マルチプロダクト開発を支える Vite
andpad
0
110
Claude Codeで挑むOSSコントリビュート
eycjur
0
190
UbieのAIパートナーを支えるコンテキストエンジニアリング実践
syucream
2
780
個人軟體時代
ethanhuang13
0
260
Kiroの仕様駆動開発から見えてきたAIコーディングとの正しい付き合い方
clshinji
1
180
私の後悔をAWS DMSで解決した話
hiramax
4
170
go test -json そして testing.T.Attr / Kyoto.go #63
utgwkk
1
180
実用的なGOCACHEPROG実装をするために / golang.tokyo #40
mazrean
1
120
rage against annotate_predecessor
junk0612
0
140
あのころの iPod を どうにか再生させたい
orumin
2
2.6k
Featured
See All Featured
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
333
22k
How to train your dragon (web standard)
notwaldorf
96
6.2k
The Straight Up "How To Draw Better" Workshop
denniskardys
236
140k
The Cost Of JavaScript in 2023
addyosmani
53
8.9k
Designing for humans not robots
tammielis
253
25k
Agile that works and the tools we love
rasmusluckow
330
21k
Git: the NoSQL Database
bkeepers
PRO
431
66k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
16k
Building Adaptive Systems
keathley
43
2.7k
The Power of CSS Pseudo Elements
geoffreycrofte
77
5.9k
[RailsConf 2023] Rails as a piece of cake
palkan
56
5.8k
Why Our Code Smells
bkeepers
PRO
339
57k
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/