fix: sql course meta

.astro/settings.json

@@ -3,6 +3,6 @@
 		"enabled": false
 	},
 	"_variables": {
-		"lastUpdateCheck": 1757411878192
+		"lastUpdateCheck": 1739229597159
 	}
 }

.cursor/rules/content-migration.mdc

@@ -1,155 +0,0 @@
----
-description: When user requests migrating old roadmap content to new folder from content-old to content folder
-globs: 
-alwaysApply: false
----
-# Content Migration Rule
-
-## Rule Name: content-migration
-
-## Description
-This rule provides a complete process for migrating roadmap content from old structure to new structure using migration mapping files.
-
-## When to Use
-Use this rule when you need to:
-- Migrate content from content-old directories to content directories
-- Use a migration-mapping.json file to map topic paths to content IDs
-- Populate empty content files with existing content from legacy structure
-
-## Process
-
-### 1. Prerequisites Check
-- Verify the roadmap directory has a `migration-mapping.json` file
-- Confirm `content-old/` directory exists with source content
-- Confirm `content/` directory exists with target files
-
-### 2. Migration Script Creation
-Create a Node.js script with the following functionality:
-
-```javascript
-const fs = require('fs');
-const path = require('path');
-
-// Load the migration mapping
-const migrationMapping = JSON.parse(fs.readFileSync('migration-mapping.json', 'utf8'));
-
-// Function to find old content file based on topic path
-function findOldContentFile(topicPath) {
-  const parts = topicPath.split(':');
-  
-  if (parts.length === 1) {
-    // Top level file like "introduction"
-    return path.join('content-old', parts[0], 'index.md');
-  } else if (parts.length === 2) {
-    // Like "introduction:what-is-rust"
-    const [folder, filename] = parts;
-    return path.join('content-old', folder, `${filename}.md`);
-  } else if (parts.length === 3) {
-    // Like "language-basics:syntax:variables"
-    const [folder, subfolder, filename] = parts;
-    return path.join('content-old', folder, subfolder, `${filename}.md`);
-  }
-  
-  return null;
-}
-
-// Function to find new content file based on content ID
-function findNewContentFile(contentId) {
-  const contentDir = 'content';
-  const files = fs.readdirSync(contentDir);
-  
-  // Find file that ends with the content ID
-  const matchingFile = files.find(file => file.includes(`@${contentId}.md`));
-  
-  if (matchingFile) {
-    return path.join(contentDir, matchingFile);
-  }
-  
-  return null;
-}
-
-// Process each mapping
-console.log('Starting content migration...\n');
-
-let migratedCount = 0;
-let skippedCount = 0;
-
-for (const [topicPath, contentId] of Object.entries(migrationMapping)) {
-  const oldFilePath = findOldContentFile(topicPath);
-  const newFilePath = findNewContentFile(contentId);
-  
-  if (!oldFilePath) {
-    console.log(`❌ Could not determine old file path for: ${topicPath}`);
-    skippedCount++;
-    continue;
-  }
-  
-  if (!newFilePath) {
-    console.log(`❌ Could not find new file for content ID: ${contentId} (topic: ${topicPath})`);
-    skippedCount++;
-    continue;
-  }
-  
-  if (!fs.existsSync(oldFilePath)) {
-    console.log(`❌ Old file does not exist: ${oldFilePath} (topic: ${topicPath})`);
-    skippedCount++;
-    continue;
-  }
-  
-  try {
-    // Read old content
-    const oldContent = fs.readFileSync(oldFilePath, 'utf8');
-    
-    // Write to new file
-    fs.writeFileSync(newFilePath, oldContent);
-    
-    console.log(`✅ Migrated: ${topicPath} -> ${path.basename(newFilePath)}`);
-    migratedCount++;
-  } catch (error) {
-    console.log(`❌ Error migrating ${topicPath}: ${error.message}`);
-    skippedCount++;
-  }
-}
-
-console.log(`\n📊 Migration complete:`);
-console.log(`   Migrated: ${migratedCount} files`);
-console.log(`   Skipped: ${skippedCount} files`);
-console.log(`   Total: ${Object.keys(migrationMapping).length} mappings`);
-```
-
-### 3. Execution Steps
-1. Navigate to the roadmap directory (e.g., `src/data/roadmaps/[roadmap-name]`)
-2. Create the migration script as `migrate_content.cjs`
-3. Run: `node migrate_content.cjs`
-4. Review the migration results
-5. Clean up the temporary script file
-
-### 4. Validation
-After migration:
-- Verify a few migrated files have proper content (not just titles)
-- Check that the content structure matches the old content
-- Ensure proper markdown formatting is preserved
-
-## File Structure Expected
-```
-roadmap-directory/
-├── migration-mapping.json
-├── content/
-│   ├── file1@contentId1.md
-│   ├── file2@contentId2.md
-│   └── ...
-└── content-old/
-    ├── section1/
-    │   ├── index.md
-    │   ├── topic1.md
-    │   └── subsection1/
-    │       └── subtopic1.md
-    └── section2/
-        └── ...
-```
-
-## Notes
-- The migration mapping uses colons (`:`) to separate nested paths
-- Content files in the new structure use the pattern `filename@contentId.md`
-- The script handles 1-3 levels of nesting in the old structure
-- Always create the script with `.cjs` extension to avoid ES module issues

.cursor/rules/gh-cli.mdc

