[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_388":389,"_390":391},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_283":-5,"_20":284,"_22":285,"_286":287,"_288":289,"_26":290,"_24":291,"_292":293,"_294":295,"_296":50,"_297":298,"_299":72,"_300":-5,"_301":-5,"_302":303},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":-5,"_31":32,"_33":32,"_34":-5},"handle","unset_f81c486d73","name","voicemessages","branchName","main","version","path","frontend","project",{"_35":238,"_13":14,"_37":239,"_48":-5,"_240":50,"_51":52,"_241":52,"_242":243,"_244":245,"_246":247,"_248":188,"_249":72,"_250":-5,"_251":-5,"_252":32,"_55":253,"_254":-5,"_255":-5,"_256":-5,"_257":-5,"_258":259,"_260":259,"_261":262,"_263":262,"_264":262,"_265":259,"_266":259,"_267":268,"_269":270,"_271":272,"_49":50},"tree",[96,97,98,99],"file",{"_35":93,"_13":19,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":94,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_18":95},"contents",[58,59,60],"upstream",{"_35":36,"_37":38,"_39":40,"_13":16,"_41":42,"_17":43,"_44":-5,"_45":-5,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":54,"_55":56,"_57":14},"pull","ahead",0,"behind","envVars","id","91599d6a-384c-11f0-8086-9e149126039e","createdAt",["D",1748056195569],"updatedAt",["D",1749000346558],"projectId","91595864-384c-11f0-8086-9e149126039e",58,"forkedBranchId","forkedBranchVersion","lockfileKey","1755584484815-esm.town_v_cameronpak_voicemessages@58-main","deletedAt","isOwned",false,"privacy","public","userHandle","cameronpak","orgId","47e0b4b2-7d41-46e6-8dce-0ae3d76e1a8f","projectName",{"_35":87,"_13":88,"_63":89,"_65":66,"_67":68,"_69":70,"_71":72,"_37":90,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_18":92},{"_35":81,"_13":82,"_63":83,"_65":66,"_67":68,"_69":70,"_71":72,"_37":84,"_17":32,"_74":24,"_76":85,"_78":50,"_79":-5,"_18":86},{"_35":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_37":73,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_18":80},"4f920394-dbd1-11f0-9064-42dde27851f2","index.tsx","fileId","019b2fe7-52b6-7612-a0ac-bf9c177bc771","parentId","019b2fe7-52b6-7612-a0ac-c0b89a6b65b9","branchId","4f8f08e2-dbd1-11f0-9064-42dde27851f2","branchVersion",1,"latest",true,["D",1766035247689],"fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();","deleted","label",[19,62],"4f92009c-dbd1-11f0-9064-42dde27851f2","index.html","019b2fe7-52b6-7612-a0ac-b8ef838c2a13",["D",1766035247689],"\n\n \n \n \n Voice Messages\n \n \n \n \n \n

\n \n \n",[19,82],"4f91ff48-dbd1-11f0-9064-42dde27851f2","components","019b2fe7-52b6-7612-a0ac-b692310255b3",["D",1766035247689],"directory",[19,88],"4f9204b6-dbd1-11f0-9064-42dde27851f2",["D",1766035247689],[19],{"_35":177,"_13":178,"_63":179,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":180,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":181,"_18":182},{"_35":93,"_13":19,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":122,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":123,"_18":124},{"_35":108,"_13":109,"_63":110,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":111,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":112,"_18":113},{"_35":100,"_13":101,"_63":102,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":103,"_17":32,"_74":24,"_76":104,"_78":50,"_79":-5,"_105":106,"_18":107},"4f9207fe-dbd1-11f0-9064-42dde27851f2","README.md","019b2fe7-52b6-7612-a0ac-cf0b4f466bdf",["D",1766035247689],"# Voice Notes App\n\nA web application for recording, transcribing, and sharing voice notes with expiration controls.\n\n## Features\n\n- 🎙️ Record voice notes directly in the browser\n- 🤖 AI-powered transcription using OpenAI Whisper\n- 🔗 Share voice notes via unique URLs\n- ⏰ Set expiration by max listens or date\n- 📋 Dashboard to view and manage all your voice notes\n- 🗑️ Delete voice notes you no longer need\n- 📱 Responsive design with modern UI\n\n## User Stories\n\n- I can record a voice note\n- Given I record a voice note, it is transcribed by AI\n- Given I have recorded a voice note, I can share that voice note with someone via URL\n- I can set an expiration for the voice note by number of max listens (i.e. 1 listen)\n- Or, I can set an expiration for the voice note by choosing an expiration date\n- I can see which voice notes I have sent\n- I can delete voice notes I no longer need\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ ├── voicenotes.ts # Voice note CRUD operations\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── VoiceRecorder.tsx # Recording interface\n│ │ ├── VoicePlayer.tsx # Playback interface\n│ │ ├── ShareModal.tsx # Sharing configuration\n│ │ └── Dashboard.tsx # Voice notes management\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend entry point\n│ └── style.css # Custom styles\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Tech Stack\n\n- **Backend**: Hono (TypeScript API framework)\n- **Database**: SQLite for voice note metadata\n- **Storage**: Val Town Blob storage for audio files\n- **AI**: OpenAI Whisper for transcription\n- **Frontend**: React with TypeScript\n- **Styling**: TailwindCSS","children",[],[101],"4f9206e6-dbd1-11f0-9064-42dde27851f2","shared","019b2fe7-52b6-7612-a0ac-ca3037ea1889",["D",1766035247689],[114],[109],{"_35":115,"_13":116,"_63":117,"_65":110,"_67":68,"_69":70,"_71":72,"_37":118,"_17":32,"_74":75,"_76":119,"_78":50,"_79":-5,"_105":120,"_18":121},"4f9205ce-dbd1-11f0-9064-42dde27851f2","types.ts","019b2fe7-52b6-7612-a0ac-c4f9adfe6238",["D",1766035247689],"// Shared types for voice notes app\n\nexport interface VoiceNote {\n id: string;\n title?: string;\n audioUrl: string;\n transcription?: string;\n duration: number; // in seconds\n createdAt: string;\n expiresAt?: string; // ISO date string\n maxListens?: number;\n currentListens: number;\n isExpired: boolean;\n}\n\nexport interface CreateVoiceNoteRequest {\n audioBlob: Blob;\n title?: string;\n expiresAt?: string;\n maxListens?: number;\n}\n\nexport interface ShareSettings {\n expiresAt?: string;\n maxListens?: number;\n}\n\nexport interface VoiceNoteResponse {\n success: boolean;\n voiceNote?: VoiceNote;\n shareUrl?: string;\n error?: string;\n}\n\nexport interface TranscriptionResponse {\n success: boolean;\n transcription?: string;\n error?: string;\n}",[],[109,116],["D",1766035247689],[125,126,127],[19],{"_35":87,"_13":88,"_63":89,"_65":66,"_67":68,"_69":70,"_71":72,"_37":134,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":135,"_18":136},{"_35":81,"_13":82,"_63":83,"_65":66,"_67":68,"_69":70,"_71":72,"_37":131,"_17":32,"_74":24,"_76":85,"_78":50,"_79":-5,"_105":132,"_18":133},{"_35":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_37":128,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_105":129,"_18":130},["D",1766035247689],[],[19,62],["D",1766035247689],[],[19,82],["D",1766035247689],[137,138,139,140,141],[19,88],{"_35":170,"_13":171,"_63":172,"_65":89,"_67":68,"_69":70,"_71":72,"_37":173,"_17":32,"_74":75,"_76":174,"_78":50,"_79":-5,"_105":175,"_18":176},{"_35":163,"_13":164,"_63":165,"_65":89,"_67":68,"_69":70,"_71":72,"_37":166,"_17":32,"_74":75,"_76":167,"_78":50,"_79":-5,"_105":168,"_18":169},{"_35":156,"_13":157,"_63":158,"_65":89,"_67":68,"_69":70,"_71":72,"_37":159,"_17":32,"_74":75,"_76":160,"_78":50,"_79":-5,"_105":161,"_18":162},{"_35":149,"_13":150,"_63":151,"_65":89,"_67":68,"_69":70,"_71":72,"_37":152,"_17":32,"_74":75,"_76":153,"_78":50,"_79":-5,"_105":154,"_18":155},{"_35":142,"_13":143,"_63":144,"_65":89,"_67":68,"_69":70,"_71":72,"_37":145,"_17":32,"_74":75,"_76":146,"_78":50,"_79":-5,"_105":147,"_18":148},"4f91f5e8-dbd1-11f0-9064-42dde27851f2","VoiceRecorder.tsx","019b2fe7-52b6-7612-a0ac-b2f3655ae3af",["D",1766035247689],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { ShareSettings, VoiceNote } from \"../../shared/types.ts\";\nimport ShareModal from \"./ShareModal.tsx\";\n\ninterface RecordingState {\n isRecording: boolean;\n isPaused: boolean;\n duration: number;\n audioBlob: Blob | null;\n audioUrl: string | null;\n}\n\ninterface VoiceRecorderProps {\n onVoiceNoteCreated?: () => void;\n}\n\nexport default function VoiceRecorder({ onVoiceNoteCreated }: VoiceRecorderProps) {\n const [recordingState, setRecordingState] = useState({\n isRecording: false,\n isPaused: false,\n duration: 0,\n audioBlob: null,\n audioUrl: null,\n });\n\n const [title, setTitle] = useState(\"\");\n const [isUploading, setIsUploading] = useState(false);\n const [showShareModal, setShowShareModal] = useState(false);\n const [createdVoiceNote, setCreatedVoiceNote] = useState(null);\n const [shareUrl, setShareUrl] = useState(\"\");\n\n const mediaRecorderRef = useRef(null);\n const audioChunksRef = useRef([]);\n const timerRef = useRef(null);\n const streamRef = useRef(null);\n\n useEffect(() => {\n return () => {\n if (timerRef.current) {\n clearInterval(timerRef.current);\n }\n if (streamRef.current) {\n streamRef.current.getTracks().forEach(track => track.stop());\n }\n };\n }, []);\n\n const startRecording = async () => {\n try {\n const stream = await navigator.mediaDevices.getUserMedia({ audio: true });\n streamRef.current = stream;\n\n const mediaRecorder = new MediaRecorder(stream);\n mediaRecorderRef.current = mediaRecorder;\n audioChunksRef.current = [];\n\n mediaRecorder.ondataavailable = (event) => {\n if (event.data.size > 0) {\n audioChunksRef.current.push(event.data);\n }\n };\n\n mediaRecorder.onstop = () => {\n const audioBlob = new Blob(audioChunksRef.current, { type: \"audio/webm\" });\n const audioUrl = URL.createObjectURL(audioBlob);\n\n setRecordingState(prev => ({\n ...prev,\n audioBlob,\n audioUrl,\n isRecording: false,\n }));\n };\n\n mediaRecorder.start();\n\n setRecordingState(prev => ({\n ...prev,\n isRecording: true,\n isPaused: false,\n duration: 0,\n }));\n\n // Start timer\n timerRef.current = setInterval(() => {\n setRecordingState(prev => ({\n ...prev,\n duration: prev.duration + 1,\n }));\n }, 1000);\n } catch (error) {\n console.error(\"Error starting recording:\", error);\n alert(\"Could not access microphone. Please check permissions.\");\n }\n };\n\n const stopRecording = () => {\n if (mediaRecorderRef.current && recordingState.isRecording) {\n mediaRecorderRef.current.stop();\n\n if (timerRef.current) {\n clearInterval(timerRef.current);\n timerRef.current = null;\n }\n\n if (streamRef.current) {\n streamRef.current.getTracks().forEach(track => track.stop());\n }\n }\n };\n\n const resetRecording = () => {\n if (recordingState.audioUrl) {\n URL.revokeObjectURL(recordingState.audioUrl);\n }\n\n setRecordingState({\n isRecording: false,\n isPaused: false,\n duration: 0,\n audioBlob: null,\n audioUrl: null,\n });\n\n setTitle(\"\");\n };\n\n const handleSave = (shareSettings: ShareSettings) => {\n if (!recordingState.audioBlob) return;\n\n setIsUploading(true);\n\n const formData = new FormData();\n formData.append(\"audio\", recordingState.audioBlob, \"recording.webm\");\n formData.append(\"title\", title);\n formData.append(\"duration\", recordingState.duration.toString());\n\n if (shareSettings.expiresAt) {\n formData.append(\"expiresAt\", shareSettings.expiresAt);\n }\n\n if (shareSettings.maxListens) {\n formData.append(\"maxListens\", shareSettings.maxListens.toString());\n }\n\n fetch(\"/api/voicenotes\", {\n method: \"POST\",\n body: formData,\n })\n .then(response => response.json())\n .then(data => {\n if (data.success) {\n setCreatedVoiceNote(data.voiceNote);\n setShareUrl(data.shareUrl);\n setShowShareModal(false);\n resetRecording();\n } else {\n alert(\"Error saving voice message: \" + data.error);\n }\n })\n .catch(error => {\n console.error(\"Error saving voice message:\", error);\n alert(\"Error saving voice message\");\n })\n .finally(() => {\n setIsUploading(false);\n });\n };\n\n const formatDuration = (seconds: number) => {\n const mins = Math.floor(seconds / 60);\n const secs = seconds % 60;\n return `${mins}:${secs.toString().padStart(2, \"0\")}`;\n };\n\n const copyToClipboard = async (text: string) => {\n try {\n await navigator.clipboard.writeText(text);\n alert(\"Link copied to clipboard!\");\n } catch (error) {\n console.error(\"Failed to copy:\", error);\n }\n };\n\n if (createdVoiceNote) {\n return (\n

✅

\n Voice Message Created!\n

\n Your voice message has been saved and is being transcribed.\n

\n\n

Share this link:

\n \n copyToClipboard(shareUrl)}\n className=\"px-4 py-2 bg-blue-600 text-white rounded-md hover:bg-blue-700 text-sm\"\n >\n Copy\n \n

