\\s*]*href=\"([^\"]*)\"[^>]*>([^<]*?):<\\/strong><\\/a>([^]*?)\\[(\\d+)\\]\\s*<\\/p>/g;\n\n let reviewMatch;\n while ((reviewMatch = reviewRegex.exec(postHtml)) !== null) {\n const reviewer_url = reviewMatch[1];\n const reviewer = reviewMatch[2].trim();\n let review_text = reviewMatch[3].trim();\n const review_score = parseInt(reviewMatch[4]);\n\n // Clean up the review text - remove HTML tags and extra whitespace\n review_text = review_text\n .replace(/<[^>]*>/g, \"\") // Remove HTML tags\n .replace(/\\s+/g, \" \") // Normalize whitespace\n .replace(/–/g, \"–\") // Decode HTML entities\n .replace(/&/g, \"&\")\n .replace(/&/g, \"&\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/"/g, \"\\\"\")\n .replace(/’/g, \"'\")\n .replace(/“/g, \"\\\"\")\n .replace(/”/g, \"\\\"\")\n .trim();\n\n // Only add if we have the essential data\n if (reviewer && review_text && review_score) {\n reviews.push({\n song_index: songIndex,\n artist,\n song_title,\n href,\n overall_score,\n reviewer,\n reviewer_url,\n review_text,\n review_score,\n });\n }\n }\n\n return reviews;\n}\n\n// Function to find all post divs in the HTML\nfunction findPostDivs(html: string): string[] {\n const postDivs: string[] = [];\n\n // Find all li elements with the post class\n const postRegex = /]*class=\"[^\"]*wp-block-post[^\"]*\"[^>]*>(.*?)<\\/li>/gs;\n\n let match;\n while ((match = postRegex.exec(html)) !== null) {\n postDivs.push(match[0]);\n }\n\n return postDivs;\n}\n\n// Main execution - process multiple pages\nconst pagesTotal = 5;\nlet songIndex = 0;\n\n// Parse each post div and extract reviews\nconst allReviews: Array<{\n song_index: number;\n artist: string;\n song_title: string;\n href: string;\n overall_score: number | null;\n reviewer: string;\n reviewer_url: string;\n review_text: string;\n review_score: number;\n}> = [];\n\nfor (let i = 2; i <= pagesTotal; i++) {\n console.log(`Processing page ${i}/${pagesTotal}...`);\n const res = await fetch(url(i));\n const text = await res.text();\n\n // Find all post divs\n const postDivs = findPostDivs(text);\n console.log(`Found ${postDivs.length} post divs on page ${i}`);\n\n postDivs.forEach((postHtml) => {\n console.log(`Processing song ${songIndex}...`);\n const reviews = parsePostDiv(postHtml, songIndex);\n allReviews.push(...reviews);\n\n console.log(reviews);\n songIndex++; // Increment for each song/post\n });\n}\n\nconsole.log(`Total reviews extracted: ${allReviews.length}`);\nconsole.log(`Total songs processed: ${songIndex}`);\n\n// Insert all reviews into SQLite\nfor (const review of allReviews) {\n await sqlite.execute(\n `\n INSERT INTO ${TABLE_NAME} \n (song_index, artist, song_title, href, overall_score, reviewer, reviewer_url, review_text, review_score)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n `,\n [\n review.song_index,\n review.artist,\n review.song_title,\n review.href,\n review.overall_score,\n review.reviewer,\n review.reviewer_url,\n review.review_text,\n review.review_score,\n ],\n );\n}\n\nconsole.log(`Successfully cached ${allReviews.length} reviews to SQLite table: ${TABLE_NAME}`);\nconsole.log(\"Script execution completed!\");",[144],"4a707d4c-43a0-11f0-b588-76b3cceeab13","exampleDiv.html","cd583614-439b-11f0-a6ef-76b3cceeab13",17,["D",1749301617109],3,"

\n
\n Skye Newman – Family Matters\n
\n\n

\n
\n It’s a rare condition, this day and age, to read any bad blurbs on\n the Jukebox page…\n
\n
\n \n \n
\n [Video]
[5.73]\n \n
\n
\n Claire Davidson: I can see why, only two singles\n into her career, Columbia has given Skye Newman such an immediate push:\n it’s not everyday you happen upon a vocalist genuinely reminiscent of\n Amy Winehouse, albeit without the more sardonic contours that emphasized\n Winehouse’s gallows humor. In “Family Matters,” though, there’s little\n room for self-deprecation, as Newman narrates her family’s\n intergenerational struggles with drug addiction with a sobering\n bluntness, detailing the degree to which her own life has been\n endangered due to growing up in such an unstable environment. Newman’s\n candor is admirable, but the song surrounding her seems unsure of its\n own scope: the first verse begins as a more agonized ballad, whereas the\n second seems to flirt with a particularly morose form of ironic\n deflection, incorporating the presence of a more relaxed groove. “It is\n what it is” may be the song’s refrain of radical acceptance, but it’s\n clear Newman is looking to express a more visceral pain, leaving the\n remainder of the track feeling complacent by comparison.
[6]\n
\n

\n Julian Axelrod: Weirdly anonymous for a song with such\n intensely personal lyrics. Skye Newman is the T-1000 to Sky Ferreira’s\n Terminator, a blonde pop singer emerging to consume her like-named\n predecessor after a decade of dormancy.
[5]\n

\n Leah\n Isobel: Not to be a grump, but this feels vaguely\n condescending. The petulant lyrical tone (“you’re so dramatic/ I could\n tell you about me/ but you won’t understand” is a real whopper of\n self-righteous judgment) and Skye’s showboating performance aim for\n gravitas but land on hamminess instead. Still, I can’t drag this too\n hard. Even the clumsiest attempt to confront real suffering will matter\n to someone; perhaps that’s enough.
[5]\n

