やるぞ！DBaaS x サーバーレスPHP / Let's do it! DBaaS x Serverless PHP

Slide 1

Slide 1 text

DBaaS x PHP PHP 2024 2 0 24 . 1 . 12 @seike 4 60 1

Slide 2

Slide 2 text

自己 @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

Slide 3

Slide 3 text

3 DBaaS PHP

Slide 4

Slide 4 text

4 ?

Slide 5

Slide 5 text

言自 Cloud Native Computing Foundation 文 CNCF Serverless Whitepaper v 1 . 0 https://github.com/cncf/wg-serverless/tree/master/whitepapers/serverless-overview 5

Slide 6

Slide 6 text

自 6

Slide 7

Slide 7 text

FaaS 7 FaaS(Function as a Service) 心 AWS AWS Lambda Azure Azure Functions GCP Google Cloud Functions Google Cloud Run AWS Lamnda PHP 行

Slide 8

Slide 8 text

用　用　用 8

Slide 9

Slide 9 text

Slide 10

Slide 10 text

自 CI/CD 自非 10

Slide 11

Slide 11 text

立用 11

Slide 12

Slide 12 text

心非 50 0 100 0 req/sec 心用非大 12

Slide 13

Slide 13 text

Slide 14

Slide 14 text

14 PHP

Slide 15

Slide 15 text

15 Bref

Slide 16

Slide 16 text

Bref PHP 　 AWS Lambda 　 Laravel Symfony 人　 CLI 16

Slide 17

Slide 17 text

Bref AWS Laravel AWS Lambda Laravel 用高 17

Slide 18

Slide 18 text

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/**'

Slide 19

Slide 19 text

PHP Fusic 用・ 19

Slide 20

Slide 20 text

AWS Lambda in production with Bref PHP Lovers Meetup vol. 0 ~

Slide 21

Slide 21 text

21 PHP

Slide 22

Slide 22 text

22 DBaaS

Slide 23

Slide 23 text

23 Supabase

Slide 24

Slide 24 text

supabase っPostgreSQL supabase PostgreSQL っっ Google GitHub Facebook っ自 API SQL RESTful API 自 PostgREST 用っ行っ一自行っ GitHub 用 -> EC 2 24

Slide 25

Slide 25 text

supabase っPostgreSQL supabase PostgreSQL っ自 API SQL RESTful API 自 PostgREST 用 25

Slide 26

Slide 26 text

Client OSS Client OSS Composer PostgREST PostgreSQL 用 RESTful API 自生 26 $ composer require supabase/postgrest-php

Slide 27

Slide 27 text

Client 生 -> ORM 用用用　 ORM 　 from 行 select insert update delete match like in 行 order limit 27

Slide 28

Slide 28 text

金 Free 2 用人目 $25 金用 28

Slide 29

Slide 29 text

Slide 30

Slide 30 text

30 DBaaS x PHP

Slide 31

Slide 31 text

Slide 32

Slide 32 text

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

Slide 33

Slide 33 text

Laravel x Bref 33 ID

Slide 34

Slide 34 text

Laravel x Bref 34

Slide 35

Slide 35 text

Laravel Breeze 用 35 っServerless Framework $ composer require laravel/breeze dev $ php artisan breeze:install

Slide 36

Slide 36 text

36 php js css Image AWS Lambda

Slide 37

Slide 37 text

Serverless Lift 37 っserverless-lift $ serverless plugin install -n serverless-lift

Slide 38

Slide 38 text

Serverless Lift 38

Slide 39

Slide 39 text

Serverless Lift 39 Public HTML API 風 ID ID ID

Slide 40

Slide 40 text

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

Slide 41

Slide 41 text

Laravel Breeze Supabase 用 41 ID ID

Slide 42

Slide 42 text

Slide 43

Slide 43 text

43 DBaaS x PHP

Slide 44

Slide 44 text

自己 @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

Slide 45

Slide 45 text

Thank You We are Hiring ! https://recruit.fusic.co.jp/