\n\n {\n setCreatedVoiceNote(null);\n setShareUrl(\"\");\n onVoiceNoteCreated?.();\n }}\n className=\"px-6 py-2 bg-gray-600 text-white rounded-md hover:bg-gray-700\"\n >\n View All Messages\n \n

\n );\n }\n\n return (\n

\n {!recordingState.isRecording && !recordingState.audioBlob && (\n <>\n

🎙️

\n Ready to Record\n

\n Click the button below to start recording your voice message\n

\n \n Start Recording\n \n \n )}\n\n {recordingState.isRecording && (\n <>\n

🔴

\n Recording...\n

\n {formatDuration(recordingState.duration)}\n

\n \n Stop Recording\n \n \n )}\n\n {recordingState.audioBlob && (\n <>\n

🎵

\n Recording Complete\n

\n Duration: {formatDuration(recordingState.duration)}\n

\n\n \n\n

\n \n Title (optional)\n \n setTitle(e.target.value)}\n placeholder=\"Enter a title for your voice message\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n\n

\n \n Re-record\n \n setShowShareModal(true)}\n disabled={isUploading}\n className=\"px-6 py-2 bg-blue-600 text-white rounded-md hover:bg-blue-700 disabled:opacity-50\"\n >\n {isUploading ? \"Saving...\" : \"Save & Share\"}\n \n

\n \n )}\n

