feat: fail fast if db not connecting

Bumps the npm_and_yarn group with 1 update in the / directory: [vite](https://github.com/vitejs/vite/tree/HEAD/packages/vite).


Updates `vite` from 7.1.10 to 7.1.11
- [Release notes](https://github.com/vitejs/vite/releases)
- [Changelog](https://github.com/vitejs/vite/blob/main/packages/vite/CHANGELOG.md)
- [Commits](https://github.com/vitejs/vite/commits/v7.1.11/packages/vite)

---
updated-dependencies:
- dependency-name: vite
  dependency-version: 7.1.11
  dependency-type: direct:development
  dependency-group: npm_and_yarn
...

Signed-off-by: dependabot[bot] <support@github.com>

package-lock.json

@@ -35,7 +35,7 @@
 				"tailwindcss": "^4.0.0",
 				"typescript": "^5.0.0",
 				"typescript-eslint": "^8.20.0",
-				"vite": "^7.1.10"
+				"vite": "^7.1.11"
 			}
 		},
 		"node_modules/@drizzle-team/brocli": {
@@ -4924,9 +4924,9 @@
 			"license": "MIT"
 		},
 		"node_modules/vite": {
-			"version": "7.1.10",
+			"version": "7.1.11",
-			"resolved": "https://registry.npmjs.org/vite/-/vite-7.1.10.tgz",
+			"resolved": "https://registry.npmjs.org/vite/-/vite-7.1.11.tgz",
-			"integrity": "sha512-CmuvUBzVJ/e3HGxhg6cYk88NGgTnBoOo7ogtfJJ0fefUWAxN/WDSUa50o+oVBxuIhO8FoEZW0j2eW7sfjs5EtA==",
+			"integrity": "sha512-uzcxnSDVjAopEUjljkWh8EIrg6tlzrjFUfMcR1EVsRDGwf/ccef0qQPRyOrROwhrTDaApueq+ja+KLPlzR/zdg==",
 			"license": "MIT",
 			"dependencies": {
 				"esbuild": "^0.25.0",

package.json

@@ -35,7 +35,7 @@
 		"tailwindcss": "^4.0.0",
 		"typescript": "^5.0.0",
 		"typescript-eslint": "^8.20.0",
-		"vite": "^7.1.10"
+		"vite": "^7.1.11"
 	},
 	"dependencies": {
 		"@sveltejs/adapter-node": "^5.3.1",

src/hooks.server.ts

@@ -1,8 +1,30 @@
 // src/hooks.server.ts
 import type { Handle } from '@sveltejs/kit';
 import { generateUserId } from '$lib/generateUserId.js';
+import { ensureDatabaseConnection } from '$lib/database/healthCheck';
+
+// Global flag to track if database health check has been performed
+let dbHealthCheckPerformed = false;
 
 export const handle: Handle = async ({ event, resolve }) => {
+	// Perform database health check only once during application startup
+	if (!dbHealthCheckPerformed) {
+		try {
+			await ensureDatabaseConnection({
+				maxRetries: 3,
+				baseDelay: 1000,
+				maxDelay: 10000,
+				timeout: 5000
+			});
+			dbHealthCheckPerformed = true;
+		} catch (error) {
+			console.error('Database health check failed:', error);
+			// The ensureDatabaseConnection function will exit the process
+			// if the database is unavailable, so this catch is just for safety
+			process.exit(1);
+		}
+	}
+
 	const cactoideUserId = event.cookies.get('cactoideUserId');
 	const userId = generateUserId();
 

src/lib/calendarHelpers.ts

@@ -15,7 +15,10 @@ export interface CalendarEvent {
  * Formats a date and time string for iCal format (UTC)
  */
 export const formatDateForICal = (date: string, time: string): string => {
-	const eventDate = new Date(`${date}T${time}`);
+	// Parse date and time as local timezone to avoid timezone issues
+	const [year, month, day] = date.split('-').map(Number);
+	const [hours, minutes, seconds] = time.split(':').map(Number);
+	const eventDate = new Date(year, month - 1, day, hours, minutes, seconds || 0);
 	return eventDate.toISOString().replace(/[-:]/g, '').split('.')[0] + 'Z';
 };
 

src/lib/database/healthCheck.ts

@@ -0,0 +1,104 @@
+import postgres from 'postgres';
+import { env } from '$env/dynamic/private';
+
+interface HealthCheckOptions {
+	maxRetries?: number;
+	baseDelay?: number;
+	maxDelay?: number;
+	timeout?: number;
+}
+
+interface HealthCheckResult {
+	success: boolean;
+	error?: string;
+	attempts: number;
+	duration?: number;
+}
+
+/**
+ * Performs a database health check with retry logic and exponential backoff
+ */
+export async function checkDatabaseHealth(
+	options: HealthCheckOptions = {}
+): Promise<HealthCheckResult> {
+	const {
+		maxRetries = 3,
+		baseDelay = 1000, // 1 second
+		maxDelay = 10000, // 10 seconds
+		timeout = 5000 // 5 seconds
+	} = options;
+
+	if (!env.DATABASE_URL) {
+		console.error('DATABASE_URL environment variable is not set');
+		return {
+			success: false,
+			error: 'DATABASE_URL environment variable is not set',
+			attempts: 0
+		};
+	}
+
+	let lastError: Error | null = null;
+
+	console.log(`Starting database health check (max retries: ${maxRetries})`);
+
+	for (let attempt = 1; attempt <= maxRetries; attempt++) {
+		console.log(`Attempt ${attempt}/${maxRetries} - Testing database connection`);
+
+		try {
+			// Create a new connection for the health check
+			const client = postgres(env.DATABASE_URL, {
+				max: 1,
+				idle_timeout: 20,
+				connect_timeout: timeout / 1000, // Convert to seconds
+				onnotice: () => {} // Suppress notices
+			});
+
+			// Test the connection with a simple query
+			await client`SELECT 1 as health_check`;
+			await client.end();
+
+			console.log(`Database connection successful on attempt ${attempt}.`);
+
+			return {
+				success: true,
+				attempts: attempt
+			};
+		} catch (error) {
+			lastError = error as Error;
+			const errorMessage = error instanceof Error ? error.message : 'Unknown error';
+			console.error(`Connection failed on attempt ${attempt}: ${errorMessage}`);
+
+			// Don't wait after the last attempt
+			if (attempt < maxRetries) {
+				const delay = Math.min(baseDelay * Math.pow(2, attempt - 1), maxDelay);
+				console.log(`Waiting ${delay}ms before retry...`);
+				await new Promise((resolve) => setTimeout(resolve, delay));
+			}
+		}
+	}
+
+	const finalError = lastError?.message || 'Unknown database connection error';
+
+	console.error(`All ${maxRetries} attempts failed. Final error: ${finalError}`);
+
+	return {
+		success: false,
+		error: finalError,
+		attempts: maxRetries
+	};
+}
+
+/**
+ * Runs database health check and exits the process if it fails
+ */
+export async function ensureDatabaseConnection(options?: HealthCheckOptions): Promise<void> {
+	const result = await checkDatabaseHealth(options);
+
+	if (!result.success) {
+		console.error('Database connection failed after all retry attempts');
+		console.error(`Error: ${result.error}`);
+		console.error(`Attempts made: ${result.attempts}`);
+		console.error('Exiting application...');
+		process.exit(1);
+	}
+}

src/lib/dateHelpers.ts

@@ -1,11 +1,14 @@
 import type { Event } from './types';
 
 export const formatDate = (dateString: string): string => {
-	const date = new Date(dateString);
+	// Parse the date string as local date to avoid timezone issues
-	const year = date.getFullYear();
+	// Split the date string and create a Date object in local timezone
-	const month = String(date.getMonth() + 1).padStart(2, '0');
+	const [year, month, day] = dateString.split('-').map(Number);
-	const day = String(date.getDate()).padStart(2, '0');
+	const date = new Date(year, month - 1, day); // month is 0-indexed in Date constructor
-	return `${year}/${month}/${day}`;
+	const formattedYear = date.getFullYear();
+	const formattedMonth = String(date.getMonth() + 1).padStart(2, '0');
+	const formattedDay = String(date.getDate()).padStart(2, '0');
+	return `${formattedYear}/${formattedMonth}/${formattedDay}`;
 };
 
 export const formatTime = (timeString: string): string => {
@@ -17,7 +20,10 @@ export const formatTime = (timeString: string): string => {
 export const isEventInTimeRange = (event: Event, timeFilter: string): boolean => {
 	if (timeFilter === 'any') return true;
 
-	const eventDate = new Date(`${event.date}T${event.time}`);
+	// Parse date and time as local timezone to avoid timezone issues
+	const [year, month, day] = event.date.split('-').map(Number);
+	const [hours, minutes, seconds] = event.time.split(':').map(Number);
+	const eventDate = new Date(year, month - 1, day, hours, minutes, seconds || 0);
 	const now = new Date();
 
 	// Handle temporal status filters

src/routes/create/+page.server.ts

@@ -56,7 +56,13 @@ export const actions: Actions = {
 			});
 		}
 
-		if (new Date(date) < new Date()) {
+		// Check if date is in the past using local timezone
+		const [year, month, day] = date.split('-').map(Number);
+		const eventDate = new Date(year, month - 1, day);
+		const today = new Date();
+		today.setHours(0, 0, 0, 0);
+
+		if (eventDate < today) {
 			return fail(400, {
 				error: 'Date cannot be in the past.',
 				values: {
@@ -105,7 +111,7 @@ export const actions: Actions = {
 				type: type,
 				attendeeLimit: type === 'limited' ? parseInt(attendeeLimit) : null,
 				visibility: visibility,
-				userId: userId
+				userId: userId!
 			})
 			.catch((error) => {
 				console.error('Unexpected error', error);

src/routes/discover/+page.svelte

@@ -1,11 +1,14 @@
 <script lang="ts">
 	import type { Event, EventType } from '$lib/types';
 	import { goto } from '$app/navigation';
-	import type { PageData } from '../$types';
 	import { formatTime, formatDate, isEventInTimeRange } from '$lib/dateHelpers';
 	import { t } from '$lib/i18n/i18n.js';
 	import Fuse from 'fuse.js';
 
+	type DiscoverPageData = {
+		events: Event[];
+	};
+
 	let publicEvents: Event[] = [];
 	let error = '';
 	let searchQuery = '';
@@ -16,7 +19,7 @@
 	let showFilters = false;
 	let fuse: Fuse<Event>;
 
-	export let data: PageData;
+	export let data: DiscoverPageData;
 	// Use the server-side data
 	$: publicEvents = data?.events || [];
 
@@ -67,8 +70,15 @@
 
 		// Sort events by date and time
 		events = events.sort((a, b) => {
-			const dateA = new Date(`${a.date}T${a.time}`);
+			// Parse dates as local timezone to avoid timezone issues
-			const dateB = new Date(`${b.date}T${b.time}`);
+			const parseEventDateTime = (event: Event) => {
+				const [year, month, day] = event.date.split('-').map(Number);
+				const [hours, minutes, seconds] = event.time.split(':').map(Number);
+				return new Date(year, month - 1, day, hours, minutes, seconds || 0);
+			};
+
+			const dateA = parseEventDateTime(a);
+			const dateB = parseEventDateTime(b);
 
 			if (selectedSortOrder === 'asc') {
 				return dateA.getTime() - dateB.getTime();

src/routes/event/[id]/edit/+page.server.ts

@@ -86,8 +86,9 @@ export const actions: Actions = {
 			});
 		}
 
-		// Check if date is in the past (but allow editing past events for corrections)
+		// Check if date is in the past using local timezone (but allow editing past events for corrections)
-		const eventDate = new Date(date);
+		const [year, month, day] = date.split('-').map(Number);
+		const eventDate = new Date(year, month - 1, day);
 		const today = new Date();
 		today.setHours(0, 0, 0, 0);