\n \n

\n Garden Mapper - Database Admin\n

View and manage database contents

\n \n Back to Garden\n \n

\n\n

\n \n

\n Database Information\n

Loading database information...

\n\n

\n \n Refresh Data\n \n \n Show JSON View\n \n

\n\n \n

\n Plants Table\n

\n\n \n

Schema

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

CID	Name	Type	Not Null	Default Value	Primary Key
\n Loading schema...\n

\n\n \n

Records

\n \n \n \n \n Loading records...\n \n \n \n \n

\n\n \n

\n Gardens Table\n

\n\n \n

Schema

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

CID	Name	Type	Not Null	Default Value	Primary Key
\n Loading schema...\n

\n\n \n

Records

\n \n \n \n \n Loading records...\n \n \n \n \n

\n\n \n

\n\n \n \n",[],[156,174],{"_103":184,"_95":185,"_157":186,"_159":158,"_160":142,"_161":141,"_163":119,"_105":187,"_100":188,"_165":179,"_167":189,"_168":22,"_169":-5,"_170":190,"_98":191},"676c7ebe-459e-11f0-9252-76b3cceeab13","index.html","ed24e416-34ef-11f0-863c-9e149126039e",["D",1749520709069],134,"\n\n \n \n \n Gardenon\n \n \n \n \n \n \n

\n \n

Gardenon

\n Map your garden and track plant information\n

\n \n Admin Panel\n \n

\n\n \n

\n\n \n \n

\n Create New Garden\n

\n \n Garden Name\n \n \n

\n \n Width (pixels)\n \n \n

\n \n Height (pixels)\n \n \n

\n \n Cancel\n \n \n Create Garden\n \n

\n \n\n \n \n

\n Plant Information\n

\n \n ×\n \n

\n \n

Loading plant information...

\n \n

Failed to load plant information. Please try again.

\n \n

Description

\n \n

Light Needs

\n \n

Soil Needs

\n \n

Moisture Needs

\n \n

Bloom Time

\n \n

Height

\n \n

Spread

\n \n\n

\n \n

Garden Map

\n \n \n \n \n + New\n \n

\n \n Garden Settings\n \n

\n Tap anywhere on the map to add a plant\n

\n\n \n

\n Plant Details\n

\n \n Lookup Info\n \n

\n\n \n \n\n \n

Your Plants

\n No plants added yet. Tap on the map to get started.\n