@@ -1,389 +0,0 @@
----
-description: GitHub pull requests
-globs: 
-alwaysApply: false
----
-# gh cli
-
-Work seamlessly with GitHub from the command line.
-
-USAGE
-  gh <command> <subcommand> [flags]
-
-CORE COMMANDS
-  auth:          Authenticate gh and git with GitHub
-  browse:        Open repositories, issues, pull requests, and more in the browser
-  codespace:     Connect to and manage codespaces
-  gist:          Manage gists
-  issue:         Manage issues
-  org:           Manage organizations
-  pr:            Manage pull requests
-  project:       Work with GitHub Projects.
-  release:       Manage releases
-  repo:          Manage repositories
-
-GITHUB ACTIONS COMMANDS
-  cache:         Manage GitHub Actions caches
-  run:           View details about workflow runs
-  workflow:      View details about GitHub Actions workflows
-
-ALIAS COMMANDS
-  co:            Alias for "pr checkout"
-
-ADDITIONAL COMMANDS
-  alias:         Create command shortcuts
-  api:           Make an authenticated GitHub API request
-  attestation:   Work with artifact attestations
-  completion:    Generate shell completion scripts
-  config:        Manage configuration for gh
-  extension:     Manage gh extensions
-  gpg-key:       Manage GPG keys
-  label:         Manage labels
-  preview:       Execute previews for gh features
-  ruleset:       View info about repo rulesets
-  search:        Search for repositories, issues, and pull requests
-  secret:        Manage GitHub secrets
-  ssh-key:       Manage SSH keys
-  status:        Print information about relevant issues, pull requests, and notifications across repositories
-  variable:      Manage GitHub Actions variables
-
-HELP TOPICS
-  accessibility: Learn about GitHub CLI's accessibility experiences
-  actions:       Learn about working with GitHub Actions
-  environment:   Environment variables that can be used with gh
-  exit-codes:    Exit codes used by gh
-  formatting:    Formatting options for JSON data exported from gh
-  mintty:        Information about using gh with MinTTY
-  reference:     A comprehensive reference of all gh commands
-
-FLAGS
-  --help      Show help for command
-  --version   Show gh version
-
-EXAMPLES
-  $ gh issue create
-  $ gh repo clone cli/cli
-  $ gh pr checkout 321
-
-LEARN MORE
-  Use `gh <command> <subcommand> --help` for more information about a command.
-  Read the manual at https://cli.github.com/manual
-  Learn about exit codes using `gh help exit-codes`
-  Learn about accessibility experiences using `gh help accessibility`
-
-## gh pr
-
-Work with GitHub pull requests.
-
-USAGE
-  gh pr <command> [flags]
-
-GENERAL COMMANDS
-  create:        Create a pull request
-  list:          List pull requests in a repository
-  status:        Show status of relevant pull requests
-
-TARGETED COMMANDS
-  checkout:      Check out a pull request in git
-  checks:        Show CI status for a single pull request
-  close:         Close a pull request
-  comment:       Add a comment to a pull request
-  diff:          View changes in a pull request
-  edit:          Edit a pull request
-  lock:          Lock pull request conversation
-  merge:         Merge a pull request
-  ready:         Mark a pull request as ready for review
-  reopen:        Reopen a pull request
-  review:        Add a review to a pull request
-  unlock:        Unlock pull request conversation
-  update-branch: Update a pull request branch
-  view:          View a pull request
-
-FLAGS
-  -R, --repo [HOST/]OWNER/REPO   Select another repository using the [HOST/]OWNER/REPO format
-
-INHERITED FLAGS
-  --help   Show help for command
-
-ARGUMENTS
-  A pull request can be supplied as argument in any of the following formats:
-  - by number, e.g. "123";
-  - by URL, e.g. "https://github.com/OWNER/REPO/pull/123"; or
-  - by the name of its head branch, e.g. "patch-1" or "OWNER:patch-1".
-
-EXAMPLES
-  $ gh pr checkout 353
-  $ gh pr create --fill
-  $ gh pr view --web
-
-LEARN MORE
-  Use `gh <command> <subcommand> --help` for more information about a command.
-  Read the manual at https://cli.github.com/manual
-  Learn about exit codes using `gh help exit-codes`
-  Learn about accessibility experiences using `gh help accessibility`
-
-## gh pr list
-
-List pull requests in a GitHub repository. By default, this only lists open PRs.
-
-The search query syntax is documented here:
-<https://docs.github.com/en/search-github/searching-on-github/searching-issues-and-pull-requests>
-
-For more information about output formatting flags, see `gh help formatting`.
-
-USAGE
-  gh pr list [flags]
-
-ALIASES
-  gh pr ls
-
-FLAGS
-      --app string        Filter by GitHub App author
-  -a, --assignee string   Filter by assignee
-  -A, --author string     Filter by author
-  -B, --base string       Filter by base branch
-  -d, --draft             Filter by draft state
-  -H, --head string       Filter by head branch ("<owner>:<branch>" syntax not supported)
-  -q, --jq expression     Filter JSON output using a jq expression
-      --json fields       Output JSON with the specified fields
-  -l, --label strings     Filter by label
-  -L, --limit int         Maximum number of items to fetch (default 30)
-  -S, --search query      Search pull requests with query
-  -s, --state string      Filter by state: {open|closed|merged|all} (default "open")
-  -t, --template string   Format JSON output using a Go template; see "gh help formatting"
-  -w, --web               List pull requests in the web browser
-
-INHERITED FLAGS
-      --help                     Show help for command
-  -R, --repo [HOST/]OWNER/REPO   Select another repository using the [HOST/]OWNER/REPO format
-
-JSON FIELDS
-  additions, assignees, author, autoMergeRequest, baseRefName, baseRefOid, body,
-  changedFiles, closed, closedAt, closingIssuesReferences, comments, commits,
-  createdAt, deletions, files, fullDatabaseId, headRefName, headRefOid,
-  headRepository, headRepositoryOwner, id, isCrossRepository, isDraft, labels,
-  latestReviews, maintainerCanModify, mergeCommit, mergeStateStatus, mergeable,
-  mergedAt, mergedBy, milestone, number, potentialMergeCommit, projectCards,
-  projectItems, reactionGroups, reviewDecision, reviewRequests, reviews, state,
-  statusCheckRollup, title, updatedAt, url
-
-EXAMPLES
-  # List PRs authored by you
-  $ gh pr list --author "@me"
-  
-  # List PRs with a specific head branch name
-  $ gh pr list --head "typo"
-  
-  # List only PRs with all of the given labels
-  $ gh pr list --label bug --label "priority 1"
-  
-  # Filter PRs using search syntax
-  $ gh pr list --search "status:success review:required"
-  
-  # Find a PR that introduced a given commit
-  $ gh pr list --search "<SHA>" --state merged
-
-LEARN MORE
-  Use `gh <command> <subcommand> --help` for more information about a command.
-  Read the manual at https://cli.github.com/manual
-  Learn about exit codes using `gh help exit-codes`
-  Learn about accessibility experiences using `gh help accessibility`
-
-## gh pr diff
-
-View changes in a pull request.
-
-Without an argument, the pull request that belongs to the current branch
-is selected.
-
-With `--web` flag, open the pull request diff in a web browser instead.
-
-
-USAGE
-  gh pr diff [<number> | <url> | <branch>] [flags]
-
-FLAGS
-      --color string   Use color in diff output: {always|never|auto} (default "auto")
-      --name-only      Display only names of changed files
-      --patch          Display diff in patch format
-  -w, --web            Open the pull request diff in the browser
-
-INHERITED FLAGS
-      --help                     Show help for command
-  -R, --repo [HOST/]OWNER/REPO   Select another repository using the [HOST/]OWNER/REPO format
-
-LEARN MORE
-  Use `gh <command> <subcommand> --help` for more information about a command.
-  Read the manual at https://cli.github.com/manual
-  Learn about exit codes using `gh help exit-codes`
-  Learn about accessibility experiences using `gh help accessibility`
-
-## gh pr merge
-
-Merge a pull request on GitHub.
-
-Without an argument, the pull request that belongs to the current branch
-is selected.
-
-When targeting a branch that requires a merge queue, no merge strategy is required.
-If required checks have not yet passed, auto-merge will be enabled.
-If required checks have passed, the pull request will be added to the merge queue.
-To bypass a merge queue and merge directly, pass the `--admin` flag.
-
-
-USAGE
-  gh pr merge [<number> | <url> | <branch>] [flags]
-
-FLAGS
-      --admin                   Use administrator privileges to merge a pull request that does not meet requirements
-  -A, --author-email text       Email text for merge commit author
-      --auto                    Automatically merge only after necessary requirements are met
-  -b, --body text               Body text for the merge commit
-  -F, --body-file file          Read body text from file (use "-" to read from standard input)
-  -d, --delete-branch           Delete the local and remote branch after merge
-      --disable-auto            Disable auto-merge for this pull request
-      --match-head-commit SHA   Commit SHA that the pull request head must match to allow merge
-  -m, --merge                   Merge the commits with the base branch
-  -r, --rebase                  Rebase the commits onto the base branch
-  -s, --squash                  Squash the commits into one commit and merge it into the base branch
-  -t, --subject text            Subject text for the merge commit
-
-INHERITED FLAGS
-      --help                     Show help for command
-  -R, --repo [HOST/]OWNER/REPO   Select another repository using the [HOST/]OWNER/REPO format
-
-LEARN MORE
-  Use `gh <command> <subcommand> --help` for more information about a command.
-  Read the manual at https://cli.github.com/manual
-  Learn about exit codes using `gh help exit-codes`
-  Learn about accessibility experiences using `gh help accessibility`
-
-## gh pr review 
-
-Add a review to a pull request.
-
-Without an argument, the pull request that belongs to the current branch is reviewed.
-
-
-USAGE
-  gh pr review [<number> | <url> | <branch>] [flags]
-
-FLAGS
-  -a, --approve           Approve pull request
-  -b, --body string       Specify the body of a review
-  -F, --body-file file    Read body text from file (use "-" to read from standard input)
-  -c, --comment           Comment on a pull request
-  -r, --request-changes   Request changes on a pull request
-
-INHERITED FLAGS
-      --help                     Show help for command
-  -R, --repo [HOST/]OWNER/REPO   Select another repository using the [HOST/]OWNER/REPO format
-
-EXAMPLES
-  # Approve the pull request of the current branch
-  $ gh pr review --approve
-  
-  # Leave a review comment for the current branch
-  $ gh pr review --comment -b "interesting"
-  
-  # Add a review for a specific pull request
-  $ gh pr review 123
-  
-  # Request changes on a specific pull request
-  $ gh pr review 123 -r -b "needs more ASCII art"
-
-LEARN MORE
-  Use `gh <command> <subcommand> --help` for more information about a command.
-  Read the manual at https://cli.github.com/manual
-  Learn about exit codes using `gh help exit-codes`
-  Learn about accessibility experiences using `gh help accessibility`
-
-## gh pr checkout
-
-Check out a pull request in git
-
-USAGE
-  gh pr checkout [<number> | <url> | <branch>] [flags]
-
-FLAGS
-  -b, --branch string        Local branch name to use (default [the name of the head branch])
-      --detach               Checkout PR with a detached HEAD
-  -f, --force                Reset the existing local branch to the latest state of the pull request
-      --recurse-submodules   Update all submodules after checkout
-
-INHERITED FLAGS
-      --help                     Show help for command
-  -R, --repo [HOST/]OWNER/REPO   Select another repository using the [HOST/]OWNER/REPO format
-
-EXAMPLES
-  # Interactively select a PR from the 10 most recent to check out
-  $ gh pr checkout
-  
-  # Checkout a specific PR
-  $ gh pr checkout 32
-  $ gh pr checkout https://github.com/OWNER/REPO/pull/32
-  $ gh pr checkout feature
-
-LEARN MORE
-  Use `gh <command> <subcommand> --help` for more information about a command.
-  Read the manual at https://cli.github.com/manual
-  Learn about exit codes using `gh help exit-codes`
-  Learn about accessibility experiences using `gh help accessibility`
-
-  ## gh pr close
-
-  Close a pull request
-
-USAGE
-  gh pr close {<number> | <url> | <branch>} [flags]
-
-FLAGS
-  -c, --comment string   Leave a closing comment
-  -d, --delete-branch    Delete the local and remote branch after close
-
-INHERITED FLAGS
-      --help                     Show help for command
-  -R, --repo [HOST/]OWNER/REPO   Select another repository using the [HOST/]OWNER/REPO format
-
-LEARN MORE
-  Use `gh <command> <subcommand> --help` for more information about a command.
-  Read the manual at https://cli.github.com/manual
-  Learn about exit codes using `gh help exit-codes`
-  Learn about accessibility experiences using `gh help accessibility`
-
-## gh pr comment
-
-Add a comment to a GitHub pull request.
-
-Without the body text supplied through flags, the command will interactively
-prompt for the comment text.
-
-
-USAGE
-  gh pr comment [<number> | <url> | <branch>] [flags]
-
-FLAGS
-  -b, --body text        The comment body text
-  -F, --body-file file   Read body text from file (use "-" to read from standard input)
-      --create-if-none   Create a new comment if no comments are found. Can be used only with --edit-last
-      --delete-last      Delete the last comment of the current user
-      --edit-last        Edit the last comment of the current user
-  -e, --editor           Skip prompts and open the text editor to write the body in
-  -w, --web              Open the web browser to write the comment
-      --yes              Skip the delete confirmation prompt when --delete-last is provided
-
-INHERITED FLAGS
-      --help                     Show help for command
-  -R, --repo [HOST/]OWNER/REPO   Select another repository using the [HOST/]OWNER/REPO format
-
-EXAMPLES
-  $ gh pr comment 13 --body "Hi from GitHub CLI"
-
-LEARN MORE
-  Use `gh <command> <subcommand> --help` for more information about a command.
-  Read the manual at https://cli.github.com/manual
-  Learn about exit codes using `gh help exit-codes`
-  Learn about accessibility experiences using `gh help accessibility`
-
-
-

