Apologies if it's a bit rough -- paper cut on my index finger, but I wanted to share this anyway. Sign the MyGB guestbook here.  [MyGB](https://github.com/verfasor/MyGB) is a beefed-up version of the guestbook script originally mentioned in "[brewing a guestbook using cloudflare workers](https://mgx.bearblog.dev/brewing-a-guestbook-using-cloudflare-workers/)". This worker.js lets you host your own guestbook for free using Cloudflare's global network. It's designed to be lightweight and easy to embed anywhere. There is no middle man, no multi tenancy -- you own the code and you own the database. ## How it works * **The Engine (Cloudflare Workers):** The code runs on Cloudflare's edge servers. This makes your guestbook load instantly for visitors, no matter where they are. * **The Memory (Cloudflare D1):** Your data (messages, settings) is stored in D1, a SQL database that lives on the edge. * **The Look (HTML/CSS):** The user interface is generated directly by the worker. No complex build steps or frontend frameworks like React or Vue are needed..just fast, raw HTML and CSS. The entire application lives in a single file [worker.js](https://github.com/verfasor/MyGB/blob/main/worker.js), making it incredibly easy to manage and deploy. ## Philosophy **AI-Ready**: The code is extensively commented and structured to be easily understood. You can drop `worker.js` into your favorite AI agent or coding assistant to add new features, change the design, or customize it to your liking. **Open Source (AGPL v3)**: The source code is licensed under **GNU AGPL v3**. Please ensure that any "good" derivatives or improvements you make remain open source so others can benefit from them. ## Your project, your rules Consider MyGB as a primer or a starting foundation. You are encouraged to optimize the code, improve the database schema, or rewrite entire sections to fit your specific needs. The goal is to give you a solid, working guestbook that you can truly make your own. ## Deployment guide (no coding required) You can deploy this guestbook directly from the Cloudflare Dashboard without touching a command line. If you are a developer, you may refer to [getting-started.md](https://github.com/verfasor/MyGB/blob/main/getting-started.md) on GitHub repo. ### Prerequisites - A Cloudflare account (Free tier is fine) ### Step 1: create a D1 database  1. Log in to your Cloudflare Dashboard. 2. Go to **Storage & databases** > **D1 SQL database**. 3. Click **Create database**. 4. Name it `guestbook-db` (or anything you like). 5. Click **Create**. ### Step 2: create the Worker 1. Go to **Compute & AI** > **Workers & Pages** > **Overview**. 2. Click **Create application**.  3. Choose **"Start with Hello World!"** 4. Name your worker (e.g., `my-guestbook`).  6. Click **Deploy** (this creates a default Hello World worker and redirects you to the Worker overview page). 7. Click **Edit code**. ### Step 3: add the code 1. In the online code editor, you'll see a `worker.js` file. 2. Delete all the existing code in that file. 3. Copy the entire content of [worker.js](https://github.com/verfasor/MyGB/blob/main/worker.js) from the repository and paste it into the editor. 4. Deploy it.  > Ignore the `{"success":false,"error":"Cannot read properties of undefined (reading 'prepare')"}` error -- we will bind Database in the next step. ### Step 4: bind the database  1. Go back to your Worker's overview page (click the back arrow or navigate via dashboard). 2. Click the **Bindings** tab. 3. Click **Add binding**. 4. Choose **D1 Database**. 5. Variable name: `DB` (Must be exactly `DB`). 6. Database: Select the database you created in Step 1. 7. Cloudflare will automatically redeploy. ### Step 5: configure environment variables  1. In **Settings** tab of Worker, look for the **Variables and Secrets** section. 2. Click **Add**. 3. Add the following variables: 4. Click **Deploy** to apply changes. ### Step 6: initialize the database The application will automatically create the necessary database tables (`entries` and `settings`) when you first access it. **No manual SQL execution is required!** If you prefer to manually initialize the database, you can run the following SQL in the D1 Console: ```sql CREATE TABLE IF NOT EXISTS entries ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, message TEXT NOT NULL, site TEXT, email TEXT, created_at TEXT NOT NULL DEFAULT (datetime('now')), approved INTEGER NOT NULL DEFAULT 0 ); CREATE INDEX IF NOT EXISTS idx_approved ON entries(approved); CREATE INDEX IF NOT EXISTS idx_created_at ON entries(created_at); CREATE TABLE IF NOT EXISTS settings ( key TEXT PRIMARY KEY, value TEXT ); ``` ### Step 7: custom domain (optional)  Instead of the default `my-guestbook.your-subdomain.workers.dev`, you can use your own domain (e.g., `guestbook.example.com`). 1. Go to your Worker's **Settings** > **Domains & Routes**. 2. Click **Add Custom Domain**. 3. Enter the domain you want to use (it must be a domain active in your Cloudflare account). **Important for Turnstile:** If you use a custom domain, you must update your Turnstile widget settings: * Add your custom domain (e.g., `guestbook.example.com`) to the allowed domains list in the Turnstile dashboard. * If you plan to **embed** the guestbook on another site (e.g., `myblog.com`), add that domain to the Turnstile allowed list as well. > See Turnstile configuration in [security settings](#security). **Recommendation for API_URL:** If you are using a custom domain, it is highly recommended to add the `API_URL` variable in your Worker settings (e.g., `https://guestbook.example.com`). This ensures that if you visit the worker directly or use the embed code, the client-side scripts will always point to the correct custom domain API. ### Step 8: done! Visit your Worker's URL (e.g., `https://my-guestbook.your-subdomain.workers.dev`). - **Guestbook:** The home page is your guestbook. - **Admin Panel:** Go to `/login` to access the admin dashboard using the password you set. - **Embed:** Go to `/admin/embed` to get the code snippet for your website. ## Features & configuration Once logged into the Admin Panel, you can configure the guestbook via the **Settings** tab. These settings are stored in your D1 database. ### General settings - **Site Name:** The title of your guestbook page and HTML `