\n Tim\n de Reuse: There’s been a zillion cultural artifacts\n produced in the last decade about capital-T Trauma in the last decade;\n it’s so zeitgeisty you can’t even make an animated Disney feature\n without fitting the word “intergenerational” somewhere on the back of\n the box. At this point, one gets tired of the subject. The way Newman’s\n voice cracks out “it is what it is” seems refreshing in contrast; she’s\n offering no narrative of overcoming, just the tremble of joints under\n heavy weight. “A line meant two things / since I was like five” is an\n awkward, goofy zinger, but I wouldn’t have bought the depth of her\n predicament if she had put it more poetically.
[8]\n

\n Mark\n Sinker: Swearing is like the sunglasses in They\n Live: pop them on your face at the right moment and the\n structures that rule us are revealed. The vocal is a seamless fiction\n until we get to “bastard” and suddenly it’s pure Bexleyheath. (I have no\n idea where in South East London’s she’s from, to be honest. This is a\n somewhat muddling and faraway region of London for me and anyway her\n shtick is apparently that she moved around a ton – but the\n desedimentation effect is what it is… )
[6]\n

\n Ian\n Mathers: Honestly, I don’t find myself minding the way\n both the vocals and the lyrics feel a bit off to me, because I’m so\n distracted at the way the production makes me feel like someone’s\n homaging the first Unkle record.
[6]\n

\n Nortey Dowuona: From sparking one career to sparking another, Boo is a true Young Money\n legend.
[7]\n

\n Jel\n Bugle: This is totally Voice UK coded! Olly Murs and\n will.i.am would both turn around in their chairs. She sounds like\n Anne-Marie; it’s totally all right.
[6]\n

\n Katherine St. Asaph: The industry’s obsession with\n finding authentic-sounding Amy Winehouse-type singers without the\n inconveniently authentic volatility is rivaled only by its obsession\n with finding powerful-voiced soul singers without the melanin. What’s\n good about “Family Matters” are mostly the parts that sound like like\n Alicia Keys’ “Un-Thinkable”; what I in particular appreciate is how it\n sounds like a former American Idol fifth placer whose second\n post-Idol album exists solely in rural used record stores and\n YouTube playlists with the description “Provided to YouTube by\n TuneCore.” It’s pitched at a somewhat younger demographic, sure, but\n what separates “Family Matters” from, say, Alyssa Raghu or La’Porsha Renae or Elise Testone is less a matter of quality than the budget for\n marketing and expensive-sounding sounds. Newman’s lyrics are actually\n pretty raw, but in a straightforward way that makes them feel like raw\n pulpable material for AI slop (“With straightforward yet poignant lines, Newman speaks of\n family wounds, unmet expectations, and the desire to be seen for who she\n truly is, not who others want her to be,” groundbreaking really). And\n while none of this is really fair to Skye Newman, who isn’t responsible\n for the obsessions of A&R types, the allocations of record-label\n budgets, or the mindset of SEO bros, the context is still there.
[6]\n

\n Jacob\n Sujin Kuppermann: Perfectly fine as a piece of writing,\n but everything about this sounds like it was composed to later be sped\n up and rapped over.
[6]\n

\n Jonathan Bradley: “All happy families are alike,” wrote\n Tolstoy. “Each unhappy family is unhappy in its own way.” Right, but\n that doesn’t mean every chronicle of an unhappy family is worth the Anna Karenina\n treatment. “I could tell you about me,” says Skye Newman, her voice\n a baby-croak. “But you won’t understand.” What are we doing here\n then?
[2]\n

",[152],"pulls","forks","envVars",{"_165":53,"_167":53},"connections",{"_165":53,"_166":53},"count","unfilledCount","emptyCount",{"_20":151,"_13":152,"_119":153,"_121":-5,"_122":21,"_123":154,"_125":49,"_22":182,"_29":156,"_128":102,"_129":157,"_131":38,"_132":-5,"_173":183,"_90":184},{"_20":143,"_13":144,"_119":145,"_121":-5,"_122":21,"_123":30,"_125":49,"_22":179,"_29":147,"_128":148,"_129":149,"_131":38,"_132":-5,"_173":180,"_90":181},{"_20":134,"_13":135,"_119":47,"_121":-5,"_122":21,"_123":136,"_125":49,"_22":176,"_29":138,"_128":139,"_129":140,"_131":38,"_132":141,"_173":177,"_90":178},{"_20":117,"_13":118,"_119":120,"_121":-5,"_122":21,"_123":124,"_125":49,"_22":172,"_29":127,"_128":102,"_129":130,"_131":38,"_132":-5,"_173":174,"_90":175},["D",1749307426276],"children",[],[118],["D",1749307413469],[],[135],["D",1749310201537],[],[144],["D",1749301617109],[],[152],["D",1749299664543],{"_11":12,"_88":84},{"_11":12,"_81":82,"_83":84,"_44":45,"_85":86,"_87":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_76":-5,"_77":-5,"_78":-5,"_79":14,"_80":12},"ctx",{"_69":-5,"_110":222,"_223":224,"_225":226,"_227":38,"_228":38,"_229":38,"_230":49,"_231":-5,"_232":-7,"_233":-7,"_234":53,"_235":38,"_236":38,"_237":-5,"_238":38,"_239":38,"_240":38,"_241":-5},"ENV",{"_193":194,"_195":196,"_197":26,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]

Branches1

Branches
1