Screenshots

Python codes/playground	Sql codes/playground

Tech Stack

1. Sveltekit
2. Supabase
3. Tailwindcss
4. Flowbite
5. Shikijs
6. Markdown-it
7. Codemirror
8. Sql.js
9. Pyscript

Generate supabase types

supabase gen types typescript --project-id [project-id] > ./src/lib/supabase/schema.ts

Routes

Public

/ -> topic, codes, new topic
/[subject] -> topic of specific subject, perpage=10
/codes/[lang] -> codes of specific language, perpage=10
/search -> search results in topic
/login -> log in page
/codes/playground/python -> python playground
/codes/playground/sql -> sql playground

Loggedin

/dashboard -> topics created by loggedin user
/dashboard/add -> add topic
/dashboard/edit-[id] -> edit topic of the given id

/dashboard/code -> codes created by loggedin user
/dashboard/code/add -> add code
/dashboard/code/edit-[id] -> edit code of the given id

/dashboard/reset-password -> reset password of the current user

Api(cached)

/api/codes -> get codes, perpage=10
/api/groupedTopic -> get new topics grouped by subject name, only topics added today
/api/search -> get search results, limit results 5
/api/subjects -> get topics, perpage=10