🔬 Trailblazers: Women Who Transformed STEM 🚀

Celebrating the extraordinary achievements of women who changed science forever

\n {posts.map((post, index) => (\n

{post.title}

\n ${`${post.invention_name}`}$ \n

{post.invention_name}

\n 🧠 Field: {post.field}\n ⏰ Era: {post.era}\n

{post.content}

\n \n Learn More About {post.title}\n \n \n Explore {post.invention_name}\n \n

\n ))}\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const { OpenAI } = await import(\"https://esm.town/v/std/openai\");\n const openai = new OpenAI();\n const KEY = \"Women_In_STEM\";\n const SCHEMA_VERSION = 5;\n\n // Updated table schema to include invention description\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_stem_women_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n field TEXT NOT NULL,\n era TEXT NOT NULL,\n content TEXT NOT NULL,\n sourceUrl TEXT,\n portrait_url TEXT,\n invention_name TEXT,\n invention_source_url TEXT,\n invention_portrait_url TEXT,\n invention_description TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Handle blog post generation or retrieval\n if (request.url.includes('/blog-posts')) {\n // Check if we have existing posts\n const existingPosts = await sqlite.execute(`\n SELECT * FROM ${KEY}_stem_women_${SCHEMA_VERSION} LIMIT 5\n `);\n\n if (existingPosts.rows.length === 0) {\n // Generate blog posts about women in STEM with their key inventions\n const womenAndInventions = [\n {\n name: \"Ada Lovelace\",\n invention: \"Analytical Engine Algorithm\",\n field: \"Computer Science\",\n era: \"19th Century\"\n },\n {\n name: \"Marie Curie\", \n invention: \"Radioactivity Research\",\n field: \"Physics & Chemistry\",\n era: \"Early 20th Century\"\n },\n {\n name: \"Katherine Johnson\", \n invention: \"Space Trajectory Calculations\",\n field: \"Mathematics & Space Exploration\",\n era: \"Mid 20th Century\"\n },\n {\n name: \"Rosalind Franklin\", \n invention: \"DNA Double Helix Imaging\",\n field: \"Molecular Biology\",\n era: \"Mid 20th Century\"\n },\n {\n name: \"Grace Hopper\", \n invention: \"First Compiler\",\n field: \"Computer Science\",\n era: \"Late 20th Century\"\n }\n ];\n\n for (const woman of womenAndInventions) {\n // Generate concise, inspirational biography\n const biographyCompletion = await openai.chat.completions.create({\n messages: [{ \n role: \"user\", \n content: `Write an inspirational 150-word biography about ${woman.name} that highlights her groundbreaking achievements, emphasizing how her passion, resilience, and innovative thinking transformed ${woman.field}. Focus on the moments that define her as a trailblazer and inspire future generations.` \n }],\n model: \"gpt-4o-mini\",\n max_tokens: 200\n });\n\n // Generate detailed invention description\n const inventionCompletion = await openai.chat.completions.create({\n messages: [{ \n role: \"user\", \n content: `Provide a comprehensive description of ${woman.name}'s invention: ${woman.invention}. Explain its revolutionary impact, how it changed the field of ${woman.field}, and why it was a pivotal moment in scientific progress.` \n }],\n model: \"gpt-4o-mini\",\n max_tokens: 300\n });\n\n const bio = biographyCompletion.choices[0].message.content;\n const inventionDescription = inventionCompletion.choices[0].message.content;\n\n // Generate portrait URLs using dynamic image generation service\n const portraitUrl = `https://maxm-imggenurl.web.val.run/historical-portrait-of-${woman.name.toLowerCase().replace(' ', '-')}-in-professional-attire`;\n const inventionUrl = `https://maxm-imggenurl.web.val.run/${woman.invention.toLowerCase().replace(' ', '-')}-scientific-diagram`;\n\n await sqlite.execute(`\n INSERT INTO ${KEY}_stem_women_${SCHEMA_VERSION} \n (title, field, era, content, sourceUrl, portrait_url, \n invention_name, invention_source_url, invention_portrait_url, invention_description) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n woman.name, \n woman.field,\n woman.era,\n bio,\n `https://en.wikipedia.org/wiki/${woman.name.replace(\" \", \"_\")}`,\n portraitUrl,\n woman.invention,\n `https://en.wikipedia.org/wiki/${woman.invention.replace(\" \", \"_\")}`,\n inventionUrl,\n inventionDescription\n ]);\n }\n }\n\n const posts = await sqlite.execute(`\n SELECT * FROM ${KEY}_stem_women_${SCHEMA_VERSION} ORDER BY created_at DESC\n `);\n\n return Response.json(posts.rows);\n }\n\n // Serve the main page\n return new Response(`\n \n \n Women in STEM Blog\n \n \n \n \n

\n \n \n \n \n `, {\n headers: { \"Content-Type\": \"text/html\" }\n });\n}\n\nconst css = `\nbody {\n font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, 'Open Sans', 'Helvetica Neue', sans-serif;\n line-height: 1.6;\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n background-color: #f4f4f4;\n}\n\n.blog-container {\n background: white;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n}\n\nheader {\n text-align: center;\n border-bottom: 2px solid #e0e0e0;\n padding-bottom: 20px;\n margin-bottom: 20px;\n}\n\n.blog-post {\n margin-bottom: 30px;\n padding-bottom: 20px;\n border-bottom: 1px solid #e0e0e0;\n}\n\n.portraits-container {\n display: flex;\n justify-content: space-between;\n align-items: center;\n margin-bottom: 20px;\n}\n\n.portrait-section {\n display: flex;\n flex-direction: column;\n align-items: center;\n width: 45%;\n}\n\n.portrait {\n width: 150px;\n height: 150px;\n border-radius: 50%;\n object-fit: cover;\n margin-bottom: 10px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n}\n\n.scientist-portrait {\n border: 3px solid #3498db;\n}\n\n.invention-portrait {\n border: 3px solid #2ecc71;\n}\n\n.blog-post h2, .blog-post h3 {\n color: #2c3e50;\n margin: 0;\n text-align: center;\n}\n\n.post-meta {\n display: flex;\n justify-content: space-between;\n color: #7f8c8d;\n font-size: 0.9em;\n margin-bottom: 15px;\n}\n\n.links {\n display: flex;\n justify-content: space-between;\n}\n\na {\n color: #3498db;\n text-decoration: none;\n padding: 5px 10px;\n border-radius: 4px;\n background-color: #f0f0f0;\n}\n\na:hover {\n text-decoration: underline;\n background-color: #e0e0e0;\n}\n\nfooter {\n text-align: center;\n margin-top: 20px;\n font-size: 0.8em;\n color: #7f8c8d;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/hadji_b/Women_In_STEM/code/main.tsx","extension","actionData","errors"]