Component Garden

A showcase of reusable UI components for char.build projects.

\n\n

Getting Started

Import components from the shared library in your project:

\n            {`import { Button, Input, Card } from \"../../shared/components.tsx\";`}\n

\n\n

Basic Components

\n \n

Button

\n \n \n \n

\n \n

Input

\n \n

Card

\n \n

This is content inside a card component.

\n \n

\n \n ,\n );\n\n return new Response(\"\" + html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}",[],[160,177,183],{"_106":191,"_96":192,"_161":193,"_163":178,"_164":144,"_165":103,"_166":120,"_108":194,"_102":32,"_168":195,"_170":196,"_171":22,"_172":-5,"_173":197,"_100":198},"884f495a-0597-11f0-887b-569c3dd06744","handler.tsx","4236cdcb-2b73-4f6a-b293-d3c65b7d0a2e",["D",1742480883345],"script","/** @jsxImportSource https://esm.sh/react@18.3.1 */\nimport { renderToString } from \"https://esm.sh/react-dom@18.3.1/server\";\nimport React from \"https://esm.sh/react@18.3.1\";\n\n// Simple handler for the ComponentGarden project\nexport default async function(req, context) {\n console.log(\"ComponentGarden handler called!\");\n const { email, basePath, relativePath } = context;\n const isLoggedIn = Boolean(email);\n\n // Log info about the request\n console.log(`ComponentGarden handling request:\n - Path: ${relativePath}\n - Base path: ${basePath}\n - Auth: ${isLoggedIn ? \"Logged in as \" + email : \"Not logged in\"}\n `);\n\n // Simple HTML response\n const html = renderToString(\n \n \n ComponentGarden | char.build\n \n \n \n \n\n

ComponentGarden

This is a sample project page for ComponentGarden.

The current path is: {relativePath}

\n {isLoggedIn && (\n

Welcome, {email.split(\"@\")[0]}!

You're now logged in across all char.build projects.

\n )}\n

\n \n ,\n );\n\n return new Response(\"\" + html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}",[],[160,177,192],[160,177],{"_106":201,"_96":202,"_161":203,"_163":162,"_164":144,"_165":103,"_166":120,"_108":204,"_102":32,"_168":169,"_170":-5,"_171":22,"_172":-5,"_173":205,"_100":339},"884ff3fa-0597-11f0-887b-569c3dd06744","ideaScore","26edf656-ab55-4820-961a-6b1385bca034",["D",1742480883345],[206,221,229,237,245,253,260,268,276,284,291,299,307,315,323,331],{"_106":207,"_96":208,"_161":209,"_163":203,"_164":144,"_165":103,"_166":120,"_108":210,"_102":32,"_168":169,"_170":-5,"_171":22,"_172":-5,"_173":211,"_100":220},"884f85e6-0597-11f0-887b-569c3dd06744","docs","0c153f13-f354-4584-aa5b-c60774de0d44",["D",1742480883345],[212],{"_106":213,"_96":214,"_161":215,"_163":209,"_164":144,"_165":103,"_166":120,"_108":216,"_102":32,"_168":186,"_170":217,"_171":22,"_172":-5,"_173":218,"_100":219},"884f4f22-0597-11f0-887b-569c3dd06744","roadmap.md","e7bcc47e-f668-4608-8326-40c62837b150",["D",1742480883345],"# IdeaScore Development Roadmap\n\n## Project Overview\n\nIdeaScore is a tool for ranking project ideas based on payoff-to-effort ratio. The core concept allows users to:\n\n1. Add ideas with descriptions\n2. Rate each idea on effort (1-10) and payoff (1-10)\n3. View ideas ranked by payoff-to-effort ratio\n4. Tag, filter, and organize ideas\n5. Visualize ideas using charts and graphs\n\nThis roadmap breaks down the development process into manageable checkpoints, allowing for incremental progress and regular feedback.\n\n## Development Phases\n\n### Phase 1: Core Data Model & Basic UI\n\n**Checkpoint 1.1: Project Setup & Planning**\n- [x] Create a detailed project plan document in the ideaScore folder\n- [x] Define database schema design document\n- [x] Create basic UI wireframes for main screens\n- [x] Define core user stories and acceptance criteria\n- [x] Set up testing strategy document\n\n**Checkpoint 1.2: Database Schema Setup**\n- [x] Create SQL schema for ideas table\n- [x] Implement database initialization in handler.tsx\n- [x] Write basic database utility functions (query, insert, update, delete)\n- [x] Add error handling for database operations\n- [x] Write simple tests for database operations\n\n**Checkpoint 1.3: Splash Page**\n- [ ] Design and implement a splash page for non-logged-in users\n- [ ] Add information about the app's purpose and features\n- [ ] Create a clear call-to-action for authentication\n- [ ] Ensure responsive design for all devices\n\n**Checkpoint 1.4: Add Idea Form**\n- [ ] Create simple HTML form for adding ideas\n- [ ] Implement form submission handler\n- [ ] Add validation for required fields\n- [ ] Implement feedback for successful submission\n- [ ] Style the form with basic CSS\n\n**Checkpoint 1.5: List View Implementation**\n- [ ] Create basic list view of existing ideas\n- [ ] Implement sorting by created date (newest first)\n- [ ] Add basic pagination\n- [ ] Style the list with basic CSS\n- [ ] Implement empty state for no ideas\n\n**Checkpoint 1.6: Idea Scoring**\n- [ ] Extend form to include effort score (1-10)\n- [ ] Extend form to include payoff score (1-10)\n- [ ] Add ratio calculation (payoff/effort)\n- [ ] Implement sorting by ratio\n- [ ] Add visual indicator for high-ratio ideas\n\n### Phase 2: Enhanced UI & Basic Features\n\n**Checkpoint 2.1: UI Refinement**\n- [ ] Implement responsive design for mobile/tablet/desktop\n- [ ] Add consistent color scheme and typography\n- [ ] Create a navigation menu for different views\n- [ ] Improve form layout and usability\n- [ ] Add loading states and transitions\n\n**Checkpoint 2.2: Idea Editing**\n- [ ] Create edit form UI\n- [ ] Implement edit form submission handler\n- [ ] Add validation for edit form\n- [ ] Implement optimistic UI updates\n- [ ] Add cancel button and confirmation dialog\n\n**Checkpoint 2.3: Enhanced Filtering**\n- [ ] Add filter by minimum/maximum effort\n- [ ] Add filter by minimum/maximum payoff\n- [ ] Add filter by date range\n- [ ] Implement filter persistence in URL parameters\n- [ ] Create UI for managing multiple filters\n\n**Checkpoint 2.4: Dashboard View**\n- [ ] Create simple dashboard with key metrics\n- [ ] Add \"Top 5 Ideas by Ratio\" widget\n- [ ] Add \"Recently Added\" widget\n- [ ] Add \"Quick Stats\" (total ideas, average scores, etc.)\n- [ ] Make dashboard the default landing page\n\n**Checkpoint 2.5: Idea Details View**\n- [ ] Create detailed view for single idea\n- [ ] Add formatted date display\n- [ ] Implement idea deletion with confirmation\n- [ ] Add visual representation of scores\n- [ ] Add \"back to list\" navigation\n\n### Phase 3: Tagging System\n\n**Checkpoint 3.1: Tag Data Model**\n- [ ] Extend database schema for tags and idea-tag relationships\n- [ ] Implement tag CRUD operations\n- [ ] Create tag utility functions\n- [ ] Add tag count tracking\n- [ ] Implement tag suggestion logic\n\n**Checkpoint 3.2: Tag UI**\n- [ ] Add tag creation UI\n- [ ] Implement tag selection dropdown/autocomplete\n- [ ] Create tag display in idea list/detail views\n- [ ] Add tag filtering interface\n- [ ] Implement tag cloud visualization\n\n### Phase 4: Visualization\n\n**Checkpoint 4.1: Basic Visualizations**\n- [ ] Implement simple bar chart for ideas by ratio\n- [ ] Create bubble chart visualization (payoff vs. effort)\n- [ ] Add interactive elements to charts (hover, click)\n- [ ] Implement view switching between charts and lists\n- [ ] Add data export functionality\n\n### Phase 5: Advanced Features - Part 1\n\n**Checkpoint 5.1: Idea Status Tracking**\n- [ ] Add status field to ideas (new, in-progress, completed, abandoned)\n- [ ] Implement status change UI and handlers\n- [ ] Add status-based filtering\n- [ ] Create status-based visualizations\n- [ ] Implement status change history\n\n**Checkpoint 5.2: Retroactive Scoring**\n- [ ] Add functionality to mark ideas as completed\n- [ ] Implement actual effort/payoff scoring for completed ideas\n- [ ] Create comparison view between estimated and actual scores\n- [ ] Add metrics for score accuracy\n- [ ] Implement scoring calibration insights\n\n### Phase 6: Advanced Features - Part 2\n\n**Checkpoint 6.1: Bulk Operations**\n- [ ] Implement multi-select UI for ideas\n- [ ] Add bulk tagging functionality\n- [ ] Implement bulk status updates\n- [ ] Add bulk delete with confirmation\n- [ ] Create bulk export options\n\n**Checkpoint 6.2: Data Import/Export**\n- [ ] Implement CSV import functionality\n- [ ] Add spreadsheet template for import\n- [ ] Create comprehensive data export (all ideas, tags, etc.)\n- [ ] Add scheduled backup functionality\n- [ ] Implement import validation and error handling\n\n**Checkpoint 6.3: Collaborative Idea Rating**\n- [ ] Allow multiple users to rate the same idea\n- [ ] Each user can provide their own effort and payoff scores\n- [ ] Display both individual and aggregate ratings\n- [ ] Include comparison views between different user ratings\n- [ ] Add commenting functionality for discussion\n\n### Phase 7: AI Integration\n\n**Checkpoint 7.1: Basic AI Features**\n- [ ] Implement AI-based tag suggestions\n- [ ] Add AI scoring suggestions based on description\n- [ ] Create AI insights for idea patterns\n- [ ] Implement idea similarity detection\n- [ ] Add AI-generated summaries of idea collections\n\n### Phase 8: Progressive Web App & API\n\n**Checkpoint 8.1: PWA Implementation**\n- [ ] Configure app for offline functionality\n- [ ] Add manifest and service workers\n- [ ] Implement data synchronization\n- [ ] Add installation prompts\n- [ ] Test across devices\n\n**Checkpoint 8.2: API Development**\n- [ ] Define API endpoints\n- [ ] Implement authentication for API\n- [ ] Create documentation\n- [ ] Add rate limiting and security measures\n- [ ] Implement versioning\n\n### Phase 9: Pro Tier & Polish\n\n**Checkpoint 9.1: Pro Features**\n- [ ] Define pro tier feature set\n- [ ] Implement subscription system\n- [ ] Add advanced analytics for pro users\n- [ ] Create shareable dashboards\n- [ ] Implement team collaboration features\n\n## Testing Strategy\n\nThroughout all phases, maintain:\n\n- Unit tests for database operations\n- Component tests for UI elements\n- End-to-end tests for critical flows\n- Accessibility testing\n- Performance testing for data-heavy operations\n\n## Development Approach\n\n1. Complete each checkpoint before moving to the next\n2. Get approval after each checkpoint is completed\n3. Maintain test coverage throughout\n4. Document changes in a changelog\n5. Periodically review and adjust the roadmap as needed\n\n## Project Management\n\nCreate a simple project management file in the ideaScore folder to track:\n\n- Current phase and checkpoint\n- Completed items\n- Known issues\n- Planned next steps\n- Testing results\n\nThis roadmap is intended to be a living document that evolves as the project progresses.",[],[160,202,208,214],[160,202,208],{"_106":222,"_96":223,"_161":224,"_163":203,"_164":144,"_165":103,"_166":120,"_108":225,"_102":32,"_168":186,"_170":226,"_171":22,"_172":-5,"_173":227,"_100":228},"884f882a-0597-11f0-887b-569c3dd06744","README.md","7ca87861-8843-4475-8631-61a94264382c",["D",1742480883345],"# IdeaScore\n\nIdeaScore is a tool for ranking project ideas based on payoff-to-effort ratio. The application helps users prioritize their ideas by focusing on those with the highest potential value for the least effort.\n\n## Features\n\n- Add ideas with title, description, effort score, and payoff score\n- Automatically calculate payoff-to-effort ratio\n- View ideas ranked by ratio\n- Track statistics about your ideas\n- Simple, intuitive interface\n\n## Documentation\n\nFor detailed documentation, see the `docs` folder:\n\n- [Project Roadmap](docs/roadmap.md) - Development phases and checkpoints\n- [Database Schema](docs/schema.md) - Database structure\n- [User Stories](docs/userstories.md) - User stories and acceptance criteria\n- [Data Architecture](docs/data_architecture.md) - Data isolation strategy\n- [Project Plan](docs/project_plan.md) - Development approach\n- [Project Updates](docs/project_updates.md) - Updates to the project plan\n- [Wireframes](docs/wireframes.md) - UI wireframes\n- [Test Strategy](docs/test_strategy.md) - Testing approach\n- [Project Status](docs/project_status.md) - Current status and progress\n\n## Development Status\n\nCurrently in Phase 1, implementing the core functionality.\n\n## Usage\n\n1. Sign in using your Google account\n2. Add your ideas with title, description, effort score (1-10), and payoff score (1-10)\n3. View your ideas ranked by payoff-to-effort ratio\n4. Focus on implementing the ideas with the highest ratio first\n",[],[160,202,223],{"_106":230,"_96":231,"_161":232,"_163":203,"_164":144,"_165":103,"_166":120,"_108":233,"_102":32,"_168":186,"_170":234,"_171":22,"_172":-5,"_173":235,"_100":236},"884f899c-0597-11f0-887b-569c3dd06744","api.tsx","7751ec3e-f21c-4cac-b4ff-979cbae70f6e",["D",1742480883345],"/**\n * API endpoints for the IdeaScore application\n */\n\nimport * as db from './database.ts';\n\ninterface ApiContext {\n email: string;\n sqlite: any;\n relativePath: string;\n ideaId?: number;\n}\n\n/**\n * Handle API requests\n * @param {Request} req - The request object\n * @param {Object} context - The context object\n * @param {string} context.email - The user's email\n * @param {Object} context.sqlite - The SQLite instance\n * @param {string} context.relativePath - The relative path\n * @returns {Response} The API response\n */\nexport async function handleApiRequest(req: Request, { email, sqlite, relativePath }: ApiContext): Promise {\n // Only allow API requests for logged-in users\n if (!email) {\n return new Response(JSON.stringify({ error: \"Authentication required\" }), { \n status: 401,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n \n try {\n // Handle different API endpoints\n if (relativePath === '/api/ideas' && req.method === 'GET') {\n return await getIdeas(req, { email, sqlite });\n } \n else if (relativePath === '/api/ideas' && req.method === 'POST') {\n return await addIdea(req, { email, sqlite });\n } \n else if (relativePath.match(/^\\/api\\/ideas\\/\\d+$/) && req.method === 'GET') {\n const ideaId = parseInt(relativePath.split('/').pop() || '0', 10);\n return await getIdeaById(req, { email, sqlite, ideaId });\n } \n else if (relativePath.match(/^\\/api\\/ideas\\/\\d+$/) && req.method === 'PUT') {\n const ideaId = parseInt(relativePath.split('/').pop() || '0', 10);\n return await updateIdea(req, { email, sqlite, ideaId });\n } \n else if (relativePath.match(/^\\/api\\/ideas\\/\\d+$/) && req.method === 'DELETE') {\n const ideaId = parseInt(relativePath.split('/').pop() || '0', 10);\n return await deleteIdea(req, { email, sqlite, ideaId });\n } \n else if (relativePath === '/api/stats' && req.method === 'GET') {\n return await getStats(req, { email, sqlite });\n } \n else {\n // Unknown endpoint\n return new Response(JSON.stringify({ error: \"Endpoint not found\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n } catch (error: any) {\n console.error(\"API error:\", error);\n return new Response(JSON.stringify({ error: error.message || \"Internal server error\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n\n/**\n * Get ideas with pagination and sorting\n */\nasync function getIdeas(req: Request, { email, sqlite }: ApiContext): Promise {\n const url = new URL(req.url);\n const sortBy = url.searchParams.get('sortBy') || 'created_at';\n const sortOrder = url.searchParams.get('sortOrder') || 'DESC';\n const limit = parseInt(url.searchParams.get('limit') || '100', 10);\n const offset = parseInt(url.searchParams.get('offset') || '0', 10);\n \n const ideas = await db.getIdeas(sqlite, email, { sortBy, sortOrder, limit, offset });\n \n return new Response(JSON.stringify({ ideas }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n}\n\n/**\n * Add a new idea\n */\nasync function addIdea(req: Request, { email, sqlite }: ApiContext): Promise {\n let data;\n \n // Check content type to handle both JSON and form data\n const contentType = req.headers.get('Content-Type') || '';\n \n if (contentType.includes('application/json')) {\n // Parse JSON request\n data = await req.json();\n } else if (contentType.includes('application/x-www-form-urlencoded')) {\n // Parse form data\n const formData = await req.formData();\n data = {\n title: formData.get('title'),\n description: formData.get('description') || '',\n effortScore: parseInt(formData.get('effortScore')?.toString() || '0', 10),\n payoffScore: parseInt(formData.get('payoffScore')?.toString() || '0', 10)\n };\n } else {\n throw new Error(\"Unsupported content type\");\n }\n \n // Validate the data\n if (!data.title) {\n throw new Error(\"Title is required\");\n }\n \n if (!data.effortScore || data.effortScore < 1 || data.effortScore > 10) {\n throw new Error(\"Effort score must be between 1 and 10\");\n }\n \n if (!data.payoffScore || data.payoffScore < 1 || data.payoffScore > 10) {\n throw new Error(\"Payoff score must be between 1 and 10\");\n }\n \n // Add the idea\n const idea = await db.addIdea(sqlite, email, data);\n \n return new Response(JSON.stringify({ idea }), {\n status: 201,\n headers: { \"Content-Type\": \"application/json\" }\n });\n}\n\n/**\n * Get an idea by ID\n */\nasync function getIdeaById(req: Request, { email, sqlite, ideaId }: ApiContext): Promise {\n if (!ideaId) {\n throw new Error(\"Idea ID is required\");\n }\n \n const idea = await db.getIdeaById(sqlite, email, ideaId);\n \n if (!idea) {\n return new Response(JSON.stringify({ error: \"Idea not found\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n \n return new Response(JSON.stringify({ idea }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n}\n\n/**\n * Update an existing idea\n */\nasync function updateIdea(req: Request, { email, sqlite, ideaId }: ApiContext): Promise {\n if (!ideaId) {\n throw new Error(\"Idea ID is required\");\n }\n \n const updates = await req.json();\n const idea = await db.updateIdea(sqlite, email, ideaId, updates);\n \n if (!idea) {\n return new Response(JSON.stringify({ error: \"Idea not found\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n \n return new Response(JSON.stringify({ idea }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n}\n\n/**\n * Delete an idea\n */\nasync function deleteIdea(req: Request, { email, sqlite, ideaId }: ApiContext): Promise {\n if (!ideaId) {\n throw new Error(\"Idea ID is required\");\n }\n \n const success = await db.deleteIdea(sqlite, email, ideaId);\n \n if (!success) {\n return new Response(JSON.stringify({ error: \"Idea not found\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n \n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n}\n\n/**\n * Get statistics about the user's ideas\n */\nasync function getStats(req: Request, { email, sqlite }: ApiContext): Promise {\n const stats = await db.getIdeaStats(sqlite, email);\n \n return new Response(JSON.stringify({ stats }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n}",[],[160,202,231],{"_106":238,"_96":239,"_161":240,"_163":203,"_164":144,"_165":103,"_166":120,"_108":241,"_102":32,"_168":186,"_170":242,"_171":22,"_172":-5,"_173":243,"_100":244},"884f8ece-0597-11f0-887b-569c3dd06744","data_architecture.md","052c34a1-f58b-4597-a774-9dd8ffd10e49",["D",1742480883345],"# IdeaScore Data Architecture\n\nThis document outlines the data architecture for the IdeaScore application, with a particular focus on preventing data conflicts with other applications in the charBuildSuperapp ecosystem.\n\n## Data Isolation Strategy\n\n### Table Naming Conventions\n\nAll tables in the IdeaScore application will follow these naming conventions:\n\n1. Prefix all tables with `ideascore_` to prevent naming conflicts with other applications\n2. Include a version suffix (e.g., `_v1`) to support schema evolution\n3. Examples: `ideascore_ideas_v1`, `ideascore_tags_v1`, etc.\n\n```sql\n-- Example of proper table naming\nCREATE TABLE IF NOT EXISTS ideascore_ideas_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n -- other fields\n);\n```\n\n### User Data Isolation\n\nAll queries must include user email filtering to ensure users only see their own data:\n\n1. Every table must include a `user_email` column\n2. Every query must filter by the user's email\n3. Composite indexes should include `user_email` for performance\n\n```sql\n-- Example of proper user isolation in a query\nSELECT * FROM ideascore_ideas_v1 \nWHERE user_email = ? \nORDER BY created_at DESC;\n```\n\n### Database Functions\n\nTo ensure consistent data access patterns, we will create database utility functions that:\n\n1. Always include appropriate table prefixes\n2. Always include user isolation\n3. Implement proper error handling\n4. Use parameterized queries to prevent SQL injection\n\n```javascript\n// Example of a proper database function\nasync function getUserIdeas(email, sortBy = 'created_at', order = 'DESC') {\n const validSortFields = ['created_at', 'title', 'effort_score', 'payoff_score', 'ratio'];\n const sortField = validSortFields.includes(sortBy) ? sortBy : 'created_at';\n \n try {\n return await sqlite.execute(\n `SELECT * FROM ideascore_ideas_v1 \n WHERE user_email = ? AND is_deleted = 0\n ORDER BY ${sortField} ${order === 'ASC' ? 'ASC' : 'DESC'}`,\n [email]\n );\n } catch (error) {\n console.error('Database error in getUserIdeas:', error);\n throw new Error('Failed to retrieve ideas');\n }\n}\n```\n\n## Data Access Patterns\n\n### Database Initialization\n\nDatabase tables should be initialized in a modular way that doesn't interfere with other applications:\n\n```javascript\nasync function initializeIdeaScoreDatabase() {\n console.log(\"Initializing IdeaScore database...\");\n const SCHEMA_VERSION = 1;\n\n try {\n // Create ideas table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ideascore_ideas_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n effort_score INTEGER NOT NULL CHECK(effort_score BETWEEN 1 AND 10),\n payoff_score INTEGER NOT NULL CHECK(payoff_score BETWEEN 1 AND 10),\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n user_email TEXT NOT NULL,\n is_deleted BOOLEAN DEFAULT 0\n )\n `);\n \n // Create index for user isolation\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_ideascore_ideas_user_email \n ON ideascore_ideas_v1(user_email)\n `);\n \n console.log(\"IdeaScore database initialized successfully\");\n return SCHEMA_VERSION;\n } catch (error) {\n console.error(\"IdeaScore database initialization error:\", error);\n throw error;\n }\n}\n```\n\n### Shared Context\n\nThe `context` object passed from the main handler provides access to shared resources. We should use it consistently:\n\n```javascript\n// Example handler showing proper context usage\nexport default async function(req, context) {\n const { email, sqlite, basePath, relativePath } = context;\n \n // Initialize our specific database tables\n const SCHEMA_VERSION = await initializeIdeaScoreDatabase();\n \n // Continue with request handling...\n}\n```\n\n## Best Practices for Data Safety\n\n1. **Never modify shared tables**: Only modify tables that belong to the IdeaScore application\n2. **Use transactions** for operations that modify multiple records\n3. **Validate all input data** before database operations\n4. **Implement soft deletes** using `is_deleted` flags rather than actual DELETE operations\n5. **Log database errors** with enough context to debug but without exposing sensitive data\n6. **Implement periodic data backup** mechanisms\n7. **Version your queries** along with your schema\n\n## Testing Data Isolation\n\nBefore deploying any changes, test that:\n\n1. Data from one application doesn't appear in another\n2. One user's data doesn't appear for another user\n3. Schema changes don't affect other applications\n4. Error handling properly captures and reports database issues\n\n## Future Considerations\n\nAs the application grows, consider:\n\n1. Implementing a more robust ORM-like layer\n2. Adding database migration tools\n3. Considering data partitioning strategies\n4. Implementing more advanced access control\n5. Adding audit logging for sensitive operations\n\nBy following these guidelines, we can ensure that the IdeaScore application maintains proper data isolation while still benefiting from the shared infrastructure of the charBuildSuperapp ecosystem.\n",[],[160,202,239],{"_106":246,"_96":247,"_161":248,"_163":203,"_164":144,"_165":103,"_166":120,"_108":249,"_102":32,"_168":186,"_170":250,"_171":22,"_172":-5,"_173":251,"_100":252},"884f98ce-0597-11f0-887b-569c3dd06744","database.ts","e04d511c-0711-4ee1-9da3-35e1a2ca931d",["D",1742480883345],"/**\n * Database utilities for IdeaScore\n * \n * This module provides database initialization and utility functions\n * for the IdeaScore application.\n */\n\n// Schema version - increment when making breaking changes\nconst SCHEMA_VERSION = 1;\n\ninterface IdeaData {\n title: string;\n description?: string;\n effortScore: number;\n payoffScore: number;\n}\n\ninterface IdeaRecord extends IdeaData {\n id: number;\n effort_score: number;\n payoff_score: number;\n created_at: string;\n updated_at: string;\n ratio: number;\n}\n\ninterface IdeaStats {\n total_ideas: number;\n avg_effort: number;\n avg_payoff: number;\n avg_ratio: number;\n}\n\ninterface QueryOptions {\n sortBy?: string;\n sortOrder?: string;\n limit?: number;\n offset?: number;\n}\n\n/**\n * Initialize the IdeaScore database schema\n * @param {Object} sqlite - The SQLite instance from the context\n * @returns {Promise}\n */\nexport async function initializeDatabase(sqlite: any): Promise {\n console.log(\"Initializing IdeaScore database...\");\n\n try {\n // Create ideas table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ideascore_ideas_v${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n effort_score INTEGER NOT NULL CHECK(effort_score BETWEEN 1 AND 10),\n payoff_score INTEGER NOT NULL CHECK(payoff_score BETWEEN 1 AND 10),\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n user_email TEXT NOT NULL,\n is_deleted BOOLEAN DEFAULT 0\n )\n `);\n \n // Create index for user isolation\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_ideascore_ideas_user_email \n ON ideascore_ideas_v${SCHEMA_VERSION}(user_email)\n `);\n \n console.log(\"IdeaScore database initialized successfully\");\n } catch (error) {\n console.error(\"IdeaScore database initialization error:\", error);\n throw error;\n }\n}\n\n/**\n * Add a new idea to the database\n * @param {Object} sqlite - The SQLite instance from the context\n * @param {string} userEmail - The user's email address\n * @param {Object} idea - The idea object to add\n * @param {string} idea.title - The idea title\n * @param {string} idea.description - The idea description\n * @param {number} idea.effortScore - The effort score (1-10)\n * @param {number} idea.payoffScore - The payoff score (1-10)\n * @returns {Promise

Component Garden

Getting Started

Basic Components

Button

Input

Card

ComponentGarden

Welcome, {email.split(\"@\")[0]}!

💡 IdeaScore Dashboard

Top Ideas

Add New Idea

Recently Added

dcm31

charBuildSuperapp