\n \n\n \n \n",[],[156,185],[156],{"_103":194,"_95":99,"_157":195,"_159":-5,"_160":142,"_161":196,"_163":119,"_105":197,"_100":178,"_165":179,"_167":198,"_168":22,"_169":-5,"_170":199,"_98":200},"e472c6f8-434a-11f0-97e2-76b3cceeab13","f817be70-34ef-11f0-90ea-9e149126039e",155,["D",1749264938776],"# Garden Mapper\n\nA Val Town application for mapping multiple gardens and tracking information about each plant.\n\n## Features\n\n- **Multiple Garden Support** - Create and manage multiple gardens with different names and sizes\n- **Garden Selector** - Easily switch between different gardens using the dropdown selector\n- **Garden Settings** - Rename gardens and customize their size individually\n- Interactive garden map interface\n- Add plants with specific coordinates and diameters\n- Store notes and information about each plant\n- Edit and delete existing plants\n- Visual representation of plants on the map\n- Mobile-friendly with touch support\n- Admin panel for database management and inspection of both plants and gardens tables\n\n## API Endpoints\n\nThe application provides the following RESTful API endpoints:\n\n### Gardens\n\n#### GET /api/gardens\nReturns a list of all gardens.\n\n#### GET /api/gardens/:id\nReturns details for a specific garden by ID.\n\n#### POST /api/gardens\nCreates a new garden. Required fields:\n- `name`: Name of the garden\n\nOptional fields:\n- `garden_width`: Width of the garden map in pixels (300-2000, default: 800)\n- `garden_height`: Height of the garden map in pixels (300-2000, default: 500)\n\n#### PUT /api/gardens/:id\nUpdates garden settings. All fields are optional:\n- `name`: Name of the garden\n- `garden_width`: Width of the garden map in pixels (300-2000)\n- `garden_height`: Height of the garden map in pixels (300-2000)\n\n#### DELETE /api/gardens/:id\nRemoves a garden and all its plants. Cannot delete the last remaining garden.\n\n### Plants\n\n#### GET /api/gardens/:gardenId/plants\nReturns a list of all plants in a specific garden.\n\n#### GET /api/plants\nReturns a list of all plants across all gardens (for admin purposes).\n\n### GET /api/plants/:id\nReturns details for a specific plant by ID.\n\n### POST /api/plants\nCreates a new plant. Required fields:\n- `garden_id`: ID of the garden this plant belongs to\n- `x_coordinate`: X position on the map\n- `y_coordinate`: Y position on the map\n- `diameter`: Size of the plant in pixels\n\nOptional fields:\n- `name`: Name of the plant\n- `notes`: Additional information about the plant\n\n### PUT /api/plants/:id\nUpdates an existing plant. All fields are optional.\n\n### DELETE /api/plants/:id\nRemoves a plant from the garden.\n\n## Database Schema\n\nThe application uses SQLite with the following schemas:\n\n### Gardens Table\n```sql\nCREATE TABLE gardens_v2 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n garden_width INTEGER NOT NULL DEFAULT 800,\n garden_height INTEGER NOT NULL DEFAULT 500,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)\n```\n\n### Plants Table\n```sql\nCREATE TABLE garden_plants_v3 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n garden_id INTEGER NOT NULL,\n x_coordinate REAL NOT NULL,\n y_coordinate REAL NOT NULL,\n diameter REAL NOT NULL,\n name TEXT,\n notes TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)\n```\n\n## Usage\n\n### Garden Management\n\n1. **Select a Garden**: Use the dropdown selector next to \"Garden Map\" to switch between your gardens\n2. **Create New Garden**: Click the \"+ New\" button to create a new garden with a custom name and size\n3. **Garden Settings**: Click \"Garden Settings\" to rename your current garden or change its dimensions\n4. **Delete Garden**: Use the \"Delete Garden\" button in the settings modal (you cannot delete your last garden)\n\n### Plant Management\n\n1. **Add Plants**: Tap anywhere on the current garden map to immediately see a placeholder plant and open the edit form\n2. **Edit Plants**: Fill in the plant details form and tap \"Save Plant\" to convert the placeholder into a real plant\n3. **Clear Form**: Tap \"Clear Form\" to remove the placeholder plant and reset the form\n4. **Select Plants**: Tap on existing plants to edit their details\n5. **Move Plants**: Select a plant and click \"Move\", then click where you want to move it\n6. **Plant List**: Use the plant list on the right to quickly find and select plants in the current garden\n\n### Garden Settings\n\n- **Custom Sizes**: Set any garden size between 300×300 and 2000×2000 pixels\n- **Preset Options**: Choose from Small (600×400), Medium (800×500), or Large (1000×600) sizes\n- **Garden Names**: Give each garden a descriptive name like \"Front Yard\", \"Vegetable Garden\", etc.\n- **Persistent Settings**: Your garden settings are saved in the database and restored when you return to the app\n\n### Admin Panel\n\nAccess the admin panel by clicking \"Admin Panel\" in the header to view both database tables (plants and gardens) with their schemas and records.\n\n### Placeholder Plant Features\n\n- **Immediate Visual Feedback**: When you click the map, a gray dashed placeholder plant appears instantly\n- **Real-time Size Updates**: Adjust the diameter in the form to see the placeholder plant resize in real-time\n- **Smart Cleanup**: Placeholder plants are automatically removed when you save, clear the form, or select an existing plant\n\n## Technologies Used\n\n- Hono.js for the API backend\n- SQLite for data storage\n- Vanilla JavaScript for the frontend\n- Twind for styling",[],[99],{"_103":202,"_95":203,"_157":117,"_159":-5,"_160":142,"_161":204,"_163":119,"_105":205,"_100":206,"_165":207,"_167":208,"_168":22,"_169":209,"_170":210,"_98":211},"936ec5fc-4351-11f0-8770-76b3cceeab13","index.ts",178,["D",1749267809331],26,"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/cors\";\nimport { serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Initialize Hono app\nconst app = new Hono();\n\n// Enable CORS\napp.use(\"/*\", cors());\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Database setup\nconst TABLE_NAME = \"garden_plants_v3\";\nconst GARDENS_TABLE_NAME = \"gardens_v2\";\n\n// Initialize database\nasync function initDatabase() {\n // Create gardens table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${GARDENS_TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n garden_width INTEGER NOT NULL DEFAULT 800,\n garden_height INTEGER NOT NULL DEFAULT 500,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create plants table with garden_id reference\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n garden_id INTEGER NOT NULL,\n x_coordinate REAL NOT NULL,\n y_coordinate REAL NOT NULL,\n diameter REAL NOT NULL,\n name TEXT,\n notes TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Insert default garden if none exist\n await sqlite.execute(`INSERT OR IGNORE INTO ${GARDENS_TABLE_NAME} (id, name, garden_width, garden_height) \n VALUES (1, 'My Garden', 700, 500)`);\n}\n\n// Initialize database on startup\ninitDatabase();\n\n// API Routes\n// Get all gardens\napp.get(\"/api/gardens\", async (c) => {\n const gardensResult = await sqlite.execute(`SELECT * FROM ${GARDENS_TABLE_NAME} ORDER BY id ASC`);\n return c.json(gardensResult.rows);\n});\n\n// Get a specific garden\napp.get(\"/api/gardens/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const gardenResult = await sqlite.execute(`SELECT * FROM ${GARDENS_TABLE_NAME} WHERE id = ?`, [id]);\n\n if (gardenResult.rows.length === 0) {\n return c.json({ error: \"Garden not found\" }, 404);\n }\n\n return c.json(gardenResult.rows[0]);\n});\n\n// Create a new garden\napp.post(\"/api/gardens\", async (c) => {\n const body = await c.req.json();\n\n // Validate required fields\n if (!body.name) {\n return c.json({ error: \"Garden name is required\" }, 400);\n }\n\n // Validate garden dimensions\n const garden_width = body.garden_width || 800;\n const garden_height = body.garden_height || 500;\n\n if (\n garden_width < 300 || garden_width > 2000\n || garden_height < 300 || garden_height > 2000\n ) {\n return c.json({ error: \"Garden dimensions must be between 300 and 2000 pixels\" }, 400);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO ${GARDENS_TABLE_NAME} (name, garden_width, garden_height) \n VALUES (?, ?, ?)\n RETURNING *`,\n [body.name, garden_width, garden_height],\n );\n\n return c.json(result.rows[0], 201);\n});\n\n// Update garden settings\napp.put(\"/api/gardens/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n\n // Get the current garden to update only provided fields\n const currentGarden = await sqlite.execute(`SELECT * FROM ${GARDENS_TABLE_NAME} WHERE id = ?`, [id]);\n\n if (currentGarden.rows.length === 0) {\n return c.json({ error: \"Garden not found\" }, 404);\n }\n\n const garden = currentGarden.rows[0];\n\n // Update with new values or keep existing ones\n const name = body.name !== undefined ? body.name : garden.name;\n const garden_width = body.garden_width !== undefined ? body.garden_width : garden.garden_width;\n const garden_height = body.garden_height !== undefined ? body.garden_height : garden.garden_height;\n\n // Validate garden dimensions if they're being updated\n if (\n garden_width < 300 || garden_width > 2000\n || garden_height < 300 || garden_height > 2000\n ) {\n return c.json({ error: \"Garden dimensions must be between 300 and 2000 pixels\" }, 400);\n }\n\n const result = await sqlite.execute(\n `UPDATE ${GARDENS_TABLE_NAME} \n SET name = ?, garden_width = ?, garden_height = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n RETURNING *`,\n [name, garden_width, garden_height, id],\n );\n\n return c.json(result.rows[0]);\n});\n\n// Delete a garden\napp.delete(\"/api/gardens/:id\", async (c) => {\n const id = c.req.param(\"id\");\n\n // Check if this is the last garden\n const gardenCount = await sqlite.execute(`SELECT COUNT(*) as count FROM ${GARDENS_TABLE_NAME}`);\n if (gardenCount.rows[0].count <= 1) {\n return c.json({ error: \"Cannot delete the last garden\" }, 400);\n }\n\n await sqlite.execute(`DELETE FROM ${GARDENS_TABLE_NAME} WHERE id = ?`, [id]);\n\n return c.json({ success: true });\n});\n\n// Get all plants for a specific garden\napp.get(\"/api/gardens/:gardenId/plants\", async (c) => {\n const gardenId = c.req.param(\"gardenId\");\n const plantResults = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE garden_id = ? ORDER BY id DESC`, [\n gardenId,\n ]);\n return c.json(plantResults.rows);\n});\n\n// Get all plants (for admin purposes)\napp.get(\"/api/plants\", async (c) => {\n const plantResults = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} ORDER BY id DESC`);\n return c.json(plantResults.rows);\n});\n\n// Get database info (for admin purposes)\napp.get(\"/api/admin/db\", async (c) => {\n // Get table schema for plants\n const plantsSchema = await sqlite.execute(`PRAGMA table_info(${TABLE_NAME})`);\n\n // Get table schema for gardens\n const gardensSchema = await sqlite.execute(`PRAGMA table_info(${GARDENS_TABLE_NAME})`);\n\n // Get all plant records\n const plantRecords = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} ORDER BY id DESC`);\n\n // Get all garden records\n const gardenRecords = await sqlite.execute(`SELECT * FROM ${GARDENS_TABLE_NAME} ORDER BY id ASC`);\n\n // Get count of plant records\n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLE_NAME}`);\n const count = countResult.rows[0]?.count || 0;\n\n return c.json({\n plants_table: {\n name: TABLE_NAME,\n schema: plantsSchema,\n records: plantRecords,\n count,\n },\n gardens_table: {\n name: GARDENS_TABLE_NAME,\n schema: gardensSchema,\n records: gardenRecords,\n count: gardenRecords.rows.length,\n },\n });\n});\n\n// Get a specific plant\napp.get(\"/api/plants/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const plants = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [id]);\n\n if (plants.length === 0) {\n return c.json({ error: \"Plant not found\" }, 404);\n }\n\n return c.json(plants.rows[0]);\n});\n\n// Create a new plant\napp.post(\"/api/plants\", async (c) => {\n const body = await c.req.json();\n\n // Validate required fields\n if (!body.x_coordinate || !body.y_coordinate || !body.diameter || !body.garden_id) {\n return c.json({ error: \"x_coordinate, y_coordinate, diameter, and garden_id are required\" }, 400);\n }\n\n // Verify garden exists\n const gardenCheck = await sqlite.execute(`SELECT id FROM ${GARDENS_TABLE_NAME} WHERE id = ?`, [body.garden_id]);\n if (gardenCheck.rows.length === 0) {\n return c.json({ error: \"Garden not found\" }, 404);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (garden_id, x_coordinate, y_coordinate, diameter, name, notes) \n VALUES (?, ?, ?, ?, ?, ?)\n RETURNING *`,\n [\n body.garden_id,\n body.x_coordinate,\n body.y_coordinate,\n body.diameter,\n body.name || \"\",\n body.notes || \"\",\n ],\n );\n\n return c.json(result.rows[0], 201);\n});\n\n// Update a plant\napp.put(\"/api/plants/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n\n // Get the current plant to update only provided fields\n const currentPlant = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [id]);\n\n if (currentPlant.rows.length === 0) {\n return c.json({ error: \"Plant not found\" }, 404);\n }\n\n const plant = currentPlant.rows[0];\n\n // Update with new values or keep existing ones\n const garden_id = body.garden_id !== undefined ? body.garden_id : plant.garden_id;\n const x_coordinate = body.x_coordinate !== undefined ? body.x_coordinate : plant.x_coordinate;\n const y_coordinate = body.y_coordinate !== undefined ? body.y_coordinate : plant.y_coordinate;\n const diameter = body.diameter !== undefined ? body.diameter : plant.diameter;\n const name = body.name !== undefined ? body.name : plant.name;\n const notes = body.notes !== undefined ? body.notes : plant.notes;\n\n // Verify garden exists if garden_id is being changed\n if (body.garden_id !== undefined) {\n const gardenCheck = await sqlite.execute(`SELECT id FROM ${GARDENS_TABLE_NAME} WHERE id = ?`, [garden_id]);\n if (gardenCheck.rows.length === 0) {\n return c.json({ error: \"Garden not found\" }, 404);\n }\n }\n\n const result = await sqlite.execute(\n `UPDATE ${TABLE_NAME} \n SET garden_id = ?, x_coordinate = ?, y_coordinate = ?, diameter = ?, name = ?, notes = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n RETURNING *`,\n [garden_id, x_coordinate, y_coordinate, diameter, name, notes, id],\n );\n\n return c.json(result.rows[0]);\n});\n\n// Delete a plant\napp.delete(\"/api/plants/:id\", async (c) => {\n const id = c.req.param(\"id\");\n\n await sqlite.execute(`DELETE FROM ${TABLE_NAME} WHERE id = ?`, [id]);\n\n return c.json({ success: true });\n});\n\n// Serve static files\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\", import.meta.url));\napp.get(\"/admin\", (c) => serveFile(\"/frontend/admin.html\", import.meta.url));\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Export the Hono app\nexport default app.fetch;","gardenon",[],[203],"files",[154,172,183,193,201],"counts",{"_216":32,"_217":122,"_218":32,"_219":220},"pulls","branches","forks","envVars",{"_221":32,"_222":32},"count","emptyCount","contents",[],{"_103":194,"_160":142,"_157":195,"_95":99,"_167":198,"_165":179,"_100":178,"_159":-5,"_105":226,"_161":196,"_169":-5,"_98":227},["D",1749264938776],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":236,"_179":241,"_244":245,"_286":287,"_297":-7,"_298":32,"_299":22},{"_103":104,"_95":96,"_105":237,"_107":-5,"_108":22,"_109":110,"_111":112,"_113":114,"_14":115,"_116":117,"_118":119,"_120":-5,"_121":122,"_16":123,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":238,"_136":239,"_139":240,"_151":22},["D",1747686357282],{"_93":94,"_134":135},{"_93":94,"_138":135},{"_100":141,"_95":43,"_103":142,"_143":104,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":96,"_150":94},{"_103":194,"_95":99,"_157":195,"_159":-5,"_160":142,"_161":196,"_163":119,"_105":242,"_100":178,"_165":179,"_167":198,"_168":22,"_169":-5,"_98":243},["D",1749264938776],[99],"history",[246,248,254,260,266,272,277,282],{"_103":194,"_160":142,"_157":195,"_95":99,"_167":198,"_165":179,"_100":178,"_159":-5,"_105":247,"_161":196,"_169":-5},["D",1749264938776],{"_103":249,"_160":142,"_157":195,"_95":99,"_167":250,"_165":179,"_100":251,"_159":-5,"_105":252,"_161":253,"_169":-5},"ed58a204-4347-11f0-b03d-76b3cceeab13","# Garden Mapper\n\nA Val Town application for mapping your garden and tracking information about each plant.\n\n## Features\n\n- Interactive garden map interface\n- **Customizable garden size** - Resize your garden map to fit your needs\n- Add plants with specific coordinates and diameters\n- Store notes and information about each plant\n- Edit and delete existing plants\n- Visual representation of plants on the map\n- Mobile-friendly with touch support\n- Admin panel for database management and inspection of both plants and settings tables\n\n## API Endpoints\n\nThe application provides the following RESTful API endpoints:\n\n### Garden Settings\n\n#### GET /api/settings\nReturns the current garden configuration settings.\n\n#### PUT /api/settings\nUpdates garden configuration settings. Required fields:\n- `garden_width`: Width of the garden map in pixels (300-2000)\n- `garden_height`: Height of the garden map in pixels (300-2000)\n\n### Plants\n\n#### GET /api/plants\nReturns a list of all plants in the garden.\n\n### GET /api/plants/:id\nReturns details for a specific plant by ID.\n\n### POST /api/plants\nCreates a new plant. Required fields:\n- `x_coordinate`: X position on the map\n- `y_coordinate`: Y position on the map\n- `diameter`: Size of the plant in pixels\n\nOptional fields:\n- `name`: Name of the plant\n- `notes`: Additional information about the plant\n\n### PUT /api/plants/:id\nUpdates an existing plant. All fields are optional.\n\n### DELETE /api/plants/:id\nRemoves a plant from the garden.\n\n## Database Schema\n\nThe application uses SQLite with the following schemas:\n\n### Plants Table\n```sql\nCREATE TABLE garden_plants (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n x_coordinate REAL NOT NULL,\n y_coordinate REAL NOT NULL,\n diameter REAL NOT NULL,\n name TEXT,\n notes TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)\n```\n\n### Settings Table\n```sql\nCREATE TABLE garden_settings (\n id INTEGER PRIMARY KEY CHECK (id = 1),\n garden_width INTEGER NOT NULL DEFAULT 800,\n garden_height INTEGER NOT NULL DEFAULT 500,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)\n```\n\n## Usage\n\n1. **Resize your garden**: Click the \"Resize Garden\" button next to the Garden Map header to set a custom size for your garden map. Choose from preset sizes or enter custom dimensions.\n2. Tap anywhere on the map to immediately see a placeholder plant at that location and open the edit form\n3. Fill in the plant details form and tap \"Save Plant\" to convert the placeholder into a real plant\n4. Tap \"Clear Form\" to remove the placeholder plant and reset the form\n5. Tap on existing plants to edit their details\n6. Use the plant list on the right to quickly find and select plants\n7. Access the admin panel by clicking \"Admin Panel\" in the header to view both database tables (plants and settings) with their schemas and records\n\n### Garden Resizing\n\n- **Custom Sizes**: Set any garden size between 300×300 and 2000×2000 pixels\n- **Preset Options**: Choose from Small (600×400), Medium (800×500), or Large (1000×600) sizes\n- **Persistent Settings**: Your garden size preference is saved in the database and restored when you return to the app\n- **Responsive Design**: The garden map adapts to your chosen dimensions while maintaining mobile compatibility\n\n### Placeholder Plant Features\n\n- **Immediate Visual Feedback**: When you click the map, a gray dashed placeholder plant appears instantly\n- **Real-time Size Updates**: Adjust the diameter in the form to see the placeholder plant resize in real-time\n- **Smart Cleanup**: Placeholder plants are automatically removed when you save, clear the form, or select an existing plant\n\n## Technologies Used\n\n- Hono.js for the API backend\n- SQLite for data storage\n- Vanilla JavaScript for the frontend\n- Twind for styling",6,["D",1749263665212],154,{"_103":255,"_160":142,"_157":195,"_95":99,"_167":256,"_165":179,"_100":257,"_159":-5,"_105":258,"_161":259,"_169":-5},"cc963464-4202-11f0-9d37-76b3cceeab13","# Garden Mapper\n\nA Val Town application for mapping your garden and tracking information about each plant.\n\n## Features\n\n- Interactive garden map interface\n- Add plants with specific coordinates and diameters\n- Store notes and information about each plant\n- Edit and delete existing plants\n- Visual representation of plants on the map\n- Mobile-friendly with touch support\n- Admin panel for database management and inspection\n\n## API Endpoints\n\nThe application provides the following RESTful API endpoints:\n\n### GET /api/plants\nReturns a list of all plants in the garden.\n\n### GET /api/plants/:id\nReturns details for a specific plant by ID.\n\n### POST /api/plants\nCreates a new plant. Required fields:\n- `x_coordinate`: X position on the map\n- `y_coordinate`: Y position on the map\n- `diameter`: Size of the plant in pixels\n\nOptional fields:\n- `name`: Name of the plant\n- `notes`: Additional information about the plant\n\n### PUT /api/plants/:id\nUpdates an existing plant. All fields are optional.\n\n### DELETE /api/plants/:id\nRemoves a plant from the garden.\n\n## Database Schema\n\nThe application uses SQLite with the following schema:\n\n```sql\nCREATE TABLE garden_plants (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n x_coordinate REAL NOT NULL,\n y_coordinate REAL NOT NULL,\n diameter REAL NOT NULL,\n name TEXT,\n notes TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)\n```\n\n## Usage\n\n1. Tap anywhere on the map to immediately see a placeholder plant at that location and open the edit form\n2. Fill in the plant details form and tap \"Save Plant\" to convert the placeholder into a real plant\n3. Tap \"Clear Form\" to remove the placeholder plant and reset the form\n4. Tap on existing plants to edit their details\n5. Use the plant list on the right to quickly find and select plants\n6. Access the admin panel by clicking \"Admin Panel\" in the header to view database contents\n\n### Placeholder Plant Features\n\n- **Immediate Visual Feedback**: When you click the map, a gray dashed placeholder plant appears instantly\n- **Real-time Size Updates**: Adjust the diameter in the form to see the placeholder plant resize in real-time\n- **Smart Cleanup**: Placeholder plants are automatically removed when you save, clear the form, or select an existing plant\n\n## Technologies Used\n\n- Hono.js for the API backend\n- SQLite for data storage\n- Vanilla JavaScript for the frontend\n- Twind for styling",5,["D",1749124023816],153,{"_103":261,"_160":142,"_157":195,"_95":99,"_167":262,"_165":179,"_100":263,"_159":-5,"_105":264,"_161":265,"_169":-5},"b795dd36-3775-11f0-b818-9e149126039e","# Garden Mapper\n\nA Val Town application for mapping your garden and tracking information about each plant.\n\n## Features\n\n- Interactive garden map interface\n- Add plants with specific coordinates and diameters\n- Store notes and information about each plant\n- Edit and delete existing plants\n- Visual representation of plants on the map\n- Mobile-friendly with touch support\n- Admin panel for database management and inspection\n\n## API Endpoints\n\nThe application provides the following RESTful API endpoints:\n\n### GET /api/plants\nReturns a list of all plants in the garden.\n\n### GET /api/plants/:id\nReturns details for a specific plant by ID.\n\n### POST /api/plants\nCreates a new plant. Required fields:\n- `x_coordinate`: X position on the map\n- `y_coordinate`: Y position on the map\n- `diameter`: Size of the plant in pixels\n\nOptional fields:\n- `name`: Name of the plant\n- `notes`: Additional information about the plant\n\n### PUT /api/plants/:id\nUpdates an existing plant. All fields are optional.\n\n### DELETE /api/plants/:id\nRemoves a plant from the garden.\n\n## Database Schema\n\nThe application uses SQLite with the following schema:\n\n```sql\nCREATE TABLE garden_plants (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n x_coordinate REAL NOT NULL,\n y_coordinate REAL NOT NULL,\n diameter REAL NOT NULL,\n name TEXT,\n notes TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)\n```\n\n## Usage\n\n1. Tap anywhere on the map to open the edit form and add a new plant at that location\n2. Fill in the plant details form and tap \"Save Plant\"\n3. Tap on existing plants to edit their details\n4. Use the plant list on the right to quickly find and select plants\n5. Access the admin panel by clicking \"Admin Panel\" in the header to view database contents\n\n## Technologies Used\n\n- Hono.js for the API backend\n- SQLite for data storage\n- Vanilla JavaScript for the frontend\n- Twind for styling",4,["D",1747963917893],30,{"_103":267,"_160":142,"_157":195,"_95":99,"_167":268,"_165":179,"_100":269,"_159":-5,"_105":270,"_161":271,"_169":-5},"7f025686-3638-11f0-991e-9e149126039e","# Garden Mapper\n\nA Val Town application for mapping your garden and tracking information about each plant.\n\n## Features\n\n- Interactive garden map interface\n- Add plants with specific coordinates and diameters\n- Store notes and information about each plant\n- Edit and delete existing plants\n- Visual representation of plants on the map\n- Mobile-friendly with touch support\n- Admin panel for database management and inspection\n\n## API Endpoints\n\nThe application provides the following RESTful API endpoints:\n\n### GET /api/plants\nReturns a list of all plants in the garden.\n\n### GET /api/plants/:id\nReturns details for a specific plant by ID.\n\n### POST /api/plants\nCreates a new plant. Required fields:\n- `x_coordinate`: X position on the map\n- `y_coordinate`: Y position on the map\n- `diameter`: Size of the plant in pixels\n\nOptional fields:\n- `name`: Name of the plant\n- `notes`: Additional information about the plant\n\n### PUT /api/plants/:id\nUpdates an existing plant. All fields are optional.\n\n### DELETE /api/plants/:id\nRemoves a plant from the garden.\n\n## Database Schema\n\nThe application uses SQLite with the following schema:\n\n```sql\nCREATE TABLE garden_plants (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n x_coordinate REAL NOT NULL,\n y_coordinate REAL NOT NULL,\n diameter REAL NOT NULL,\n name TEXT,\n notes TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)\n```\n\n## Usage\n\n1. Tap \"Add Plant\" to start adding a new plant\n2. Tap on the map to place the plant at that location\n3. Fill in the plant details form and tap \"Save Plant\"\n4. Tap on existing plants to edit their details\n5. Use the plant list on the right to quickly find and select plants\n6. Access the admin panel by clicking \"Admin Panel\" in the header to view database contents\n\n## Technologies Used\n\n- Hono.js for the API backend\n- SQLite for data storage\n- Vanilla JavaScript for the frontend\n- Twind for styling",3,["D",1747827672536],24,{"_103":273,"_160":142,"_157":195,"_95":99,"_167":274,"_165":179,"_100":162,"_159":-5,"_105":275,"_161":276,"_169":-5},"7b42ec18-3638-11f0-9140-9e149126039e","# Garden Mapper\n\nA Val Town application for mapping your garden and tracking information about each plant.\n\n## Features\n\n- Interactive garden map interface\n- Add plants with specific coordinates and diameters\n- Store notes and information about each plant\n- Edit and delete existing plants\n- Visual representation of plants on the map\n- Mobile-friendly with touch support\n- Admin panel for database management and inspection\n\n## API Endpoints\n\nThe application provides the following RESTful API endpoints:\n\n### GET /api/plants\nReturns a list of all plants in the garden.\n\n### GET /api/plants/:id\nReturns details for a specific plant by ID.\n\n### POST /api/plants\nCreates a new plant. Required fields:\n- `x_coordinate`: X position on the map\n- `y_coordinate`: Y position on the map\n- `diameter`: Size of the plant in pixels\n\nOptional fields:\n- `name`: Name of the plant\n- `notes`: Additional information about the plant\n\n### PUT /api/plants/:id\nUpdates an existing plant. All fields are optional.\n\n### DELETE /api/plants/:id\nRemoves a plant from the garden.\n\n## Database Schema\n\nThe application uses SQLite with the following schema:\n\n```sql\nCREATE TABLE garden_plants (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n x_coordinate REAL NOT NULL,\n y_coordinate REAL NOT NULL,\n diameter REAL NOT NULL,\n name TEXT,\n notes TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)\n```\n\n## Usage\n\n1. Tap \"Add Plant\" to start adding a new plant\n2. Tap on the map to place the plant at that location\n3. Fill in the plant details form and tap \"Save Plant\"\n4. Tap on existing plants to edit their details\n5. Use the plant list on the right to quickly find and select plants\n\n## Technologies Used\n\n- Hono.js for the API backend\n- SQLite for data storage\n- Vanilla JavaScript for the frontend\n- Twind for styling",["D",1747827666240],23,{"_103":278,"_160":142,"_157":195,"_95":99,"_167":279,"_165":179,"_100":122,"_159":-5,"_105":280,"_161":281,"_169":-5},"975724e2-34f2-11f0-b146-9e149126039e","# Garden Mapper\n\nA Val Town application for mapping your garden and tracking information about each plant.\n\n## Features\n\n- Interactive garden map interface\n- Add plants with specific coordinates and diameters\n- Store notes and information about each plant\n- Edit and delete existing plants\n- Visual representation of plants on the map\n- Mobile-friendly with touch support\n\n## API Endpoints\n\nThe application provides the following RESTful API endpoints:\n\n### GET /api/plants\nReturns a list of all plants in the garden.\n\n### GET /api/plants/:id\nReturns details for a specific plant by ID.\n\n### POST /api/plants\nCreates a new plant. Required fields:\n- `x_coordinate`: X position on the map\n- `y_coordinate`: Y position on the map\n- `diameter`: Size of the plant in pixels\n\nOptional fields:\n- `name`: Name of the plant\n- `notes`: Additional information about the plant\n\n### PUT /api/plants/:id\nUpdates an existing plant. All fields are optional.\n\n### DELETE /api/plants/:id\nRemoves a plant from the garden.\n\n## Database Schema\n\nThe application uses SQLite with the following schema:\n\n```sql\nCREATE TABLE garden_plants (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n x_coordinate REAL NOT NULL,\n y_coordinate REAL NOT NULL,\n diameter REAL NOT NULL,\n name TEXT,\n notes TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)\n```\n\n## Usage\n\n1. Tap \"Add Plant\" to start adding a new plant\n2. Tap on the map to place the plant at that location\n3. Fill in the plant details form and tap \"Save Plant\"\n4. Tap on existing plants to edit their details\n5. Use the plant list on the right to quickly find and select plants\n\n## Technologies Used\n\n- Hono.js for the API backend\n- SQLite for data storage\n- Vanilla JavaScript for the frontend\n- Twind for styling",["D",1747687697421],16,{"_103":283,"_160":142,"_157":195,"_95":99,"_167":284,"_165":179,"_100":32,"_159":-5,"_105":285,"_161":269,"_169":-5},"f817bdc6-34ef-11f0-90ea-9e149126039e","# Garden Mapper\n\nA Val Town application for mapping your garden and tracking information about each plant.\n\n## Features\n\n- Interactive garden map interface\n- Add plants with specific coordinates and diameters\n- Store notes and information about each plant\n- Edit and delete existing plants\n- Visual representation of plants on the map\n\n## API Endpoints\n\nThe application provides the following RESTful API endpoints:\n\n### GET /api/plants\nReturns a list of all plants in the garden.\n\n### GET /api/plants/:id\nReturns details for a specific plant by ID.\n\n### POST /api/plants\nCreates a new plant. Required fields:\n- `x_coordinate`: X position on the map\n- `y_coordinate`: Y position on the map\n- `diameter`: Size of the plant in pixels\n\nOptional fields:\n- `name`: Name of the plant\n- `notes`: Additional information about the plant\n\n### PUT /api/plants/:id\nUpdates an existing plant. All fields are optional.\n\n### DELETE /api/plants/:id\nRemoves a plant from the garden.\n\n## Database Schema\n\nThe application uses SQLite with the following schema:\n\n```sql\nCREATE TABLE garden_plants (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n x_coordinate REAL NOT NULL,\n y_coordinate REAL NOT NULL,\n diameter REAL NOT NULL,\n name TEXT,\n notes TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n)\n```\n\n## Usage\n\n1. Click \"Add Plant\" to start adding a new plant\n2. Click on the map to place the plant at that location\n3. Fill in the plant details form and click \"Save Plant\"\n4. Click on existing plants to edit their details\n5. Use the plant list on the right to quickly find and select plants\n\n## Technologies Used\n\n- Hono.js for the API backend\n- SQLite for data storage\n- Vanilla JavaScript for the frontend\n- Twind for styling",["D",1747686571256],"versions",[288,290,291,292,293,294,295,296],{"_179":246,"_289":248},"previous",{"_179":248,"_289":254},{"_179":254,"_289":260},{"_179":260,"_289":266},{"_179":266,"_289":272},{"_179":272,"_289":277},{"_179":277,"_289":282},{"_179":282,"_289":-5},"versionNumber","page","hasNext","actionData","errors"]

Llad

Gardenon

History for README.md