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

PHPカンファレンス北海道2024
https://phpcon.hokkaido.jp/

Transcript

1. DBaaS x PHP PHP 2024 2 0 24 . 1 . 12 @seike 4 60 1
2. 自己 @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. 3 DBaaS PHP
4. 4 ?
5. 言 自 Cloud Native Computing Foundation 文 CNCF Serverless Whitepaper v 1 . 0 https://github.com/cncf/wg-serverless/tree/master/whitepapers/serverless-overview 5
6. 自 6
7. FaaS 7 FaaS(Function as a Service) 心 AWS AWS Lambda Azure Azure Functions GCP Google Cloud Functions Google Cloud Run AWS Lamnda PHP 行
8. 用 　用 　 用 8
10. 自 CI/CD 自 非 10
11. 立 用 11
12. 心 非 50 0 100 0 req/sec 心 用 非 大 12
14. 14 PHP
15. 15 Bref
16. Bref PHP 　 AWS Lambda 　 Laravel Symfony 人 　 CLI 16
17. Bref AWS Laravel AWS Lambda Laravel 用 高 17
18. 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/**'
19. PHP Fusic 用 ・ 19
20. 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. 21 PHP
22. 22 DBaaS
23. 23 Supabase
24. supabase っPostgreSQL supabase PostgreSQL っ っ Google GitHub Facebook っ 自 API SQL RESTful API 自 PostgREST 用 っ 行 っ 一 自 行 っ GitHub 用 -> EC 2 24
25. supabase っPostgreSQL supabase PostgreSQL っ 自 API SQL RESTful API 自 PostgREST 用 25
26. Client OSS Client OSS Composer PostgREST PostgreSQL 用 RESTful API 自 生 26 $ composer require supabase/postgrest-php
27. Client 生 -> ORM 用 用 用 　 ORM 　 from 行 select insert update delete match like in 行 order limit 27
28. 金 Free 2 用 人目 $25 金 用 28
30. 30 DBaaS x PHP
32. 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
33. Laravel x Bref 33 ID
34. Laravel x Bref 34
35. Laravel Breeze 用 35 っServerless Framework $ composer require laravel/breeze dev $ php artisan breeze:install
36. 36 php js css Image AWS Lambda
37. Serverless Lift 37 っserverless-lift $ serverless plugin install -n serverless-lift
38. Serverless Lift 38
39. Serverless Lift 39 Public HTML API 風 ID ID ID
40. 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
41. Laravel Breeze Supabase 用 41 ID ID
43. 43 DBaaS x PHP
44. 自己 @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
45. Thank You We are Hiring ! https://recruit.fusic.co.jp/