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 Serverless PHP
Search
shiro seike
PRO
January 13, 2024
Programming
0
150
やるぞ!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
地方こそサーバーレス、その意義に迫るサーバーレスPHP / Serverless PHP: The Rural Areas, and Why Serverless PHP Matters
seike460
PRO
2
49
サーバーレスらしさを意識した AWSにおける開発手法 / Development methodologies in AWS that are serverless-like
seike460
PRO
1
56
OpenAPIを中心に考えるAPI開発入門 / Introduction to API Development with a Focus on OpenAPI
seike460
PRO
2
190
PHP8.3の機能を振り返る / Review of PHP 8.3 features
seike460
PRO
1
120
フルサーバーレスアーキテクチャの運用を重ねた先に見える価値 / The value that can be seen beyond the operation of a full serverless architecture
seike460
PRO
0
23
決断するための勇気、そのためのBacklog / Courage to make decisions, Backlog for that.
seike460
PRO
4
2.1k
Backlog API x Generative AI
seike460
PRO
0
87
「サーバーレス」ってなんだろう みんなでワイガヤ談義 / What is "serverless?" Wigaya discussion with everyone
seike460
PRO
0
34
とにかくHTTP3をライトニングに話す / Anyway, I'll talk to Lightning about HTTP3.
seike460
PRO
0
130
Other Decks in Programming
See All in Programming
TypeScriptのパフォーマンス改善
yajihum
9
4.1k
TypeScriptコードの漸進的改善 / Progressive Improvement of TypeScript Code
medley
1
130
GNU Makeの使い方 / How to use GNU Make
kaityo256
PRO
12
4.3k
Inner Source@DB: Eine Geschichte über Open-Source-Praktiken im DB Konzern
morl99
1
100
Exploring Type-Informed Lint Rules in Rust based Linters
unvalley
2
330
仕様と実装で学ぶOpenTelemetry
drumato
2
170
dbtのドメイン分割による データ基盤の改善とDigdagとの連携
sakama
0
490
CDKコントリビュートの最初の壁を越えよう! -簡単issueの見つけ方-
badmintoncryer
3
390
『Railsオワコン』と言われる時代に、なぜブルーモ証券はRailsを選ぶのか
free_world21
2
410
Deep Dive into React Stream/Serialize
mugi_uno
3
780
PHPコードの実行モデルを理解する / Understanding-the-PHP-Execution-Model
shin1x1
0
130
Goのmultiple errorsについて (2024年4月版)
syumai
4
1.3k
Featured
See All Featured
Teambox: Starting and Learning
jrom
128
8.4k
Learning to Love Humans: Emotional Interface Design
aarron
267
39k
In The Pink: A Labor of Love
frogandcode
138
21k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
21
1.6k
KATA
mclloyd
16
12k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
188
16k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
155
14k
Documentation Writing (for coders)
carmenintech
60
4k
Fireside Chat
paigeccino
22
2.6k
The Brand Is Dead. Long Live the Brand.
mthomps
49
30k
Making the Leap to Tech Lead
cromwellryan
125
8.5k
Creatively Recalculating Your Daily Design Routine
revolveconf
211
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/