\n\n {showShareModal && (\n setShowShareModal(false)}\n isUploading={isUploading}\n />\n )}\n

\n );\n}",[],[19,88,143],"4f91eae4-dbd1-11f0-9064-42dde27851f2","VoicePlayer.tsx","019b2fe7-52b6-7612-a0ac-afbf10692199",["D",1766035247689],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { VoiceNote } from \"../../shared/types.ts\";\n\ninterface VoicePlayerProps {\n voiceNoteId: string;\n}\n\nexport default function VoicePlayer({ voiceNoteId }: VoicePlayerProps) {\n const [voiceNote, setVoiceNote] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [audioUrl, setAudioUrl] = useState(null);\n\n useEffect(() => {\n fetchVoiceNote();\n }, [voiceNoteId]);\n\n const fetchVoiceNote = async () => {\n try {\n setLoading(true);\n const response = await fetch(`/api/voicenotes/${voiceNoteId}`);\n const data = await response.json();\n\n if (data.success) {\n setVoiceNote(data.voiceNote);\n // Get audio URL\n setAudioUrl(`/api/voicenotes/${voiceNoteId}/audio`);\n } else {\n setError(data.error || \"Voice message not found\");\n }\n } catch (err) {\n setError(\"Failed to load voice message\");\n console.error(\"Error fetching voice message:\", err);\n } finally {\n setLoading(false);\n }\n };\n\n const formatDuration = (seconds: number) => {\n const mins = Math.floor(seconds / 60);\n const secs = seconds % 60;\n return `${mins}:${secs.toString().padStart(2, \"0\")}`;\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\n };\n\n const getExpirationInfo = () => {\n if (!voiceNote) return null;\n\n if (voiceNote.isExpired) {\n return {\n text: \"This voice message has expired\",\n color: \"text-red-600\",\n icon: \"⚠️\",\n };\n }\n\n if (voiceNote.expiresAt) {\n const expiresDate = new Date(voiceNote.expiresAt);\n const now = new Date();\n const timeLeft = expiresDate.getTime() - now.getTime();\n const daysLeft = Math.ceil(timeLeft / (1000 * 60 * 60 * 24));\n\n return {\n text: `Expires on ${formatDate(voiceNote.expiresAt)} (${daysLeft} day${daysLeft !== 1 ? \"s\" : \"\"} left)`,\n color: daysLeft <= 1 ? \"text-orange-600\" : \"text-gray-600\",\n icon: \"⏰\",\n };\n }\n\n if (voiceNote.maxListens) {\n const listensLeft = voiceNote.maxListens - voiceNote.currentListens;\n return {\n text: `${listensLeft} listen${\n listensLeft !== 1 ? \"s\" : \"\"\n } remaining (${voiceNote.currentListens}/${voiceNote.maxListens} used)`,\n color: listensLeft <= 1 ? \"text-orange-600\" : \"text-gray-600\",\n icon: \"👂\",\n };\n }\n\n return null;\n };\n\n const copyToClipboard = async (text: string) => {\n try {\n await navigator.clipboard.writeText(text);\n alert(\"Transcription copied to clipboard!\");\n } catch (error) {\n console.error(\"Failed to copy:\", error);\n }\n };\n\n if (loading) {\n return (\n

⏳

\n Loading Voice Note...\n