.env.example

@@ -1,12 +1,4 @@
 PUBLIC_API_URL=https://api.roadmap.sh
 PUBLIC_AVATAR_BASE_URL=https://dodrc8eu8m09s.cloudfront.net/avatars
 PUBLIC_EDITOR_APP_URL=https://draw.roadmap.sh
-PUBLIC_COURSE_APP_URL=http://localhost:5173
-
-PUBLIC_STRIPE_INDIVIDUAL_MONTHLY_PRICE_ID=
-PUBLIC_STRIPE_INDIVIDUAL_YEARLY_PRICE_ID=
-
-PUBLIC_STRIPE_INDIVIDUAL_MONTHLY_PRICE_AMOUNT=10
-PUBLIC_STRIPE_INDIVIDUAL_YEARLY_PRICE_AMOUNT=100
-
-ROADMAP_API_KEY=
+PUBLIC_COURSE_APP_URL=http://localhost:5173

.github/ISSUE_TEMPLATE/05-project-contribution.yml

@@ -0,0 +1,35 @@
+name: "🙏 ​ ​Submit a Project Idea"
+description: Help us add project ideas to roadmaps.
+labels: [project contribution]
+assignees: []
+body:
+  - type: markdown
+    attributes:
+      value: |
+        Thanks for taking the time to submit a project idea! Please fill out the information below and we'll get back to you as soon as we can.
+  - type: input
+    id: roadmap-title
+    attributes:
+      label: What Roadmap is this project for?
+      placeholder: e.g. Backend Roadmap
+    validations:
+      required: true
+  - type: dropdown
+    id: project-difficulty
+    attributes:
+      label: Project Difficulty
+      options:
+        - Beginner
+        - Intermediate
+        - Advanced
+    validations:
+      required: true
+  - type: textarea
+    id: roadmap-description
+    attributes:
+      label: Add Project Details
+      description: Please write a detailed description of the project in 3rd person e.g. "You are required to build a..."
+      placeholder: |
+          e.g. You are required to build a RESTful API...
+    validations:
+      required: true

