-
-
-
- - {#if $activeCategory === 'Blog'} - Engineering Blog - {:else if $activeCategory === 'Project'} - Work Projects - {:else if $activeCategory === 'Digital Garden'} - 🌱 Digital Garden - {:else if $activeTag} - {$activeTag} - {:else} - All Work - {/if} - ({$filteredPosts.length}) -
- {#if hasFilters} - - {/if} -
-
-
-
- {#each Object.keys($postsByYear).reverse() as year}
-
- {#each globalCategories as { name, count }}
-
-
- {/each}
-
-
-
-
- {#if globalTags.length > 0}
-
-
-
- {/if}
-
-
-
-
- {$activeTag || 'Tags'}
-
-
-
- {globalTags[globalTags.findIndex((t) => t.name === $activeTag)]?.count ||
- globalTags.length}
-
- - {year} -
-
- {#each $postsByYear[year] as post}
-
+ {#each availableRoles as role}
+
+ {/each}
+
+```
+
+## Security Considerations
+
+1. **Role Security**:
+- Roles stored in database and JWT
+- Server-side validation for all role changes
+- Type-safe role handling prevents errors
+
+2. **JWT Security**:
+- Roles included in signed tokens
+- Cannot be tampered with
+- Validated on server
+
+## Environment Setup
+
+Required environment variables:
+```env
+AUTH_SECRET=your-secret-key
+GOOGLE_ID=your-google-client-id
+GOOGLE_SECRET=your-google-client-secret
+RESEND_API_KEY=your-resend-api-key
+DATABASE_URL=your-postgres-connection-string
+```
+
+## Conclusion
+
+This authentication system provides a secure and efficient solution with:
+- Simplified role management (single role per user)
+- Type-safe role handling
+- Efficient JWT-based session management
+- Clear separation of client and server concerns
+- Maintainable and scalable design
diff --git a/top-sveltekit/pg-auth-electricsql/README.md b/top-sveltekit/pg-auth-electricsql/README.md
new file mode 100644
index 0000000..e30302f
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/README.md
@@ -0,0 +1,141 @@
+# Ctwhome top-sveltekit
+Unified full-stack with SvelteKit (Svelte 5), TailwindCSS, DaisyUI, AuthJS, ElectricSQL Postgres, and more.\
+by [ctwhome](https://ctwhome.com)
+
+## Goal of the template
+1. **Local-first architecture**: Data lives locally and syncs with the database seamlessly.
+
+2. **Simplicity in code**: Update Svelte stores locally and let syncing happen in the background.
+
+3. **Future scalability**: Add real-time sync, offline-first capabilities, and avoid duplicating effort with local storage or API requests.
+
+4. **Role-Based Access Control**: Server-side authorization with built-in role management.
+
+
+## Installation and running locally
+```bash
+bunx degit ctwhome/top-sveltekit
+```
+
+```bash
+bunx degit ctwhome/top-sveltekit newName --mode=git # --mode-git if cloning a private repo
+```
+
+Libraries to install for auth:
+```bash
+bun add pg node-pg-migrate dotenv @auth/sveltekit @auth/pg-adapter
+```
+
+## Database Migrations
+The project uses node-pg-migrate with a simplified three-digit numbering format (001, 002, etc.).
+
+Creating a new migration:
+```bash
+bun migrate create my_migration_name
+```
+This will create a new migration file like `migrations/002_my_migration_name.sql`
+
+Running migrations:
+```bash
+# Development
+bun migrate up
+
+# Production
+bun migrate:production
+```
+
+## Setup Steps:
+1. Install the dependencies with `bun install`
+2. Generate the google OAUTH credentials for auth.js
+3. 
+4. Copy the .env.local.example file to .env.local
+5. Fill in the .env.local file with your own values
+6. Copy the .env.example file to .env
+7. Run `npx auth secret` to generate a secret key for the auth.js adapter
+8. Run migrations with `bun migrate up`. This will:
+ - Create necessary tables including users, roles, and user_roles
+ - Set up authentication tables for auth.js
+ - Create default roles (admin and user)
+ - Create two example users: alice (admin) and bob (user)
+
+## Authentication & Authorization
+
+The template uses Auth.js with PostgreSQL adapter for session management and a server-side gatekeeper for Role-Based Access Control (RBAC). Here's how it works:
+
+### Roles
+- By default, any authenticated user is treated as having the 'user' role
+- Additional roles (like 'admin') can be explicitly assigned through the `roles` and `user_roles` tables
+- Users can have multiple explicit roles
+- Users without any explicit roles are automatically treated as regular users
+
+### Protecting Routes
+You can protect routes based on roles in two ways:
+
+1. Using the protectRoute middleware directly:
+```typescript
+// In your +page.server.ts or +server.ts
+import { protectRoute } from '$lib/server/gatekeeper';
+
+// For admin-only routes
+export const handle = sequence(handleAuth, protectRoute('admin'));
+
+// For authenticated users (no specific role required)
+export const handle = sequence(handleAuth, protectRoute('user'));
+```
+
+2. Using the provided example for route-based protection:
+```typescript
+// In hooks.server.ts
+export const protectAdminRoutes: Handle = async ({ event, resolve }) => {
+ if (event.url.pathname.startsWith('/admin')) {
+ return protectRoute('admin')({ event, resolve });
+ }
+ return resolve(event);
+};
+
+export const handle = sequence(handleAuth, protectRoute(), protectAdminRoutes);
+```
+
+### Accessing User Roles
+User roles are automatically added to the session and can be accessed in your routes and components:
+
+```typescript
+// In your +page.svelte
+let { session } = await parent();
+$: userRoles = session?.user?.roles || ['user']; // Defaults to ['user'] if no explicit roles
+
+// Check if user has admin role
+$: isAdmin = userRoles.includes('admin');
+```
+
+## Development
+
+Run locally:
+```bash
+bun dev
+```
+
+## Updating fork
+1. Add remote from the original repository in your forked repository:
+```bash
+git remote add upstream git://github.com/ctwhome/top-sveltekit.git
+git fetch upstream
+```
+
+2. Updating your fork from the original repo to keep up with their changes:
+```bash
+git pull upstream main
+```
+
+Start the development server on [http://localhost:5173](http://localhost:5173)
+
+```bash
+bun dev
+```
+
+## Production
+
+Build the application for production:
+
+```bash
+bun build
diff --git a/top-sveltekit/pg-auth-electricsql/bun.lockb b/top-sveltekit/pg-auth-electricsql/bun.lockb
new file mode 100755
index 0000000..6ed1aa6
Binary files /dev/null and b/top-sveltekit/pg-auth-electricsql/bun.lockb differ
diff --git a/top-sveltekit/pg-auth-electricsql/example .env b/top-sveltekit/pg-auth-electricsql/example .env
new file mode 100644
index 0000000..daec1f4
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/example .env
@@ -0,0 +1,38 @@
+# TO ENABLE ROW LEVEL SECURITY IT IS IMPORTANT TO CREATE THE USER ROLE THAT WILL BE ACCESSED LATER IN THE CONNECTION
+
+# ```
+# CREATE USER top-sveltekit WITH PASSWORD 'top-sveltekit';
+# GRANT SELECT, INSERT, UPDATE, DELETE ON chats TO top-sveltekit;
+# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO top-sveltekit;
+# ```
+
+
+
+AUTH_GOOGLE_ID=10...
+AUTH_GOOGLE_SECRET=GO...
+
+# Production database
+# DATABASE_URL_PROD=postgres://
+
+# Dev database pg-node
+DATABASE_URL=postgres://
+
+
+# DATABASE CONNECTIONS FOR AUTH.JS ADAPTER run with `npx auth secret`
+AUTH_SECRET= # Added by `npx auth`. Read more: https://cli.authjs.dev
+
+DB_HOST=
+DB_PORT=
+DB_USER=
+DB_NAME=
+DB_PASSWORD=
+DB_SSL=false
+MAX_CLIENTS=20
+IDLE_TIMEOUT_MILLIS=30000
+CONNECTION_TIMEOUT_MILLIS=2000
+
+
+
+# Resend API key
+AUTH_RESEND_KEY = re_...
+
diff --git a/top-sveltekit/pg-auth-electricsql/example .env.local b/top-sveltekit/pg-auth-electricsql/example .env.local
new file mode 100644
index 0000000..504a654
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/example .env.local
@@ -0,0 +1,23 @@
+# TO ENABLE ROW LEVEL SECURITY IT IS IMPORTANT TO CREATE THE USER ROLE THAT WILL BE ACCESSED LATER IN THE CONNECTION
+
+# ```
+# CREATE USER top-sveltekit WITH PASSWORD 'top-sveltekit';
+# GRANT SELECT, INSERT, UPDATE, DELETE ON chats TO top-sveltekit;
+# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO top-sveltekit;
+# ```
+
+
+
+
+# Connection with the local database running on the local machine
+# Dev database pg-node
+
+PUBLIC_LOCALHOST=true
+
+DATABASE_URL=postgres://postgres:postgres@localhost:5432/topsveltekit
+
+DB_HOST=localhost
+DB_PORT=5432
+DB_USER=postgres
+DB_PASSWORD=postgres
+DB_NAME=topsveltekit
diff --git a/top-sveltekit/pg-auth-electricsql/mdsvex.config.js b/top-sveltekit/pg-auth-electricsql/mdsvex.config.js
new file mode 100644
index 0000000..c328681
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/mdsvex.config.js
@@ -0,0 +1,85 @@
+import { visit } from 'unist-util-visit'
+
+import autolinkHeadings from 'rehype-autolink-headings'
+import slugPlugin from 'rehype-slug'
+
+import relativeImages from 'mdsvex-relative-images'
+// import remarkHeadings from '@vcarl/remark-headings'
+import remarkExternalLinks from 'remark-external-links';
+import readingTime from 'remark-reading-time';
+
+// import remarkToc from 'remark-toc'
+
+
+export default {
+ extensions: ['.svx', '.md'],
+ smartypants: {
+ dashes: 'oldschool'
+ },
+ layout: {
+ _: "/src/lib/markdown-layouts/default.svelte", // Default layout for markdown files
+ blog: "/src/lib/markdown-layouts/blog.svelte",
+ project: "/src/lib/markdown-layouts/project.svelte",
+ },
+ remarkPlugins: [
+ videos,
+ relativeImages,
+ // remarkToc,
+ // headings,
+ // adds a `readingTime` frontmatter attribute
+ readingTime,
+ // external links open in a new tab
+ [remarkExternalLinks, { target: '_blank', rel: 'noopener' }],
+ ],
+ rehypePlugins: [
+ slugPlugin,
+ [
+ autolinkHeadings, { behavior: 'wrap' }
+ ]
+ ]
+}
+
+/**
+ * Adds support to video files in markdown image links
+ */
+function videos() {
+ const extensions = ['mp4', 'webm']
+ return function transformer(tree) {
+ visit(tree, 'image', (node) => {
+ if (extensions.some((ext) => node.url.endsWith(ext))) {
+ node.type = 'html'
+ node.value = `
+
+ `
+ }
+ })
+ }
+}
+
+/**
+ * Parses headings and includes the result in metadata
+ */
+// function headings() {
+// return function transformer(tree, vfile) {
+// // run remark-headings plugin
+// remarkHeadings()(tree, vfile)
+
+// // include the headings data in mdsvex frontmatter
+// vfile.data.fm ??= {}
+// vfile.data.fm.headings = vfile.data.headings.map((heading) => ({
+// ...heading,
+// // slugify heading.value
+// id: heading.value
+// .toLowerCase()
+// .replace(/\s/g, '-')
+// .replace(/[^a-z0-9-]/g, '')
+// }))
+// }
+// }
diff --git a/top-sveltekit/pg-auth-electricsql/migrations/000_template.sql b/top-sveltekit/pg-auth-electricsql/migrations/000_template.sql
new file mode 100644
index 0000000..97021a8
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/migrations/000_template.sql
@@ -0,0 +1,4 @@
+-- Up Migration
+
+
+-- Down Migration
\ No newline at end of file
diff --git a/top-sveltekit/pg-auth-electricsql/migrations/001_init.sql b/top-sveltekit/pg-auth-electricsql/migrations/001_init.sql
new file mode 100644
index 0000000..0cac7b4
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/migrations/001_init.sql
@@ -0,0 +1,80 @@
+-- Up Migration
+
+-- Create auth tables
+CREATE TABLE users (
+ id SERIAL PRIMARY KEY,
+ name VARCHAR(255),
+ email VARCHAR(255) UNIQUE,
+ password VARCHAR(255),
+ "emailVerified" TIMESTAMPTZ,
+ image TEXT,
+ role VARCHAR(50)
+);
+
+CREATE TABLE verification_token (
+ identifier TEXT NOT NULL,
+ expires TIMESTAMPTZ NOT NULL,
+ token TEXT NOT NULL,
+ PRIMARY KEY (identifier, token)
+);
+
+CREATE TABLE accounts (
+ id SERIAL PRIMARY KEY,
+ "userId" INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+ type VARCHAR(255) NOT NULL,
+ provider VARCHAR(255) NOT NULL,
+ "providerAccountId" VARCHAR(255) NOT NULL,
+ refresh_token TEXT,
+ access_token TEXT,
+ expires_at BIGINT,
+ id_token TEXT,
+ scope TEXT,
+ session_state TEXT,
+ token_type TEXT,
+ UNIQUE("provider", "providerAccountId")
+);
+
+-- Insert sample admin user (password: password)
+INSERT INTO users (name, email, password, "emailVerified", image) VALUES
+('Alice Doe', 'alice@ctwhome.com', '$2a$12$qZNxIFh/Yayqshdz.3ZH2Oy2uORW/MqDS9NlfkIZsm6xnK5ZtCyJG', '2023-10-10', 'https://img.daisyui.com/images/stock/photo-1534528741775-53994a69daeb.webp'),
+('Bob Sponge', 'bob@ctwhome.com', '$2a$12$qZNxIFh/Yayqshdz.3ZH2Oy2uORW/MqDS9NlfkIZsm6xnK5ZtCyJG', '2023-10-10', '/images/diamond.jpg');
+
+
+-- Assign admin role
+UPDATE users
+SET role = 'admin'
+WHERE email = 'alice@ctwhome.com';
+
+-- Auto-assign admin role to specific Google user
+CREATE OR REPLACE FUNCTION assign_admin_role()
+RETURNS TRIGGER AS $$
+BEGIN
+ RAISE NOTICE 'Trigger function called for email: %', NEW.email;
+
+ IF NEW.email = 'ctw@ctwhome.com' THEN
+ RAISE NOTICE 'Setting admin role for ctw@ctwhome.com';
+ NEW.role = 'admin'; -- Using = instead of :=
+ ELSE
+ RAISE NOTICE 'Setting default user role';
+ NEW.role = COALESCE(NEW.role, 'user'); -- Only set user if role is null
+ END IF;
+
+ RAISE NOTICE 'Final role value: %', NEW.role;
+ RETURN NEW;
+END;
+$$ LANGUAGE plpgsql;
+
+CREATE TRIGGER auto_assign_admin_role
+BEFORE INSERT ON users
+FOR EACH ROW
+EXECUTE FUNCTION assign_admin_role();
+
+-- Create indexes
+CREATE INDEX users_email_idx ON users (email);
+CREATE INDEX accounts_user_id_idx ON accounts ("userId");
+CREATE INDEX accounts_provider_id_idx ON accounts ("providerAccountId");
+
+-- Down Migration
+DROP TABLE accounts;
+DROP TABLE users;
+DROP TABLE verification_token;
diff --git a/top-sveltekit/pg-auth-electricsql/migrations/002_todos.sql b/top-sveltekit/pg-auth-electricsql/migrations/002_todos.sql
new file mode 100644
index 0000000..3e0bf90
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/migrations/002_todos.sql
@@ -0,0 +1,27 @@
+-- Create todos table with user relationship
+CREATE TABLE IF NOT EXISTS todos (
+ id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
+ title TEXT NOT NULL,
+ completed BOOLEAN DEFAULT FALSE,
+ user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+ created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
+ updated_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP
+);
+
+-- Create function to automatically update updated_at timestamp
+CREATE OR REPLACE FUNCTION update_updated_at_column()
+RETURNS TRIGGER AS $$
+BEGIN
+ NEW.updated_at = CURRENT_TIMESTAMP;
+ RETURN NEW;
+END;
+$$ language 'plpgsql';
+
+-- Create trigger to automatically update updated_at timestamp
+CREATE TRIGGER update_todos_updated_at
+ BEFORE UPDATE ON todos
+ FOR EACH ROW
+ EXECUTE FUNCTION update_updated_at_column();
+
+-- Create index on user_id for faster lookups
+CREATE INDEX idx_todos_user_id ON todos(user_id);
diff --git a/top-sveltekit/pg-auth-electricsql/package.json b/top-sveltekit/pg-auth-electricsql/package.json
new file mode 100644
index 0000000..cc329e9
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/package.json
@@ -0,0 +1,84 @@
+{
+ "name": "top-sveltekit",
+ "version": "0.0.1",
+ "private": true,
+ "scripts": {
+ "dev": "vite dev",
+ "build": "vite build",
+ "preview": "vite preview",
+ "migrate": "bun -r dotenv/config node-pg-migrate --dotenv-path=.env.local",
+ "migrate:production": "node-pg-migrate",
+ "check": "svelte-kit sync && svelte-check --tsconfig ./tsconfig.json",
+ "check:watch": "svelte-kit sync && svelte-check --tsconfig ./tsconfig.json --watch",
+ "lint": "prettier --check . && eslint .",
+ "format": "prettier --write .",
+ "postbuild": "vite build --mode preview"
+ },
+ "devDependencies": {
+ "@divriots/jampack": "^0.30.0",
+ "@iconify/json": "^2.2.190",
+ "@sveltejs/adapter-node": "^5.2.9",
+ "@sveltejs/adapter-vercel": "^5.5.0",
+ "@sveltejs/enhanced-img": "^0.4.1",
+ "@sveltejs/kit": "^2.9.0",
+ "@sveltejs/vite-plugin-svelte": "^5.0.1",
+ "@tailwindcss/container-queries": "^0.1.1",
+ "@tailwindcss/forms": "^0.5.9",
+ "@tailwindcss/typography": "^0.5.15",
+ "@types/eslint": "^9.6.1",
+ "@typescript-eslint/eslint-plugin": "^8.16.0",
+ "@typescript-eslint/parser": "^8.16.0",
+ "@vcarl/remark-headings": "^0.1.0",
+ "autoprefixer": "^10.4.20",
+ "daisyui": "^4.12.14",
+ "eslint": "^9.15.0",
+ "eslint-config-prettier": "^9.1.0",
+ "eslint-plugin-svelte": "^2.46.0",
+ "fs-extra": "^11.2.0",
+ "glob": "^11.0.0",
+ "idb": "^8.0.0",
+ "mdsvex": "^0.12.3",
+ "mdsvex-relative-images": "^1.0.3",
+ "postcss": "^8.4.49",
+ "prettier": "^3.4.1",
+ "prettier-plugin-svelte": "^3.3.2",
+ "prettier-plugin-tailwindcss": "^0.6.9",
+ "rehype-autolink-headings": "^7.1.0",
+ "rehype-slug": "^6.0.0",
+ "remark-external-links": "^9.0.1",
+ "remark-reading-time": "^2.0.1",
+ "remark-toc": "^9.0.0",
+ "svelte": "^5.2.11",
+ "svelte-check": "^4.1.0",
+ "svelte-preprocess-import-assets": "^1.1.0",
+ "svelte-youtube-embed": "^0.3.3",
+ "tailwindcss": "^3.4.15",
+ "tslib": "^2.8.1",
+ "typescript": "^5.7.2",
+ "unist-util-visit": "^5.0.0",
+ "unplugin-icons": "^0.20.2",
+ "vite": "^6.0.1",
+ "vite-plugin-restart": "^0.4.0",
+ "vite-plugin-static-copy": "^2.2.0",
+ "vitest": "^2.1.6"
+ },
+ "type": "module",
+ "dependencies": {
+ "@auth/pg-adapter": "^1.7.4",
+ "@auth/sveltekit": "^1.7.4",
+ "@google/generative-ai": "^0.21.0",
+ "@types/bcrypt": "^5.0.2",
+ "@types/sortablejs": "^1.15.8",
+ "bcrypt": "^5.1.1",
+ "date-fns": "^4.1.0",
+ "dotenv": "^16.4.5",
+ "node-html-parser": "^6.1.13",
+ "node-pg-migrate": "^7.8.0",
+ "pg": "^8.13.1",
+ "sortablejs": "^1.15.6",
+ "svelte-french-toast": "^1.2.0",
+ "svelte-persisted-store": "^0.12.0",
+ "theme-change": "^2.5.0",
+ "vanilla-tilt": "^1.8.1"
+ }
+}
diff --git a/portfolio/postcss.config.js b/top-sveltekit/pg-auth-electricsql/postcss.config.js
similarity index 100%
rename from portfolio/postcss.config.js
rename to top-sveltekit/pg-auth-electricsql/postcss.config.js
diff --git a/top-sveltekit/pg-auth-electricsql/src/app.d.ts b/top-sveltekit/pg-auth-electricsql/src/app.d.ts
new file mode 100644
index 0000000..02cd02a
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/app.d.ts
@@ -0,0 +1,44 @@
+import type { Session, User } from '@auth/core/types';
+import type { Role } from '$lib/types';
+
+// Extend the User type to include roles and id
+interface CustomUser extends Omit {
+ id: string;
+ email: string | null | undefined;
+ name?: string | null;
+ image?: string | null;
+ roles?: Role[]; // Use Role enum instead of string[]
+}
+
+// Extend the Session type to include our custom user
+interface CustomSession extends Omit {
+ user: CustomUser;
+}
+
+// Define credentials type for auth
+interface Credentials {
+ email: string;
+ password: string;
+}
+
+declare global {
+ namespace App {
+ interface Locals {
+ getSession(): Promise;
+ roles?: Role[]; // Use Role enum instead of string[]
+ }
+ interface PageData {
+ session: CustomSession | null;
+ }
+ // interface Error {}
+ // interface Platform {}
+ }
+}
+
+// Extend the auth module's types
+declare module '@auth/core/types' {
+ interface User extends CustomUser { }
+ interface Session extends CustomSession { }
+}
+
+export { Credentials, CustomUser, CustomSession };
diff --git a/top-sveltekit/pg-auth-electricsql/src/app.html b/top-sveltekit/pg-auth-electricsql/src/app.html
new file mode 100644
index 0000000..ee46e37
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/app.html
@@ -0,0 +1,17 @@
+
+
+
+
+
+
+
+
+
+ %sveltekit.head%
+
+
+
+
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Autocomplete.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Autocomplete.svelte
new file mode 100644
index 0000000..1f032ca
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Autocomplete.svelte
@@ -0,0 +1,94 @@
+
+
+
+
+ {title}
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/SideMenu.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/SideMenu.svelte
new file mode 100644
index 0000000..4980586
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/SideMenu.svelte
@@ -0,0 +1,128 @@
+
+
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/SocialIcons.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/SocialIcons.svelte
new file mode 100644
index 0000000..71083c7
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/SocialIcons.svelte
@@ -0,0 +1,67 @@
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/TiltContent.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/TiltContent.svelte
new file mode 100644
index 0000000..d46db95
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/TiltContent.svelte
@@ -0,0 +1,38 @@
+
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/themeChamge/DaisyUIThemeSwitcher.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/themeChamge/DaisyUIThemeSwitcher.svelte
new file mode 100644
index 0000000..8bc5783
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/themeChamge/DaisyUIThemeSwitcher.svelte
@@ -0,0 +1,74 @@
+
+
+({
+ todos: [],
+ loading: false,
+ error: null
+ });
+
+ return {
+ subscribe,
+ fetchTodos: async () => {
+ update(state => ({ ...state, loading: true }));
+ try {
+ const response = await fetch('/api/todos');
+ if (!response.ok) throw new Error('Failed to fetch todos');
+ const data = await response.json();
+
+ update(state => ({
+ ...state,
+ todos: data,
+ loading: false,
+ error: null
+ }));
+ } catch (error) {
+ update(state => ({
+ ...state,
+ error: error instanceof Error ? error.message : 'An error occurred',
+ loading: false
+ }));
+ }
+ },
+
+ addTodo: async (title: string) => {
+ update(state => ({ ...state, loading: true }));
+ try {
+ const response = await fetch('/api/todos', {
+ method: 'POST',
+ headers: { 'Content-Type': 'application/json' },
+ body: JSON.stringify({ title })
+ });
+ if (!response.ok) throw new Error('Failed to add todo');
+ const data = await response.json();
+
+ update(state => ({
+ ...state,
+ todos: [data, ...state.todos],
+ loading: false,
+ error: null
+ }));
+ } catch (error) {
+ update(state => ({
+ ...state,
+ error: error instanceof Error ? error.message : 'An error occurred',
+ loading: false
+ }));
+ }
+ },
+
+ toggleTodo: async (id: string, completed: boolean) => {
+ update(state => ({ ...state, loading: true }));
+ try {
+ const response = await fetch(`/api/todos/${id}`, {
+ method: 'PATCH',
+ headers: { 'Content-Type': 'application/json' },
+ body: JSON.stringify({ completed })
+ });
+ if (!response.ok) throw new Error('Failed to update todo');
+ const data = await response.json();
+
+ update(state => ({
+ ...state,
+ todos: state.todos.map(todo =>
+ todo.id === id ? data : todo
+ ),
+ loading: false,
+ error: null
+ }));
+ } catch (error) {
+ update(state => ({
+ ...state,
+ error: error instanceof Error ? error.message : 'An error occurred',
+ loading: false
+ }));
+ }
+ },
+
+ deleteTodo: async (id: string) => {
+ update(state => ({ ...state, loading: true }));
+ try {
+ const response = await fetch(`/api/todos/${id}`, {
+ method: 'DELETE'
+ });
+ if (!response.ok) throw new Error('Failed to delete todo');
+
+ update(state => ({
+ ...state,
+ todos: state.todos.filter(todo => todo.id !== id),
+ loading: false,
+ error: null
+ }));
+ } catch (error) {
+ update(state => ({
+ ...state,
+ error: error instanceof Error ? error.message : 'An error occurred',
+ loading: false
+ }));
+ }
+ }
+ };
+}
+
+export const todoStore = createTodoStore();
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/types.ts b/top-sveltekit/pg-auth-electricsql/src/lib/types.ts
new file mode 100644
index 0000000..8a526f5
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/types.ts
@@ -0,0 +1,4 @@
+export enum Role {
+ USER = 'user',
+ ADMIN = 'admin'
+}
diff --git a/portfolio/src/lib/utils/content.ts b/top-sveltekit/pg-auth-electricsql/src/lib/utils/content.ts
similarity index 100%
rename from portfolio/src/lib/utils/content.ts
rename to top-sveltekit/pg-auth-electricsql/src/lib/utils/content.ts
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/utils/fetchData.ts b/top-sveltekit/pg-auth-electricsql/src/lib/utils/fetchData.ts
new file mode 100644
index 0000000..2907f02
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/utils/fetchData.ts
@@ -0,0 +1,25 @@
+export const fetchData = async (url: string, method?: 'GET' | 'POST', data?: any) => {
+ try {
+ if (method === 'POST') {
+ const response = await fetch(url, {
+ method: 'POST',
+ headers: {
+ 'Content-Type': 'application/json',
+ },
+ body: JSON.stringify(data),
+ });
+ const data = await response.json();
+ return data;
+ }
+
+ else {
+ const response = await fetch(url);
+ const data = await response.json();
+ return data;
+ }
+
+ } catch (error) {
+ console.error('Error fetching data:', error.message);
+ return [];
+ }
+};
\ No newline at end of file
diff --git a/portfolio/src/lib/utils/repace-url-for-seo.ts b/top-sveltekit/pg-auth-electricsql/src/lib/utils/repace-url-for-seo.ts
similarity index 100%
rename from portfolio/src/lib/utils/repace-url-for-seo.ts
rename to top-sveltekit/pg-auth-electricsql/src/lib/utils/repace-url-for-seo.ts
diff --git a/portfolio/src/lib/utils/slugFromPath.test.ts b/top-sveltekit/pg-auth-electricsql/src/lib/utils/slugFromPath.test.ts
similarity index 100%
rename from portfolio/src/lib/utils/slugFromPath.test.ts
rename to top-sveltekit/pg-auth-electricsql/src/lib/utils/slugFromPath.test.ts
diff --git a/portfolio/src/lib/utils/slugFromPath.ts b/top-sveltekit/pg-auth-electricsql/src/lib/utils/slugFromPath.ts
similarity index 100%
rename from portfolio/src/lib/utils/slugFromPath.ts
rename to top-sveltekit/pg-auth-electricsql/src/lib/utils/slugFromPath.ts
diff --git a/portfolio/src/lib/utils/util.ts b/top-sveltekit/pg-auth-electricsql/src/lib/utils/utils.ts
similarity index 100%
rename from portfolio/src/lib/utils/util.ts
rename to top-sveltekit/pg-auth-electricsql/src/lib/utils/utils.ts
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/+layout.server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/+layout.server.ts
new file mode 100644
index 0000000..d98c23e
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/+layout.server.ts
@@ -0,0 +1,17 @@
+import type { LayoutServerLoad } from "./$types"
+import { redirect } from '@sveltejs/kit';
+
+export const load: LayoutServerLoad = async (event) => {
+ const session = await event.locals.auth();
+
+ // Add redirections if needed
+ if (!session?.user && event.url.pathname === '/profile') {
+ throw redirect(302, '/');
+ }
+
+ return {
+ session
+ }
+}
+// export const prerender = true
+// export const ssr = false;
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/+layout.svelte b/top-sveltekit/pg-auth-electricsql/src/routes/+layout.svelte
new file mode 100644
index 0000000..1055be3
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/+layout.svelte
@@ -0,0 +1,36 @@
+
+
+
+ 
+
+
+🔍 What I Do:
+I’m a proponent of cutting-edge technologies, specializing in SvelteKit, Vite, ThreeJS, and BabylonJS, among others. My work focuses on crafting visually compelling and scientifically robust digital platforms. From corporate branding to 3D point cloud navigation systems for museums, I create seamless digital experiences that bring visions to life.
+
+🎯 My Approach:
+As a practitioner of the Design Thinking methodology and Agile Kanban processes, I always place the user at the center of my design and development projects. I believe in the power of prototypes, wireframes, and most importantly, user feedback, to guide my designs from concept to completion.
+
+👨🔬 Research & Interests:
+My background includes a Masters in Artificial Intelligence, and my research intersects human-computer interaction and behavioral sciences. I am passionate about breaking down complex problems and democratizing communication between users and organizations.
+
+🌱 Looking Ahead:
+I look at the world with an optimistic lens, always seeking to optimize user experiences, even in everyday activities. If you’re intrigued by what I can offer, I am open to projects and collaborative opportunities that align with my skill set.
+
+🤝 Let’s Collaborate:
+Interested in taking your project to the next level? Get in Touch
\ No newline at end of file
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/admin/+page.server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/admin/+page.server.ts
new file mode 100644
index 0000000..f5d682c
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/admin/+page.server.ts
@@ -0,0 +1,19 @@
+import { redirect } from '@sveltejs/kit';
+import type { PageServerLoad } from './$types';
+
+export const load: PageServerLoad = async ({ locals }) => {
+ const session = await locals.getSession();
+
+ if (!session?.user) {
+ throw redirect(302, '/auth/signin');
+ }
+
+ const roles = locals.roles || [];
+ if (!roles.includes('admin')) {
+ throw redirect(302, '/');
+ }
+
+ return {
+ user: session.user
+ };
+};
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/admin/+page.svelte b/top-sveltekit/pg-auth-electricsql/src/routes/admin/+page.svelte
new file mode 100644
index 0000000..a1e6c1b
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/admin/+page.svelte
@@ -0,0 +1,145 @@
+
+
+ = {};
+
+export const GET: RequestHandler = async ({ locals }) => {
+ const session = await locals.getSession();
+ if (!session?.user?.email) {
+ return json({ error: 'Unauthorized' }, { status: 401 });
+ }
+
+ const apiKey = userApiKeys[session.user.email] || '';
+ return json({ apiKey });
+};
+
+export const POST: RequestHandler = async ({ request, locals }) => {
+ const session = await locals.getSession();
+ if (!session?.user?.email) {
+ return json({ error: 'Unauthorized' }, { status: 401 });
+ }
+
+ const { apiKey } = await request.json();
+ userApiKeys[session.user.email] = apiKey;
+
+ return json({ success: true });
+};
\ No newline at end of file
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/auth/login/+page.svelte b/top-sveltekit/pg-auth-electricsql/src/routes/auth/login/+page.svelte
new file mode 100644
index 0000000..27439d7
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/auth/login/+page.svelte
@@ -0,0 +1,22 @@
+
+
+ (/usr/local/Cellar/pnpm/6.32.4/libexec/lib/node_modules/pnpm/dist/pnpm.cjs:92290:22)\n at ChildProcess.emit (node:events:519:28)\n at maybeClose (node:internal/child_process:1105:16)\n at ChildProcess._handle.onexit (node:internal/child_process:305:5)"
+ }
+ },
+ "2 warn pnpm:global": " Local package.json exists, but node_modules missing, did you mean to install?"
+}
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/.prettierignore b/top-sveltekit/postgres-rls/.prettierignore
new file mode 100644
index 0000000..53062ff
--- /dev/null
+++ b/top-sveltekit/postgres-rls/.prettierignore
@@ -0,0 +1,14 @@
+.DS_Store
+node_modules
+/build
+/.svelte-kit
+/package
+.env
+.env.*
+!.env.example
+
+# Ignore files for PNPM, NPM and YARN
+pnpm-lock.yaml
+package-lock.json
+yarn.lock
+*.sql
diff --git a/top-sveltekit/postgres-rls/.prettierrc b/top-sveltekit/postgres-rls/.prettierrc
new file mode 100644
index 0000000..f4019a2
--- /dev/null
+++ b/top-sveltekit/postgres-rls/.prettierrc
@@ -0,0 +1,10 @@
+{
+ "useTabs": true,
+ "singleQuote": true,
+ "trailingComma": "none",
+ "printWidth": 100,
+ "plugins": ["prettier-plugin-svelte","prettier-plugin-tailwindcss"],
+ "pluginSearchDirs": ["."],
+ "overrides": [{ "files": "*.svelte", "options": { "parser": "svelte" } }],
+ "htmlWhitespaceSensitivity": "ignore"
+}
diff --git a/top-sveltekit/postgres-rls/.vscode/launch.json b/top-sveltekit/postgres-rls/.vscode/launch.json
new file mode 100644
index 0000000..95445ed
--- /dev/null
+++ b/top-sveltekit/postgres-rls/.vscode/launch.json
@@ -0,0 +1,15 @@
+{
+ // Use IntelliSense to learn about possible attributes.
+ // Hover to view descriptions of existing attributes.
+ // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
+ "version": "0.2.0",
+ "configurations": [
+ {
+ "type": "chrome",
+ "request": "launch",
+ "name": "Launch Chrome against localhost",
+ "url": "http://localhost:5173",
+ "webRoot": "${workspaceFolder}"
+ }
+ ]
+}
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/.vscode/settings.json b/top-sveltekit/postgres-rls/.vscode/settings.json
new file mode 100644
index 0000000..c26eb74
--- /dev/null
+++ b/top-sveltekit/postgres-rls/.vscode/settings.json
@@ -0,0 +1,17 @@
+{
+ "window.title": "📙 Top Sveltekit - ${activeEditorShort}",
+ "eslint.workingDirectories": [
+ {
+ "mode": "auto"
+ }
+ ],
+ "editor.codeActionsOnSave": {
+ "source.fixAll.eslint": "explicit"
+ },
+ "eslint.validate": [
+ "javascript"
+ ],
+ "[sql]": {
+ "editor.formatOnSave": false
+ },
+}
diff --git a/top-sveltekit/postgres-rls/README.md b/top-sveltekit/postgres-rls/README.md
new file mode 100644
index 0000000..42fd710
--- /dev/null
+++ b/top-sveltekit/postgres-rls/README.md
@@ -0,0 +1,73 @@
+# Ctwhome top-sveltekit
+Unified full-stack with SvelteKit (Svelte 5), TailwindCSS, DaisyUI, AuthJS, ElectricSQL Postgres, and more.\
+by [ctwhome](https://ctwhome.com)
+
+## Goal of the template
+1. **Local-first architecture**: Data lives locally and syncs with the database seamlessly.
+
+2. **Simplicity in code**: Update Svelte stores locally and let syncing happen in the background.
+
+3. **Future scalability**: Add real-time sync, offline-first capabilities, and avoid duplicating effort with local storage or API requests.
+
+
+## Installation and running locally
+```bash
+bunx degit ctwhome/top-sveltekit
+```
+
+```
+bunx degit ctwhome/top-sveltekit newName --mode=git # --mode-git if cloning a private repo
+```
+
+Libraries to install for auth:
+```
+bun add pg node-pg-migrate dotenv @auth/sveltekit @auth/pg-adapter
+```
+
+Running Migrations:
+```shell
+bun migrate up
+bun migrate down # with number to run back as many
+```
+
+
+
+Steps:
+1. Install the dependencies with `bun install`
+2. Generate the google OAUTH credentials for the auth.js.
+3. 
+4. copy the .env.local.example file to .env.local
+5. fill in the .env.local file with your own values
+6. copy the .env.example file to .env
+7. run `npx auth secret` to generate a secret key for the auth.js adapter
+8. Run migrations files to setup the database `bun run migrate up`. It will create the neccesary tables and functions, users and two example users alice and bob.
+
+
+Run locally:
+```bash
+bun dev
+```
+
+## Updating fork
+1. Add remote from the original repository in your forked repository:
+```shell
+git remote add upstream git://github.com/ctwhome/top-sveltekit.git
+git fetch upstream
+```
+1. Updating your fork from the original repo to keep up with their changes:
+ `git pull upstream main`
+
+Start the development server on [http://localhost:5173](http://localhost:5173)
+
+```bash
+bun dev
+```
+
+## Production
+
+Build the application for production:
+
+```bash
+bun build
+```
+
diff --git a/top-sveltekit/postgres-rls/bun.lockb b/top-sveltekit/postgres-rls/bun.lockb
new file mode 100755
index 0000000..737fb83
Binary files /dev/null and b/top-sveltekit/postgres-rls/bun.lockb differ
diff --git a/top-sveltekit/postgres-rls/example .env b/top-sveltekit/postgres-rls/example .env
new file mode 100644
index 0000000..daec1f4
--- /dev/null
+++ b/top-sveltekit/postgres-rls/example .env
@@ -0,0 +1,38 @@
+# TO ENABLE ROW LEVEL SECURITY IT IS IMPORTANT TO CREATE THE USER ROLE THAT WILL BE ACCESSED LATER IN THE CONNECTION
+
+# ```
+# CREATE USER top-sveltekit WITH PASSWORD 'top-sveltekit';
+# GRANT SELECT, INSERT, UPDATE, DELETE ON chats TO top-sveltekit;
+# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO top-sveltekit;
+# ```
+
+
+
+AUTH_GOOGLE_ID=10...
+AUTH_GOOGLE_SECRET=GO...
+
+# Production database
+# DATABASE_URL_PROD=postgres://
+
+# Dev database pg-node
+DATABASE_URL=postgres://
+
+
+# DATABASE CONNECTIONS FOR AUTH.JS ADAPTER run with `npx auth secret`
+AUTH_SECRET= # Added by `npx auth`. Read more: https://cli.authjs.dev
+
+DB_HOST=
+DB_PORT=
+DB_USER=
+DB_NAME=
+DB_PASSWORD=
+DB_SSL=false
+MAX_CLIENTS=20
+IDLE_TIMEOUT_MILLIS=30000
+CONNECTION_TIMEOUT_MILLIS=2000
+
+
+
+# Resend API key
+AUTH_RESEND_KEY = re_...
+
diff --git a/top-sveltekit/postgres-rls/example .env.local b/top-sveltekit/postgres-rls/example .env.local
new file mode 100644
index 0000000..7eefcd6
--- /dev/null
+++ b/top-sveltekit/postgres-rls/example .env.local
@@ -0,0 +1,23 @@
+# TO ENABLE ROW LEVEL SECURITY IT IS IMPORTANT TO CREATE THE USER ROLE THAT WILL BE ACCESSED LATER IN THE CONNECTION
+
+# ```
+# CREATE USER top-sveltekit WITH PASSWORD 'top-sveltekit';
+# GRANT SELECT, INSERT, UPDATE, DELETE ON chats TO top-sveltekit;
+# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO top-sveltekit;
+# ```
+
+
+
+
+# Connection with the local database running on the local machine
+# Dev database pg-node
+
+PUBLIC_LOCALHOST=true
+
+DATABASE_URL=postgres://postgres:postgres@localhost:5432/top-sveltekit
+
+DB_HOST=localhost
+DB_PORT=5432
+DB_USER=postgres
+DB_PASSWORD=postgres
+DB_NAME=top-sveltekit
diff --git a/top-sveltekit/postgres-rls/mdsvex.config.js b/top-sveltekit/postgres-rls/mdsvex.config.js
new file mode 100644
index 0000000..c328681
--- /dev/null
+++ b/top-sveltekit/postgres-rls/mdsvex.config.js
@@ -0,0 +1,85 @@
+import { visit } from 'unist-util-visit'
+
+import autolinkHeadings from 'rehype-autolink-headings'
+import slugPlugin from 'rehype-slug'
+
+import relativeImages from 'mdsvex-relative-images'
+// import remarkHeadings from '@vcarl/remark-headings'
+import remarkExternalLinks from 'remark-external-links';
+import readingTime from 'remark-reading-time';
+
+// import remarkToc from 'remark-toc'
+
+
+export default {
+ extensions: ['.svx', '.md'],
+ smartypants: {
+ dashes: 'oldschool'
+ },
+ layout: {
+ _: "/src/lib/markdown-layouts/default.svelte", // Default layout for markdown files
+ blog: "/src/lib/markdown-layouts/blog.svelte",
+ project: "/src/lib/markdown-layouts/project.svelte",
+ },
+ remarkPlugins: [
+ videos,
+ relativeImages,
+ // remarkToc,
+ // headings,
+ // adds a `readingTime` frontmatter attribute
+ readingTime,
+ // external links open in a new tab
+ [remarkExternalLinks, { target: '_blank', rel: 'noopener' }],
+ ],
+ rehypePlugins: [
+ slugPlugin,
+ [
+ autolinkHeadings, { behavior: 'wrap' }
+ ]
+ ]
+}
+
+/**
+ * Adds support to video files in markdown image links
+ */
+function videos() {
+ const extensions = ['mp4', 'webm']
+ return function transformer(tree) {
+ visit(tree, 'image', (node) => {
+ if (extensions.some((ext) => node.url.endsWith(ext))) {
+ node.type = 'html'
+ node.value = `
+
+ `
+ }
+ })
+ }
+}
+
+/**
+ * Parses headings and includes the result in metadata
+ */
+// function headings() {
+// return function transformer(tree, vfile) {
+// // run remark-headings plugin
+// remarkHeadings()(tree, vfile)
+
+// // include the headings data in mdsvex frontmatter
+// vfile.data.fm ??= {}
+// vfile.data.fm.headings = vfile.data.headings.map((heading) => ({
+// ...heading,
+// // slugify heading.value
+// id: heading.value
+// .toLowerCase()
+// .replace(/\s/g, '-')
+// .replace(/[^a-z0-9-]/g, '')
+// }))
+// }
+// }
diff --git a/top-sveltekit/postgres-rls/migrations/1724096061617_init.sql b/top-sveltekit/postgres-rls/migrations/1724096061617_init.sql
new file mode 100644
index 0000000..7b4d7e7
--- /dev/null
+++ b/top-sveltekit/postgres-rls/migrations/1724096061617_init.sql
@@ -0,0 +1,87 @@
+-- Up Migration
+-- https://authjs.dev/getting-started/adapters/pg
+
+-- Function Definitions
+DROP FUNCTION IF EXISTS set_app_user CASCADE;
+CREATE OR REPLACE FUNCTION set_app_user(user_id INTEGER) RETURNS TEXT AS $$
+BEGIN
+ PERFORM set_config('app.user_id', user_id::TEXT, false);
+ RETURN 'User set successfully';
+END;
+$$ LANGUAGE plpgsql;
+
+
+
+-- Table Definitions
+CREATE TABLE verification_token
+(
+ identifier TEXT NOT NULL,
+ expires TIMESTAMPTZ NOT NULL,
+ token TEXT NOT NULL,
+ PRIMARY KEY (identifier, token)
+);
+
+CREATE TABLE accounts
+(
+ id SERIAL,
+ "userId" INTEGER NOT NULL,
+ type VARCHAR(255) NOT NULL,
+ provider VARCHAR(255) NOT NULL,
+ "providerAccountId" VARCHAR(255) NOT NULL,
+ refresh_token TEXT,
+ access_token TEXT,
+ expires_at BIGINT,
+ id_token TEXT,
+ scope TEXT,
+ session_state TEXT,
+ token_type TEXT,
+ PRIMARY KEY (id)
+);
+
+CREATE TABLE sessions
+(
+ id SERIAL,
+ "userId" INTEGER NOT NULL,
+ expires TIMESTAMPTZ NOT NULL,
+ "sessionToken" VARCHAR(255) NOT NULL,
+ PRIMARY KEY (id)
+);
+
+CREATE TABLE users
+(
+ id SERIAL,
+ name VARCHAR(255),
+ email VARCHAR(255) UNIQUE,
+ password VARCHAR(255),
+ "emailVerified" TIMESTAMPTZ,
+ image TEXT,
+ PRIMARY KEY (id)
+);
+
+-- Create a unique index on the email column
+CREATE UNIQUE INDEX users_email_idx ON users (email);
+
+-- Insert sample users
+INSERT INTO users (name, email, password, "emailVerified", image)
+VALUES ('Alice Doe', 'alice@ctwhome.com', '$2a$12$qZNxIFh/Yayqshdz.3ZH2Oy2uORW/MqDS9NlfkIZsm6xnK5ZtCyJG', '2023-10-10', 'https://img.daisyui.com/images/stock/photo-1534528741775-53994a69daeb.webp'), -- admin
+ ('Bob Sponge', 'bob@ctwhome.com', '$2a$12$qZNxIFh/Yayqshdz.3ZH2Oy2uORW/MqDS9NlfkIZsm6xnK5ZtCyJG', '2023-10-10', '/images/diamond.jpg'); -- admin
+
+-- Grant permissions to the database user (replace 'appuser' with the actual username if different)
+GRANT SELECT, INSERT, UPDATE, DELETE ON users TO appuser;
+GRANT SELECT, INSERT, UPDATE, DELETE ON accounts TO appuser;
+GRANT SELECT, INSERT, UPDATE, DELETE ON sessions TO appuser;
+GRANT SELECT, INSERT, UPDATE, DELETE ON verification_token TO appuser;
+
+-- Grant sequence usage for tables with SERIAL or auto-incrementing IDs
+GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO appuser;
+
+-- If the users table is in a different schema, replace 'public' with the correct schema name
+GRANT USAGE ON SCHEMA public TO appuser;
+
+
+-- Down Migration
+DROP TABLE accounts;
+DROP TABLE sessions;
+DROP TABLE users;
+DROP TABLE verification_token;
+DROP FUNCTION IF EXISTS set_app_user;
diff --git a/top-sveltekit/postgres-rls/package.json b/top-sveltekit/postgres-rls/package.json
new file mode 100644
index 0000000..2490963
--- /dev/null
+++ b/top-sveltekit/postgres-rls/package.json
@@ -0,0 +1,97 @@
+{
+ "name": "top-sveltekit",
+ "version": "0.0.1",
+ "private": true,
+ "scripts": {
+ "dev": "vite dev",
+ "build": "vite build",
+ "preview": "vite preview",
+ "migrate": "DATABASE_URL=postgres://postgres:postgres@localhost:5432/top-sveltekit pnpm node-pg-migrate",
+ "migrate:production": "node-pg-migrate",
+ "check": "svelte-kit sync && svelte-check --tsconfig ./tsconfig.json",
+ "check:watch": "svelte-kit sync && svelte-check --tsconfig ./tsconfig.json --watch",
+ "lint": "prettier --check . && eslint .",
+ "format": "prettier --write .",
+ "postbuild": "vite build --mode preview"
+ },
+ "devDependencies": {
+ "@divriots/jampack": "^0.30.0",
+ "@iconify-json/arcticons": "^1.2.6",
+ "@iconify-json/bi": "^1.2.1",
+ "@iconify-json/carbon": "^1.2.4",
+ "@iconify-json/ci": "^1.2.1",
+ "@iconify-json/fa6-solid": "^1.2.2",
+ "@iconify-json/iconamoon": "^1.2.1",
+ "@iconify-json/lucide": "^1.2.17",
+ "@iconify-json/material-symbols": "^1.2.8",
+ "@iconify-json/mdi": "^1.2.1",
+ "@iconify-json/mingcute": "^1.2.1",
+ "@iconify-json/ph": "^1.2.1",
+ "@iconify-json/ri": "^1.2.3",
+ "@iconify-json/simple-icons": "^1.2.13",
+ "@iconify-json/streamline": "^1.2.1",
+ "@sveltejs/adapter-node": "^5.2.9",
+ "@sveltejs/adapter-vercel": "^5.5.0",
+ "@sveltejs/enhanced-img": "^0.4.1",
+ "@sveltejs/kit": "^2.9.0",
+ "@sveltejs/vite-plugin-svelte": "^5.0.1",
+ "@tailwindcss/container-queries": "^0.1.1",
+ "@tailwindcss/forms": "^0.5.9",
+ "@tailwindcss/typography": "^0.5.15",
+ "@types/eslint": "^9.6.1",
+ "@typescript-eslint/eslint-plugin": "^8.16.0",
+ "@typescript-eslint/parser": "^8.16.0",
+ "@vcarl/remark-headings": "^0.1.0",
+ "autoprefixer": "^10.4.20",
+ "daisyui": "^4.12.14",
+ "eslint": "^9.15.0",
+ "eslint-config-prettier": "^9.1.0",
+ "eslint-plugin-svelte": "^2.46.0",
+ "fs-extra": "^11.2.0",
+ "glob": "^11.0.0",
+ "idb": "^8.0.0",
+ "mdsvex": "^0.12.3",
+ "mdsvex-relative-images": "^1.0.3",
+ "postcss": "^8.4.49",
+ "prettier": "^3.4.1",
+ "prettier-plugin-svelte": "^3.3.2",
+ "prettier-plugin-tailwindcss": "^0.6.9",
+ "rehype-autolink-headings": "^7.1.0",
+ "rehype-slug": "^6.0.0",
+ "remark-external-links": "^9.0.1",
+ "remark-reading-time": "^2.0.1",
+ "remark-toc": "^9.0.0",
+ "svelte": "^5.2.11",
+ "svelte-check": "^4.1.0",
+ "svelte-preprocess-import-assets": "^1.1.0",
+ "svelte-youtube-embed": "^0.3.3",
+ "tailwindcss": "^3.4.15",
+ "tslib": "^2.8.1",
+ "typescript": "^5.7.2",
+ "unist-util-visit": "^5.0.0",
+ "unplugin-icons": "^0.20.2",
+ "vite": "^6.0.1",
+ "vite-plugin-restart": "^0.4.0",
+ "vite-plugin-static-copy": "^2.2.0",
+ "vitest": "^2.1.6"
+ },
+ "type": "module",
+ "dependencies": {
+ "@auth/pg-adapter": "^1.7.4",
+ "@auth/sveltekit": "^1.7.4",
+ "@google/generative-ai": "^0.21.0",
+ "@types/bcrypt": "^5.0.2",
+ "@types/sortablejs": "^1.15.8",
+ "bcrypt": "^5.1.1",
+ "date-fns": "^4.1.0",
+ "dotenv": "^16.4.5",
+ "node-html-parser": "^6.1.13",
+ "node-pg-migrate": "^7.8.0",
+ "pg": "^8.13.1",
+ "sortablejs": "^1.15.6",
+ "svelte-french-toast": "^1.2.0",
+ "svelte-persisted-store": "^0.12.0",
+ "theme-change": "^2.5.0",
+ "vanilla-tilt": "^1.8.1"
+ }
+}
diff --git a/top-sveltekit/postgres-rls/postcss.config.js b/top-sveltekit/postgres-rls/postcss.config.js
new file mode 100644
index 0000000..0f77216
--- /dev/null
+++ b/top-sveltekit/postgres-rls/postcss.config.js
@@ -0,0 +1,6 @@
+export default {
+ plugins: {
+ tailwindcss: {},
+ autoprefixer: {}
+ }
+};
diff --git a/portfolio/src/app.d.ts b/top-sveltekit/postgres-rls/src/app.d.ts
similarity index 100%
rename from portfolio/src/app.d.ts
rename to top-sveltekit/postgres-rls/src/app.d.ts
diff --git a/top-sveltekit/postgres-rls/src/app.html b/top-sveltekit/postgres-rls/src/app.html
new file mode 100644
index 0000000..ee46e37
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/app.html
@@ -0,0 +1,17 @@
+
+
+
+
+
+
+
+
+
+ %sveltekit.head%
+
+
+
+
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/Autocomplete.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/Autocomplete.svelte
new file mode 100644
index 0000000..1f032ca
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/Autocomplete.svelte
@@ -0,0 +1,94 @@
+
+
+
+ {title}
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/SideMenu.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/SideMenu.svelte
new file mode 100644
index 0000000..4980586
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/SideMenu.svelte
@@ -0,0 +1,128 @@
+
+
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/SocialIcons.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/SocialIcons.svelte
new file mode 100644
index 0000000..71083c7
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/SocialIcons.svelte
@@ -0,0 +1,67 @@
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/TiltContent.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/TiltContent.svelte
new file mode 100644
index 0000000..d46db95
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/TiltContent.svelte
@@ -0,0 +1,38 @@
+
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/themeChamge/DaisyUIThemeSwitcher.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/themeChamge/DaisyUIThemeSwitcher.svelte
new file mode 100644
index 0000000..8bc5783
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/themeChamge/DaisyUIThemeSwitcher.svelte
@@ -0,0 +1,74 @@
+
+
+ };
+
+
+
+
+// Get all posts and add metadata
+// export const posts = Object.entries(import.meta.glob('/content/**/*.md', { eager: true }))
+// Gets the metadata of the mdfile directly
+export const content = Object.entries(import.meta.glob('/src/work/**/*.md', { eager: true }))
+ .filter(
+ ([path, post]) => post.metadata.published
+ )
+
+ .map(([filepath, post]) => {
+ const html = parse(post.default.render().html)
+ const preview = post.metadata.preview ? parse(post.metadata.preview) : html.querySelector('p')
+
+ return {
+ ...post.metadata,
+
+ // generate the slug from the file path
+ slug: filepath
+ .replace(/(\/index)?\.md/, '')
+ .split('/')
+ .pop(),
+
+ // whether or not this file is `my-post.md` or `my-post/index.md`
+ // (needed to do correct dynamic import in posts/[slug].svelte)
+ isIndexFile: filepath.endsWith('/index.md'),
+
+ // format date as yyyy-MM-dd
+ date: post.metadata.date
+ ? format(
+ // offset by timezone so that the date is correct
+ addTimezoneOffset(new Date(post.metadata.date)),
+ 'yyyy-MM-dd'
+ )
+ : undefined,
+
+ preview: {
+ html: preview.toString(),
+ // text-only preview (i.e no html elements), used for SEO
+ text: preview.structuredText ?? preview.toString()
+ },
+
+ }
+ })
+ // sort by date
+ .sort((a, b) => new Date(b.date).getTime() - new Date(a.date).getTime())
+ // add references to the next/previous post
+ .map((post, index, allPosts) => ({
+ ...post,
+ next: allPosts[index - 1],
+ previous: allPosts[index + 1]
+ }))
+
+function addTimezoneOffset(date) {
+ const offsetInMilliseconds = new Date().getTimezoneOffset() * 60 * 1000
+ return new Date(new Date(date).getTime() + offsetInMilliseconds)
+}
diff --git a/top-sveltekit/postgres-rls/src/lib/utils/fetchData.ts b/top-sveltekit/postgres-rls/src/lib/utils/fetchData.ts
new file mode 100644
index 0000000..2907f02
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/utils/fetchData.ts
@@ -0,0 +1,25 @@
+export const fetchData = async (url: string, method?: 'GET' | 'POST', data?: any) => {
+ try {
+ if (method === 'POST') {
+ const response = await fetch(url, {
+ method: 'POST',
+ headers: {
+ 'Content-Type': 'application/json',
+ },
+ body: JSON.stringify(data),
+ });
+ const data = await response.json();
+ return data;
+ }
+
+ else {
+ const response = await fetch(url);
+ const data = await response.json();
+ return data;
+ }
+
+ } catch (error) {
+ console.error('Error fetching data:', error.message);
+ return [];
+ }
+};
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/lib/utils/repace-url-for-seo.ts b/top-sveltekit/postgres-rls/src/lib/utils/repace-url-for-seo.ts
new file mode 100644
index 0000000..8a5aa8b
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/utils/repace-url-for-seo.ts
@@ -0,0 +1,12 @@
+// Usage: replaceURL(inputString, category)
+// Description: Replace the url of the image with the url of the category
+export const replaceURL = (inputString, category) => {
+ const regex = /(https:\/\/portfolio\.ctwhome\.com\/)(?!wp-content)/g;
+ return (
+ inputString
+ .replace(regex, (match) => 'https://ctwhome.com/') // replace the url
+ .replace(/content="noindex/g, 'content="index') // replace noindex with index
+ // remove htnl comments
+ .replace(//g, '')
+ );
+};
diff --git a/top-sveltekit/postgres-rls/src/lib/utils/slugFromPath.test.ts b/top-sveltekit/postgres-rls/src/lib/utils/slugFromPath.test.ts
new file mode 100644
index 0000000..bddeccc
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/utils/slugFromPath.test.ts
@@ -0,0 +1,35 @@
+import { describe, it, expect } from 'vitest';
+import { slugFromPath } from './slugFromPath';
+
+describe('slugFromPath', () => {
+ it('extracts slug from paths correctly', () => {
+ const cases = [
+ {
+ path: '/foo/bar/test-slug.md',
+ expected: 'test-slug'
+ },
+ {
+ path: '/foo/bar/test-slug.svx',
+ expected: 'test-slug'
+ },
+ {
+ path: '/foo/bar/test-slug.svelte.md',
+ expected: 'test-slug'
+ }
+ ];
+
+ cases.forEach(({ path, expected }) => expect(slugFromPath(path)).toBe(expected));
+ });
+
+ it('returns null for unknown extension', () => {
+ const path = '/foo/bar/test-slug.abc';
+
+ expect(slugFromPath(path)).toBeNull();
+ });
+
+ it('returns null for no extension', () => {
+ const path = '/foo/bar/test-slug';
+
+ expect(slugFromPath(path)).toBeNull();
+ });
+});
diff --git a/top-sveltekit/postgres-rls/src/lib/utils/slugFromPath.ts b/top-sveltekit/postgres-rls/src/lib/utils/slugFromPath.ts
new file mode 100644
index 0000000..c00dfc6
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/utils/slugFromPath.ts
@@ -0,0 +1,2 @@
+export const slugFromPath = (path: string) =>
+ path.match(/([\w-]+)\.(svelte\.md|md|svx)/i)?.[1] ?? null;
diff --git a/top-sveltekit/postgres-rls/src/lib/utils/utils.ts b/top-sveltekit/postgres-rls/src/lib/utils/utils.ts
new file mode 100644
index 0000000..e6d6418
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/utils/utils.ts
@@ -0,0 +1,18 @@
+export const slugFromPath = (path) => path.match(/([\w-]+)\.(svelte\.md|md|svx)/i)?.[1] ?? null
+
+export const getOS = () => {
+}
+
+export const subString = (input, from, to) => {
+ return input.slice(input.indexOf(from) + from.length, input.lastIndexOf(to))
+}
+
+export const timeago = (timestamp, locale = "en") => {
+}
+
+export const formattedDate = (date) => {
+ return new Date(date).toLocaleDateString("en-UK", { dateStyle: "medium" })
+}
+
+export const slugify = (str) => {
+}
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/routes/+layout.server.ts b/top-sveltekit/postgres-rls/src/routes/+layout.server.ts
new file mode 100644
index 0000000..4ee55da
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/+layout.server.ts
@@ -0,0 +1,28 @@
+import type { LayoutServerLoad } from "./$types"
+import { redirect } from '@sveltejs/kit';
+
+export const load: LayoutServerLoad = async (event) => {
+ // const session = await event.locals.auth();
+ //
+ // redirections if needed, but must return the session for the app to work.
+
+ /* if (session?.user?.id) {
+ if (event.url.pathname === '/') {
+ throw redirect(302, '/profile');
+ }
+ }
+ else {
+ if (event.url.pathname === '/profile') {
+ throw redirect(302, '/');
+ }
+ } */
+
+
+ return {
+ //! Returning the seesion is important to make sure the user the app is authenticated and make it available to the rest of the app
+ //! https://authjs.dev/reference/sveltekit#managing-the-session
+ // session
+ }
+}
+// export const prerender = true
+// export const ssr = false;
diff --git a/top-sveltekit/postgres-rls/src/routes/+layout.svelte b/top-sveltekit/postgres-rls/src/routes/+layout.svelte
new file mode 100644
index 0000000..1055be3
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/+layout.svelte
@@ -0,0 +1,36 @@
+
+
+
+
+
+
+🔍 What I Do:
+I’m a proponent of cutting-edge technologies, specializing in SvelteKit, Vite, ThreeJS, and BabylonJS, among others. My work focuses on crafting visually compelling and scientifically robust digital platforms. From corporate branding to 3D point cloud navigation systems for museums, I create seamless digital experiences that bring visions to life.
+
+🎯 My Approach:
+As a practitioner of the Design Thinking methodology and Agile Kanban processes, I always place the user at the center of my design and development projects. I believe in the power of prototypes, wireframes, and most importantly, user feedback, to guide my designs from concept to completion.
+
+👨🔬 Research & Interests:
+My background includes a Masters in Artificial Intelligence, and my research intersects human-computer interaction and behavioral sciences. I am passionate about breaking down complex problems and democratizing communication between users and organizations.
+
+🌱 Looking Ahead:
+I look at the world with an optimistic lens, always seeking to optimize user experiences, even in everyday activities. If you’re intrigued by what I can offer, I am open to projects and collaborative opportunities that align with my skill set.
+
+🤝 Let’s Collaborate:
+Interested in taking your project to the next level? Get in Touch
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/routes/api/register/+server.ts b/top-sveltekit/postgres-rls/src/routes/api/register/+server.ts
new file mode 100644
index 0000000..0b35173
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/api/register/+server.ts
@@ -0,0 +1,30 @@
+import { json } from '@sveltejs/kit';
+import type { RequestHandler } from './$types';
+import { pool } from '$lib/db/db';
+import bcrypt from 'bcrypt';
+
+export const POST: RequestHandler = async ({ request }) => {
+ const { email, password } = await request.json();
+
+ try {
+ // Check if user already exists
+ const existingUser = await pool.query('SELECT * FROM users WHERE email = $1', [email]);
+ if (existingUser.rows.length > 0) {
+ return json({ error: 'User already exists' }, { status: 400 });
+ }
+
+ // Hash the password
+ const hashedPassword = await bcrypt.hash(password, 10);
+
+ // Insert new user
+ const result = await pool.query(
+ 'INSERT INTO users (email, password) VALUES ($1, $2) RETURNING id, email',
+ [email, hashedPassword]
+ );
+
+ return json({ user: result.rows[0] });
+ } catch (error) {
+ console.error('Registration error:', error);
+ return json({ error: 'An error occurred during registration' }, { status: 500 });
+ }
+};
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/routes/api/sendEmail/+server.ts b/top-sveltekit/postgres-rls/src/routes/api/sendEmail/+server.ts
new file mode 100644
index 0000000..8c476cb
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/api/sendEmail/+server.ts
@@ -0,0 +1,40 @@
+import type { RequestHandler } from '@sveltejs/kit';
+import { env } from '$env/dynamic/private';
+import { json } from '@sveltejs/kit';
+
+const AUTH_RESEND_KEY = env.AUTH_RESEND_KEY;
+
+export const POST: RequestHandler = async ({ request }) => {
+ const { subject, content } = await request.json();
+ const html = `
+ ${content}
+ `;
+
+ try {
+ const response = await fetch('https://api.resend.com/emails', {
+ method: 'POST',
+ headers: {
+ Authorization: 'Bearer ' + AUTH_RESEND_KEY,
+ 'Content-Type': 'application/json',
+ },
+ body: JSON.stringify({
+ from: 'feedback-top-sveltekit@ctwhome.com',
+ to: 'ctw@ctwhome.com', // Replace with your support email
+ subject: subject,
+ html: html,
+ }),
+ });
+
+ if (!response.ok) {
+ const errorDetails = await response.json();
+ throw new Error(`Network response was not ok: ${JSON.stringify(errorDetails)}`);
+ }
+
+ const data = await response.json();
+ console.log('Feedback email sent successfully:', data);
+ return json({ success: true, message: 'Feedback sent successfully' });
+ } catch (error) {
+ console.error('Error sending feedback email:', error);
+ return json({ success: false, message: 'Failed to send feedback: ' + error.message }, { status: 500 });
+ }
+}
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/routes/api/user/api-key/+server.ts b/top-sveltekit/postgres-rls/src/routes/api/user/api-key/+server.ts
new file mode 100644
index 0000000..3627b49
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/api/user/api-key/+server.ts
@@ -0,0 +1,27 @@
+import { json } from '@sveltejs/kit';
+import type { RequestHandler } from './$types';
+
+// In a real application, you would store this in a database
+let userApiKeys: Record = {};
+
+export const GET: RequestHandler = async ({ locals }) => {
+ const session = await locals.getSession();
+ if (!session?.user?.email) {
+ return json({ error: 'Unauthorized' }, { status: 401 });
+ }
+
+ const apiKey = userApiKeys[session.user.email] || '';
+ return json({ apiKey });
+};
+
+export const POST: RequestHandler = async ({ request, locals }) => {
+ const session = await locals.getSession();
+ if (!session?.user?.email) {
+ return json({ error: 'Unauthorized' }, { status: 401 });
+ }
+
+ const { apiKey } = await request.json();
+ userApiKeys[session.user.email] = apiKey;
+
+ return json({ success: true });
+};
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/routes/auth/login/+page.svelte b/top-sveltekit/postgres-rls/src/routes/auth/login/+page.svelte
new file mode 100644
index 0000000..27439d7
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/auth/login/+page.svelte
@@ -0,0 +1,22 @@
+
+
+
+//
+// ${config.siteName}
+// ${config.siteDescription}
+// ${config.siteUrl}
+// -
+//
${post.title}
+// ${post.description}
+// ${config.siteUrl}${post.slug}
+// ${config.siteUrl}${post.slug}
+// ${new Date(post.published).toUTCString()}
+//
+// `
+// )
+// .join('')}
+//
+//
+// `.trim()
+
+// return new Response(xml, { headers })
+// }
diff --git a/top-sveltekit/postgres-rls/src/routes/sitemap.xml/+server.js b/top-sveltekit/postgres-rls/src/routes/sitemap.xml/+server.js
new file mode 100644
index 0000000..b0507cb
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/sitemap.xml/+server.js
@@ -0,0 +1,59 @@
+// TODO
+// // This is an endpoint that generates a basic sitemap for the index page and all posts.
+// // It's helpful for SEO but does require you to keep it updated to reflect the routes of your website.
+// // It is OK to delete this file if you'd rather not bother with it.
+
+// import { posts } from '$lib/data/posts'
+// import { website } from '$lib/info'
+
+// export const prerender = true
+
+// // make sure this matches your post route
+// const getPostUrl = (slug) => `${website}/post/${slug}`
+
+// /**
+// * @type {import('@sveltejs/kit').RequestHandler}
+// */
+// export async function GET({ setHeaders }) {
+// setHeaders({
+// 'Cache-Control': `max-age=0, s-max-age=600`,
+// 'Content-Type': 'application/xml'
+// })
+
+// const xml = `
+//
+//
+// ${website}
+// 1.0
+//
+
+// ${posts
+// .map(
+// (post) => `
+// ${getPostUrl(post.slug)}
+// ${
+// post.updated
+// ? new Date(post.updated).toISOString()
+// : new Date(post.date).toISOString()
+// }
+// monthly
+// 1.0
+// `
+// )
+// .join('')}
+// `
+
+// return new Response(xml)
+// }
diff --git a/top-sveltekit/postgres-rls/src/routes/terms/+page.md b/top-sveltekit/postgres-rls/src/routes/terms/+page.md
new file mode 100644
index 0000000..69ba217
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/terms/+page.md
@@ -0,0 +1,8 @@
+# Terms of Service
+
+No rights can be derived from the information provided on this website. Although the information on this website has been compiled with the utmost care and is regularly updated, the Netherlands eScience Center cannot guarantee that it is free of errors and always up to date. As such, the eScience Center cannot be held liable for any information that might contain errors or be outdated.
+All material is owned by the Netherlands eScience Center. Reproduction is permitted, except where otherwise stated, provided the source is acknowledged.
+Personal profile pages of eScience Center staff do not in any way constitute official eScience content. The views and opinions expressed are strictly those of the page authors.
+The Netherlands eScience Center does not guarantee that the website will function error-free or uninterrupted.
+The Netherlands eScience Center website contains links to various external sites. These links are provided for reference purposes only. The Netherlands eScience Center does not necessarily endorse or recommend any entities listed on this website, nor does it necessarily share the views expressed by them. The Netherlands eScience Center cannot be held liable for any damage, loss or injury that a person or organisation may suffer as a result of any dealing with an organisation or person reached via these web pages.
+The Netherlands eScience Center shall not be liable for any damages of any kind, including consequential or incidental damages, arising from the submission, installation, maintenance, transmission, copying, modification, distribution or use of any materials.
diff --git a/top-sveltekit/postgres-rls/static/favicon.png b/top-sveltekit/postgres-rls/static/favicon.png
new file mode 100644
index 0000000..7225aa2
Binary files /dev/null and b/top-sveltekit/postgres-rls/static/favicon.png differ
diff --git a/top-sveltekit/postgres-rls/static/image.png b/top-sveltekit/postgres-rls/static/image.png
new file mode 100644
index 0000000..0ce351b
Binary files /dev/null and b/top-sveltekit/postgres-rls/static/image.png differ
diff --git a/top-sveltekit/postgres-rls/static/images/about.webp b/top-sveltekit/postgres-rls/static/images/about.webp
new file mode 100644
index 0000000..a13c954
Binary files /dev/null and b/top-sveltekit/postgres-rls/static/images/about.webp differ
diff --git a/portfolio/src/lib/assets/images/ctw-jess-profile.avif b/top-sveltekit/postgres-rls/static/images/profile.avif
similarity index 100%
rename from portfolio/src/lib/assets/images/ctw-jess-profile.avif
rename to top-sveltekit/postgres-rls/static/images/profile.avif
diff --git a/top-sveltekit/postgres-rls/static/manifest.json b/top-sveltekit/postgres-rls/static/manifest.json
new file mode 100644
index 0000000..3154b05
--- /dev/null
+++ b/top-sveltekit/postgres-rls/static/manifest.json
@@ -0,0 +1,16 @@
+
+{
+ "name": "top-sveltekit",
+ "short_name": "top-sveltekit",
+ "start_url": "/",
+ "display": "standalone",
+ "background_color": "#000000",
+ "theme_color": "#000000",
+ "icons": [
+ {
+ "src": "favicon.png",
+ "sizes": "512x512",
+ "type": "image/png"
+ }
+ ]
+}
diff --git a/top-sveltekit/postgres-rls/svelte.config.js b/top-sveltekit/postgres-rls/svelte.config.js
new file mode 100644
index 0000000..7bc393f
--- /dev/null
+++ b/top-sveltekit/postgres-rls/svelte.config.js
@@ -0,0 +1,40 @@
+import path from 'path';
+// import adapter from '@sveltejs/adapter-node';
+import adapter from '@sveltejs/adapter-vercel';
+import { vitePreprocess } from '@sveltejs/vite-plugin-svelte';
+import { mdsvex } from "mdsvex";
+import mdsvexConfig from './mdsvex.config.js'
+
+
+/** @type {import('@sveltejs/kit').Config} */
+const config = {
+
+ // Consult https://kit.svelte.dev/docs/integrations#preprocessors
+ // for more information about preprocessors
+ preprocess: [
+ vitePreprocess(),
+ mdsvex(mdsvexConfig),
+ ],
+ // extensions: ['.svelte', '.md', '.svx'],
+ extensions: [
+ '.svelte',
+ ...mdsvexConfig.extensions
+ ],
+ kit: {
+ // https://kit.svelte.dev/docs/adapter-static
+ adapter: adapter({
+ // runtime: 'edge',
+ fallback: '200.html' // may differ from host to host
+ }),
+
+ alias: {
+ // these are the aliases and paths to them
+ $api: path.resolve('./src/api'),
+ $components: path.resolve('./src/lib/components'),
+ $assets: path.resolve('./src/assets'),
+ $content: path.resolve('./src/lib/content')
+ }
+ }
+};
+
+export default config;
diff --git a/top-sveltekit/postgres-rls/tailwind.config.js b/top-sveltekit/postgres-rls/tailwind.config.js
new file mode 100644
index 0000000..9990efb
--- /dev/null
+++ b/top-sveltekit/postgres-rls/tailwind.config.js
@@ -0,0 +1,91 @@
+import { de } from 'date-fns/locale'
+
+/** @type {import('tailwindcss').Config} */
+export default {
+ content: ['./src/**/*.{html,js,svelte,ts,md}'],
+ theme: {
+ extend: {
+ typography: {
+ DEFAULT: {
+ css: {
+ table: {
+ width: '100%',
+ overflowX: 'auto',
+ },
+
+ a: {
+ textDecoration: 'none',
+ '&:hover': {
+ textDecoration: 'underline',
+ },
+ },
+ },
+ },
+ },
+ }
+ },
+ plugins: [
+ require('daisyui'),
+ require('@tailwindcss/typography'),
+ require('@tailwindcss/forms'),
+ require('@tailwindcss/container-queries')
+ ],
+ daisyui: {
+ themes: [
+ {
+
+ ctw: {
+ primary: '#ffb83d',
+ 'primary-focus': '#db8b00',
+ 'primary-content': 'black',
+ secondary: '#5e9c91',
+ 'secondary-focus': '#3e655f',
+ 'secondary-content': '#FFFFFF',
+ accent: '#37cdbe',
+ 'accent-focus': '#2aa79b',
+ 'accent-content': '#FFFFFF',
+ neutral: '#3d4451',
+ 'neutral-focus': '#2a2e37',
+ 'neutral-content': '#ffffff',
+ 'base-100': '#171717',
+ 'base-200': '#333',
+ 'base-300': '#555',
+ 'base-content': '#E8E8E8',
+ info: '#2094f3',
+ success: '#009485',
+ warning: '#FF9900',
+ error: '#ff5724'
+ }
+ },
+ "dark",
+ "light",
+ "night",
+ "cupcake",
+ "bumblebee",
+ "emerald",
+ "corporate",
+ "synthwave",
+ "retro",
+ "cyberpunk",
+ "valentine",
+ "halloween",
+ "garden",
+ "forest",
+ "aqua",
+ "lofi",
+ "pastel",
+ "fantasy",
+ "wireframe",
+ "black",
+ "luxury",
+ "dracula",
+ "cmyk",
+ "autumn",
+ "business",
+ "acid",
+ "lemonade",
+ "coffee",
+ "winter",
+ ]
+ }
+};
diff --git a/top-sveltekit/postgres-rls/tsconfig.json b/top-sveltekit/postgres-rls/tsconfig.json
new file mode 100644
index 0000000..7b94a97
--- /dev/null
+++ b/top-sveltekit/postgres-rls/tsconfig.json
@@ -0,0 +1,20 @@
+{
+ "extends": "./.svelte-kit/tsconfig.json",
+ "compilerOptions": {
+ "allowJs": true,
+ "checkJs": true,
+ "esModuleInterop": true,
+ "forceConsistentCasingInFileNames": true,
+ "resolveJsonModule": true,
+ "skipLibCheck": true,
+ "sourceMap": true,
+ "strict": true,
+ "moduleResolution": "bundler",
+ "types": ["svelte", "unplugin-icons/types/svelte"]
+ }
+ // Path aliases are handled by https://kit.svelte.dev/docs/configuration#alias
+ // except $lib which is handled by https://kit.svelte.dev/docs/configuration#files
+ //
+ // If you want to overwrite includes/excludes, make sure to copy over the relevant includes/excludes
+ // from the referenced tsconfig.json - TypeScript does not merge them in
+}
diff --git a/top-sveltekit/postgres-rls/vercel.json b/top-sveltekit/postgres-rls/vercel.json
new file mode 100644
index 0000000..04f80f7
--- /dev/null
+++ b/top-sveltekit/postgres-rls/vercel.json
@@ -0,0 +1,3 @@
+{
+ "regions": ["fra1"]
+}
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/vite.config.ts b/top-sveltekit/postgres-rls/vite.config.ts
new file mode 100644
index 0000000..239721a
--- /dev/null
+++ b/top-sveltekit/postgres-rls/vite.config.ts
@@ -0,0 +1,26 @@
+import { sveltekit } from '@sveltejs/kit/vite';
+import { defineConfig } from 'vite';
+import { enhancedImages } from '@sveltejs/enhanced-img';
+import Icons from 'unplugin-icons/vite'
+
+import VitePluginRestart from 'vite-plugin-restart';
+import { viteStaticCopy } from 'vite-plugin-static-copy'
+
+
+export default defineConfig({
+ plugins: [
+ enhancedImages(),
+
+ VitePluginRestart({ restart: ['./content/**'] }),
+ viteStaticCopy({ targets: [{ src: './src/lib/content/*', dest: './content/' }] }),
+
+ sveltekit(),
+ Icons({
+ compiler: 'svelte',
+ autoInstall: true,
+ }),
+ ],
+ // optimizeDeps: {
+ // disabled: true,
+ // },
+});
diff --git a/portfolio/.env.example b/website/.env.example
similarity index 100%
rename from portfolio/.env.example
rename to website/.env.example
diff --git a/portfolio/.eslintignore b/website/.eslintignore
similarity index 100%
rename from portfolio/.eslintignore
rename to website/.eslintignore
diff --git a/website/.eslintrc.cjs b/website/.eslintrc.cjs
new file mode 100644
index 0000000..ebc1958
--- /dev/null
+++ b/website/.eslintrc.cjs
@@ -0,0 +1,30 @@
+module.exports = {
+ root: true,
+ extends: [
+ 'eslint:recommended',
+ 'plugin:@typescript-eslint/recommended',
+ 'plugin:svelte/recommended',
+ 'prettier'
+ ],
+ parser: '@typescript-eslint/parser',
+ plugins: ['@typescript-eslint'],
+ parserOptions: {
+ sourceType: 'module',
+ ecmaVersion: 2020,
+ extraFileExtensions: ['.svelte']
+ },
+ env: {
+ browser: true,
+ es2017: true,
+ node: true
+ },
+ overrides: [
+ {
+ files: ['*.svelte'],
+ parser: 'svelte-eslint-parser',
+ parserOptions: {
+ parser: '@typescript-eslint/parser'
+ }
+ }
+ ]
+};
diff --git a/portfolio/.gitignore b/website/.gitignore
similarity index 100%
rename from portfolio/.gitignore
rename to website/.gitignore
diff --git a/website/.npmrc b/website/.npmrc
new file mode 100644
index 0000000..b6f27f1
--- /dev/null
+++ b/website/.npmrc
@@ -0,0 +1 @@
+engine-strict=true
diff --git a/portfolio/.prettierignore b/website/.prettierignore
similarity index 100%
rename from portfolio/.prettierignore
rename to website/.prettierignore
diff --git a/portfolio/.prettierrc b/website/.prettierrc
similarity index 100%
rename from portfolio/.prettierrc
rename to website/.prettierrc
diff --git a/website/.vscode/launch.json b/website/.vscode/launch.json
new file mode 100644
index 0000000..95445ed
--- /dev/null
+++ b/website/.vscode/launch.json
@@ -0,0 +1,15 @@
+{
+ // Use IntelliSense to learn about possible attributes.
+ // Hover to view descriptions of existing attributes.
+ // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
+ "version": "0.2.0",
+ "configurations": [
+ {
+ "type": "chrome",
+ "request": "launch",
+ "name": "Launch Chrome against localhost",
+ "url": "http://localhost:5173",
+ "webRoot": "${workspaceFolder}"
+ }
+ ]
+}
\ No newline at end of file
diff --git a/portfolio/.vscode/settings.json b/website/.vscode/settings.json
similarity index 100%
rename from portfolio/.vscode/settings.json
rename to website/.vscode/settings.json
diff --git a/portfolio/README.md b/website/README.md
similarity index 100%
rename from portfolio/README.md
rename to website/README.md
diff --git a/portfolio/bun.lockb b/website/bun.lockb
similarity index 100%
rename from portfolio/bun.lockb
rename to website/bun.lockb
diff --git a/portfolio/mdsvex.config.js b/website/mdsvex.config.js
similarity index 100%
rename from portfolio/mdsvex.config.js
rename to website/mdsvex.config.js
diff --git a/portfolio/package.json b/website/package.json
similarity index 100%
rename from portfolio/package.json
rename to website/package.json
diff --git a/website/postcss.config.js b/website/postcss.config.js
new file mode 100644
index 0000000..0f77216
--- /dev/null
+++ b/website/postcss.config.js
@@ -0,0 +1,6 @@
+export default {
+ plugins: {
+ tailwindcss: {},
+ autoprefixer: {}
+ }
+};
diff --git a/website/src/app.d.ts b/website/src/app.d.ts
new file mode 100644
index 0000000..f59b884
--- /dev/null
+++ b/website/src/app.d.ts
@@ -0,0 +1,12 @@
+// See https://kit.svelte.dev/docs/types#app
+// for information about these interfaces
+declare global {
+ namespace App {
+ // interface Error {}
+ // interface Locals {}
+ // interface PageData {}
+ // interface Platform {}
+ }
+}
+
+export {};
diff --git a/portfolio/src/app.html b/website/src/app.html
similarity index 100%
rename from portfolio/src/app.html
rename to website/src/app.html
diff --git a/portfolio/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/+page.md b/website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/+page.md
similarity index 97%
rename from portfolio/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/+page.md
rename to website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/+page.md
index a0216c1..4c3ec50 100644
--- a/portfolio/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/+page.md
+++ b/website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/+page.md
@@ -7,7 +7,7 @@ categories:
tags:
- Design
- Web
-coverImage: images/cover.jpg
+coverImage: images/cover.avif
displayCover: true
---
diff --git a/website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/cover.avif b/website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/cover.avif
new file mode 100644
index 0000000..a02804b
Binary files /dev/null and b/website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/cover.avif differ
diff --git a/portfolio/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/cover.jpg b/website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/cover.jpg
similarity index 100%
rename from portfolio/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/cover.jpg
rename to website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/cover.jpg
diff --git a/portfolio/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/silvina1.jpg b/website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/silvina1.jpg
similarity index 100%
rename from portfolio/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/silvina1.jpg
rename to website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/silvina1.jpg
diff --git a/portfolio/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/silvina2.jpg b/website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/silvina2.jpg
similarity index 100%
rename from portfolio/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/silvina2.jpg
rename to website/src/content/2012-10-09-singer-silvina-magari-album-promotion-marketplace-design-implementation/images/silvina2.jpg
diff --git a/portfolio/src/content/2013-07-11-leaplearn/+page.md b/website/src/content/2013-07-11-leaplearn/+page.md
similarity index 85%
rename from portfolio/src/content/2013-07-11-leaplearn/+page.md
rename to website/src/content/2013-07-11-leaplearn/+page.md
index be8d6b1..670dd43 100644
--- a/portfolio/src/content/2013-07-11-leaplearn/+page.md
+++ b/website/src/content/2013-07-11-leaplearn/+page.md
@@ -3,13 +3,13 @@ published: true
title: LeapLearn
date: 2013-07-1
categories:
- - Project
+ - Research Project
tags:
- 3D-visualization
- JavaScript
- Threejs
- Web
-coverImage: images/leaplearn-cover.jpg
+coverImage: images/leaplearn-cover.avif
displayCover: true
---
+
+
%sveltekit.body%
+
+
+
\ No newline at end of file
diff --git a/top-sveltekit/pg-auth-electricsql/src/auth.ts b/top-sveltekit/pg-auth-electricsql/src/auth.ts
new file mode 100644
index 0000000..0692b5d
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/auth.ts
@@ -0,0 +1,64 @@
+import { SvelteKitAuth } from "@auth/sveltekit";
+import Google from "@auth/sveltekit/providers/google";
+import Credentials from "@auth/sveltekit/providers/credentials";
+import PostgresAdapter from "@auth/pg-adapter";
+import { pool } from "$lib/db/db";
+import type { CustomSession } from "./app";
+import bcrypt from 'bcrypt';
+import Resend from "@auth/sveltekit/providers/resend";
+
+export const { handle: handleAuth, signIn, signOut } = SvelteKitAuth({
+ trustHost: true,
+ adapter: PostgresAdapter(pool),
+ secret: process.env.AUTH_SECRET,
+ session: {
+ strategy: "jwt"
+ },
+ providers: [
+ Resend({
+ from: "top-sveltekit@ctwhome.com",
+ name: "Chat Diamond",
+ }),
+ Google,
+ Credentials({
+ name: 'Credentials',
+ async authorize(credentials) {
+ const { email, password } = credentials as { email: string; password: string };
+ if (!email || !password) return null;
+
+ const user = (await pool.query('SELECT * FROM users WHERE email = $1', [email])).rows[0];
+ if (!user || !await bcrypt.compare(password, user.password)) return null;
+
+ return {
+ id: user.id.toString(),
+ email: user.email,
+ name: user.name || null,
+ image: user.image || null
+ };
+ }
+ })
+ ],
+ callbacks: {
+ async jwt({ token, user }) {
+ if (user) {
+ // Get user data including role on initial sign in
+ const userData = (await pool.query('SELECT id, role FROM users WHERE id = $1', [user.id])).rows[0];
+ token.id = userData.id;
+ token.role = userData.role || 'user';
+ }
+ return token;
+ },
+ async session({ session, token }) {
+ if (!session?.user || !token) return session;
+
+ return {
+ ...session,
+ user: {
+ ...session.user,
+ id: token.id as string,
+ roles: [token.role as string] // Use role from JWT token
+ }
+ } as CustomSession;
+ }
+ }
+});
diff --git a/top-sveltekit/pg-auth-electricsql/src/hooks.server.ts b/top-sveltekit/pg-auth-electricsql/src/hooks.server.ts
new file mode 100644
index 0000000..b6eabf2
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/hooks.server.ts
@@ -0,0 +1,24 @@
+// https://kit.svelte.dev/docs/hooks
+import { sequence } from '@sveltejs/kit/hooks';
+import type { Handle } from '@sveltejs/kit';
+import { handleAuth } from "./auth";
+import { protectRoute } from '$lib/server/gatekeeper';
+
+// Sequence of middleware to run
+// 1. handleAuth - Handles authentication from @auth
+// 2. protectRoute - Our gatekeeper for RBAC (no role required by default)
+export const handle = sequence(handleAuth, protectRoute());
+
+// Example of how to protect specific routes with roles:
+// You can create additional middleware for specific routes like this:
+/*
+export const protectAdminRoutes: Handle = async ({ event, resolve }) => {
+ if (event.url.pathname.startsWith('/admin')) {
+ return protectRoute(Role.ADMIN)({ event, resolve });
+ }
+ return resolve(event);
+};
+
+// Then add it to the sequence:
+export const handle = sequence(handleAuth, protectRoute(), protectAdminRoutes);
+*/
diff --git a/portfolio/src/lib/actions/lazy-load.js b/top-sveltekit/pg-auth-electricsql/src/lib/actions/lazy-load.js
similarity index 100%
rename from portfolio/src/lib/actions/lazy-load.js
rename to top-sveltekit/pg-auth-electricsql/src/lib/actions/lazy-load.js
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/api.ts b/top-sveltekit/pg-auth-electricsql/src/lib/api.ts
new file mode 100644
index 0000000..758f16a
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/api.ts
@@ -0,0 +1,31 @@
+// API functions for top-sveltekit
+
+/**
+ * Sends an email with the given subject and content.
+ * @param subject The subject of the email
+ * @param content The content of the email
+ * @returns A promise that resolves with the result of the email sending process
+ */
+export async function sendEmail(subject: string, content: string): Promise<{ success: boolean; message: string }> {
+ try {
+ const response = await fetch('/api/sendEmail', {
+ method: 'POST',
+ headers: {
+ 'Content-Type': 'application/json',
+ },
+ body: JSON.stringify({ subject, content }),
+ });
+
+ if (!response.ok) {
+ const errorData = await response.json();
+ throw new Error(errorData.message || 'Failed to send email');
+ }
+
+ const result = await response.json();
+ console.log('Email sent successfully:', result);
+ return { success: true, message: 'Recieved loud and clear\n Thanks for your feedback!' };
+ } catch (error) {
+ console.error('Error sending email:', error);
+ return { success: false, message: error.message || 'Failed to send feedback' };
+ }
+}
\ No newline at end of file
diff --git a/portfolio/src/lib/assets/css/app.css b/top-sveltekit/pg-auth-electricsql/src/lib/assets/css/app.css
similarity index 100%
rename from portfolio/src/lib/assets/css/app.css
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/css/app.css
diff --git a/portfolio/src/lib/assets/css/code-highlighted-prisma.css b/top-sveltekit/pg-auth-electricsql/src/lib/assets/css/code-highlighted-prisma.css
similarity index 100%
rename from portfolio/src/lib/assets/css/code-highlighted-prisma.css
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/css/code-highlighted-prisma.css
diff --git a/portfolio/src/lib/assets/css/scrollbar-color.css b/top-sveltekit/pg-auth-electricsql/src/lib/assets/css/scrollbar-color.css
similarity index 100%
rename from portfolio/src/lib/assets/css/scrollbar-color.css
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/css/scrollbar-color.css
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/assets/icons/Logo.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/assets/icons/Logo.svelte
new file mode 100644
index 0000000..9a62bb6
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/assets/icons/Logo.svelte
@@ -0,0 +1,76 @@
+
+
+
diff --git a/portfolio/src/lib/assets/images/ctw-grey.svg b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/ctw-grey.svg
similarity index 100%
rename from portfolio/src/lib/assets/images/ctw-grey.svg
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/images/ctw-grey.svg
diff --git a/portfolio/src/lib/assets/images/ctw-jess-profile.jpg b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/ctw-jess-profile.jpg
similarity index 100%
rename from portfolio/src/lib/assets/images/ctw-jess-profile.jpg
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/images/ctw-jess-profile.jpg
diff --git a/portfolio/src/lib/assets/images/ctw.svg b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/ctw.svg
similarity index 100%
rename from portfolio/src/lib/assets/images/ctw.svg
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/images/ctw.svg
diff --git a/portfolio/src/lib/assets/images/ctwhome-profile.webp b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/ctwhome-profile.webp
similarity index 100%
rename from portfolio/src/lib/assets/images/ctwhome-profile.webp
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/images/ctwhome-profile.webp
diff --git a/portfolio/src/lib/assets/images/dev.svg b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/dev.svg
similarity index 100%
rename from portfolio/src/lib/assets/images/dev.svg
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/images/dev.svg
diff --git a/portfolio/src/lib/assets/images/digital-garden.svg b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/digital-garden.svg
similarity index 100%
rename from portfolio/src/lib/assets/images/digital-garden.svg
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/images/digital-garden.svg
diff --git a/portfolio/src/lib/assets/images/logo-small.svg b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/logo-small.svg
similarity index 100%
rename from portfolio/src/lib/assets/images/logo-small.svg
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/images/logo-small.svg
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/logo.svg b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/logo.svg
new file mode 100644
index 0000000..3613fc4
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/logo.svg
@@ -0,0 +1,11 @@
+
diff --git a/portfolio/src/lib/assets/images/product-design.svg b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/product-design.svg
similarity index 100%
rename from portfolio/src/lib/assets/images/product-design.svg
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/images/product-design.svg
diff --git a/portfolio/src/lib/assets/images/ux.svg b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/ux.svg
similarity index 100%
rename from portfolio/src/lib/assets/images/ux.svg
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/images/ux.svg
diff --git a/portfolio/src/lib/assets/images/web.svg b/top-sveltekit/pg-auth-electricsql/src/lib/assets/images/web.svg
similarity index 100%
rename from portfolio/src/lib/assets/images/web.svg
rename to top-sveltekit/pg-auth-electricsql/src/lib/assets/images/web.svg
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/Todo.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/Todo.svelte
new file mode 100644
index 0000000..33e3812
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/Todo.svelte
@@ -0,0 +1,83 @@
+
+
+
+
+
+ {#if $todoStore.loading}
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Analytics.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Analytics.svelte
new file mode 100644
index 0000000..bc4bad9
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Analytics.svelte
@@ -0,0 +1,30 @@
+
+
+
+
+
+ {:else if $todoStore.error}
+
+
+ {:else}
+
+ {#each $todoStore.todos as todo (todo.id)}
+
+ {/if}
+
+
+ {/each}
+
+ {#if $todoStore.todos.length === 0}
+
+
+
+ handleToggle(todo.id, todo.completed)}
+ class="checkbox"
+ />
+
+ {todo.title}
+
+
+
+ No todos yet. Add one above!
+ {/if}
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Carousel.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Carousel.svelte
new file mode 100644
index 0000000..8ecfff7
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Carousel.svelte
@@ -0,0 +1,63 @@
+
+
+
+ Input search with auto complete, defer and keyboard navigatio (WIP).
+
+
+
+
+
+ {#if showDropdown}
+ {#if searchValue}
+ -
+ {#each filteredOptions as option, i}
+
- + {option} + + {/each} +
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/GlobalToast.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/GlobalToast.svelte
new file mode 100644
index 0000000..7b96638
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/GlobalToast.svelte
@@ -0,0 +1,25 @@
+
+
+Image Carousel
+ {#each [gallery_items[currentSlideItem]] as item (currentSlideItem)} + + {/each} + +
+
+
+ {#if error}
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/LogOutButton.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/LogOutButton.svelte
new file mode 100644
index 0000000..05a21d5
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/LogOutButton.svelte
@@ -0,0 +1,10 @@
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/LoginButton.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/LoginButton.svelte
new file mode 100644
index 0000000..1f62921
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/LoginButton.svelte
@@ -0,0 +1,70 @@
+
+
+{error}
+ {/if}
+
+
+ {#if $page.data.session}
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/LoginForm.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/LoginForm.svelte
new file mode 100644
index 0000000..c7ba27d
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/LoginForm.svelte
@@ -0,0 +1,51 @@
+
+
+
+
+
+ {:else}
+
+ 
{
+ if (e.target instanceof HTMLImageElement) {
+ console.error('Image failed to load:', e.target.src);
+ e.target.onerror = null; // Prevent infinite loop
+ e.target.src = '/images/profile.avif';
+ }
+ }}
+ />
+
+
+
+
+
+ {/if}
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/MagicLinkForm.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/MagicLinkForm.svelte
new file mode 100644
index 0000000..fd7ea9e
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/MagicLinkForm.svelte
@@ -0,0 +1,64 @@
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/RegisterForm.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/RegisterForm.svelte
new file mode 100644
index 0000000..3c892b0
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/RegisterForm.svelte
@@ -0,0 +1,170 @@
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/types.ts b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/types.ts
new file mode 100644
index 0000000..8a220d6
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/types.ts
@@ -0,0 +1,22 @@
+export interface AuthResult {
+ ok?: boolean;
+ error?: string;
+ url?: string;
+ status?: number;
+}
+
+export interface RegisterResponse {
+ error?: string;
+ user?: {
+ id: string;
+ email: string;
+ name?: string;
+ };
+}
+
+export interface AuthError {
+ message: string;
+ code?: string;
+}
+
+export type AuthProvider = 'credentials' | 'google' | 'magic-link';
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/utils.ts b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/utils.ts
new file mode 100644
index 0000000..c79a726
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/Login/utils.ts
@@ -0,0 +1,32 @@
+import type { AuthError } from './types';
+
+export function closeLoginModal() {
+ const modalCheckbox = document.getElementById('login-modal') as HTMLInputElement;
+ if (modalCheckbox) {
+ modalCheckbox.checked = false;
+ }
+}
+
+export function getAuthErrorMessage(error: unknown): string {
+ if (typeof error === 'string') return error;
+ if (error && typeof error === 'object' && 'message' in error) {
+ return (error as AuthError).message;
+ }
+ return 'An unexpected error occurred';
+}
+
+export function validatePassword(password: string): string | null {
+ if (password.length < 8) {
+ return 'Password must be at least 8 characters long';
+ }
+ // Add more password validation rules as needed
+ return null;
+}
+
+export function validateEmail(email: string): string | null {
+ const emailRegex = /^[^\s@]+@[^\s@]+\.[^\s@]+$/;
+ if (!emailRegex.test(email)) {
+ return 'Please enter a valid email address';
+ }
+ return null;
+}
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/NativeFileApi.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/NativeFileApi.svelte
new file mode 100644
index 0000000..551a96a
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/NativeFileApi.svelte
@@ -0,0 +1,201 @@
+
+
+
++ {isRegistering ? 'Create Account' : 'Login Access'} +
+ +
+ {#if isRegistering}
+
+
+
+ {/if}
+
+ OR
+
+ {#if isRegistering}
+ Already have an account?
+
+ {:else}
+ Don't have an account?
+
+ {/if}
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/ProfilePicture.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/ProfilePicture.svelte
new file mode 100644
index 0000000..35f6868
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/ProfilePicture.svelte
@@ -0,0 +1,27 @@
+
+
+
+
+ Access to the native file system API
+ + + + + + + + + + + + +Open directory
+
+
+
+{JSON.stringify(numberFiles, null, 2)}
+ {#each Object.values(tree) as { name, handle }}
+ fileClicked(handle)}>
+ {name}
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ {/each}
+ {JSON.stringify(tree, null, 2)}
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/SEO.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/SEO.svelte
new file mode 100644
index 0000000..703f708
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/SEO.svelte
@@ -0,0 +1,21 @@
+
+
+J. Gonzalez - Ctw
+ {subtitle}
+
+
+ {@render children?.()}
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/feedback/FeedbackButton.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/feedback/FeedbackButton.svelte
new file mode 100644
index 0000000..ee7dcd5
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/feedback/FeedbackButton.svelte
@@ -0,0 +1,133 @@
+
+
+{#if showButton}
+
+{/if}
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/footerMain.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/footerMain.svelte
new file mode 100644
index 0000000..d568f69
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/footerMain.svelte
@@ -0,0 +1,73 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ Design
+ should have a meaning.
+
+ Engineering + should have a purpose. +
+ And ultimately, + Technology + should empower people. +
+ + Engineering + should have a purpose. +
+ And ultimately, + Technology + should empower people. +
+
+ Latest work
+
+
+
+
diff --git a/portfolio/src/lib/components/themeChamge/themes.json b/top-sveltekit/pg-auth-electricsql/src/lib/components/ui/themeChamge/themes.json
similarity index 100%
rename from portfolio/src/lib/components/themeChamge/themes.json
rename to top-sveltekit/pg-auth-electricsql/src/lib/components/ui/themeChamge/themes.json
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/content/README.md b/top-sveltekit/pg-auth-electricsql/src/lib/content/README.md
new file mode 100644
index 0000000..98dff1d
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/content/README.md
@@ -0,0 +1,22 @@
+# Instructions for the posts
+
+frontmatter variables:
+```yaml
+published: true
+title: Blog 1
+description: A description here
+date: 2024-01-01
+coverImage: image.avif
+displayCover: true # False to only show the cover in the list
+tags:
+ - tag 1
+ - tag 2
+
+layout: blog
+type: blog
+```
+
+## Very important notes
+
+> The images NEED to be inside the `./images/` folder to work
+> All image name MUST be unique!
\ No newline at end of file
diff --git a/portfolio/src/content/2024-04-26-the-future-of-image-and-video-format/images/cover.avif b/top-sveltekit/pg-auth-electricsql/src/lib/content/TEMPLATE/images/cover.avif
similarity index 100%
rename from portfolio/src/content/2024-04-26-the-future-of-image-and-video-format/images/cover.avif
rename to top-sveltekit/pg-auth-electricsql/src/lib/content/TEMPLATE/images/cover.avif
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/content/TEMPLATE/index.md b/top-sveltekit/pg-auth-electricsql/src/lib/content/TEMPLATE/index.md
new file mode 100644
index 0000000..0281886
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/content/TEMPLATE/index.md
@@ -0,0 +1,18 @@
+---
+published: true
+title: Title Template
+description: Description
+
+date: 2024-01-01
+
+coverImage: images/cover.avif
+displayCover: true
+tags:
+ - Tag
+categories:
+ - Blog
+ - Project
+layout: blog | project
+---
+### Copy this template
+
diff --git a/portfolio/src/content/content.ts b/top-sveltekit/pg-auth-electricsql/src/lib/content/content.ts
similarity index 100%
rename from portfolio/src/content/content.ts
rename to top-sveltekit/pg-auth-electricsql/src/lib/content/content.ts
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/db/db.ts b/top-sveltekit/pg-auth-electricsql/src/lib/db/db.ts
new file mode 100644
index 0000000..22b7c75
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/db/db.ts
@@ -0,0 +1,52 @@
+// src/lib/db.ts
+import { env } from "$env/dynamic/private"
+import pkg from 'pg';
+const { Pool } = pkg;
+
+export const pool = new Pool({
+ connectionString: env.DATABASE_URL,
+ ssl: env.DB_SSL === 'true',
+ max: Number(env.MAX_CLIENTS) || 20,
+ idleTimeoutMillis: Number(env.IDLE_TIMEOUT_MILLIS) || 30000,
+ connectionTimeoutMillis: Number(env.CONNECTION_TIMEOUT_MILLIS) || 2000
+});
+
+// Utility function to query the database
+export const query = (text: string, params?: any[]) => {
+ return pool.query(text, params);
+};
+
+// Close the pool gracefully when the application is shutting down
+process.on('SIGINT', () => {
+ pool.end(() => {
+ console.log('pg pool has ended');
+ process.exit(0);
+ });
+});
+
+// Utility function to query the database
+// using Parameterized queries, to avoid SQL injection
+// read more here: https://node-postgres.com/features/queries
+/**
+ *
+ * @param text SQL query
+ * @param params Parameters to be passed to the query
+ * @param auth Auth object from locals.auth()
+ * @returns json response
+ */
+export async function sql(text: string, params?: any[]) {
+ try {
+ const result = await query(text, params);
+ return result.rows;
+ }
+ catch (error) {
+ console.error('SQL function error:', error.message);
+ console.error('For query:', text);
+
+ if (error.message.includes('not extensible')) {
+ console.error('Object not extensible error. Params:', params);
+ console.error('Query text:', text);
+ }
+ throw error; // Re-throw the error to be handled by the caller
+ }
+};
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/markdown-layouts/blog.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/markdown-layouts/blog.svelte
new file mode 100644
index 0000000..32f4d4e
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/markdown-layouts/blog.svelte
@@ -0,0 +1,13 @@
+
+
+
+
+
+
+ Change theme
+
+
+
+
+
+ {#each themes as theme}
+
+
+
+ {/each}
+
+
+
+
+
+
+
+ {theme.id}
+
+
+
+
+
+
+
+
+ {@render children?.()}
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/markdown-layouts/default.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/markdown-layouts/default.svelte
new file mode 100644
index 0000000..d0dd642
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/markdown-layouts/default.svelte
@@ -0,0 +1,15 @@
+
+
+
+
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/markdown-layouts/project.svelte b/top-sveltekit/pg-auth-electricsql/src/lib/markdown-layouts/project.svelte
new file mode 100644
index 0000000..6cc41a1
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/markdown-layouts/project.svelte
@@ -0,0 +1,13 @@
+
+
+
+
+
+ {@render children?.()}
+
+
+ {@render children?.()}
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/models/menu-itmes.ts b/top-sveltekit/pg-auth-electricsql/src/lib/models/menu-itmes.ts
new file mode 100644
index 0000000..cdb5485
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/models/menu-itmes.ts
@@ -0,0 +1,10 @@
+export default [
+
+ { title: 'About', path: '/about', displayTitle: 'About' },
+
+ // {
+ // title: 'Latest Work',
+ // path: '/work',
+ // displayTitle: 'Latest Work'
+ // }
+];
diff --git a/portfolio/src/lib/models/status-enum.ts b/top-sveltekit/pg-auth-electricsql/src/lib/models/status-enum.ts
similarity index 100%
rename from portfolio/src/lib/models/status-enum.ts
rename to top-sveltekit/pg-auth-electricsql/src/lib/models/status-enum.ts
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/server/gatekeeper.ts b/top-sveltekit/pg-auth-electricsql/src/lib/server/gatekeeper.ts
new file mode 100644
index 0000000..39bda4b
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/server/gatekeeper.ts
@@ -0,0 +1,40 @@
+import type { Handle } from '@sveltejs/kit';
+import { error } from '@sveltejs/kit';
+
+import { Role } from '$lib/types';
+
+// Function to check if user has required role
+function hasRequiredRole(userRole: string, requiredRole: Role): boolean {
+ // Any authenticated user has USER role
+ if (requiredRole === Role.USER) {
+ return true;
+ }
+ return userRole === requiredRole;
+}
+
+// Middleware to protect routes based on role
+export const protectRoute = (requiredRole?: Role): Handle => {
+ return async ({ event, resolve }) => {
+ const session = await event.locals.getSession();
+
+ // If route requires authentication and user is not logged in
+ if (requiredRole && !session?.user?.id) {
+ throw error(401, 'Unauthorized');
+ }
+
+ if (session?.user) {
+ // Get role from session (set in JWT token)
+ const userRole = session.user.roles?.[0] || Role.USER;
+
+ // Check role if required
+ if (requiredRole && !hasRequiredRole(userRole, requiredRole)) {
+ throw error(403, 'Forbidden');
+ }
+
+ // Set role in locals for use in routes
+ event.locals.roles = [userRole];
+ }
+
+ return resolve(event);
+ };
+};
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/siteSettings.ts b/top-sveltekit/pg-auth-electricsql/src/lib/siteSettings.ts
new file mode 100644
index 0000000..06aad95
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/siteSettings.ts
@@ -0,0 +1,16 @@
+export const siteSettings = {
+ title: 'Ctwhome - Top Sveltekit',
+ description: 'Web Engineering - Projects and Portfolio of J. Gonzalez',
+ baseUrl: 'https://ctwhome.com',
+ twitterHandle: '@ctwhome',
+ facebookAppId: '1234567890',
+ image: '/images/og-image.jpg',
+ imageAlt: 'My site image',
+ siteName: 'My Site',
+ siteLocale: 'en_US',
+ siteLang: 'en',
+ siteDirection: 'ltr',
+ siteThemeColor: '#000000',
+ siteBackgroundColor: '#ffffff',
+ siteKeywords: 'Web engineering, Ctw, Ctw portfolio'
+}
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/stores/menu.store.ts b/top-sveltekit/pg-auth-electricsql/src/lib/stores/menu.store.ts
new file mode 100644
index 0000000..0797360
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/stores/menu.store.ts
@@ -0,0 +1,15 @@
+import { writable } from 'svelte/store';
+
+export const isMenuOpen = writable(false);
+
+export function toggleMenu() {
+ isMenuOpen.update(state => !state);
+}
+
+export function closeMenu() {
+ isMenuOpen.set(false);
+}
+
+export function openMenu() {
+ isMenuOpen.set(true);
+}
\ No newline at end of file
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/stores/toast.store.ts b/top-sveltekit/pg-auth-electricsql/src/lib/stores/toast.store.ts
new file mode 100644
index 0000000..ed188c0
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/stores/toast.store.ts
@@ -0,0 +1,30 @@
+import { writable } from 'svelte/store';
+import toast from 'svelte-french-toast';
+
+function createToastStore() {
+ const { subscribe, update } = writable({});
+
+ return {
+ subscribe,
+ success: (message: string) => {
+ update(() => {
+ toast.success(message, {
+ position: 'top-center',
+ duration: 5000
+ });
+ return {};
+ });
+ },
+ error: (message: string) => {
+ update(() => {
+ toast.error(message, {
+ position: 'top-center',
+ duration: 5000
+ });
+ return {};
+ });
+ }
+ };
+}
+
+export const toastStore = createToastStore();
\ No newline at end of file
diff --git a/top-sveltekit/pg-auth-electricsql/src/lib/stores/todoStore.ts b/top-sveltekit/pg-auth-electricsql/src/lib/stores/todoStore.ts
new file mode 100644
index 0000000..99819cc
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/lib/stores/todoStore.ts
@@ -0,0 +1,128 @@
+import { writable } from 'svelte/store';
+
+interface Todo {
+ id: string;
+ title: string;
+ completed: boolean;
+ user_id: string;
+ created_at: string;
+ updated_at: string;
+}
+
+interface TodoState {
+ todos: Todo[];
+ loading: boolean;
+ error: string | null;
+}
+
+function createTodoStore() {
+ const { subscribe, set, update } = writable
+
diff --git a/portfolio/src/routes/+layout.ts b/top-sveltekit/pg-auth-electricsql/src/routes/+layout.ts
similarity index 100%
rename from portfolio/src/routes/+layout.ts
rename to top-sveltekit/pg-auth-electricsql/src/routes/+layout.ts
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/+page.svelte b/top-sveltekit/pg-auth-electricsql/src/routes/+page.svelte
new file mode 100644
index 0000000..5dadc0b
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/+page.svelte
@@ -0,0 +1,24 @@
+
+
+{#if $page.data.session}
+
+ dev database
+
+ {/if}
+
+
+{/if}
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/about/+page.md b/top-sveltekit/pg-auth-electricsql/src/routes/about/+page.md
new file mode 100644
index 0000000..f087354
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/about/+page.md
@@ -0,0 +1,30 @@
+---
+# layout: blog
+---
+
+
+
+
+
+
+
+
+ Top-sveltekit
++ Experience the power of advanced AI assistants in a native-like app interface. +
+ +
+
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/api/admin/users/+server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/api/admin/users/+server.ts
new file mode 100644
index 0000000..9a7d0c0
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/api/admin/users/+server.ts
@@ -0,0 +1,32 @@
+import { json, error } from '@sveltejs/kit';
+import { pool } from '$lib/db/db';
+import { Role } from '$lib/types';
+import type { RequestEvent } from './$types';
+
+export async function GET({ locals }: RequestEvent) {
+ const session = await locals.getSession();
+ if (!session?.user?.id) {
+ throw error(401, 'Unauthorized');
+ }
+
+ const userRole = session.user.roles?.[0];
+ if (userRole !== Role.ADMIN) {
+ throw error(403, 'Forbidden');
+ }
+
+ try {
+ const result = await pool.query(`
+ SELECT
+ id,
+ email,
+ name,
+ ARRAY[role] as roles
+ FROM users
+ ORDER BY id
+ `);
+
+ return json(result.rows);
+ } catch (err) {
+ throw error(500, 'Failed to fetch users');
+ }
+}
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/api/admin/users/[userId]/roles/+server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/api/admin/users/[userId]/roles/+server.ts
new file mode 100644
index 0000000..2c850a7
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/api/admin/users/[userId]/roles/+server.ts
@@ -0,0 +1,47 @@
+import { json, error } from '@sveltejs/kit';
+import { pool } from '$lib/db/db';
+import { Role } from '$lib/types';
+import type { RequestEvent } from './$types';
+
+export async function PUT({ locals, params, request }: RequestEvent) {
+ const session = await locals.getSession();
+ if (!session?.user?.id) {
+ throw error(401, 'Unauthorized');
+ }
+
+ const userRole = session.user.roles?.[0];
+ if (userRole !== Role.ADMIN) {
+ throw error(403, 'Forbidden');
+ }
+
+ const userId = params.userId;
+ const { role: newRole, action } = await request.json();
+ console.log('Updating role:', { userId, newRole, action });
+
+ try {
+ // Update the user's role
+ if (action === 'add') {
+ await pool.query(
+ 'UPDATE users SET role = $1 WHERE id = $2',
+ [newRole, userId]
+ );
+ } else if (action === 'remove') {
+ await pool.query(
+ 'UPDATE users SET role = $1 WHERE id = $2',
+ [Role.USER, userId]
+ );
+ }
+
+ // Log the result
+ const updatedUser = await pool.query(
+ 'SELECT id, email, role FROM users WHERE id = $1',
+ [userId]
+ );
+ console.log('Updated user:', updatedUser.rows[0]);
+
+ return json({ success: true });
+ } catch (err) {
+ console.error('Error updating user role:', err);
+ throw error(500, 'Failed to update user role');
+ }
+}
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/api/register/+server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/api/register/+server.ts
new file mode 100644
index 0000000..0b35173
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/api/register/+server.ts
@@ -0,0 +1,30 @@
+import { json } from '@sveltejs/kit';
+import type { RequestHandler } from './$types';
+import { pool } from '$lib/db/db';
+import bcrypt from 'bcrypt';
+
+export const POST: RequestHandler = async ({ request }) => {
+ const { email, password } = await request.json();
+
+ try {
+ // Check if user already exists
+ const existingUser = await pool.query('SELECT * FROM users WHERE email = $1', [email]);
+ if (existingUser.rows.length > 0) {
+ return json({ error: 'User already exists' }, { status: 400 });
+ }
+
+ // Hash the password
+ const hashedPassword = await bcrypt.hash(password, 10);
+
+ // Insert new user
+ const result = await pool.query(
+ 'INSERT INTO users (email, password) VALUES ($1, $2) RETURNING id, email',
+ [email, hashedPassword]
+ );
+
+ return json({ user: result.rows[0] });
+ } catch (error) {
+ console.error('Registration error:', error);
+ return json({ error: 'An error occurred during registration' }, { status: 500 });
+ }
+};
\ No newline at end of file
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/api/sendEmail/+server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/api/sendEmail/+server.ts
new file mode 100644
index 0000000..8c476cb
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/api/sendEmail/+server.ts
@@ -0,0 +1,40 @@
+import type { RequestHandler } from '@sveltejs/kit';
+import { env } from '$env/dynamic/private';
+import { json } from '@sveltejs/kit';
+
+const AUTH_RESEND_KEY = env.AUTH_RESEND_KEY;
+
+export const POST: RequestHandler = async ({ request }) => {
+ const { subject, content } = await request.json();
+ const html = `
+ ${content}
+ `;
+
+ try {
+ const response = await fetch('https://api.resend.com/emails', {
+ method: 'POST',
+ headers: {
+ Authorization: 'Bearer ' + AUTH_RESEND_KEY,
+ 'Content-Type': 'application/json',
+ },
+ body: JSON.stringify({
+ from: 'feedback-top-sveltekit@ctwhome.com',
+ to: 'ctw@ctwhome.com', // Replace with your support email
+ subject: subject,
+ html: html,
+ }),
+ });
+
+ if (!response.ok) {
+ const errorDetails = await response.json();
+ throw new Error(`Network response was not ok: ${JSON.stringify(errorDetails)}`);
+ }
+
+ const data = await response.json();
+ console.log('Feedback email sent successfully:', data);
+ return json({ success: true, message: 'Feedback sent successfully' });
+ } catch (error) {
+ console.error('Error sending feedback email:', error);
+ return json({ success: false, message: 'Failed to send feedback: ' + error.message }, { status: 500 });
+ }
+}
\ No newline at end of file
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/api/todos/+server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/api/todos/+server.ts
new file mode 100644
index 0000000..08fa798
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/api/todos/+server.ts
@@ -0,0 +1,44 @@
+import { json } from '@sveltejs/kit';
+import type { RequestHandler } from './$types';
+import { query } from '$lib/db/db';
+
+export const GET: RequestHandler = async ({ locals }) => {
+ const session = await locals.getSession();
+ if (!session) {
+ return new Response('Unauthorized', { status: 401 });
+ }
+
+ try {
+ const todos = await query(
+ 'SELECT * FROM todos WHERE user_id = $1 ORDER BY created_at DESC',
+ [session.user.id]
+ );
+ return json(todos.rows);
+ } catch (error) {
+ console.error('Error fetching todos:', error);
+ return new Response('Internal Server Error', { status: 500 });
+ }
+};
+
+export const POST: RequestHandler = async ({ request, locals }) => {
+ const session = await locals.getSession();
+ if (!session) {
+ return new Response('Unauthorized', { status: 401 });
+ }
+
+ try {
+ const { title } = await request.json();
+ if (!title) {
+ return new Response('Title is required', { status: 400 });
+ }
+
+ const result = await query(
+ 'INSERT INTO todos (title, user_id) VALUES ($1, $2) RETURNING *',
+ [title, session.user.id]
+ );
+ return json(result.rows[0]);
+ } catch (error) {
+ console.error('Error creating todo:', error);
+ return new Response('Internal Server Error', { status: 500 });
+ }
+};
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/api/todos/[id]/+server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/api/todos/[id]/+server.ts
new file mode 100644
index 0000000..356a993
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/api/todos/[id]/+server.ts
@@ -0,0 +1,54 @@
+import { json } from '@sveltejs/kit';
+import type { RequestHandler } from './$types';
+import { query } from '$lib/db/db';
+
+export const PATCH: RequestHandler = async ({ params, request, locals }) => {
+ const session = await locals.getSession();
+ if (!session) {
+ return new Response('Unauthorized', { status: 401 });
+ }
+
+ try {
+ const { completed } = await request.json();
+ if (typeof completed !== 'boolean') {
+ return new Response('Invalid completed value', { status: 400 });
+ }
+
+ const result = await query(
+ 'UPDATE todos SET completed = $1 WHERE id = $2 AND user_id = $3 RETURNING *',
+ [completed, params.id, session.user.id]
+ );
+
+ if (result.rows.length === 0) {
+ return new Response('Todo not found', { status: 404 });
+ }
+
+ return json(result.rows[0]);
+ } catch (error) {
+ console.error('Error updating todo:', error);
+ return new Response('Internal Server Error', { status: 500 });
+ }
+};
+
+export const DELETE: RequestHandler = async ({ params, locals }) => {
+ const session = await locals.getSession();
+ if (!session) {
+ return new Response('Unauthorized', { status: 401 });
+ }
+
+ try {
+ const result = await query(
+ 'DELETE FROM todos WHERE id = $1 AND user_id = $2 RETURNING id',
+ [params.id, session.user.id]
+ );
+
+ if (result.rows.length === 0) {
+ return new Response('Todo not found', { status: 404 });
+ }
+
+ return new Response(null, { status: 204 });
+ } catch (error) {
+ console.error('Error deleting todo:', error);
+ return new Response('Internal Server Error', { status: 500 });
+ }
+};
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/api/user/api-key/+server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/api/user/api-key/+server.ts
new file mode 100644
index 0000000..3627b49
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/api/user/api-key/+server.ts
@@ -0,0 +1,27 @@
+import { json } from '@sveltejs/kit';
+import type { RequestHandler } from './$types';
+
+// In a real application, you would store this in a database
+let userApiKeys: Record
+
+
+ {#if loading}
+ User Management
+{users.length} Users
+
+
+
+ {:else if error}
+
+ {error}
+
+ {:else}
+
+
+
+
+
+ {/if}
+| ID | +User | +Roles | +|
|---|---|---|---|
| {user.id} | +
+ |
+ {user.email} | +
+
+
+
+
+ {#if user.roles.includes(Role.ADMIN)}
+
+
+
+ {:else}
+
+
+ {/if}
+ |
+
+
diff --git a/portfolio/src/routes/contact/+page.server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/contact/+page.server.ts
similarity index 100%
rename from portfolio/src/routes/contact/+page.server.ts
rename to top-sveltekit/pg-auth-electricsql/src/routes/contact/+page.server.ts
diff --git a/portfolio/src/routes/contact/+page.svelte b/top-sveltekit/pg-auth-electricsql/src/routes/contact/+page.svelte
similarity index 80%
rename from portfolio/src/routes/contact/+page.svelte
rename to top-sveltekit/pg-auth-electricsql/src/routes/contact/+page.svelte
index 4b5011f..47baa87 100644
--- a/portfolio/src/routes/contact/+page.svelte
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/contact/+page.svelte
@@ -1,5 +1,5 @@
-
diff --git a/portfolio/src/routes/privacy/+page.md b/top-sveltekit/pg-auth-electricsql/src/routes/privacy/+page.md
similarity index 100%
rename from portfolio/src/routes/privacy/+page.md
rename to top-sveltekit/pg-auth-electricsql/src/routes/privacy/+page.md
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/profile/+page.svelte b/top-sveltekit/pg-auth-electricsql/src/routes/profile/+page.svelte
new file mode 100644
index 0000000..cab0097
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/profile/+page.svelte
@@ -0,0 +1,25 @@
+
+
+
+
+
+
+
+ Sign in to your account
+Or start your 14-day free trial
+
+
+
+
+ OR
+
+ {#if $page.data.session}
+
diff --git a/top-sveltekit/pg-auth-electricsql/src/routes/profile/UserInfo.svelte b/top-sveltekit/pg-auth-electricsql/src/routes/profile/UserInfo.svelte
new file mode 100644
index 0000000..b59216c
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/src/routes/profile/UserInfo.svelte
@@ -0,0 +1,43 @@
+
+
+{JSON.stringify($page.data.session, null, 2)}
+ {:else}
+ Not logged in
+ {/if}
+
+
diff --git a/portfolio/src/routes/rss.xml/+server.ts b/top-sveltekit/pg-auth-electricsql/src/routes/rss.xml/+server.ts
similarity index 100%
rename from portfolio/src/routes/rss.xml/+server.ts
rename to top-sveltekit/pg-auth-electricsql/src/routes/rss.xml/+server.ts
diff --git a/portfolio/src/routes/sitemap.xml/+server.js b/top-sveltekit/pg-auth-electricsql/src/routes/sitemap.xml/+server.js
similarity index 100%
rename from portfolio/src/routes/sitemap.xml/+server.js
rename to top-sveltekit/pg-auth-electricsql/src/routes/sitemap.xml/+server.js
diff --git a/portfolio/src/routes/terms/+page.md b/top-sveltekit/pg-auth-electricsql/src/routes/terms/+page.md
similarity index 100%
rename from portfolio/src/routes/terms/+page.md
rename to top-sveltekit/pg-auth-electricsql/src/routes/terms/+page.md
diff --git a/portfolio/static/favicon.png b/top-sveltekit/pg-auth-electricsql/static/favicon.png
similarity index 100%
rename from portfolio/static/favicon.png
rename to top-sveltekit/pg-auth-electricsql/static/favicon.png
diff --git a/top-sveltekit/pg-auth-electricsql/static/image.png b/top-sveltekit/pg-auth-electricsql/static/image.png
new file mode 100644
index 0000000..0ce351b
Binary files /dev/null and b/top-sveltekit/pg-auth-electricsql/static/image.png differ
diff --git a/portfolio/static/images/about.webp b/top-sveltekit/pg-auth-electricsql/static/images/about.webp
similarity index 100%
rename from portfolio/static/images/about.webp
rename to top-sveltekit/pg-auth-electricsql/static/images/about.webp
diff --git a/portfolio/static/images/profile.avif b/top-sveltekit/pg-auth-electricsql/static/images/profile.avif
similarity index 100%
rename from portfolio/static/images/profile.avif
rename to top-sveltekit/pg-auth-electricsql/static/images/profile.avif
diff --git a/top-sveltekit/pg-auth-electricsql/static/manifest.json b/top-sveltekit/pg-auth-electricsql/static/manifest.json
new file mode 100644
index 0000000..3154b05
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/static/manifest.json
@@ -0,0 +1,16 @@
+
+{
+ "name": "top-sveltekit",
+ "short_name": "top-sveltekit",
+ "start_url": "/",
+ "display": "standalone",
+ "background_color": "#000000",
+ "theme_color": "#000000",
+ "icons": [
+ {
+ "src": "favicon.png",
+ "sizes": "512x512",
+ "type": "image/png"
+ }
+ ]
+}
diff --git a/top-sveltekit/pg-auth-electricsql/svelte.config.js b/top-sveltekit/pg-auth-electricsql/svelte.config.js
new file mode 100644
index 0000000..7bc393f
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/svelte.config.js
@@ -0,0 +1,40 @@
+import path from 'path';
+// import adapter from '@sveltejs/adapter-node';
+import adapter from '@sveltejs/adapter-vercel';
+import { vitePreprocess } from '@sveltejs/vite-plugin-svelte';
+import { mdsvex } from "mdsvex";
+import mdsvexConfig from './mdsvex.config.js'
+
+
+/** @type {import('@sveltejs/kit').Config} */
+const config = {
+
+ // Consult https://kit.svelte.dev/docs/integrations#preprocessors
+ // for more information about preprocessors
+ preprocess: [
+ vitePreprocess(),
+ mdsvex(mdsvexConfig),
+ ],
+ // extensions: ['.svelte', '.md', '.svx'],
+ extensions: [
+ '.svelte',
+ ...mdsvexConfig.extensions
+ ],
+ kit: {
+ // https://kit.svelte.dev/docs/adapter-static
+ adapter: adapter({
+ // runtime: 'edge',
+ fallback: '200.html' // may differ from host to host
+ }),
+
+ alias: {
+ // these are the aliases and paths to them
+ $api: path.resolve('./src/api'),
+ $components: path.resolve('./src/lib/components'),
+ $assets: path.resolve('./src/assets'),
+ $content: path.resolve('./src/lib/content')
+ }
+ }
+};
+
+export default config;
diff --git a/top-sveltekit/pg-auth-electricsql/tailwind.config.js b/top-sveltekit/pg-auth-electricsql/tailwind.config.js
new file mode 100644
index 0000000..9990efb
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/tailwind.config.js
@@ -0,0 +1,91 @@
+import { de } from 'date-fns/locale'
+
+/** @type {import('tailwindcss').Config} */
+export default {
+ content: ['./src/**/*.{html,js,svelte,ts,md}'],
+ theme: {
+ extend: {
+ typography: {
+ DEFAULT: {
+ css: {
+ table: {
+ width: '100%',
+ overflowX: 'auto',
+ },
+
+ a: {
+ textDecoration: 'none',
+ '&:hover': {
+ textDecoration: 'underline',
+ },
+ },
+ },
+ },
+ },
+ }
+ },
+ plugins: [
+ require('daisyui'),
+ require('@tailwindcss/typography'),
+ require('@tailwindcss/forms'),
+ require('@tailwindcss/container-queries')
+ ],
+ daisyui: {
+ themes: [
+ {
+
+ ctw: {
+ primary: '#ffb83d',
+ 'primary-focus': '#db8b00',
+ 'primary-content': 'black',
+ secondary: '#5e9c91',
+ 'secondary-focus': '#3e655f',
+ 'secondary-content': '#FFFFFF',
+ accent: '#37cdbe',
+ 'accent-focus': '#2aa79b',
+ 'accent-content': '#FFFFFF',
+ neutral: '#3d4451',
+ 'neutral-focus': '#2a2e37',
+ 'neutral-content': '#ffffff',
+ 'base-100': '#171717',
+ 'base-200': '#333',
+ 'base-300': '#555',
+ 'base-content': '#E8E8E8',
+ info: '#2094f3',
+ success: '#009485',
+ warning: '#FF9900',
+ error: '#ff5724'
+ }
+ },
+ "dark",
+ "light",
+ "night",
+ "cupcake",
+ "bumblebee",
+ "emerald",
+ "corporate",
+ "synthwave",
+ "retro",
+ "cyberpunk",
+ "valentine",
+ "halloween",
+ "garden",
+ "forest",
+ "aqua",
+ "lofi",
+ "pastel",
+ "fantasy",
+ "wireframe",
+ "black",
+ "luxury",
+ "dracula",
+ "cmyk",
+ "autumn",
+ "business",
+ "acid",
+ "lemonade",
+ "coffee",
+ "winter",
+ ]
+ }
+};
diff --git a/portfolio/tsconfig.json b/top-sveltekit/pg-auth-electricsql/tsconfig.json
similarity index 100%
rename from portfolio/tsconfig.json
rename to top-sveltekit/pg-auth-electricsql/tsconfig.json
diff --git a/top-sveltekit/pg-auth-electricsql/vercel.json b/top-sveltekit/pg-auth-electricsql/vercel.json
new file mode 100644
index 0000000..04f80f7
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/vercel.json
@@ -0,0 +1,3 @@
+{
+ "regions": ["fra1"]
+}
\ No newline at end of file
diff --git a/top-sveltekit/pg-auth-electricsql/vite.config.ts b/top-sveltekit/pg-auth-electricsql/vite.config.ts
new file mode 100644
index 0000000..c6c6a83
--- /dev/null
+++ b/top-sveltekit/pg-auth-electricsql/vite.config.ts
@@ -0,0 +1,25 @@
+import { sveltekit } from '@sveltejs/kit/vite';
+import { defineConfig } from 'vite';
+import { enhancedImages } from '@sveltejs/enhanced-img';
+import Icons from 'unplugin-icons/vite'
+
+import VitePluginRestart from 'vite-plugin-restart';
+import { viteStaticCopy } from 'vite-plugin-static-copy'
+
+
+export default defineConfig({
+ plugins: [
+ enhancedImages(),
+
+ VitePluginRestart({ restart: ['./content/**'] }),
+ viteStaticCopy({ targets: [{ src: './src/lib/content/*', dest: './content/' }] }),
+
+ sveltekit(),
+ Icons({
+ compiler: 'svelte',
+ }),
+ ],
+ // optimizeDeps: {
+ // disabled: true,
+ // },
+});
diff --git a/top-sveltekit/postgres-rls/.eslintignore b/top-sveltekit/postgres-rls/.eslintignore
new file mode 100644
index 0000000..e6d91c5
--- /dev/null
+++ b/top-sveltekit/postgres-rls/.eslintignore
@@ -0,0 +1,14 @@
+.DS_Store
+node_modules
+/build
+/.svelte-kit
+/package
+.env
+.env.*
+!.env.example
+
+# Ignore files for PNPM, NPM and YARN
+pnpm-lock.yaml
+package-lock.json
+yarn.lock
+*.sql
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/.eslintrc.cjs b/top-sveltekit/postgres-rls/.eslintrc.cjs
new file mode 100644
index 0000000..ebc1958
--- /dev/null
+++ b/top-sveltekit/postgres-rls/.eslintrc.cjs
@@ -0,0 +1,30 @@
+module.exports = {
+ root: true,
+ extends: [
+ 'eslint:recommended',
+ 'plugin:@typescript-eslint/recommended',
+ 'plugin:svelte/recommended',
+ 'prettier'
+ ],
+ parser: '@typescript-eslint/parser',
+ plugins: ['@typescript-eslint'],
+ parserOptions: {
+ sourceType: 'module',
+ ecmaVersion: 2020,
+ extraFileExtensions: ['.svelte']
+ },
+ env: {
+ browser: true,
+ es2017: true,
+ node: true
+ },
+ overrides: [
+ {
+ files: ['*.svelte'],
+ parser: 'svelte-eslint-parser',
+ parserOptions: {
+ parser: '@typescript-eslint/parser'
+ }
+ }
+ ]
+};
diff --git a/top-sveltekit/postgres-rls/.gitignore b/top-sveltekit/postgres-rls/.gitignore
new file mode 100644
index 0000000..0aa14da
--- /dev/null
+++ b/top-sveltekit/postgres-rls/.gitignore
@@ -0,0 +1,19 @@
+.DS_Store
+node_modules
+/build
+/dist
+/.svelte-kit
+/package
+.env
+.env.*
+!.env.example
+vite.config.js.timestamp-*
+vite.config.ts.timestamp-*
+.history
+.vercel
+.jampack
+.idea
+firebase-debug.log
+firestore-emulator-data
+data
+logs
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/.npmrc b/top-sveltekit/postgres-rls/.npmrc
new file mode 100644
index 0000000..b6f27f1
--- /dev/null
+++ b/top-sveltekit/postgres-rls/.npmrc
@@ -0,0 +1 @@
+engine-strict=true
diff --git a/top-sveltekit/postgres-rls/.pnpm-debug.log b/top-sveltekit/postgres-rls/.pnpm-debug.log
new file mode 100644
index 0000000..30f3a4c
--- /dev/null
+++ b/top-sveltekit/postgres-rls/.pnpm-debug.log
@@ -0,0 +1,22 @@
+{
+ "0 debug pnpm:scope": {
+ "selected": 1
+ },
+ "1 error pnpm": {
+ "code": "ELIFECYCLE",
+ "errno": "ENOENT",
+ "syscall": "spawn",
+ "file": "sh",
+ "pkgid": "top-sveltekit@0.0.1",
+ "stage": "build",
+ "script": "vite build",
+ "pkgname": "top-sveltekit",
+ "err": {
+ "name": "pnpm",
+ "message": "top-sveltekit@0.0.1 build: `vite build`\nspawn ENOENT",
+ "code": "ELIFECYCLE",
+ "stack": "pnpm: top-sveltekit@0.0.1 build: `vite build`\nspawn ENOENT\n at ChildProcess.
+
+
+
+
+
+
+ {
+ if (e.target instanceof HTMLImageElement) {
+ console.error('Image failed to load:', e.target.src);
+ e.target.onerror = null; // Prevent infinite loop
+ e.target.src = '/images/profile.avif';
+ }
+ }}
+ />
+
+
+
+
+
+
+
+
+
+
+ {$page.data?.session?.user?.name ||
+ $page.data?.session?.user?.email?.split('@')[0] ||
+ 'User'}
+
+
+ {$page.data?.session?.user?.email || ''}
+
+ %sveltekit.body%
+
+
+
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/auth.ts b/top-sveltekit/postgres-rls/src/auth.ts
new file mode 100644
index 0000000..894c3a9
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/auth.ts
@@ -0,0 +1,55 @@
+import { SvelteKitAuth } from "@auth/sveltekit";
+import Google from "@auth/sveltekit/providers/google";
+import Credentials from "@auth/sveltekit/providers/credentials";
+import PostgresAdapter from "@auth/pg-adapter";
+import { pool } from "$lib/db/db";
+
+import bcrypt from 'bcrypt';
+import Resend from "@auth/sveltekit/providers/resend";
+
+export const { handle: handleAuth, signIn, signOut } = SvelteKitAuth({
+ trustHost: true,
+ adapter: PostgresAdapter(pool),
+ secret: process.env.AUTH_SECRET,
+ providers: [
+ Resend({
+ from: "top-sveltekit@ctwhome.com",
+ name: "Chat Diamond",
+ }),
+ Google,
+ Credentials({
+ name: 'Credentials',
+ async authorize(credentials) {
+ // console.log('🎹 authorize credentials');
+ const { email, password } = credentials;
+ const result = await pool.query('SELECT * FROM users WHERE email = $1', [email]);
+ const user = result.rows[0];
+ if (user) {
+ const isValid = await bcrypt.compare(password, user.password);
+ if (isValid) {
+ console.log('User authorized', user);
+ return { id: user.id, email: user.email };
+ }
+ }
+ console.log('User authorization failed');
+ return null;
+ }
+ })
+ ],
+ callbacks: {
+ async session({ session, user }) {
+ if (user) {
+ session.user.id = user.id;
+ session.user.email = user.email;
+ }
+ return session;
+ },
+ async signIn({ user }) {
+ // console.log('🎹 signIn');
+ if (user) {
+ return true;
+ }
+ return false;
+ },
+ }
+});
diff --git a/top-sveltekit/postgres-rls/src/hooks.server.ts b/top-sveltekit/postgres-rls/src/hooks.server.ts
new file mode 100644
index 0000000..4da49ad
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/hooks.server.ts
@@ -0,0 +1,22 @@
+// https://kit.svelte.dev/docs/hooks
+import { env } from '$env/dynamic/private';
+import { sequence } from '@sveltejs/kit/hooks';
+import type { Handle } from '@sveltejs/kit';
+import { handleAuth } from "./auth";
+import { pool } from "$lib/db/db";
+
+// Initialize the database connection
+// console.log('🎹 DATABASE_URL', env.DATABASE_URL, env.DB_USER);
+
+// Set the app.user_id in the database to enable row level security
+const setAppUser: Handle = async ({ event, resolve }) => {
+ const session = await event.locals.getSession();
+ if (session?.user?.id) {
+ await pool.query('SELECT set_app_user($1)', [session.user.id]);
+ } else {
+ await pool.query('SELECT set_app_user(NULL)');
+ }
+ return resolve(event);
+}
+
+export const handle = sequence(handleAuth, setAppUser);
diff --git a/top-sveltekit/postgres-rls/src/lib/actions/lazy-load.js b/top-sveltekit/postgres-rls/src/lib/actions/lazy-load.js
new file mode 100644
index 0000000..169ede0
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/actions/lazy-load.js
@@ -0,0 +1,32 @@
+// See how the options work here: https://developer.mozilla.org/en-US/docs/Web/API/Intersection_Observer_API
+let options = {
+ root: null,
+ rootMargin: '0px',
+ threshold: 0
+};
+
+export const lazyLoad = (image, src) => {
+ const loaded = () => {
+ //image.classList.add('visible') // doesn't work in REPL
+ image.style.opacity = '1'; // REPL hack to apply loading animation
+ };
+ const observer = new IntersectionObserver((entries) => {
+ if (entries[0].isIntersecting) {
+ console.log('an image has loaded'); // console log for REPL
+ image.src = src; // replace placeholder src with the image src on observe
+ if (image.complete) {
+ // check if instantly loaded
+ loaded();
+ } else {
+ image.addEventListener('load', loaded); // if the image isn't loaded yet, add an event listener
+ }
+ }
+ }, options);
+ observer.observe(image); // intersection observer
+
+ return {
+ destroy() {
+ image.removeEventListener('load', loaded); // clean up the event listener
+ }
+ };
+};
diff --git a/top-sveltekit/postgres-rls/src/lib/api.ts b/top-sveltekit/postgres-rls/src/lib/api.ts
new file mode 100644
index 0000000..758f16a
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/api.ts
@@ -0,0 +1,31 @@
+// API functions for top-sveltekit
+
+/**
+ * Sends an email with the given subject and content.
+ * @param subject The subject of the email
+ * @param content The content of the email
+ * @returns A promise that resolves with the result of the email sending process
+ */
+export async function sendEmail(subject: string, content: string): Promise<{ success: boolean; message: string }> {
+ try {
+ const response = await fetch('/api/sendEmail', {
+ method: 'POST',
+ headers: {
+ 'Content-Type': 'application/json',
+ },
+ body: JSON.stringify({ subject, content }),
+ });
+
+ if (!response.ok) {
+ const errorData = await response.json();
+ throw new Error(errorData.message || 'Failed to send email');
+ }
+
+ const result = await response.json();
+ console.log('Email sent successfully:', result);
+ return { success: true, message: 'Recieved loud and clear\n Thanks for your feedback!' };
+ } catch (error) {
+ console.error('Error sending email:', error);
+ return { success: false, message: error.message || 'Failed to send feedback' };
+ }
+}
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/css/app.css b/top-sveltekit/postgres-rls/src/lib/assets/css/app.css
new file mode 100644
index 0000000..e56a37b
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/css/app.css
@@ -0,0 +1,42 @@
+@import './scrollbar-color.css';
+
+@tailwind base;
+@tailwind components;
+@tailwind utilities;
+
+pre code {
+ @apply text-base font-mono !important;
+}
+
+a[target="_blank"] {
+ @apply underline;
+}
+
+
+/* Target tables within prose to make them scrollable */
+.prose {
+ overflow-x: auto;
+ /* Allows horizontal scrolling on the prose container */
+}
+
+.prose table {
+ min-width: 100%;
+ /* Ensures tables are not less than the width of their container */
+ display: block;
+ /* Changes table display from table to block to work with overflow */
+ white-space: nowrap;
+ /* Prevents wrapping within the table cells */
+
+}
+
+.prose table td,
+.prose table th {
+ white-space: normal;
+ /* Allows text to wrap within the cell */
+ word-wrap: break-word;
+ /* Breaks long words if necessary to fit within the cell */
+ min-width: 120px;
+ /* Ensures a minimum width for smaller content */
+ max-width: 250px;
+ /* Limits the width to prevent extremely wide cells */
+}
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/css/code-highlighted-prisma.css b/top-sveltekit/postgres-rls/src/lib/assets/css/code-highlighted-prisma.css
new file mode 100644
index 0000000..d36e1a7
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/css/code-highlighted-prisma.css
@@ -0,0 +1,151 @@
+/*
+ * Synthwave '84 Theme originally by Robb Owen [@Robb0wen] for Visual Studio Code
+ * Demo: https://marc.dev/demo/prism-synthwave84
+ *
+ * Ported for PrismJS by Marc Backes [@themarcba]
+ */
+
+code[class*="language-"],
+pre[class*="language-"] {
+ /* color: #f92aad; */
+ @apply text-primary;
+ /* text-shadow: 0 0 2px #100c0f, 0 0 5px #dc078e33, 0 0 10px #fff3; */
+ background: none;
+ font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace;
+ font-size: 1em;
+ text-align: left;
+ white-space: pre;
+ word-spacing: normal;
+ word-break: normal;
+ word-wrap: normal;
+ line-height: 1.5;
+
+ -moz-tab-size: 4;
+ -o-tab-size: 4;
+ tab-size: 4;
+
+ -webkit-hyphens: none;
+ -moz-hyphens: none;
+ -ms-hyphens: none;
+ hyphens: none;
+}
+
+/* Code blocks */
+pre[class*="language-"] {
+ padding: 1em;
+ margin: .5em 0;
+ overflow: auto;
+}
+
+:not(pre)>code[class*="language-"],
+pre[class*="language-"] {
+ @apply bg-base-200;
+}
+
+/* Inline code */
+:not(pre)>code[class*="language-"] {
+ padding: .1em;
+ border-radius: .3em;
+ white-space: normal;
+}
+
+.token.comment,
+.token.block-comment,
+.token.prolog,
+.token.doctype,
+.token.cdata {
+ @apply text-accent
+ /* color: #8e8e8e; */
+}
+
+.token.punctuation {
+ @apply text-secondary
+ /* color: #ccc; */
+}
+
+.token.tag,
+.token.attr-name,
+.token.namespace,
+.token.number,
+.token.unit,
+.token.hexcode,
+.token.deleted {
+ @apply text-error;
+ /* color: #e2777a; */
+}
+
+.token.property,
+.token.selector {
+ @apply text-success
+ /* color: #72f1b8; */
+ /* text-shadow: 0 0 2px #100c0f, 0 0 10px #257c5575, 0 0 35px #21272475; */
+}
+
+.token.function-name {
+ @apply text-info;
+ /* color: #6196cc; */
+}
+
+.token.boolean,
+.token.selector .token.id,
+.token.function {
+ @apply text-primary
+ /* text-shadow: 0 0 2px #001716, 0 0 3px #03edf975, 0 0 5px #03edf975, 0 0 8px #03edf975; */
+}
+
+.token.class-name {
+ /* color: #fff5f6; */
+ @apply text-primary
+ /* text-shadow: 0 0 2px #000, 0 0 10px #fc1f2c75, 0 0 5px #fc1f2c75, 0 0 25px #fc1f2c75; */
+}
+
+.token.constant,
+.token.symbol {
+ /* color: #f92aad; */
+ @apply text-accent
+ /* text-shadow: 0 0 2px #100c0f, 0 0 5px #dc078e33, 0 0 10px #fff3; */
+}
+
+.token.important,
+.token.atrule,
+.token.keyword,
+.token.selector .token.class,
+.token.builtin {
+ /* color: #f4eee4; */
+ @apply text-accent
+ /* text-shadow: 0 0 2px #393a33, 0 0 8px #f39f0575, 0 0 2px #f39f0575; */
+}
+
+.token.string,
+.token.char,
+.token.attr-value,
+.token.regex,
+.token.variable {
+ @apply text-accent
+ /* color: #f87c32; */
+}
+
+.token.operator,
+.token.entity,
+.token.url {
+ /* color: #67cdcc; */
+ @apply text-info
+}
+
+.token.important,
+.token.bold {
+ font-weight: bold;
+}
+
+.token.italic {
+ font-style: italic;
+}
+
+.token.entity {
+ cursor: help;
+}
+
+.token.inserted {
+ /* color: green; */
+ @apply text-success
+}
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/css/scrollbar-color.css b/top-sveltekit/postgres-rls/src/lib/assets/css/scrollbar-color.css
new file mode 100644
index 0000000..3d79e51
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/css/scrollbar-color.css
@@ -0,0 +1,21 @@
+/* width */
+::-webkit-scrollbar {
+ width: 8px;
+}
+
+/* Track */
+::-webkit-scrollbar-track {
+ @apply bg-base-100;
+ border-radius: 2px;
+}
+
+/* Handle */
+::-webkit-scrollbar-thumb {
+ @apply bg-base-300 bg-opacity-50;
+ border-radius: 2px;
+}
+
+/* Handle on hover */
+::-webkit-scrollbar-thumb:hover {
+ @apply bg-base-300;
+}
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/icons/Logo.svelte b/top-sveltekit/postgres-rls/src/lib/assets/icons/Logo.svelte
new file mode 100644
index 0000000..9a62bb6
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/icons/Logo.svelte
@@ -0,0 +1,76 @@
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/images/ctw-grey.svg b/top-sveltekit/postgres-rls/src/lib/assets/images/ctw-grey.svg
new file mode 100644
index 0000000..5cf3ab5
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/images/ctw-grey.svg
@@ -0,0 +1,40 @@
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/images/ctw-jess-profile.jpg b/top-sveltekit/postgres-rls/src/lib/assets/images/ctw-jess-profile.jpg
new file mode 100644
index 0000000..07fb728
Binary files /dev/null and b/top-sveltekit/postgres-rls/src/lib/assets/images/ctw-jess-profile.jpg differ
diff --git a/portfolio/static/3d/nebula/ctw.svg b/top-sveltekit/postgres-rls/src/lib/assets/images/ctw.svg
similarity index 100%
rename from portfolio/static/3d/nebula/ctw.svg
rename to top-sveltekit/postgres-rls/src/lib/assets/images/ctw.svg
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/images/ctwhome-profile.webp b/top-sveltekit/postgres-rls/src/lib/assets/images/ctwhome-profile.webp
new file mode 100644
index 0000000..8ac5489
Binary files /dev/null and b/top-sveltekit/postgres-rls/src/lib/assets/images/ctwhome-profile.webp differ
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/images/dev.svg b/top-sveltekit/postgres-rls/src/lib/assets/images/dev.svg
new file mode 100644
index 0000000..0f81a54
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/images/dev.svg
@@ -0,0 +1,50 @@
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/images/digital-garden.svg b/top-sveltekit/postgres-rls/src/lib/assets/images/digital-garden.svg
new file mode 100644
index 0000000..d1a12bb
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/images/digital-garden.svg
@@ -0,0 +1,37 @@
+
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/images/logo-small.svg b/top-sveltekit/postgres-rls/src/lib/assets/images/logo-small.svg
new file mode 100644
index 0000000..27fe3e6
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/images/logo-small.svg
@@ -0,0 +1,20 @@
+
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/images/logo.svg b/top-sveltekit/postgres-rls/src/lib/assets/images/logo.svg
new file mode 100644
index 0000000..3613fc4
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/images/logo.svg
@@ -0,0 +1,11 @@
+
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/images/product-design.svg b/top-sveltekit/postgres-rls/src/lib/assets/images/product-design.svg
new file mode 100644
index 0000000..f1b4a20
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/images/product-design.svg
@@ -0,0 +1,37 @@
+
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/images/ux.svg b/top-sveltekit/postgres-rls/src/lib/assets/images/ux.svg
new file mode 100644
index 0000000..b92a9e4
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/images/ux.svg
@@ -0,0 +1,48 @@
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/assets/images/web.svg b/top-sveltekit/postgres-rls/src/lib/assets/images/web.svg
new file mode 100644
index 0000000..d63b4a4
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/assets/images/web.svg
@@ -0,0 +1,37 @@
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/Analytics.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/Analytics.svelte
new file mode 100644
index 0000000..bc4bad9
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/Analytics.svelte
@@ -0,0 +1,30 @@
+
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/Carousel.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/Carousel.svelte
new file mode 100644
index 0000000..8ecfff7
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/Carousel.svelte
@@ -0,0 +1,63 @@
+
+
+
+ Input search with auto complete, defer and keyboard navigatio (WIP).
+
+
+
+
+
+ {#if showDropdown}
+ {#if searchValue}
+ -
+ {#each filteredOptions as option, i}
+
- + {option} + + {/each} +
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/GlobalToast.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/GlobalToast.svelte
new file mode 100644
index 0000000..7b96638
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/GlobalToast.svelte
@@ -0,0 +1,25 @@
+
+
+Image Carousel
+ {#each [gallery_items[currentSlideItem]] as item (currentSlideItem)} + + {/each} + +
+
+ {#if $page.data.session}
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/Login/LoginForm.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/Login/LoginForm.svelte
new file mode 100644
index 0000000..9e5a403
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/Login/LoginForm.svelte
@@ -0,0 +1,75 @@
+
+
+
+
+
+ {:else}
+
+
+
+
+
+
+
+ {/if}
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/Login/MagicLinkForm.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/Login/MagicLinkForm.svelte
new file mode 100644
index 0000000..fd7ea9e
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/Login/MagicLinkForm.svelte
@@ -0,0 +1,64 @@
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/Login/RegisterForm.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/Login/RegisterForm.svelte
new file mode 100644
index 0000000..4643b58
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/Login/RegisterForm.svelte
@@ -0,0 +1,123 @@
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/NativeFileApi.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/NativeFileApi.svelte
new file mode 100644
index 0000000..551a96a
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/NativeFileApi.svelte
@@ -0,0 +1,201 @@
+
+
+
++ {isRegistering ? 'Create Account' : 'Login Access'} +
+
+ {#if !isRegistering}
+
+ (isRegistering = false)} />
+ {:else}
+
+OR
+
+
+
+ {/if}
+
+
+
+
+ {#if isRegistering}
+
+ {#if isRegistering}
+ Already have an account?
+
+ {:else}
+ Don't have an account?
+
+ {/if}
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/ProfilePicture.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/ProfilePicture.svelte
new file mode 100644
index 0000000..35f6868
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/ProfilePicture.svelte
@@ -0,0 +1,27 @@
+
+
+
+
+ Access to the native file system API
+ + + + + + + + + + + + +Open directory
+
+
+
+{JSON.stringify(numberFiles, null, 2)}
+ {#each Object.values(tree) as { name, handle }}
+ fileClicked(handle)}>
+ {name}
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ {/each}
+ {JSON.stringify(tree, null, 2)}
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/SEO.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/SEO.svelte
new file mode 100644
index 0000000..703f708
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/SEO.svelte
@@ -0,0 +1,21 @@
+
+
+J. Gonzalez - Ctw
+ {subtitle}
+
+
+ {@render children?.()}
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/feedback/FeedbackButton.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/feedback/FeedbackButton.svelte
new file mode 100644
index 0000000..ee7dcd5
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/feedback/FeedbackButton.svelte
@@ -0,0 +1,133 @@
+
+
+{#if showButton}
+
+{/if}
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/footerMain.svelte b/top-sveltekit/postgres-rls/src/lib/components/ui/footerMain.svelte
new file mode 100644
index 0000000..d568f69
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/footerMain.svelte
@@ -0,0 +1,73 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ Design
+ should have a meaning.
+
+ Engineering + should have a purpose. +
+ And ultimately, + Technology + should empower people. +
+ + Engineering + should have a purpose. +
+ And ultimately, + Technology + should empower people. +
+
+ Latest work
+
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/components/ui/themeChamge/themes.json b/top-sveltekit/postgres-rls/src/lib/components/ui/themeChamge/themes.json
new file mode 100644
index 0000000..5892579
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/components/ui/themeChamge/themes.json
@@ -0,0 +1,122 @@
+[
+ {
+ "id": "ctw",
+ "name": "Ctw"
+ },
+ {
+ "name": "🌚 dark",
+ "id": "dark"
+ },
+ {
+ "name": "🌝 light",
+ "id": "light"
+ },
+ {
+ "name": "🧁 cupcake",
+ "id": "cupcake"
+ },
+ {
+ "name": "🐝 bumblebee",
+ "id": "bumblebee"
+ },
+ {
+ "name": "✳️ Emerald",
+ "id": "emerald"
+ },
+ {
+ "name": "🏢 Corporate",
+ "id": "corporate"
+ },
+ {
+ "name": "🌃 synthwave",
+ "id": "synthwave"
+ },
+ {
+ "name": "👴 retro",
+ "id": "retro"
+ },
+ {
+ "name": "🤖 cyberpunk",
+ "id": "cyberpunk"
+ },
+ {
+ "name": "🌸 valentine",
+ "id": "valentine"
+ },
+ {
+ "name": "🎃 halloween",
+ "id": "halloween"
+ },
+ {
+ "name": "🌷 garden",
+ "id": "garden"
+ },
+ {
+ "name": "🌲 forest",
+ "id": "forest"
+ },
+ {
+ "name": "🐟 aqua",
+ "id": "aqua"
+ },
+ {
+ "name": "👓 lofi",
+ "id": "lofi"
+ },
+ {
+ "name": "🖍 pastel",
+ "id": "pastel"
+ },
+ {
+ "name": "🧚♀️ fantasy",
+ "id": "fantasy"
+ },
+ {
+ "name": "📝 Wireframe",
+ "id": "wireframe"
+ },
+ {
+ "name": "🏴 black",
+ "id": "black"
+ },
+ {
+ "name": "💎 luxury",
+ "id": "luxury"
+ },
+ {
+ "name": "🧛♂️ dracula",
+ "id": "dracula"
+ },
+ {
+ "name": "🖨 CMYK",
+ "id": "cmyk"
+ },
+ {
+ "name": "🍁 Autumn",
+ "id": "autumn"
+ },
+ {
+ "name": "💼 Business",
+ "id": "business"
+ },
+ {
+ "name": "💊 Acid",
+ "id": "acid"
+ },
+ {
+ "name": "🍋 Lemonade",
+ "id": "lemonade"
+ },
+ {
+ "name": "🌙 Night",
+ "id": "night"
+ },
+ {
+ "name": "☕️ Coffee",
+ "id": "coffee"
+ },
+ {
+ "name": "❄️ Winter",
+ "id": "winter"
+ }
+]
diff --git a/top-sveltekit/postgres-rls/src/lib/content/README.md b/top-sveltekit/postgres-rls/src/lib/content/README.md
new file mode 100644
index 0000000..98dff1d
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/content/README.md
@@ -0,0 +1,22 @@
+# Instructions for the posts
+
+frontmatter variables:
+```yaml
+published: true
+title: Blog 1
+description: A description here
+date: 2024-01-01
+coverImage: image.avif
+displayCover: true # False to only show the cover in the list
+tags:
+ - tag 1
+ - tag 2
+
+layout: blog
+type: blog
+```
+
+## Very important notes
+
+> The images NEED to be inside the `./images/` folder to work
+> All image name MUST be unique!
\ No newline at end of file
diff --git a/portfolio/src/content/TEMPLATE/images/cover.avif b/top-sveltekit/postgres-rls/src/lib/content/TEMPLATE/images/cover.avif
similarity index 100%
rename from portfolio/src/content/TEMPLATE/images/cover.avif
rename to top-sveltekit/postgres-rls/src/lib/content/TEMPLATE/images/cover.avif
diff --git a/top-sveltekit/postgres-rls/src/lib/content/TEMPLATE/index.md b/top-sveltekit/postgres-rls/src/lib/content/TEMPLATE/index.md
new file mode 100644
index 0000000..0281886
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/content/TEMPLATE/index.md
@@ -0,0 +1,18 @@
+---
+published: true
+title: Title Template
+description: Description
+
+date: 2024-01-01
+
+coverImage: images/cover.avif
+displayCover: true
+tags:
+ - Tag
+categories:
+ - Blog
+ - Project
+layout: blog | project
+---
+### Copy this template
+
diff --git a/top-sveltekit/postgres-rls/src/lib/content/content.ts b/top-sveltekit/postgres-rls/src/lib/content/content.ts
new file mode 100644
index 0000000..261d0a9
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/content/content.ts
@@ -0,0 +1,33 @@
+//
+// This file help to get all the content from the markdown files in the content
+// folder. It is used in the server.ts file in the blog folder to
+// get all the content for pre - rendering.
+//
+
+
+// import { get } from "svelte/store"
+const content = import.meta.glob('$content/**/*.md', { eager: true })
+const filtered = [];
+
+for (const path in content) {
+ const { metadata } = content[path];
+ // Assuming that the MDsveX transformed content includes a `.toString()` method to get raw Markdown
+ // If not, you might need to adjust this depending on what `content` actually includes
+ // const markdown = rawContent.toString();
+
+ filtered.push({
+ metadata,
+ slug: path.split('/').at(-2), // Get folder name as slug
+ prevPost: null, // TODO: Implement
+ nextPost: null // TODO: Implement
+ });
+}
+// filter out the TEMPLATE and content folder
+const posts = filtered
+ .filter(filteredPost => !filteredPost.slug.includes('TEMPLATE'))
+ .filter(filteredPost => !filteredPost.slug.includes('content'))
+ .sort((a, b) => new Date(b.metadata.date) - new Date(a.metadata.date));
+
+
+export { content, posts }
+
diff --git a/top-sveltekit/postgres-rls/src/lib/db/db.ts b/top-sveltekit/postgres-rls/src/lib/db/db.ts
new file mode 100644
index 0000000..6204ec0
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/db/db.ts
@@ -0,0 +1,56 @@
+// src/lib/db.ts
+import { env } from "$env/dynamic/private"
+import pkg from 'pg';
+const { Pool } = pkg;
+
+export const pool = new Pool({
+ host: env.DB_HOST, // Database host
+ port: Number(env.DB_PORT), // Database port, default to 5432
+ user: env.DB_USER, // Database user
+ password: env.DB_PASSWORD, // Database user's password
+ database: env.DB_NAME, // Database name
+ ssl: env.DB_SSL === 'true', // Optional: set to 'true' if SSL is required
+ max: env.MAX_CLIENTS, // Max number of clients in the pool
+ idleTimeoutMillis: env.IDLE_TIMEOUT_MILLIS, // How long a client is allowed to remain idle before being closed
+ connectionTimeoutMillis: env.CONNECTION_TIMEOUT_MILLIS
+});
+
+// Utility function to query the database
+export const query = (text: string, params?: any[]) => {
+ return pool.query(text, params);
+};
+
+// Close the pool gracefully when the application is shutting down
+process.on('SIGINT', () => {
+ pool.end(() => {
+ console.log('pg pool has ended');
+ process.exit(0);
+ });
+});
+
+// Utility function to query the database
+// using Parameterized queries, to avoid SQL injection
+// read more here: https://node-postgres.com/features/queries
+/**
+ *
+ * @param text SQL query
+ * @param params Parameters to be passed to the query
+ * @param auth Auth object from locals.auth()
+ * @returns json response
+ */
+export async function sql(text: string, params?: any[]) {
+ try {
+ const result = await query(text, params);
+ return result.rows;
+ }
+ catch (error) {
+ console.error('SQL function error:', error.message);
+ console.error('For query:', text);
+
+ if (error.message.includes('not extensible')) {
+ console.error('Object not extensible error. Params:', params);
+ console.error('Query text:', text);
+ }
+ throw error; // Re-throw the error to be handled by the caller
+ }
+};
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/lib/markdown-layouts/blog.svelte b/top-sveltekit/postgres-rls/src/lib/markdown-layouts/blog.svelte
new file mode 100644
index 0000000..32f4d4e
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/markdown-layouts/blog.svelte
@@ -0,0 +1,13 @@
+
+
+
+
+
+
+ Change theme
+
+
+
+
+
+ {#each themes as theme}
+
+
+
+ {/each}
+
+
+
+
+
+
+
+ {theme.id}
+
+
+
+
+
+
+
+
+ {@render children?.()}
+
diff --git a/top-sveltekit/postgres-rls/src/lib/markdown-layouts/default.svelte b/top-sveltekit/postgres-rls/src/lib/markdown-layouts/default.svelte
new file mode 100644
index 0000000..d0dd642
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/markdown-layouts/default.svelte
@@ -0,0 +1,15 @@
+
+
+
+
+
+
diff --git a/top-sveltekit/postgres-rls/src/lib/markdown-layouts/project.svelte b/top-sveltekit/postgres-rls/src/lib/markdown-layouts/project.svelte
new file mode 100644
index 0000000..6cc41a1
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/markdown-layouts/project.svelte
@@ -0,0 +1,13 @@
+
+
+
+
+
+ {@render children?.()}
+
+
+ {@render children?.()}
+
diff --git a/top-sveltekit/postgres-rls/src/lib/models/menu-itmes.ts b/top-sveltekit/postgres-rls/src/lib/models/menu-itmes.ts
new file mode 100644
index 0000000..cdb5485
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/models/menu-itmes.ts
@@ -0,0 +1,10 @@
+export default [
+
+ { title: 'About', path: '/about', displayTitle: 'About' },
+
+ // {
+ // title: 'Latest Work',
+ // path: '/work',
+ // displayTitle: 'Latest Work'
+ // }
+];
diff --git a/top-sveltekit/postgres-rls/src/lib/models/status-enum.ts b/top-sveltekit/postgres-rls/src/lib/models/status-enum.ts
new file mode 100644
index 0000000..7398443
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/models/status-enum.ts
@@ -0,0 +1,5 @@
+export default {
+ 0: 'Seedling 🌱',
+ 1: 'Budding 🌿',
+ 2: 'Evergreen 🌳'
+};
diff --git a/top-sveltekit/postgres-rls/src/lib/siteSettings.ts b/top-sveltekit/postgres-rls/src/lib/siteSettings.ts
new file mode 100644
index 0000000..06aad95
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/siteSettings.ts
@@ -0,0 +1,16 @@
+export const siteSettings = {
+ title: 'Ctwhome - Top Sveltekit',
+ description: 'Web Engineering - Projects and Portfolio of J. Gonzalez',
+ baseUrl: 'https://ctwhome.com',
+ twitterHandle: '@ctwhome',
+ facebookAppId: '1234567890',
+ image: '/images/og-image.jpg',
+ imageAlt: 'My site image',
+ siteName: 'My Site',
+ siteLocale: 'en_US',
+ siteLang: 'en',
+ siteDirection: 'ltr',
+ siteThemeColor: '#000000',
+ siteBackgroundColor: '#ffffff',
+ siteKeywords: 'Web engineering, Ctw, Ctw portfolio'
+}
diff --git a/top-sveltekit/postgres-rls/src/lib/stores/menu.store.ts b/top-sveltekit/postgres-rls/src/lib/stores/menu.store.ts
new file mode 100644
index 0000000..0797360
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/stores/menu.store.ts
@@ -0,0 +1,15 @@
+import { writable } from 'svelte/store';
+
+export const isMenuOpen = writable(false);
+
+export function toggleMenu() {
+ isMenuOpen.update(state => !state);
+}
+
+export function closeMenu() {
+ isMenuOpen.set(false);
+}
+
+export function openMenu() {
+ isMenuOpen.set(true);
+}
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/lib/stores/toast.store.ts b/top-sveltekit/postgres-rls/src/lib/stores/toast.store.ts
new file mode 100644
index 0000000..ed188c0
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/stores/toast.store.ts
@@ -0,0 +1,30 @@
+import { writable } from 'svelte/store';
+import toast from 'svelte-french-toast';
+
+function createToastStore() {
+ const { subscribe, update } = writable({});
+
+ return {
+ subscribe,
+ success: (message: string) => {
+ update(() => {
+ toast.success(message, {
+ position: 'top-center',
+ duration: 5000
+ });
+ return {};
+ });
+ },
+ error: (message: string) => {
+ update(() => {
+ toast.error(message, {
+ position: 'top-center',
+ duration: 5000
+ });
+ return {};
+ });
+ }
+ };
+}
+
+export const toastStore = createToastStore();
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/lib/utils/content.ts b/top-sveltekit/postgres-rls/src/lib/utils/content.ts
new file mode 100644
index 0000000..0ae6ddc
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/lib/utils/content.ts
@@ -0,0 +1,71 @@
+// TODO WIP - it would be nice if i could get the metadata of the md file directly
+
+import { browser } from '$app/environment'
+import { format } from 'date-fns'
+import { parse } from 'node-html-parser'
+
+// we require some server-side APIs to parse all metadata
+if (browser) {
+ throw new Error(`posts can only be imported server-side`)
+}
+
+type Glob = { default: SvelteComponent; metadata: Record
+
diff --git a/top-sveltekit/postgres-rls/src/routes/+layout.ts b/top-sveltekit/postgres-rls/src/routes/+layout.ts
new file mode 100644
index 0000000..21fbc6a
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/+layout.ts
@@ -0,0 +1,3 @@
+export const prerender = false
+
+export const ssr = true;
\ No newline at end of file
diff --git a/top-sveltekit/postgres-rls/src/routes/+page.svelte b/top-sveltekit/postgres-rls/src/routes/+page.svelte
new file mode 100644
index 0000000..fb5c213
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/+page.svelte
@@ -0,0 +1,18 @@
+
+
+
+ dev database
+
+ {/if}
+
+
diff --git a/top-sveltekit/postgres-rls/src/routes/about/+page.md b/top-sveltekit/postgres-rls/src/routes/about/+page.md
new file mode 100644
index 0000000..f087354
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/about/+page.md
@@ -0,0 +1,30 @@
+---
+# layout: blog
+---
+
+
+
+
+
+
+
+
+ Top-sveltekit
++ Experience the power of advanced AI assistants in a native-like app interface. +
+ +
+
+
diff --git a/top-sveltekit/postgres-rls/src/routes/contact/+page.server.ts b/top-sveltekit/postgres-rls/src/routes/contact/+page.server.ts
new file mode 100644
index 0000000..5358466
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/contact/+page.server.ts
@@ -0,0 +1,9 @@
+export async function load({}) {
+ // fetch page from wordpress json api
+ const res = await fetch(`https://portfolio.ctwhome.com/wp-json/wp/v2/pages?slug=pricing}`);
+ const page = await res.json();
+
+ return {
+ page
+ };
+}
diff --git a/top-sveltekit/postgres-rls/src/routes/contact/+page.svelte b/top-sveltekit/postgres-rls/src/routes/contact/+page.svelte
new file mode 100644
index 0000000..47baa87
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/contact/+page.svelte
@@ -0,0 +1,11 @@
+
+
+
+
+
+
+
+ Sign in to your account
+Or start your 14-day free trial
+
+
+
+
+ OR
+
+ {#if page}
+
diff --git a/top-sveltekit/postgres-rls/src/routes/privacy/+page.md b/top-sveltekit/postgres-rls/src/routes/privacy/+page.md
new file mode 100644
index 0000000..8a45783
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/privacy/+page.md
@@ -0,0 +1,132 @@
+# Privacy Policy
+
+Privacy policy
+In this Privacy Statement, Stichting Netherlands eScience Center (‘eScience Center’, or also ‘us’, ‘we’ and the like) gives information about how we process personal data.
+
+Whose personal data do we process?
+We process personal data of the following types of data subjects:
+
+Website visitors
+Candidates who apply for jobs with us (employees are informed in a separate privacy notice)
+Contact persons at research institutes who request for and/or are granted funding
+Contact persons at vendors, suppliers and other business contacts
+What personal data do we process?
+Generally, we process the following types of personal data:
+
+Website visitors:
+If you sign up for our email notifications, you will be asked to fill out your first and last name, email address and the organization you work for. You can indicate what notifications you are interested in.
+If you sign up for notifications about events and you register for the event, you will be asked to submit your personal data such as your name, contact details, preferences. At the event itself, photographs or video’s may be taken of the event.
+If you want to contact us by using the contact form on the website, you will be asked to fill out your name, email address, the subject matter of your message and the message itself.
+We collect limited information through the use of analytics cookies (see more about this under ‘Do we use cookies?’ below).
+Candidates who apply for jobs with us:
+You can apply for a job with us by using the online application form, you can find a link to this form in the job offering text. We will ask you to fill out information such as your name, email address, telephone number, your resume, if you wish: LinkedIn profile, GitHub link and you will be asked to answer several questions including giving a motivational letter, submitting code samples and relevant references.
+If we invite you to continue the job application procedure, you will be interviewed by an application committee. The interview notes and the committee’s notes will usually contain your personal data.
+During the job application procedure, you may also be asked to give a presentation to our staff members. Your basic details (name) will be included in the invitation to the presentation which is sent to our staff members. In this presentation itself, you will likely add personal data about you, the presentation will also processed by us for the job application procedure.
+Contact persons at research institutes who request for and/or are granted funding:
+In the context of requests for and management of funding to research institutes, we will process personal data of contact persons, such as their names, email address, telephone number, organization they work for, job function, signatures on contracts and the like.
+Contact persons at vendors, suppliers and other business contacts:
+In the context of our vendor and supplier management and our other day to day activities, we will process personal data of contact persons at vendors, suppliers and other organizations, such as their names, address, email address, telephone number, organization they work for, job function, signatures on contracts and the like.
+Are you required to submit personal data?
+Yes, you are required to provide some of the personal data, this will be indicated when you are asked for the personal data. These personal data are required to assess whether we want to conclude a (n employment) agreement with you and may also be required to fulfill our legal obligations with respect to keeping a tax administration.
+
+For what purposes do we use your personal data?
+We use your personal data for the following purposes:
+
+Website visitors:
+To be able to send email notifications upon your request
+To be able to communicate with you if you send a message using our contact form
+If you sign up for an event: to be able to process your registration and keep an administration with respect to the event and to inform others about the event (images from the event)
+Candidates who apply for jobs with us:
+To be able to assess your fitness for the job
+To be able to communicate with you during the job application procedure
+To be able to contact you after the job application procedure has been rounded off, in case we have a suitable job opening for you
+Contact persons at research institutes who request for and/or are granted funding:
+To be able to communicate with you
+To keep an administration with respect to funding projects
+To keep an administration with respect to the research institutes, including management and performance of agreements with them
+To fulfil our legal obligations with respect to keeping a tax administration
+To inform you about strategic developments / plans
+To maintain a (commercial) relationship with you
+Contact persons at vendors, suppliers and other business contacts:
+To be able to communicate with you
+To keep an administration with respect to vendors, suppliers and other business contacts, including management and performance of agreements with them, as applicable
+To fulfil our legal obligations with respect to keeping a tax administration (e.g. name on invoices)
+To inform you about strategic developments / plans
+To maintain a (commercial) relationship with you
+On what legal basis do we process your personal data?
+We process your personal data on the following legal basis:
+
+Website visitors:
+Email notifications: consent
+Contact form: legitimate interest to communicate with you
+If you sign up for an event: legitimate interest to process your registration, manage your participation and (if applicable) share images about the event on our website and/or on professional social media such as LinkedIn
+Candidates who apply for jobs with us:
+In order to take steps at your request prior to entering into an employment agreement with you
+With respect to the personal data we keep after the job application procedure has been rounded off: our as well as your legitimate interest to contact you in case a job offering may be relevant for you
+Contact persons at research institutes who request for and/or are granted funding:
+For our legitimate interests, generally consisting of running our organization and more specifically expressed under the purposes above
+To fulfil our legal obligations with respect to keeping a tax administration
+Contact persons at vendors, suppliers and other business contacts:
+For our legitimate interests, generally consisting of running our organization and more specifically expressed under the purposes above
+To fulfil our legal obligations with respect to keeping a tax administration
+How long are your personal data stored?
+Website visitors:
+Email notifications: until you unsubscribe from the notification
+Contact form: two years
+If you sign up for an event: six months
+Candidates who apply for jobs with us:
+Candidates who have not been offered a job: 12 months after the job application procedure
+Contact persons at research institutes who request for and/or are granted funding:
+General: until two years after the agreement with the research institute has ended
+Updates: until you unsubscribe / object to our update
+Tax administration (as applicable): seven years
+Contact persons at vendors, suppliers and other business contacts:
+General: until two years after the agreement with the vendor, supplier or other business contact has ended
+Updates: until you unsubscribe / object to our update
+Tax administration: seven years
+With whom do we share your personal data?
+We make use of the following service providers:
+
+Raadhuis (website)
+Homerun (for job application registration)
+MailChimp (for email notifications)
+EventBrite (for event registration)
+Google (Google Analytics and Google forms)
+Microsoft (emails, storage)
+Exact (financial administration application)
+We may be required by law to disclose certain personal data, we will then endeavor to only disclose personal data that is strictly required pursuant to applicable laws.
+
+Are your personal data transferred to outside the European Economic Area (EEA)?
+Our service providers MailChimp, Eventbrite, and Google store personal data outside the EEA, also in countries without an adequate level of protection. They transfer the personal data using Standard Contractual Clauses. If you would like to receive more information about this, please let us know by contacting us using the contact details under ‘Contacting Us’.
+
+Do we use cookies?
+We use Google Analytics cookies that have been configured in a privacy friendly manner. This means we have concluded a data processing agreement with Google, that the last part of the IP-address has been masked, that we do not share information with Google and that we do not use other Google services in combination with the Google Analytics cookies. We do this for our legitimate purpose to be able to analyze how website visitors use our website and to improve the user friendliness thereof.
+
+What rights to do you have with respect to your personal data?
+Pursuant to the General Data Protection Regulation (GDPR), you have the following rights with regard to your personal data:
+
+the right to request access to your personal data;
+the right to receive information about the processing of your personal data;
+the right to have incorrect personal data rectified;
+under certain conditions to have your personal data erased;
+under certain conditions to have the processing of your personal data restricted;
+under certain conditions to object to the processing of your personal data – however when we use your personal data for direct marketing purposes, you can object to this unconditionally;
+if you have given consent for the processing of your personal data, to revoke that consent (this applies to future use of your personal data);
+the right to receive your personal data in a structured, commonly used and machine readable format, where it concerns personal data (i) you have submitted to us and (ii) we process based on your consent or required for the performance of our contract with you and (iii) that is processed by automated means; in that case you may also ask us to transfer your personal data to another processor, where technically feasible;
+the right to lodge a complaint with the supervisory authority.
+If you want to exercise your rights, please send a request with respect to your personal data, detailing your request and using the contact details under ‘Contacting Us’ below. We may ask you to provide additional information in order for us to verify that your request relates to your personal data.
+
+Please note that we may be entitled under applicable laws to refuse a certain request.
+
+Contacting Us
+If there are any questions regarding this Privacy Statement or about your personal data, you may contact us using the information below.
+
+Stichting Netherlands eScience Center
+Science Park 140 (Matrix I)
+1098 XG Amsterdam, The Netherlands
+info@esciencecenter.nl
+
+Can this Privacy Statement be altered?
+Yes, we reserve the right to alter this Privacy Statement. You will be notified of material changes, e.g. through a notice on the website.
+
+Last edited on 9 November 2021
diff --git a/top-sveltekit/postgres-rls/src/routes/profile/+page.svelte b/top-sveltekit/postgres-rls/src/routes/profile/+page.svelte
new file mode 100644
index 0000000..da86427
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/profile/+page.svelte
@@ -0,0 +1,53 @@
+
+
+{page.title?.rendered}
+{@html page.content?.rendered}
+ {/if}
+
+ {#if $page.data.session}
+
diff --git a/top-sveltekit/postgres-rls/src/routes/profile/UserInfo.svelte b/top-sveltekit/postgres-rls/src/routes/profile/UserInfo.svelte
new file mode 100644
index 0000000..5500941
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/profile/UserInfo.svelte
@@ -0,0 +1,34 @@
+
+
+
+
+
+
+ {:else}
+ Not logged in
+ {/if}
+
+
diff --git a/top-sveltekit/postgres-rls/src/routes/rss.xml/+server.ts b/top-sveltekit/postgres-rls/src/routes/rss.xml/+server.ts
new file mode 100644
index 0000000..3828cfa
--- /dev/null
+++ b/top-sveltekit/postgres-rls/src/routes/rss.xml/+server.ts
@@ -0,0 +1,40 @@
+// TODO
+
+// import { getPosts } from '$lib/site/posts.js'
+// import * as config from '$lib/site/config'
+
+// export const prerender = true
+
+// export async function GET() {
+// const posts = await getPosts()
+
+// const headers = { 'Content-Type': 'application/xml' }
+
+// const xml = `
+//
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ {$page.data?.session?.user?.name || $page?.data?.session?.user?.email.split('@')[0]}
+
+
+ {$page.data?.session?.user?.email}
+
+
+ {#each apps as app}
+
+
+
+
+
+
+ {/each}
+
diff --git a/website/src/routes/LandingPageComponents/PostsGrid.svelte b/website/src/routes/LandingPageComponents/PostsGrid.svelte
new file mode 100644
index 0000000..9be348e
--- /dev/null
+++ b/website/src/routes/LandingPageComponents/PostsGrid.svelte
@@ -0,0 +1,50 @@
+
+
+
+ {#each posts as post}
+ {@const currentYear = new Date(post.metadata.date).getUTCFullYear()}
+
+
+// ${config.siteName}
+// ${config.siteDescription}
+// ${config.siteUrl}
+// -
+//
${post.title}
+// ${post.description}
+// ${config.siteUrl}${post.slug}
+// ${config.siteUrl}${post.slug}
+// ${new Date(post.published).toUTCString()}
+//
+// `
+// )
+// .join('')}
+//
+//
+// `.trim()
+
+// return new Response(xml, { headers })
+// }
diff --git a/website/src/routes/sitemap.xml/+server.js b/website/src/routes/sitemap.xml/+server.js
new file mode 100644
index 0000000..b0507cb
--- /dev/null
+++ b/website/src/routes/sitemap.xml/+server.js
@@ -0,0 +1,59 @@
+// TODO
+// // This is an endpoint that generates a basic sitemap for the index page and all posts.
+// // It's helpful for SEO but does require you to keep it updated to reflect the routes of your website.
+// // It is OK to delete this file if you'd rather not bother with it.
+
+// import { posts } from '$lib/data/posts'
+// import { website } from '$lib/info'
+
+// export const prerender = true
+
+// // make sure this matches your post route
+// const getPostUrl = (slug) => `${website}/post/${slug}`
+
+// /**
+// * @type {import('@sveltejs/kit').RequestHandler}
+// */
+// export async function GET({ setHeaders }) {
+// setHeaders({
+// 'Cache-Control': `max-age=0, s-max-age=600`,
+// 'Content-Type': 'application/xml'
+// })
+
+// const xml = `
+//
+//
+// ${website}
+// 1.0
+//
+
+// ${posts
+// .map(
+// (post) => `
+// ${getPostUrl(post.slug)}
+// ${
+// post.updated
+// ? new Date(post.updated).toISOString()
+// : new Date(post.date).toISOString()
+// }
+// monthly
+// 1.0
+// `
+// )
+// .join('')}
+// `
+
+// return new Response(xml)
+// }
diff --git a/website/src/routes/terms/+page.md b/website/src/routes/terms/+page.md
new file mode 100644
index 0000000..69ba217
--- /dev/null
+++ b/website/src/routes/terms/+page.md
@@ -0,0 +1,8 @@
+# Terms of Service
+
+No rights can be derived from the information provided on this website. Although the information on this website has been compiled with the utmost care and is regularly updated, the Netherlands eScience Center cannot guarantee that it is free of errors and always up to date. As such, the eScience Center cannot be held liable for any information that might contain errors or be outdated.
+All material is owned by the Netherlands eScience Center. Reproduction is permitted, except where otherwise stated, provided the source is acknowledged.
+Personal profile pages of eScience Center staff do not in any way constitute official eScience content. The views and opinions expressed are strictly those of the page authors.
+The Netherlands eScience Center does not guarantee that the website will function error-free or uninterrupted.
+The Netherlands eScience Center website contains links to various external sites. These links are provided for reference purposes only. The Netherlands eScience Center does not necessarily endorse or recommend any entities listed on this website, nor does it necessarily share the views expressed by them. The Netherlands eScience Center cannot be held liable for any damage, loss or injury that a person or organisation may suffer as a result of any dealing with an organisation or person reached via these web pages.
+The Netherlands eScience Center shall not be liable for any damages of any kind, including consequential or incidental damages, arising from the submission, installation, maintenance, transmission, copying, modification, distribution or use of any materials.
diff --git a/portfolio/src/routes/lab/+page.svelte b/website/src/routes/toolkits/+page.svelte
similarity index 97%
rename from portfolio/src/routes/lab/+page.svelte
rename to website/src/routes/toolkits/+page.svelte
index 9ce1428..a748c81 100644
--- a/portfolio/src/routes/lab/+page.svelte
+++ b/website/src/routes/toolkits/+page.svelte
@@ -61,7 +61,7 @@
+ {#if shouldDisplayYear(currentYear)} + {currentYear} + {/if} +
+ +//
Example Markdown pages with interactive components
- MDsveX Full Example
+ MDsveX Full Example
Drag and drop with SortableJS
@@ -104,7 +104,7 @@
-
+
@@ -127,7 +127,7 @@
-
+
@@ -192,7 +192,7 @@
Framework
-
+
@@ -213,7 +213,7 @@
-
+
@@ -232,7 +232,7 @@
-
+
diff --git a/portfolio/src/routes/lab/camera-controls/+page.svelte b/website/src/routes/toolkits/camera-controls/+page.svelte
similarity index 100%
rename from portfolio/src/routes/lab/camera-controls/+page.svelte
rename to website/src/routes/toolkits/camera-controls/+page.svelte
diff --git a/website/src/routes/toolkits/camera-controls/+page.ts b/website/src/routes/toolkits/camera-controls/+page.ts
new file mode 100644
index 0000000..4d5667b
--- /dev/null
+++ b/website/src/routes/toolkits/camera-controls/+page.ts
@@ -0,0 +1,3 @@
+// This configuration only prerenders the homepage (/)
+// Other routes need their own prerender configuration if needed
+export const prerender = false;
diff --git a/portfolio/src/routes/lab/camera-controls/3d-cube.gif b/website/src/routes/toolkits/camera-controls/3d-cube.gif
similarity index 100%
rename from portfolio/src/routes/lab/camera-controls/3d-cube.gif
rename to website/src/routes/toolkits/camera-controls/3d-cube.gif
diff --git a/portfolio/src/routes/lab/camera-controls2/+page.svelte b/website/src/routes/toolkits/camera-controls2/+page.svelte
similarity index 100%
rename from portfolio/src/routes/lab/camera-controls2/+page.svelte
rename to website/src/routes/toolkits/camera-controls2/+page.svelte
diff --git a/website/src/routes/toolkits/camera-controls2/+page.ts b/website/src/routes/toolkits/camera-controls2/+page.ts
new file mode 100644
index 0000000..4d5667b
--- /dev/null
+++ b/website/src/routes/toolkits/camera-controls2/+page.ts
@@ -0,0 +1,3 @@
+// This configuration only prerenders the homepage (/)
+// Other routes need their own prerender configuration if needed
+export const prerender = false;
diff --git a/portfolio/src/routes/lab/camera-controls2/initScene.ts b/website/src/routes/toolkits/camera-controls2/initScene.ts
similarity index 100%
rename from portfolio/src/routes/lab/camera-controls2/initScene.ts
rename to website/src/routes/toolkits/camera-controls2/initScene.ts
diff --git a/portfolio/src/routes/lab/gis/+page.md b/website/src/routes/toolkits/gis/+page.md
similarity index 100%
rename from portfolio/src/routes/lab/gis/+page.md
rename to website/src/routes/toolkits/gis/+page.md
diff --git a/portfolio/src/routes/lab/gis/images/image-1.png b/website/src/routes/toolkits/gis/images/image-1.png
similarity index 100%
rename from portfolio/src/routes/lab/gis/images/image-1.png
rename to website/src/routes/toolkits/gis/images/image-1.png
diff --git a/portfolio/src/routes/lab/gis/images/image-2.png b/website/src/routes/toolkits/gis/images/image-2.png
similarity index 100%
rename from portfolio/src/routes/lab/gis/images/image-2.png
rename to website/src/routes/toolkits/gis/images/image-2.png
diff --git a/portfolio/src/routes/lab/gis/images/image-3.png b/website/src/routes/toolkits/gis/images/image-3.png
similarity index 100%
rename from portfolio/src/routes/lab/gis/images/image-3.png
rename to website/src/routes/toolkits/gis/images/image-3.png
diff --git a/portfolio/src/routes/lab/gis/images/image-4.png b/website/src/routes/toolkits/gis/images/image-4.png
similarity index 100%
rename from portfolio/src/routes/lab/gis/images/image-4.png
rename to website/src/routes/toolkits/gis/images/image-4.png
diff --git a/portfolio/src/routes/lab/gis/images/image-5.png b/website/src/routes/toolkits/gis/images/image-5.png
similarity index 100%
rename from portfolio/src/routes/lab/gis/images/image-5.png
rename to website/src/routes/toolkits/gis/images/image-5.png
diff --git a/portfolio/src/routes/lab/gis/images/image.png b/website/src/routes/toolkits/gis/images/image.png
similarity index 100%
rename from portfolio/src/routes/lab/gis/images/image.png
rename to website/src/routes/toolkits/gis/images/image.png
diff --git a/portfolio/src/routes/lab/gis/images/maps-cover.webp b/website/src/routes/toolkits/gis/images/maps-cover.webp
similarity index 100%
rename from portfolio/src/routes/lab/gis/images/maps-cover.webp
rename to website/src/routes/toolkits/gis/images/maps-cover.webp
diff --git a/portfolio/src/routes/lab/mdsvex/+page.md b/website/src/routes/toolkits/mdsvex/+page.md
similarity index 100%
rename from portfolio/src/routes/lab/mdsvex/+page.md
rename to website/src/routes/toolkits/mdsvex/+page.md
diff --git a/portfolio/src/routes/lab/mdsvex/mdsvex.avif b/website/src/routes/toolkits/mdsvex/mdsvex.avif
similarity index 100%
rename from portfolio/src/routes/lab/mdsvex/mdsvex.avif
rename to website/src/routes/toolkits/mdsvex/mdsvex.avif
diff --git a/portfolio/src/routes/lab/nebula.gif b/website/src/routes/toolkits/nebula.gif
similarity index 100%
rename from portfolio/src/routes/lab/nebula.gif
rename to website/src/routes/toolkits/nebula.gif
diff --git a/portfolio/src/routes/lab/three-camera-controls/+page.svelte b/website/src/routes/toolkits/three-camera-controls/+page.svelte
similarity index 100%
rename from portfolio/src/routes/lab/three-camera-controls/+page.svelte
rename to website/src/routes/toolkits/three-camera-controls/+page.svelte
diff --git a/website/src/routes/toolkits/three-camera-controls/+page.ts b/website/src/routes/toolkits/three-camera-controls/+page.ts
new file mode 100644
index 0000000..4d5667b
--- /dev/null
+++ b/website/src/routes/toolkits/three-camera-controls/+page.ts
@@ -0,0 +1,3 @@
+// This configuration only prerenders the homepage (/)
+// Other routes need their own prerender configuration if needed
+export const prerender = false;
diff --git a/portfolio/src/routes/lab/three-camera-controls/3d-cube.gif b/website/src/routes/toolkits/three-camera-controls/3d-cube.gif
similarity index 100%
rename from portfolio/src/routes/lab/three-camera-controls/3d-cube.gif
rename to website/src/routes/toolkits/three-camera-controls/3d-cube.gif
diff --git a/portfolio/src/routes/lab/wordpress.webp b/website/src/routes/toolkits/wordpress.webp
similarity index 100%
rename from portfolio/src/routes/lab/wordpress.webp
rename to website/src/routes/toolkits/wordpress.webp
diff --git a/portfolio/src/routes/lab/wordpress/+layout.server.ts b/website/src/routes/toolkits/wordpress/+layout.server.ts
similarity index 100%
rename from portfolio/src/routes/lab/wordpress/+layout.server.ts
rename to website/src/routes/toolkits/wordpress/+layout.server.ts
diff --git a/portfolio/src/routes/lab/wordpress/+page.server.ts b/website/src/routes/toolkits/wordpress/+page.server.ts
similarity index 100%
rename from portfolio/src/routes/lab/wordpress/+page.server.ts
rename to website/src/routes/toolkits/wordpress/+page.server.ts
diff --git a/portfolio/src/routes/lab/wordpress/+page.svelte b/website/src/routes/toolkits/wordpress/+page.svelte
similarity index 82%
rename from portfolio/src/routes/lab/wordpress/+page.svelte
rename to website/src/routes/toolkits/wordpress/+page.svelte
index 8854d5d..fbd1381 100644
--- a/portfolio/src/routes/lab/wordpress/+page.svelte
+++ b/website/src/routes/toolkits/wordpress/+page.svelte
@@ -78,7 +78,7 @@
-
+
+
Latest Work ({count})
{#if hasFilters}
@@ -89,9 +89,9 @@
{#if !data}
Loading...
{:else} -
+
-
Categories
+ Categories
{#each filteredCategories as category}
@@ -103,7 +103,7 @@
-
Tags
+ Tags
{#each filteredTags as tag}
@@ -118,31 +118,31 @@
{#each Object.keys($filteredPosts).sort().reverse() as year}
{#if $filteredPosts[year].length > 0}
-
{year}
--
+
{year}
+-
{#each $filteredPosts[year] as post}
{#if post.media_url}
{/if}
-
{@html post.post_title}
+{@html post.post_title}
-
+
{@html post.excerpt}
-
+
{#each post.categories as categorie}
+
diff --git a/website/src/routes/work/+page.ts b/website/src/routes/work/+page.ts
new file mode 100644
index 0000000..4d5667b
--- /dev/null
+++ b/website/src/routes/work/+page.ts
@@ -0,0 +1,3 @@
+// This configuration only prerenders the homepage (/)
+// Other routes need their own prerender configuration if needed
+export const prerender = false;
diff --git a/portfolio/src/routes/work/[slug]/+page.server.ts b/website/src/routes/work/[slug]/+page.server.ts
similarity index 100%
rename from portfolio/src/routes/work/[slug]/+page.server.ts
rename to website/src/routes/work/[slug]/+page.server.ts
diff --git a/portfolio/src/routes/work/[slug]/+page.svelte b/website/src/routes/work/[slug]/+page.svelte
similarity index 100%
rename from portfolio/src/routes/work/[slug]/+page.svelte
rename to website/src/routes/work/[slug]/+page.svelte
diff --git a/portfolio/static/3d/nebula/Logo.png b/website/static/3d/nebula/Logo.png
similarity index 100%
rename from portfolio/static/3d/nebula/Logo.png
rename to website/static/3d/nebula/Logo.png
diff --git a/website/static/3d/nebula/ctw.svg b/website/static/3d/nebula/ctw.svg
new file mode 100644
index 0000000..fbee11f
--- /dev/null
+++ b/website/static/3d/nebula/ctw.svg
@@ -0,0 +1,42 @@
+
+
diff --git a/portfolio/static/3d/nebula/index.html b/website/static/3d/nebula/index.html
similarity index 100%
rename from portfolio/static/3d/nebula/index.html
rename to website/static/3d/nebula/index.html
diff --git a/portfolio/static/3d/nebula/postprocessing.min.js b/website/static/3d/nebula/postprocessing.min.js
similarity index 100%
rename from portfolio/static/3d/nebula/postprocessing.min.js
rename to website/static/3d/nebula/postprocessing.min.js
diff --git a/portfolio/static/3d/nebula/smoke.png b/website/static/3d/nebula/smoke.png
similarity index 100%
rename from portfolio/static/3d/nebula/smoke.png
rename to website/static/3d/nebula/smoke.png
diff --git a/portfolio/static/3d/nebula/stars.jpg b/website/static/3d/nebula/stars.jpg
similarity index 100%
rename from portfolio/static/3d/nebula/stars.jpg
rename to website/static/3d/nebula/stars.jpg
diff --git a/portfolio/static/3d/nebula/styles.css b/website/static/3d/nebula/styles.css
similarity index 100%
rename from portfolio/static/3d/nebula/styles.css
rename to website/static/3d/nebula/styles.css
diff --git a/portfolio/static/3d/nebula/three.min.js b/website/static/3d/nebula/three.min.js
similarity index 100%
rename from portfolio/static/3d/nebula/three.min.js
rename to website/static/3d/nebula/three.min.js
diff --git a/website/static/3d/world-dots/ctw.svg b/website/static/3d/world-dots/ctw.svg
new file mode 100644
index 0000000..fbee11f
--- /dev/null
+++ b/website/static/3d/world-dots/ctw.svg
@@ -0,0 +1,42 @@
+
+
diff --git a/portfolio/static/3d/world-dots/index.html b/website/static/3d/world-dots/index.html
similarity index 100%
rename from portfolio/static/3d/world-dots/index.html
rename to website/static/3d/world-dots/index.html
diff --git a/website/static/favicon.png b/website/static/favicon.png
new file mode 100644
index 0000000..7225aa2
Binary files /dev/null and b/website/static/favicon.png differ
diff --git a/portfolio/static/googlec3d5c8ef355bc0fd.html b/website/static/googlec3d5c8ef355bc0fd.html
similarity index 100%
rename from portfolio/static/googlec3d5c8ef355bc0fd.html
rename to website/static/googlec3d5c8ef355bc0fd.html
diff --git a/website/static/images/about.webp b/website/static/images/about.webp
new file mode 100644
index 0000000..a13c954
Binary files /dev/null and b/website/static/images/about.webp differ
diff --git a/website/static/images/health30.avif b/website/static/images/health30.avif
new file mode 100644
index 0000000..278f5e7
Binary files /dev/null and b/website/static/images/health30.avif differ
diff --git a/website/static/images/ideasdiamond.avif b/website/static/images/ideasdiamond.avif
new file mode 100644
index 0000000..911b62d
Binary files /dev/null and b/website/static/images/ideasdiamond.avif differ
diff --git a/website/static/images/isthefood.avif b/website/static/images/isthefood.avif
new file mode 100644
index 0000000..b19633e
Binary files /dev/null and b/website/static/images/isthefood.avif differ
diff --git a/website/static/images/notidian.avif b/website/static/images/notidian.avif
new file mode 100644
index 0000000..0a8e8b4
Binary files /dev/null and b/website/static/images/notidian.avif differ
diff --git a/website/static/images/profile.avif b/website/static/images/profile.avif
new file mode 100644
index 0000000..02f6b6f
Binary files /dev/null and b/website/static/images/profile.avif differ
diff --git a/website/static/images/supertaal.avif b/website/static/images/supertaal.avif
new file mode 100644
index 0000000..a785826
Binary files /dev/null and b/website/static/images/supertaal.avif differ
diff --git a/website/static/images/valorlist.avif b/website/static/images/valorlist.avif
new file mode 100644
index 0000000..82d111a
Binary files /dev/null and b/website/static/images/valorlist.avif differ
diff --git a/portfolio/svelte.config.js b/website/svelte.config.js
similarity index 100%
rename from portfolio/svelte.config.js
rename to website/svelte.config.js
diff --git a/portfolio/tailwind.config.js b/website/tailwind.config.js
similarity index 100%
rename from portfolio/tailwind.config.js
rename to website/tailwind.config.js
diff --git a/website/tsconfig.json b/website/tsconfig.json
new file mode 100644
index 0000000..7b94a97
--- /dev/null
+++ b/website/tsconfig.json
@@ -0,0 +1,20 @@
+{
+ "extends": "./.svelte-kit/tsconfig.json",
+ "compilerOptions": {
+ "allowJs": true,
+ "checkJs": true,
+ "esModuleInterop": true,
+ "forceConsistentCasingInFileNames": true,
+ "resolveJsonModule": true,
+ "skipLibCheck": true,
+ "sourceMap": true,
+ "strict": true,
+ "moduleResolution": "bundler",
+ "types": ["svelte", "unplugin-icons/types/svelte"]
+ }
+ // Path aliases are handled by https://kit.svelte.dev/docs/configuration#alias
+ // except $lib which is handled by https://kit.svelte.dev/docs/configuration#files
+ //
+ // If you want to overwrite includes/excludes, make sure to copy over the relevant includes/excludes
+ // from the referenced tsconfig.json - TypeScript does not merge them in
+}
diff --git a/portfolio/vite.config.ts b/website/vite.config.ts
similarity index 100%
rename from portfolio/vite.config.ts
rename to website/vite.config.ts
{categorie.name}
diff --git a/portfolio/src/routes/lab/wordpress/[category]/[publication]/+page.server.ts b/website/src/routes/toolkits/wordpress/[category]/[publication]/+page.server.ts
similarity index 100%
rename from portfolio/src/routes/lab/wordpress/[category]/[publication]/+page.server.ts
rename to website/src/routes/toolkits/wordpress/[category]/[publication]/+page.server.ts
diff --git a/portfolio/src/routes/lab/wordpress/[category]/[publication]/+page.svelte b/website/src/routes/toolkits/wordpress/[category]/[publication]/+page.svelte
similarity index 100%
rename from portfolio/src/routes/lab/wordpress/[category]/[publication]/+page.svelte
rename to website/src/routes/toolkits/wordpress/[category]/[publication]/+page.svelte
diff --git a/portfolio/src/routes/lab/wordpress2.webp b/website/src/routes/toolkits/wordpress2.webp
similarity index 100%
rename from portfolio/src/routes/lab/wordpress2.webp
rename to website/src/routes/toolkits/wordpress2.webp
diff --git a/portfolio/src/routes/lab/world.gif b/website/src/routes/toolkits/world.gif
similarity index 100%
rename from portfolio/src/routes/lab/world.gif
rename to website/src/routes/toolkits/world.gif
diff --git a/website/src/routes/work/+page.svelte b/website/src/routes/work/+page.svelte
new file mode 100644
index 0000000..f104882
--- /dev/null
+++ b/website/src/routes/work/+page.svelte
@@ -0,0 +1,290 @@
+
+
+
+
+
+
+ + {#if $activeCategories.includes('Blog') || $activeTags.includes('Blog')} + Engineering Blog + {:else if $activeCategories.includes('Project')} + Work Projects + {:else if $activeCategories.includes('Digital Garden')} + 🌱 Digital Garden + {:else if $activeTags.length > 0} + {$activeTags.filter((tag) => tag !== 'Blog').join(', ')} + {:else} + All Work + {/if} + ({$filteredPosts.length}) +
+ {#if hasFilters} + + {/if} +
+
+
+
+ {#each globalCategories as { name, count }}
+
+ {/each}
+
+
+
+
+ 0}
+ >
+ {$activeTags.length ? `${$activeTags.length} selected` : 'Tags'}
+
+
+ {globalTags.length}
+
+ {#each Object.keys($postsByYear).reverse() as year}
+ {#each $postsByYear[year] as post}
+
+
+
+ {/each}
+ {/each}
+ + {#if shouldDisplayYear(parseInt(year))} + {year} + {/if} +
+ +
+ {#if post.metadata.coverImage}
+ 
+ {/if}
+
+
+
+
+ + {@html post.metadata.title} +
+ {#if post.metadata.description} +
+ {@html post.metadata.description}
+
+ {/if}
+
+
+
+
+ {#if post.metadata.categories}
+ {#each post.metadata.categories as category}
+
+ {category}
+ {/each}
+ {/if}
+ {#if post.metadata.tags}
+ {#each post.metadata.tags as tag}
+ {tag}
+ {/each}
+ {/if}
+