\n );\n }\n\n if (error) {\n return (\n

❌

\n Error\n

{error}

\n window.location.href = \"/\"}\n className=\"px-6 py-2 bg-blue-600 text-white rounded-md hover:bg-blue-700\"\n >\n Go Home\n \n

\n );\n }\n\n if (!voiceNote) {\n return null;\n }\n\n const expirationInfo = getExpirationInfo();\n\n return (\n

🎵

\n {voiceNote.title || \"Voice Message\"}\n

\n Created {formatDate(voiceNote.createdAt)}\n

\n Duration: {formatDuration(voiceNote.duration)}\n

\n\n {expirationInfo && (\n

\n {expirationInfo.icon} {expirationInfo.text}\n

\n )}\n\n {!voiceNote.isExpired && audioUrl && (\n

\n \n

\n )}\n\n {voiceNote.isExpired && (\n

\n This voice message has expired and can no longer be played.\n

\n )}\n\n {voiceNote.transcription && (\n

Transcription

\n copyToClipboard(voiceNote.transcription!)}\n className=\"text-sm text-blue-600 hover:text-blue-800 underline\"\n >\n Copy\n \n

\n {voiceNote.transcription}\n

\n )}\n\n {!voiceNote.transcription && !voiceNote.isExpired && (\n

\n 🤖 Transcription in progress... Refresh the page in a moment to see the text.\n

\n )}\n\n

\n window.location.href = \"/\"}\n className=\"px-6 py-2 bg-blue-600 text-white rounded-md hover:bg-blue-700\"\n >\n Create Your Own Voice Message\n \n

\n );\n}",[],[19,88,150],"4f91e300-dbd1-11f0-9064-42dde27851f2","ShareModal.tsx","019b2fe7-52b6-7612-a0ac-aa3c5b5b9566",["D",1766035247689],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { ShareSettings } from \"../../shared/types.ts\";\n\ninterface ShareModalProps {\n onSave: (settings: ShareSettings) => void;\n onCancel: () => void;\n isUploading: boolean;\n}\n\nexport default function ShareModal({ onSave, onCancel, isUploading }: ShareModalProps) {\n const [expirationType, setExpirationType] = useState<'none' | 'date' | 'listens'>('none');\n const [expirationDate, setExpirationDate] = useState('');\n const [maxListens, setMaxListens] = useState(1);\n\n const handleSave = () => {\n const settings: ShareSettings = {};\n \n if (expirationType === 'date' && expirationDate) {\n settings.expiresAt = new Date(expirationDate).toISOString();\n } else if (expirationType === 'listens') {\n settings.maxListens = maxListens;\n }\n \n onSave(settings);\n };\n\n const getTomorrowDate = () => {\n const tomorrow = new Date();\n tomorrow.setDate(tomorrow.getDate() + 1);\n return tomorrow.toISOString().split('T')[0];\n };\n\n return (\n

\n Share Settings\n

\n \n

\n \n Expiration Settings\n \n \n

\n \n setExpirationType(e.target.value as 'none')}\n className=\"mr-2\"\n />\n No expiration\n \n \n \n setExpirationType(e.target.value as 'date')}\n className=\"mr-2\"\n />\n Expire on date\n \n \n {expirationType === 'date' && (\n

\n setExpirationDate(e.target.value)}\n min={getTomorrowDate()}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n )}\n \n \n setExpirationType(e.target.value as 'listens')}\n className=\"mr-2\"\n />\n Expire after listens\n \n \n {expirationType === 'listens' && (\n

\n setMaxListens(parseInt(e.target.value) || 1)}\n min=\"1\"\n max=\"100\"\n className=\"w-20 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n \n listen{maxListens !== 1 ? 's' : ''}\n \n

\n )}\n

\n \n

\n \n Cancel\n \n \n {isUploading ? 'Saving...' : 'Save & Share'}\n \n

\n );\n}",[],[19,88,157],"4f91db9e-dbd1-11f0-9064-42dde27851f2","Dashboard.tsx","019b2fe7-52b6-7612-a0ac-a56306d5421e",["D",1766035247689],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { VoiceNote } from \"../../shared/types.ts\";\n\nexport default function Dashboard() {\n const [voiceNotes, setVoiceNotes] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n useEffect(() => {\n fetchVoiceNotes();\n }, []);\n\n const fetchVoiceNotes = async () => {\n try {\n setLoading(true);\n const response = await fetch(\"/api/voicenotes\");\n const data = await response.json();\n\n if (data.success) {\n setVoiceNotes(data.voiceNotes || []);\n } else {\n setError(data.error || \"Failed to fetch voice messages\");\n }\n } catch (err) {\n setError(\"Failed to load voice messages\");\n console.error(\"Error fetching voice messages:\", err);\n } finally {\n setLoading(false);\n }\n };\n\n const formatDuration = (seconds: number) => {\n const mins = Math.floor(seconds / 60);\n const secs = seconds % 60;\n return `${mins}:${secs.toString().padStart(2, \"0\")}`;\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"short\",\n day: \"numeric\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\n };\n\n const getStatusInfo = (voiceNote: VoiceNote) => {\n if (voiceNote.isExpired) {\n return {\n text: \"Expired\",\n color: \"text-red-600 bg-red-50\",\n icon: \"⚠️\",\n };\n }\n\n if (voiceNote.expiresAt) {\n const expiresDate = new Date(voiceNote.expiresAt);\n const now = new Date();\n const timeLeft = expiresDate.getTime() - now.getTime();\n const daysLeft = Math.ceil(timeLeft / (1000 * 60 * 60 * 24));\n\n if (daysLeft <= 1) {\n return {\n text: `Expires soon (${daysLeft} day${daysLeft !== 1 ? \"s\" : \"\"})`,\n color: \"text-orange-600 bg-orange-50\",\n icon: \"⏰\",\n };\n }\n\n return {\n text: `Expires in ${daysLeft} days`,\n color: \"text-blue-600 bg-blue-50\",\n icon: \"⏰\",\n };\n }\n\n if (voiceNote.maxListens) {\n const listensLeft = voiceNote.maxListens - voiceNote.currentListens;\n\n if (listensLeft <= 1) {\n return {\n text: `${listensLeft} listen${listensLeft !== 1 ? \"s\" : \"\"} left`,\n color: \"text-orange-600 bg-orange-50\",\n icon: \"👂\",\n };\n }\n\n return {\n text: `${listensLeft}/${voiceNote.maxListens} listens left`,\n color: \"text-blue-600 bg-blue-50\",\n icon: \"👂\",\n };\n }\n\n return {\n text: \"Active\",\n color: \"text-green-600 bg-green-50\",\n icon: \"✅\",\n };\n };\n\n const copyShareUrl = async (voiceNoteId: string) => {\n const shareUrl = `${window.location.origin}/note/${voiceNoteId}`;\n try {\n await navigator.clipboard.writeText(shareUrl);\n alert(\"Share link copied to clipboard!\");\n } catch (error) {\n console.error(\"Failed to copy:\", error);\n // Fallback: show the URL in a prompt\n prompt(\"Copy this link:\", shareUrl);\n }\n };\n\n const deleteVoiceNote = async (voiceNoteId: string) => {\n if (!confirm(\"Are you sure you want to delete this voice messages? This action cannot be undone.\")) {\n return;\n }\n\n try {\n const response = await fetch(`/api/voicenotes/${voiceNoteId}`, {\n method: \"DELETE\",\n });\n\n const data = await response.json();\n\n if (data.success) {\n setVoiceNotes(prev => prev.filter(note => note.id !== voiceNoteId));\n } else {\n alert(\"Failed to delete voice message: \" + data.error);\n }\n } catch (error) {\n console.error(\"Error deleting voice message:\", error);\n alert(\"Failed to delete voice message\");\n }\n };\n\n if (loading) {\n return (\n