.github/workflows/cloudfront-api-cache.yml

@@ -2,7 +2,7 @@ name: Clears API Cloudfront Cache
 on:
   workflow_dispatch:
 jobs:
-  cloudfront_api_cache:
+  aws_costs:
     runs-on: ubuntu-latest
     steps:
       - name: Clear Cloudfront Caching

.github/workflows/cloudfront-fe-cache.yml

@@ -2,7 +2,7 @@ name: Clears Frontend Cloudfront Cache
 on:
   workflow_dispatch:
 jobs:
-  cloudfront_fe_cache:
+  aws_costs:
     runs-on: ubuntu-latest
     steps:
       - name: Clear Cloudfront Caching

.github/workflows/greetings.yml

@@ -0,0 +1,23 @@
+name: ❤️ Greetings
+
+on:
+  issues:
+    types: [opened]
+  pull_request_target:
+    branches: [master]
+    types: [opened]
+
+jobs:
+  greet:
+    name: Greet New Contributors
+    runs-on: ubuntu-latest
+    steps:
+      - uses: actions/first-interaction@v1
+        with:
+          repo-token: ${{ secrets.GITHUB_TOKEN }}
+          pr-message: |
+            Thank you for your first ever contribution to [roadmap.sh](https://roadmap.sh)! 🎉
+            
+            Please make sure to follow the [contribution guidelines](https://github.com/kamranahmedse/developer-roadmap/blob/master/contributing.md) when contributing to this project. Any PRs that don't follow the guidelines will be closed.
+
+            Thanks for choosing to contribute, and for helping make this project better! 🌟

.github/workflows/sync-content-to-repo.yml

@@ -1,66 +0,0 @@
-name: Sync Content to Repo
-
-on:
-  workflow_dispatch:
-    inputs:
-      roadmap_slug:
-        description: "The ID of the roadmap to sync"
-        required: true
-        default: "__default__"
-
-jobs:
-  sync-content:
-    runs-on: ubuntu-latest
-    steps:
-      - uses: actions/checkout@v4
-
-      - name: Setup pnpm@v9
-        uses: pnpm/action-setup@v4
-        with:
-          version: 9
-          run_install: false
-
-      - name: Setup Node.js Version 20 (LTS)
-        uses: actions/setup-node@v4
-        with:
-          node-version: 20
-          cache: 'pnpm'
-
-      - name: Install Dependencies and Sync Content
-        run: |
-          echo "Installing Dependencies"
-          pnpm install
-          echo "Syncing Content to Repo"
-          npm run sync:content-to-repo -- --roadmap-slug=${{ inputs.roadmap_slug }} --secret=${{ secrets.GH_SYNC_SECRET }}
-
-      - name: Check for changes
-        id: verify-changed-files
-        run: |
-          if [ -n "$(git status --porcelain)" ]; then
-            echo "changed=true" >> $GITHUB_OUTPUT
-          else
-            echo "changed=false" >> $GITHUB_OUTPUT
-          fi
-      
-      - name: Create PR
-        if: steps.verify-changed-files.outputs.changed == 'true'
-        uses: peter-evans/create-pull-request@v7
-        with:
-          delete-branch: false
-          branch: "chore/sync-content-to-repo-${{ inputs.roadmap_slug }}"
-          base: "master"
-          labels: |
-            automated pr
-          reviewers: jcanalesluna,kamranahmedse
-          commit-message: "chore: sync content to repo"
-          title: "chore: sync content to repository - ${{ inputs.roadmap_slug }}"
-          body: |
-            ## Sync Content to Repo
-            
-            > [!IMPORTANT]
-            > This PR Syncs the Content to the Repo for the Roadmap: ${{ inputs.roadmap_slug }}
-            >
-            > Commit: ${{ github.sha }}
-            > Workflow Path: ${{ github.workflow_ref }}
-
-            **Please Review the Changes and Merge the PR if everything is fine.** 

.github/workflows/sync-repo-to-database.yml

@@ -1,67 +0,0 @@
-name: Sync on Roadmap Changes
-
-on:
-  push:
-    branches:
-      - master
-    paths:
-      - 'src/data/roadmaps/**'
-
-jobs:
-  sync-on-changes:
-    runs-on: ubuntu-latest
-    if: github.actor != 'github-actions[bot]' && github.actor != 'dependabot[bot]'
-    steps:
-      - uses: actions/checkout@v4
-        with:
-          fetch-depth: 2  # Fetch previous commit to compare changes
-
-      - name: Setup pnpm@v9
-        uses: pnpm/action-setup@v4
-        with:
-          version: 9
-          run_install: false
-
-      - name: Setup Node.js Version 20 (LTS)
-        uses: actions/setup-node@v4
-        with:
-          node-version: 20
-          cache: 'pnpm'
-
-      - name: Get changed files
-        id: changed-files
-        run: |
-          echo "Getting changed files in /src/data/roadmaps/"
-          
-          # Get changed files between HEAD and previous commit
-          CHANGED_FILES=$(git diff --name-only HEAD~1 HEAD -- src/data/roadmaps/)
-          
-          if [ -z "$CHANGED_FILES" ]; then
-            echo "No changes found in roadmaps directory"
-            echo "has_changes=false" >> $GITHUB_OUTPUT
-            exit 0
-          fi
-          
-          echo "Changed files:"
-          echo "$CHANGED_FILES"
-          
-          # Convert to space-separated list for the script
-          CHANGED_FILES_LIST=$(echo "$CHANGED_FILES" | tr '\n' ',')
-          
-          echo "has_changes=true" >> $GITHUB_OUTPUT
-          echo "changed_files=$CHANGED_FILES_LIST" >> $GITHUB_OUTPUT
-
-      - name: Install Dependencies
-        if: steps.changed-files.outputs.has_changes == 'true'
-        run: |
-          echo "Installing Dependencies"
-          pnpm install
-
-      - name: Run sync script with changed files
-        if: steps.changed-files.outputs.has_changes == 'true'
-        run: |
-          echo "Running sync script for changed roadmap files"
-          echo "Changed files: ${{ steps.changed-files.outputs.changed_files }}"
-          
-          # Run your script with the changed file paths
-          npm run sync:repo-to-database -- --files="${{ steps.changed-files.outputs.changed_files }}" --secret=${{ secrets.GH_SYNC_SECRET }}

.gitignore

@@ -28,6 +28,9 @@ pnpm-debug.log*
 /playwright-report/
 /playwright/.cache/
 tests-examples
-*.csveditor/
+*.csv
 
-packages/editor
+/editor/*
+!/editor/readonly-editor.tsx
+!/editor/renderer/renderer.ts
+!/editor/renderer/index.tsx

.vscode/settings.json

@@ -2,13 +2,5 @@
   "prettier.documentSelectors": ["**/*.astro"],
   "[astro]": {
     "editor.defaultFormatter": "esbenp.prettier-vscode"
-  },
-  "tailwindCSS.experimental.classRegex": [
-    ["\\b\\w+[cC]lassName\\s*=\\s*[\"']([^\"']*)[\"']"],
-    ["\\b\\w+[cC]lassName\\s*=\\s*`([^`]*)`"],
-    ["[\\w]+[cC]lassName[\"']?\\s*:\\s*[\"']([^\"']*)[\"']"],
-    ["[\\w]+[cC]lassName[\"']?\\s*:\\s*`([^`]*)`"],
-    ["cva\\(((?:[^()]|\\([^()]*\\))*)\\)", "[\"'`]([^\"'`]*).*?[\"'`]"],
-    ["cx\\(((?:[^()]|\\([^()]*\\))*)\\)", "(?:'|\"|`)([^']*)(?:'|\"|`)"]
-  ]
+  }
 }

