fix: progress nudge count

Updating formatting. Placed summary on a new line.

public/roadmap-content/git-github.json

@@ -13,6 +13,11 @@
         "url": "https://www.datacamp.com/blog/all-about-git",
         "type": "article"
       },
+      {
+        "title": "Version Control (Git) - The Missing Semester of Your CS Education",
+        "url": "https://missing.csail.mit.edu/2020/version-control/",
+        "type": "article"
+      },
       {
         "title": "GUI Clients",
         "url": "https://git-scm.com/downloads/guis",
@@ -215,6 +220,11 @@
     "title": ".gitignore",
     "description": "Ignored files are tracked in a special file named `.gitignore` that is checked in at the root of your repository. There is no explicit git ignore command: instead the `.gitignore` file must be edited and committed by hand when you have new files that you wish to ignore. `.gitignore` files contain patterns that are matched against file names in your repository to determine whether or not they should be ignored.\n\nVisit the following resources to learn more:",
     "links": [
+      {
+        "title": "gitignore - A collection of useful .gitignore templates",
+        "url": "https://github.com/github/gitignore",
+        "type": "opensource"
+      },
       {
         "title": "gitignore Documentation",
         "url": "https://git-scm.com/docs/gitignore/en",

public/roadmap-content/mlops.json

@@ -351,8 +351,13 @@
   },
   "UljuqA89_SlCSDWWMD_C_": {
     "title": "Spark",
-    "description": "Apache Spark is an open-source distributed computing system used for big data processing and analytics. It provides an interface for programming entire clusters with implicit data parallelism and fault tolerance.\n\nVisit the following resources to learn more:",
+    "description": "Apache Spark is an open-source distributed computing system designed for big data processing and analytics. It offers a unified interface for programming entire clusters, enabling efficient handling of large-scale data with built-in support for data parallelism and fault tolerance. Spark excels in processing tasks like batch processing, real-time data streaming, machine learning, and graph processing. It’s known for its speed, ease of use, and ability to process data in-memory, significantly outperforming traditional MapReduce systems. Spark is widely used in big data ecosystems for its scalability and versatility across various data processing tasks.\n\nVisit the following resources to learn more:",
     "links": [
+      {
+        "title": "ApacheSpark",
+        "url": "https://spark.apache.org/documentation.html",
+        "type": "article"
+      },
       {
         "title": "Spark By Examples",
         "url": "https://sparkbyexamples.com",

src/components/AuthenticationFlow/EmailLoginForm.tsx

@@ -1,6 +1,6 @@
 import Cookies from 'js-cookie';
 import type { FormEvent } from 'react';
-import { useState } from 'react';
+import { useId, useState } from 'react';
 import { httpPost } from '../../lib/http';
 import { TOKEN_COOKIE_NAME, setAuthToken } from '../../lib/jwt';
 
@@ -53,13 +53,16 @@ export function EmailLoginForm(props: EmailLoginFormProps) {
     setError(error?.message || 'Something went wrong. Please try again later.');
   };
 
+  const emailFieldId = `form:${useId()}`;
+  const passwordFieldId = `form:${useId()}`;
+
   return (
     <form className="w-full" onSubmit={handleFormSubmit}>
-      <label htmlFor="email" className="sr-only">
+      <label htmlFor={emailFieldId} className="sr-only">
         Email address
       </label>
       <input
-        id="email"
+        id={emailFieldId}
         name="email"
         type="email"
         autoComplete="email"
@@ -69,11 +72,11 @@ export function EmailLoginForm(props: EmailLoginFormProps) {
         value={email}
         onInput={(e) => setEmail(String((e.target as any).value))}
       />
-      <label htmlFor="password" className="sr-only">
+      <label htmlFor={passwordFieldId} className="sr-only">
         Password
       </label>
       <input
-        id="password"
+        id={passwordFieldId}
         name="password"
         type="password"
         autoComplete="current-password"

src/components/FrameRenderer/ProgressNudge.tsx

@@ -11,7 +11,9 @@ export function ProgressNudge(props: ProgressNudgeProps) {
   const $totalRoadmapNodes = useStore(totalRoadmapNodes);
   const $roadmapProgress = useStore(roadmapProgress);
 
-  const done = $roadmapProgress?.done?.length || 0;
+  const done =
+    ($roadmapProgress?.done?.length || 0) +
+    ($roadmapProgress?.skipped?.length || 0);
 
   const hasProgress = done > 0;
 
@@ -51,7 +53,8 @@ export function ProgressNudge(props: ProgressNudgeProps) {
         <span className="relative -top-[0.45px] mr-2 text-xs font-medium uppercase text-yellow-400">
           Progress
         </span>
-        <span>{done > $totalRoadmapNodes ? $totalRoadmapNodes : done}</span> of <span>{$totalRoadmapNodes}</span> Done
+        <span>{done > $totalRoadmapNodes ? $totalRoadmapNodes : done}</span> of{' '}
+        <span>{$totalRoadmapNodes}</span> Done
       </span>
 
       <span

src/data/roadmaps/datastructures-and-algorithms/content/101-programming-fundamentals/101-control-structures.md

@@ -3,4 +3,5 @@
 Control structures are fundamental elements in most programming languages that facilitate the flow of control through a program. There are three main types of control structures: Sequential, Selection and Iteration.
 - **Sequential** control structures are the default mode where instructions happen one after another.
 - **Selection** control structures (often called "conditional" or "decision" structures) allow one set of instructions to be executed if a condition is true and another if it's false. These typically include `if...else` statements.
-- **Iteration** control structures (also known as _loops_) allow a block of code to be repeated multiple times. Common loop structures include `for`, `while`, and `do...while` loops. All these control structures play a vital role in shaping the program logic.
+- **Iteration** control structures (also known as _loops_) allow a block of code to be repeated multiple times. Common loop structures include `for`, `while`, and `do...while` loops.
+All these control structures play a vital role in shaping the program logic.

src/data/roadmaps/postgresql-dba/content/sql-query-patterns--anti-patterns@G9DB1ZQjgXaHxJ4Lm6xGx.md

@@ -1,3 +1,3 @@
-# Schema Design Patterns in PostgreSQL
+# SQL Query Patterns in PostgreSQL
 
 Schema query patterns in PostgreSQL optimize data retrieval and manipulation by using indexes on frequently queried columns to speed up SELECT queries, optimizing joins with indexed foreign keys and appropriate join types, and leveraging table partitioning to limit data scans. Common Table Expressions (CTEs) break down complex queries for better readability and maintainability, while window functions allow advanced analytics within queries. Query caching and prepared statements reduce access times and execution overhead, respectively, and materialized views precompute and store complex query results for faster access. These patterns collectively enhance the efficiency, performance, and reliability of PostgreSQL queries.

src/pages/index.astro

@@ -14,16 +14,6 @@ const roleRoadmaps = await getRoadmapsByTag('role-roadmap');
 const skillRoadmaps = await getRoadmapsByTag('skill-roadmap');
 const bestPractices = await getAllBestPractices();
 const questionGroups = await getAllQuestionGroups();
-const projectGroups = [
-  {
-    title: 'Frontend',
-    id: 'frontend',
-  },
-  {
-    title: 'Backend',
-    id: 'backend',
-  },
-]
 
 const guides = await getAllGuides();
 const questionGuides = (await getAllQuestionGroups()).filter(
@@ -69,15 +59,6 @@ const videos = await getAllVideos();
       showCreateRoadmap={true}
     />
 
-    <FeaturedItems
-      heading='Project Ideas'
-      allowBookmark={false}
-      featuredItems={projectGroups.map((projectGroup) => ({
-        text: projectGroup.title,
-        url: `${projectGroup.id}/projects`,
-      }))}
-    />
-
     <FeaturedItems
       heading='Best Practices'
       featuredItems={bestPractices.map((bestPractice) => ({