Supabaseって何？PHPから触ってみる / What is Supabase, and how to touch it from PHP?

Slide 1

Slide 1 text

Supabase PHP ( 非 )PHP 2023 LT 2 0 23 . 9 . 15 @seike 4 60 1

Slide 2

Slide 2 text

自己 @seike 46 0 - - @seike 46 0 - AWS Community Builder Serverless - Fusic - / 門 - / - - PHP - PHP - PHP - - PHP 2023 行長 - Fukuoka.php Organizer 2

Slide 3

Slide 3 text

Agenda 1 .Supabase 2 .PHP 用方 3 .Supabase x Bref 3

Slide 4

Slide 4 text

01 Supabase

Slide 5

Slide 5 text

Supabase PostgreSQL Supabase PostgreSQL Google GitHub Facebook 自 API SQL RESTful API 自行一自行 GitHub 用 5

Slide 6

Slide 6 text

02 PHP 用方

Slide 7

Slide 7 text

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

Slide 8

Slide 8 text

用　 ORM 　 8

Slide 9

Slide 9 text

03 Supabase x Bref

Slide 10

Slide 10 text

Bref PHP Custom Runtime - Serverless Framework 用 - AWS Serverless Application Model(SAM) 用 - Docker Image DockerHub 用 DockerCompose 10

Slide 11

Slide 11 text

Developer Community AWS Lambda 用 PHP 用 PHP Deploy 方 PHPer 辛 Bref 力 11 service: app-supabase provider: name: aws region: ap-northeast- 1 plugins: - ./vendor/bref/bref functions: api: handler: index.php description: '' runtime: php- 8 2 -fpm timeout: 28 # in seconds (API Gateway has a timeout of 29 seconds) events: - httpApi: '*' # Exclude files from deployment package: patterns: - '!node_modules/**' - '!tests/**' $ composer require bref/bref $ vendor/bin/bref init

Slide 12

Slide 12 text

Slide 13

Slide 13 text

13 $ ab -n 1 0 0 0 -c 1 00 https://rznktx 2 jhi.execute-api.ap-northeast- 1 .amazonaws.com/ This is ApacheBench, Version 2 . 3 <$Revision: 1 90 3 6 18 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/ Benchmarking rznktx 2 jhi.execute-api.ap-northeast- 1 .amazonaws.com (be patient) Completed 100 0 requests Finished 100 0 requests Server Software: Server Hostname: rznktx 2 jhi.execute-api.ap-northeast- 1 .amazonaws.com Server Port: 44 3 SSL/TLS Protocol: TLSv 1 . 2 ,ECDHE-RSA-AES 1 2 8 -GCM-SHA 2 56 , 20 4 8 , 12 8 Server Temp Key: ECDH P- 25 6 2 56 bits TLS Server Name: rznktx 2 jhi.execute-api.ap-northeast- 1 .amazonaws.com Document Path: / Document Length: 8 6 0 bytes Concurrency Level: 10 0 Time taken for tests: 4 . 7 9 0 seconds Complete requests: 1 0 0 0 Failed requests: 0 Total transferred: 10 57 0 00 bytes HTML transferred: 860 0 0 0 bytes Requests per second: 2 08 . 78 [#/sec] (mean) Time per request: 478 . 9 7 0 [ms] (mean) Time per request: 4 . 7 90 [ms] (mean, across all concurrent requests) Transfer rate: 21 5 . 51 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 10 1 141 4 0 . 0 120 3 67 Processing: 1 61 2 56 1 54 . 6 20 0 1 16 3 Waiting: 1 6 1 2 5 5 15 4 . 0 20 0 11 63 Total: 275 3 97 1 6 5 . 7 3 45 13 42 Percentage of the requests served within a certain time (ms) 5 0 % 3 4 5 6 6 % 3 8 4 7 5 % 3 9 6 8 0 % 4 0 8 9 0 % 5 3 1 9 5 % 7 9 9 9 8 % 1056 9 9 % 1060 1 00 % 1 3 42 (longest request)