⏳

\n Loading Your Voice Messages...\n

\n );\n }\n\n if (error) {\n return (\n

❌

\n Error\n

{error}

\n \n Try Again\n \n

\n );\n }\n\n return (\n

\n 📋 Your Voice Messages\n

\n \n Refresh\n \n

\n\n {voiceNotes.length === 0\n ? (\n

🎙️

\n No Voice Messages Yet\n

\n Create your first voice message to see it here!\n

\n )\n : (\n

\n {voiceNotes.map((voiceNote) => {\n const statusInfo = getStatusInfo(voiceNote);\n\n return (\n \n

\n {voiceNote.title || \"Untitled Voice Message\"}\n

\n Created {formatDate(voiceNote.createdAt)} • {formatDuration(voiceNote.duration)}\n

\n\n \n {statusInfo.icon} {statusInfo.text}\n \n

\n\n {voiceNote.transcription && (\n

\n {voiceNote.transcription}\n

\n )}\n\n

\n 👂 {voiceNote.currentListens} listen{voiceNote.currentListens !== 1 ? \"s\" : \"\"}\n {voiceNote.maxListens && 📊 {voiceNote.maxListens} max}\n {voiceNote.expiresAt && ⏰ Expires {formatDate(voiceNote.expiresAt)}}\n

\n\n

\n window.open(`/note/${voiceNote.id}`, \"_blank\")}\n className=\"px-3 py-1 bg-blue-100 text-blue-700 rounded hover:bg-blue-200\"\n >\n View\n \n copyShareUrl(voiceNote.id)}\n className=\"px-3 py-1 bg-green-100 text-green-700 rounded hover:bg-green-200\"\n >\n Share\n \n deleteVoiceNote(voiceNote.id)}\n className=\"px-3 py-1 bg-red-100 text-red-700 rounded hover:bg-red-200\"\n >\n Delete\n \n

\n );\n })}\n

\n )}\n \n );\n}",[],[19,88,164],"4f91d856-dbd1-11f0-9064-42dde27851f2","App.tsx","019b2fe7-52b6-7612-a0ac-a02e794f11bd",["D",1766035247689],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport Dashboard from \"./Dashboard.tsx\";\nimport VoicePlayer from \"./VoicePlayer.tsx\";\nimport VoiceRecorder from \"./VoiceRecorder.tsx\";\n\ndeclare global {\n interface Window {\n __VOICE_NOTE_ID__?: string;\n }\n}\n\nexport default function App() {\n const [currentView, setCurrentView] = useState<\"recorder\" | \"player\" | \"dashboard\">(\"recorder\");\n const voiceNoteId = window.__VOICE_NOTE_ID__;\n\n useEffect(() => {\n if (voiceNoteId) {\n setCurrentView(\"player\");\n }\n }, [voiceNoteId]);\n\n return (\n

\n 🎙️ Voice Messages\n

\n Record, transcribe, and share voice notes with expiration controls\n

\n\n {/* Navigation */}\n {!voiceNoteId && (\n

\n setCurrentView(\"recorder\")}\n className={`px-6 py-2 rounded-md font-medium transition-colors ${\n currentView === \"recorder\"\n ? \"bg-blue-600 text-white\"\n : \"bg-white text-gray-700 hover:bg-gray-50\"\n }`}\n >\n 🎙️ Record\n \n setCurrentView(\"dashboard\")}\n className={`px-6 py-2 rounded-md font-medium transition-colors ${\n currentView === \"dashboard\"\n ? \"bg-blue-600 text-white\"\n : \"bg-white text-gray-700 hover:bg-gray-50\"\n }`}\n >\n 📋 My Messages\n \n

\n )}\n\n

\n {currentView === \"recorder\" && !voiceNoteId && (\n setCurrentView(\"dashboard\")} />\n )}\n\n {currentView === \"dashboard\" && !voiceNoteId && }\n\n {currentView === \"player\" && voiceNoteId && }\n

\n );\n}",[],[19,88,171],"4f91d720-dbd1-11f0-9064-42dde27851f2","backend","019b2fe7-52b6-7612-a0ac-9f697f5fbbba",["D",1766035247689],[183,184,185],[178],{"_35":216,"_13":217,"_63":218,"_65":179,"_67":68,"_69":70,"_71":72,"_37":219,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":220,"_18":221},{"_35":194,"_13":195,"_63":196,"_65":179,"_67":68,"_69":70,"_71":72,"_37":197,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":198,"_18":199},{"_35":186,"_13":187,"_63":188,"_65":179,"_67":68,"_69":70,"_71":72,"_37":189,"_17":32,"_74":190,"_76":191,"_78":50,"_79":-5,"_105":192,"_18":193},"4f91d40a-dbd1-11f0-9064-42dde27851f2","index.ts","019b2fe7-52b6-7612-a0ac-9ab6d706206f",["D",1766035247689],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport voiceNotesRoutes from \"./routes/voicenotes.ts\";\nimport staticRoutes from \"./routes/static.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Run database migrations on startup\ntry {\n await runMigrations();\n console.log(\"Migrations completed successfully\");\n} catch (error) {\n console.error(\"Migration failed:\", error);\n}\n\n// Mount routes\napp.route(\"/api/voicenotes\", voiceNotesRoutes);\napp.route(\"/\", staticRoutes);\n\nexport default app.fetch;",[],[178,187],"4f91d2b6-dbd1-11f0-9064-42dde27851f2","routes","019b2fe7-52b6-7612-a0ac-947a6f6e290a",["D",1766035247689],[200,201],[178,195],{"_35":209,"_13":210,"_63":211,"_65":196,"_67":68,"_69":70,"_71":72,"_37":212,"_17":32,"_74":75,"_76":213,"_78":50,"_79":-5,"_105":214,"_18":215},{"_35":202,"_13":203,"_63":204,"_65":196,"_67":68,"_69":70,"_71":72,"_37":205,"_17":32,"_74":75,"_76":206,"_78":50,"_79":-5,"_105":207,"_18":208},"4f91cb04-dbd1-11f0-9064-42dde27851f2","voicenotes.ts","019b2fe7-52b6-7612-a0ac-934c31395c86",["D",1766035247689],"import { type Context, Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport Groq from \"npm:groq-sdk\";\nimport type { TranscriptionResponse, VoiceNote, VoiceNoteResponse } from \"../../shared/types.ts\";\nimport { TABLE_NAME } from \"../database/migrations.ts\";\nimport {\n createVoiceNote,\n deleteVoiceNote,\n getAllVoiceNotes,\n getVoiceNote,\n incrementListenCount,\n updateTranscription,\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\nconst openai = new OpenAI();\n\n// Get all voice notes (for admin/dashboard)\napp.get(\"/\", async (c) => {\n try {\n const voiceNotes = await getAllVoiceNotes();\n return c.json({ success: true, voiceNotes });\n } catch (error) {\n console.error(\"Error fetching voice notes:\", error);\n return c.json({ success: true, voiceNotes: [] });\n }\n});\n\n// Create a new voice note\napp.post(\"/\", async (c) => {\n try {\n const formData = await c.req.formData();\n const audioFile = formData.get(\"audio\") as File;\n const title = formData.get(\"title\") as string;\n const duration = formData.get(\"duration\") as string;\n const expiresAt = formData.get(\"expiresAt\") as string;\n const maxListens = formData.get(\"maxListens\") as string;\n\n if (!audioFile) {\n return c.json({ success: false, error: \"No audio file provided\" }, 400);\n }\n\n // Generate unique ID\n const id = crypto.randomUUID();\n const blobKey = `voice_note_${id}`;\n\n // Store audio file in blob storage\n const audioBuffer = await audioFile.arrayBuffer();\n await blob.set(blobKey, new Uint8Array(audioBuffer));\n\n // Create voice note record\n const voiceNote: Omit = {\n id,\n title: title || undefined,\n audioUrl: blobKey,\n duration: duration ? parseInt(duration) : 0,\n createdAt: new Date().toISOString(),\n expiresAt: expiresAt || undefined,\n maxListens: maxListens ? parseInt(maxListens) : undefined,\n currentListens: 0,\n };\n\n await createVoiceNote(voiceNote);\n\n // Start transcription in background\n transcribeAudio(id, audioBuffer).catch(console.error);\n\n const shareUrl = `${new URL(c.req.url).origin}/note/${id}`;\n\n return c.json({\n success: true,\n voiceNote: { ...voiceNote, isExpired: false },\n shareUrl,\n });\n } catch (error) {\n console.error(\"Error creating voice note:\", error);\n return c.json({ success: false, error: \"Failed to create voice note\" }, 500);\n }\n});\n\n// Get a voice note by ID\napp.get(\"/:id\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n const voiceNote = await getVoiceNote(id);\n\n if (!voiceNote) {\n return c.json({ success: false, error: \"Voice note not found\" }, 404);\n }\n\n if (voiceNote.isExpired) {\n return c.json({ success: false, error: \"Voice note has expired\" }, 410);\n }\n\n return c.json({ success: true, voiceNote });\n } catch (error) {\n console.error(\"Error fetching voice note:\", error);\n return c.json({ success: false, error: \"Failed to fetch voice note\" }, 500);\n }\n});\n\n// Get audio file for a voice note\napp.get(\"/:id/audio\", async (c: Context) => {\n try {\n const id = c.req.param(\"id\");\n const voiceNote = await getVoiceNote(id);\n\n if (!voiceNote) {\n return c.json({ success: false, error: \"Voice note not found\" }, 404);\n }\n\n if (voiceNote.isExpired) {\n return c.json({ success: false, error: \"Voice note has expired\" }, 410);\n }\n\n // Increment listen count\n await incrementListenCount(id);\n\n // Check if audio file exists in blob storage\n if (!voiceNote.audioUrl) {\n return c.json({ success: false, error: \"Audio file not found\" }, 404);\n }\n\n // Get audio from blob storage\n const audioStream = await blob.get(voiceNote.audioUrl);\n\n if (!audioStream) {\n return c.json({ success: false, error: \"Audio file not found\" }, 404);\n }\n\n const audioArrayBuffer = await audioStream.arrayBuffer();\n\n // Set headers\n c.header(\"Content-Type\", \"audio/webm\");\n c.header(\"Content-Length\", audioArrayBuffer.byteLength.toString());\n\n // Send the buffer as the response\n return new Response(audioArrayBuffer, {\n headers: c.headers,\n });\n } catch (error) {\n console.error(\"Error serving audio:\", error);\n return c.json({ success: false, error: \"Failed to serve audio\" }, 500);\n }\n});\n\nconst groq = new Groq({\n apiKey: Deno.env.get(\"GROQ_API_KEY\") || \"\",\n});\n// Background transcription function\nasync function transcribeAudio(voiceNoteId: string, audioBuffer: ArrayBuffer) {\n try {\n // Convert ArrayBuffer to File for OpenAI\n const audioFile = new File([audioBuffer], \"audio.webm\", { type: \"audio/webm\" });\n\n const transcription = await groq.audio.transcriptions.create({\n file: audioFile,\n model: \"whisper-large-v3-turbo\",\n response_format: \"verbose_json\",\n });\n\n await updateTranscription(voiceNoteId, transcription.text);\n console.log(`Transcription completed for voice note ${voiceNoteId}`);\n } catch (error) {\n console.error(`Transcription failed for voice note ${voiceNoteId}:`, error);\n }\n}\n\n// Delete a voice note\napp.delete(\"/:id\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n const voiceNote = await getVoiceNote(id);\n\n if (!voiceNote) {\n return c.json({ success: false, error: \"Voice note not found\" }, 404);\n }\n\n // Delete audio from blob storage\n try {\n await blob.delete(voiceNote.audioUrl);\n } catch (error) {\n console.warn(\"Failed to delete audio blob:\", error);\n }\n\n // Delete from database\n await deleteVoiceNote(id);\n\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting voice note:\", error);\n return c.json({ success: false, error: \"Failed to delete voice note\" }, 500);\n }\n});\n\nexport default app;",[],[178,195,203],"4f91c9f6-dbd1-11f0-9064-42dde27851f2","static.ts","019b2fe7-52b6-7612-a0ac-8f322f8abf61",["D",1766035247689],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\nconst app = new Hono();\n\n// Serve frontend files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main app\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Serve voice note player page\napp.get(\"/note/:id\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject the voice note ID for the player\n const voiceNoteId = c.req.param(\"id\");\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\nexport default app;",[],[178,195,210],"4f91c8c0-dbd1-11f0-9064-42dde27851f2","database","019b2fe7-52b6-7612-a0ac-8bdf83078245",["D",1766035247689],[222,223],[178,217],{"_35":231,"_13":232,"_63":233,"_65":218,"_67":68,"_69":70,"_71":72,"_37":234,"_17":32,"_74":75,"_76":235,"_78":50,"_79":-5,"_105":236,"_18":237},{"_35":224,"_13":225,"_63":226,"_65":218,"_67":68,"_69":70,"_71":72,"_37":227,"_17":32,"_74":75,"_76":228,"_78":50,"_79":-5,"_105":229,"_18":230},"4f91befc-dbd1-11f0-9064-42dde27851f2","queries.ts","019b2fe7-52b6-7612-a0ac-84d37c17b611",["D",1766035247689],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./migrations.ts\";\nimport type { VoiceNote } from \"../../shared/types.ts\";\n\nexport async function createVoiceNote(voiceNote: Omit): Promise {\n try {\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (\n id, title, audio_blob_key, transcription, duration, \n created_at, expires_at, max_listens, current_listens\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n voiceNote.id,\n voiceNote.title || null,\n voiceNote.audioUrl, // This will be the blob key\n voiceNote.transcription || null,\n voiceNote.duration,\n voiceNote.createdAt,\n voiceNote.expiresAt || null,\n voiceNote.maxListens || null,\n voiceNote.currentListens\n ]\n );\n console.log(\"Voice note successfully inserted into database\");\n } catch (error) {\n console.error(\"Error inserting voice note into database:\", error);\n throw error;\n }\n}\n\nexport async function getVoiceNote(id: string): Promise {\n try {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [id]\n );\n \n // Handle the case where result.rows exists (new format) or result is an array (old format)\n const rows = result.rows || result;\n \n if (!Array.isArray(rows) || rows.length === 0) {\n return null;\n }\n \n const row = rows[0];\n const now = new Date();\n const expiresAt = row.expires_at ? new Date(row.expires_at) : null;\n const isExpiredByDate = expiresAt && now > expiresAt;\n const isExpiredByListens = row.max_listens && row.current_listens >= row.max_listens;\n const isExpired = isExpiredByDate || isExpiredByListens || false;\n \n return {\n id: row.id,\n title: row.title,\n audioUrl: row.audio_blob_key,\n transcription: row.transcription,\n duration: row.duration,\n createdAt: row.created_at,\n expiresAt: row.expires_at,\n maxListens: row.max_listens,\n currentListens: row.current_listens,\n isExpired\n };\n } catch (error) {\n console.error(\"Error getting voice note from database:\", error);\n throw error;\n }\n}\n\nexport async function incrementListenCount(id: string): Promise {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET current_listens = current_listens + 1 WHERE id = ?`,\n [id]\n );\n}\n\nexport async function updateTranscription(id: string, transcription: string): Promise {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET transcription = ? WHERE id = ?`,\n [transcription, id]\n );\n}\n\nexport async function deleteVoiceNote(id: string): Promise {\n await sqlite.execute(\n `DELETE FROM ${TABLE_NAME} WHERE id = ?`,\n [id]\n );\n}\n\nexport async function getAllVoiceNotes(): Promise {\n try {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC`);\n \n // Handle the case where result.rows exists (new format) or result is an array (old format)\n const rows = result.rows || result;\n \n if (!Array.isArray(rows)) {\n return [];\n }\n \n return rows.map(row => {\n const now = new Date();\n const expiresAt = row.expires_at ? new Date(row.expires_at) : null;\n const isExpiredByDate = expiresAt && now > expiresAt;\n const isExpiredByListens = row.max_listens && row.current_listens >= row.max_listens;\n const isExpired = isExpiredByDate || isExpiredByListens || false;\n \n return {\n id: row.id,\n title: row.title,\n audioUrl: row.audio_blob_key,\n transcription: row.transcription,\n duration: row.duration,\n createdAt: row.created_at,\n expiresAt: row.expires_at,\n maxListens: row.max_listens,\n currentListens: row.current_listens,\n isExpired\n };\n });\n } catch (error) {\n console.error('Error in getAllVoiceNotes:', error);\n throw error;\n }\n}",[],[178,217,225],"4f91b42a-dbd1-11f0-9064-42dde27851f2","migrations.ts","019b2fe7-52b6-7612-a0ac-801e33548ef0",["D",1766035247689],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'voice_notes_v1';\n\nexport async function runMigrations() {\n try {\n // Create voice notes table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id TEXT PRIMARY KEY,\n title TEXT,\n audio_blob_key TEXT NOT NULL,\n transcription TEXT,\n duration INTEGER NOT NULL,\n created_at TEXT NOT NULL,\n expires_at TEXT,\n max_listens INTEGER,\n current_listens INTEGER DEFAULT 0,\n is_expired BOOLEAN DEFAULT FALSE\n )`);\n \n console.log('Database migrations completed successfully');\n } catch (error) {\n console.error('Database migration failed:', error);\n throw error;\n }\n}\n\nexport { TABLE_NAME };",[],[178,217,232],"4f8cb538-dbd1-11f0-9064-42dde27851f2",["D",1766035247689],"legacyEnvVars","httpPrivacy","description","Record, transcribe, and share voice notes","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/18bff8bf-ce15-4f5b-07b9-ea79b4736400/square512?exp=1789585199&sig=75c32f9c3d4cc32bab8a249905a3985fd10a43add59881b75930583f4abdc68c","userId","c1ee093d-ee92-4e6f-8d9d-7b79665c7879","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","dc0397f8-bd70-4f52-aefa-bf01904f90cd","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_282":278},"org",{"_11":12,"_276":-5,"_277":278,"_246":247,"_279":280,"_281":50},"branch",{"_17":70,"_13":16,"_35":68,"_41":238,"_44":36,"_45":43,"_273":52,"_274":42,"_275":56,"_57":14,"_53":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybk9udVM5WVdIYWRSaGNlWlJwNElaTmM3aXkifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":238,"_13":14,"_37":384,"_48":-5,"_240":50,"_51":52,"_241":52,"_242":243,"_244":245,"_246":247,"_248":188,"_249":72,"_250":-5,"_251":-5,"_252":32,"_55":253,"_254":-5,"_255":-5,"_256":-5,"_257":-5,"_258":259,"_260":259,"_261":262,"_263":262,"_264":262,"_265":259,"_266":259,"_267":385,"_269":386,"_271":387,"_49":50},[324,332,341,343],"files",[324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343],"counts",{"_315":32,"_316":70,"_317":32,"_34":318,"_319":320},[309,310,311],{"_35":93,"_13":19,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":94,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_18":308},"upstreamProject",{"_35":42,"_13":14,"_242":243,"_244":245,"_51":52,"_267":306},"upstreamBranch",{"_35":36,"_37":304,"_39":305,"_13":16,"_41":42,"_17":43,"_44":-5,"_45":-5,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":54,"_55":56,"_57":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1748056195569],["D",1749000346558],{"_11":54,"_282":307},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/7fcc9ac1-f8fb-41e2-0168-af29ef7c6400/square512?exp=1789585199&sig=3ffdbdabe52178cff14f29ed36c8fb754dd43993a5642231f39a7eb1fece8819",[19],{"_35":87,"_13":88,"_63":89,"_65":66,"_67":68,"_69":70,"_71":72,"_37":90,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_18":314},{"_35":81,"_13":82,"_63":83,"_65":66,"_67":68,"_69":70,"_71":72,"_37":84,"_17":32,"_74":24,"_76":85,"_78":50,"_79":-5,"_18":313},{"_35":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_37":73,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_18":312},[19,62],[19,82],[19,88],"pulls","branches","forks",{"_321":70,"_323":70},"connections",{"_321":32,"_322":32},"count","unfilledCount","emptyCount",{"_35":177,"_13":178,"_63":179,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":180,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":382,"_18":383},{"_35":216,"_13":217,"_63":218,"_65":179,"_67":68,"_69":70,"_71":72,"_37":219,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":380,"_18":381},{"_35":231,"_13":232,"_63":233,"_65":218,"_67":68,"_69":70,"_71":72,"_37":234,"_17":32,"_74":75,"_76":235,"_78":50,"_79":-5,"_105":378,"_18":379},{"_35":224,"_13":225,"_63":226,"_65":218,"_67":68,"_69":70,"_71":72,"_37":227,"_17":32,"_74":75,"_76":228,"_78":50,"_79":-5,"_105":376,"_18":377},{"_35":194,"_13":195,"_63":196,"_65":179,"_67":68,"_69":70,"_71":72,"_37":197,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":374,"_18":375},{"_35":209,"_13":210,"_63":211,"_65":196,"_67":68,"_69":70,"_71":72,"_37":212,"_17":32,"_74":75,"_76":213,"_78":50,"_79":-5,"_105":372,"_18":373},{"_35":202,"_13":203,"_63":204,"_65":196,"_67":68,"_69":70,"_71":72,"_37":205,"_17":32,"_74":75,"_76":206,"_78":50,"_79":-5,"_105":370,"_18":371},{"_35":186,"_13":187,"_63":188,"_65":179,"_67":68,"_69":70,"_71":72,"_37":189,"_17":32,"_74":190,"_76":191,"_78":50,"_79":-5,"_105":368,"_18":369},{"_35":93,"_13":19,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":122,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":366,"_18":367},{"_35":87,"_13":88,"_63":89,"_65":66,"_67":68,"_69":70,"_71":72,"_37":134,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":364,"_18":365},{"_35":170,"_13":171,"_63":172,"_65":89,"_67":68,"_69":70,"_71":72,"_37":173,"_17":32,"_74":75,"_76":174,"_78":50,"_79":-5,"_105":362,"_18":363},{"_35":163,"_13":164,"_63":165,"_65":89,"_67":68,"_69":70,"_71":72,"_37":166,"_17":32,"_74":75,"_76":167,"_78":50,"_79":-5,"_105":360,"_18":361},{"_35":156,"_13":157,"_63":158,"_65":89,"_67":68,"_69":70,"_71":72,"_37":159,"_17":32,"_74":75,"_76":160,"_78":50,"_79":-5,"_105":358,"_18":359},{"_35":149,"_13":150,"_63":151,"_65":89,"_67":68,"_69":70,"_71":72,"_37":152,"_17":32,"_74":75,"_76":153,"_78":50,"_79":-5,"_105":356,"_18":357},{"_35":142,"_13":143,"_63":144,"_65":89,"_67":68,"_69":70,"_71":72,"_37":145,"_17":32,"_74":75,"_76":146,"_78":50,"_79":-5,"_105":354,"_18":355},{"_35":81,"_13":82,"_63":83,"_65":66,"_67":68,"_69":70,"_71":72,"_37":131,"_17":32,"_74":24,"_76":85,"_78":50,"_79":-5,"_105":352,"_18":353},{"_35":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_37":128,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_105":350,"_18":351},{"_35":108,"_13":109,"_63":110,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":111,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_105":348,"_18":349},{"_35":115,"_13":116,"_63":117,"_65":110,"_67":68,"_69":70,"_71":72,"_37":118,"_17":32,"_74":75,"_76":119,"_78":50,"_79":-5,"_105":346,"_18":347},{"_35":100,"_13":101,"_63":102,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":103,"_17":32,"_74":24,"_76":104,"_78":50,"_79":-5,"_105":344,"_18":345},[],[101],[],[109,116],[342],[109],[],[19,62],[],[19,82],[],[19,88,143],[],[19,88,150],[],[19,88,157],[],[19,88,164],[],[19,88,171],[334,335,336,337,338],[19,88],[333,339,340],[19],[],[178,187],[],[178,195,203],[],[178,195,210],[329,330],[178,195],[],[178,217,225],[],[178,217,232],[326,327],[178,217],[325,328,331],[178],["D",1766035247689],{"_11":12,"_282":278},{"_11":12,"_276":-5,"_277":278,"_246":247,"_279":280,"_281":50},{"_17":70,"_13":16,"_35":68,"_41":238,"_44":36,"_45":43,"_273":52,"_274":42,"_275":56,"_57":14,"_53":12},"ctx",{"_267":-5,"_301":421,"_422":423,"_424":425,"_426":50,"_427":50,"_428":50,"_429":72,"_430":-5,"_431":-7,"_432":-7,"_433":32,"_434":50,"_435":50,"_436":-5,"_437":50,"_438":50,"_439":50,"_440":-5},"ENV",{"_392":393,"_394":395,"_396":16,"_397":398,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408,"_409":410,"_411":412,"_413":414,"_415":416,"_417":418,"_419":420},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]