astro.config.mjs

@@ -1,31 +1,16 @@
 // https://astro.build/config
 import sitemap from '@astrojs/sitemap';
+import tailwind from '@astrojs/tailwind';
 import node from '@astrojs/node';
 import { defineConfig } from 'astro/config';
 import rehypeExternalLinks from 'rehype-external-links';
 import { serializeSitemap, shouldIndexPage } from './sitemap.mjs';
-import tailwindcss from '@tailwindcss/vite';
 
 import react from '@astrojs/react';
 
 // https://astro.build/config
 export default defineConfig({
   site: 'https://roadmap.sh/',
-  redirects: {
-    '/devops/devops-engineer': {
-      status: 301,
-      destination: '/devops',
-    },
-    '/ai-tutor': {
-      status: 301,
-      destination: '/ai',
-    },
-  },
-  vite: {
-    server: {
-      allowedHosts: ['roadmap.sh', 'port3k.kamranahmed.info'],
-    },
-  },
   markdown: {
     shikiConfig: {
       theme: 'dracula',
@@ -55,22 +40,21 @@ export default defineConfig({
       ],
     ],
   },
-  output: 'server',
+  output: 'hybrid',
   adapter: node({
     mode: 'standalone',
   }),
   trailingSlash: 'never',
   integrations: [
+    tailwind({
+      config: {
+        applyBaseStyles: false,
+      },
+    }),
     sitemap({
       filter: shouldIndexPage,
       serialize: serializeSitemap,
     }),
     react(),
   ],
-  vite: {
-    plugins: [tailwindcss()],
-    ssr: {
-      noExternal: [/^@roadmapsh\/editor.*$/],
-    },
-  },
 });

contributing.md

@@ -6,10 +6,8 @@ First of all, thank you for considering to contribute. Please look at the detail
 - [Existing Roadmaps](#existing-roadmaps)
 - [Adding Projects](#adding-projects)
 - [Adding Content](#adding-content)
-  - [How To Structure Content](#how-to-structure-content)
 - [Guidelines](#guidelines)
 - [Good vs. Not So Good Contributions](#good-vs-not-so-good-contributions)
-- [Local Development](#local-development)
 
 ## New Roadmaps
 
@@ -55,7 +53,6 @@ Find [the content directory inside the relevant roadmap](https://github.com/kamr
 
 - Content must be in English.
 - Maximum of 8 links per topic.
-- **No GeeksforGeeks links** — Links to geeksforgeeks.org are not accepted.
 - Follow the below style guide for content.
 
 Please note that we are intentionally keeping the content under the topic popup concise. You MUST always aim to explain the topic simply in a **single paragraph** or so and provide external resources where users can learn more about the topic.
@@ -82,7 +79,6 @@ Visit the following resources to learn more:
 - `@course@`
 - `@podcast@`
 - `@video@`
-- `@book@`
 
 It's important to add a valid type, this will help us categorize the content and display it properly on the roadmap. The order of the links based on type is same as above.
 
@@ -129,22 +125,6 @@ It's important to add a valid type, this will help us categorize the content and
 - PR's that don't follow our style guide, have no description, and a default title.
 - Links to your own blog articles.
 
-## Local Development
-
-For local development, you can use the following commands:
-
-```bash
-git clone git@github.com:kamranahmedse/developer-roadmap.git --depth 1
-cd developer-roadmap
-pnpm add @roadmapsh/editor@npm:@roadmapsh/dummy-editor -w
-pnpm install
-```
-Run the development server with:
-
-```bash
-pnpm dev
-```
-
 ***
 
 Have a look at the [License](./license) file.

editor/readonly-editor.tsx

@@ -0,0 +1,14 @@
+export function ReadonlyEditor(props: any) {
+  return (
+    <div className="fixed bottom-0 left-0 right-0 top-0 z-[9999] border bg-white p-5 text-black">
+      <h2 className="mb-2 text-xl font-semibold">Private Component</h2>
+      <p className="mb-4">
+        Renderer is a private component. If you are a collaborator and have
+        access to it. Run the following command:
+      </p>
+      <code className="mt-5 rounded-md bg-gray-800 p-2 text-white">
+        npm run generate-renderer
+      </code>
+    </div>
+  );
+}

editor/renderer/index.tsx

@@ -0,0 +1,14 @@
+export function Renderer(props: any) {
+  return (
+    <div className="fixed bottom-0 left-0 right-0 top-0 z-[9999] border bg-white p-5 text-black">
+      <h2 className="mb-2 text-xl font-semibold">Private Component</h2>
+      <p className="mb-4">
+        Renderer is a private component. If you are a collaborator and have
+        access to it. Run the following command:
+      </p>
+      <code className="mt-5 rounded-md bg-gray-800 p-2 text-white">
+        npm run generate-renderer
+      </code>
+    </div>
+  );
+}

editor/renderer/renderer.ts

@@ -0,0 +1,5 @@
+export function renderFlowJSON(data: any, options?: any) {
+  console.warn("renderFlowJSON is not implemented");
+  console.warn("run the following command to generate the renderer:");
+  console.warn("> npm run generate-renderer");
+}

package.json

@@ -16,125 +16,91 @@
     "roadmap-links": "node scripts/roadmap-links.cjs",
     "roadmap-dirs": "node scripts/roadmap-dirs.cjs",
     "roadmap-assets": "tsx scripts/editor-roadmap-assets.ts",
-    "refresh-assets": "tsx scripts/refresh-assets.ts",
     "editor-roadmap-dirs": "tsx scripts/editor-roadmap-dirs.ts",
     "editor-roadmap-content": "tsx scripts/editor-roadmap-content.ts",
     "roadmap-content": "node scripts/roadmap-content.cjs",
     "generate-renderer": "sh scripts/generate-renderer.sh",
-    "generate-renderer-dummy": "sh scripts/generate-renderer-dummy.sh",
     "best-practice-dirs": "node scripts/best-practice-dirs.cjs",
     "best-practice-content": "node scripts/best-practice-content.cjs",
     "generate:og": "node ./scripts/generate-og-images.mjs",
     "warm:urls": "sh ./scripts/warm-urls.sh https://roadmap.sh/sitemap-0.xml",
     "compress:images": "tsx ./scripts/compress-images.ts",
     "generate:roadmap-content-json": "tsx ./scripts/editor-roadmap-content-json.ts",
-    "migrate:editor-roadmaps": "tsx ./scripts/migrate-editor-roadmap.ts",
-    "sync:content-to-repo": "tsx ./scripts/sync-content-to-repo.ts",
-    "sync:repo-to-database": "tsx ./scripts/sync-repo-to-database.ts",
-    "migrate:content-repo-to-database": "tsx ./scripts/migrate-content-repo-to-database.ts",
-    "official:roadmap-assets": "tsx ./scripts/official-roadmap-assets.ts",
     "test:e2e": "playwright test"
   },
   "dependencies": {
-    "@ai-sdk/react": "2.0.0-beta.34",
-    "@astrojs/node": "^9.2.1",
-    "@astrojs/react": "^4.2.7",
-    "@astrojs/sitemap": "^3.4.0",
-    "@fingerprintjs/fingerprintjs": "^4.6.2",
+    "@astrojs/node": "^8.3.4",
+    "@astrojs/react": "^3.6.2",
+    "@astrojs/sitemap": "^3.2.0",
+    "@astrojs/tailwind": "^5.1.2",
+    "@fingerprintjs/fingerprintjs": "^4.5.0",
     "@microsoft/clarity": "^1.0.0",
-    "@nanostores/react": "^1.0.0",
+    "@nanostores/react": "^0.8.0",
     "@napi-rs/image": "^1.9.2",
-    "@radix-ui/react-dropdown-menu": "^2.1.15",
-    "@radix-ui/react-popover": "^1.1.14",
     "@resvg/resvg-js": "^2.6.2",
-    "@roadmapsh/editor": "workspace:*",
-    "@shikijs/transformers": "^3.9.2",
-    "@tailwindcss/vite": "^4.1.7",
-    "@tanstack/react-query": "^5.76.1",
-    "@tiptap/core": "^2.12.0",
-    "@tiptap/extension-document": "^2.12.0",
-    "@tiptap/extension-paragraph": "^2.12.0",
-    "@tiptap/extension-placeholder": "^2.12.0",
-    "@tiptap/extension-text": "^2.12.0",
-    "@tiptap/pm": "^2.12.0",
-    "@tiptap/react": "^2.12.0",
-    "@tiptap/suggestion": "^2.12.0",
-    "@types/react": "^19.1.4",
-    "@types/react-dom": "^19.1.5",
-    "astro": "^5.7.13",
+    "@tanstack/react-query": "^5.59.16",
+    "@types/react": "^18.3.11",
+    "@types/react-dom": "^18.3.1",
+    "astro": "^4.16.1",
     "clsx": "^2.1.1",
     "dayjs": "^1.11.13",
     "dom-to-image": "^2.6.0",
     "dracula-prism": "^2.1.16",
     "gray-matter": "^4.0.3",
     "htm": "^3.1.1",
-    "image-size": "^2.0.2",
-    "jose": "^6.0.11",
+    "image-size": "^1.1.1",
+    "jose": "^5.9.4",
     "js-cookie": "^3.0.5",
-    "katex": "^0.16.22",
-    "lucide-react": "^0.511.0",
-    "luxon": "^3.6.1",
-    "markdown-it-async": "^2.2.0",
-    "nanoid": "^5.1.5",
-    "nanostores": "^1.0.1",
-    "node-html-parser": "^7.0.1",
-    "npm-check-updates": "^18.0.1",
-    "playwright": "^1.52.0",
-    "prismjs": "^1.30.0",
-    "radix-ui": "^1.4.2",
-    "react": "^19.1.0",
-    "react-calendar-heatmap": "^1.10.0",
-    "react-confetti": "^6.4.0",
-    "react-dom": "^19.1.0",
-    "react-dropzone": "^14.3.8",
-    "react-markdown": "^10.1.0",
-    "react-resizable-panels": "^3.0.2",
-    "react-textarea-autosize": "^8.5.9",
-    "react-tooltip": "^5.28.1",
+    "lucide-react": "^0.452.0",
+    "luxon": "^3.5.0",
+    "nanoid": "^5.0.7",
+    "nanostores": "^0.11.3",
+    "node-html-parser": "^6.1.13",
+    "npm-check-updates": "^17.1.3",
+    "playwright": "^1.48.0",
+    "prismjs": "^1.29.0",
+    "react": "^18.3.1",
+    "react-calendar-heatmap": "^1.9.0",
+    "react-confetti": "^6.1.0",
+    "react-dom": "^18.3.1",
+    "react-tooltip": "^5.28.0",
+    "reactflow": "^11.11.4",
     "rehype-external-links": "^3.0.0",
-    "rehype-katex": "^7.0.1",
-    "remark-gfm": "^4.0.1",
-    "remark-math": "^6.0.0",
     "remark-parse": "^11.0.0",
-    "roadmap-renderer": "^1.0.7",
-    "sanitize-html": "^2.17.0",
-    "satori": "^0.13.1",
+    "roadmap-renderer": "^1.0.6",
+    "sanitize-html": "^2.13.1",
+    "satori": "^0.11.2",
     "satori-html": "^0.3.2",
-    "sharp": "^0.34.1",
-    "shiki": "^3.4.2",
+    "sharp": "^0.33.5",
     "slugify": "^1.6.6",
-    "tailwind-merge": "^3.3.0",
-    "tailwindcss": "^4.1.7",
-    "tippy.js": "^6.3.7",
+    "tailwind-merge": "^2.5.3",
+    "tailwindcss": "^3.4.13",
     "tiptap-markdown": "^0.8.10",
     "turndown": "^7.2.0",
     "unified": "^11.0.5",
-    "zod": "^4.0.17",
-    "zustand": "^5.0.4"
+    "zustand": "^4.5.5"
   },
   "devDependencies": {
-    "@ai-sdk/google": "^1.2.18",
-    "@playwright/test": "^1.52.0",
-    "@tailwindcss/typography": "^0.5.16",
+    "@ai-sdk/google": "^1.1.19",
+    "@playwright/test": "^1.48.0",
+    "@tailwindcss/typography": "^0.5.15",
     "@types/dom-to-image": "^2.6.7",
     "@types/js-cookie": "^3.0.6",
-    "@types/luxon": "^3.6.2",
-    "@types/markdown-it": "^14.1.2",
-    "@types/prismjs": "^1.26.5",
-    "@types/react-calendar-heatmap": "^1.9.0",
+    "@types/luxon": "^3.4.2",
+    "@types/prismjs": "^1.26.4",
+    "@types/react-calendar-heatmap": "^1.6.7",
     "@types/react-slick": "^0.23.13",
-    "@types/sanitize-html": "^2.16.0",
+    "@types/sanitize-html": "^2.13.0",
     "@types/turndown": "^5.0.5",
-    "ai": "5.0.0-beta.34",
-    "csv-parser": "^3.2.0",
-    "gh-pages": "^6.3.0",
+    "ai": "^4.1.51",
+    "csv-parser": "^3.0.0",
+    "gh-pages": "^6.2.0",
     "js-yaml": "^4.1.0",
     "markdown-it": "^14.1.0",
-    "openai": "^4.100.0",
-    "prettier": "^3.5.3",
+    "openai": "^4.67.3",
+    "prettier": "^3.3.3",
     "prettier-plugin-astro": "^0.14.1",
-    "prettier-plugin-tailwindcss": "^0.6.11",
-    "tailwind-scrollbar": "^4.0.2",
-    "tsx": "^4.19.4"
+    "prettier-plugin-tailwindcss": "^0.6.8",
+    "tsx": "^4.19.1"
   }
 }

pnpm-workspace.yaml

@@ -1,2 +0,0 @@
-packages:
-  - packages/*