Cloudflare D1を試す

2222.02.21

`wrangler.toml`

該当箇所をコメントアウトして書き換える

schema.sql

Run DB

データベースは.wrangler/state/v3/d1に作成される

Select query

data fetch

https://developers.cloudflare.com/d1/examples/d1-and-hono/

migrationファイル作成

unapplied migration list

apply migration

Reset table

{
    "object": "block",
    "id": "e9ec4c12-95c3-44b0-ab32-6f74ba34f09f",
    "parent": {
        "type": "page_id",
        "page_id": "75cc6655-1078-4ea0-bcac-25800df5521b"
    },
    "created_time": "2024-05-09T12:50:00.000Z",
    "last_edited_time": "2024-05-21T09:47:00.000Z",
    "created_by": {
        "object": "user",
        "id": "bfc7eebb-0d83-4600-a1a6-c7f6f9f2eec8"
    },
    "last_edited_by": {
        "object": "user",
        "id": "bfc7eebb-0d83-4600-a1a6-c7f6f9f2eec8"
    },
    "has_children": false,
    "in_trash": false,
    "type": "heading_1",
    "heading_1": {
        "rich_text": [
            {
                "type": "text",
                "text": {
                    "content": "R2",
                    "link": null
                },
                "annotations": {
                    "bold": false,
                    "italic": false,
                    "strikethrough": false,
                    "underline": false,
                    "code": false,
                    "color": "default"
                },
                "plain_text": "R2",
                "href": null
            }
        ],
        "is_toggleable": false,
        "color": "default"
    },
    "archived": false
}

https://github.com/einverne/hono-cloudflare-r2

https://m.youtube.com/watch?v=IpBM5Oz72qw

https://yusukebe.com/posts/2022/r2-beta/

https://developers.cloudflare.com/r2/

Create new bucket

bucket list