mirror of
https://github.com/Dvorinka/Dash.git
synced 2026-06-03 15:02:56 +00:00
Tomas Dvorak
b17a06fbba
A clean, customizable homelab dashboard inspired by CasaOS. Features: - Empty-first dashboard (no demo data) - 3 themes: Light, Dark, CasaOS glassmorphism - Widgets: Clock (multi-timezone), Pi-hole, Memos, Immich, Image - Drag & drop app organization - Grid + list view for apps - Groups with collapse/expand - Proper widget refresh handling - Visual timezone picker - Square app cards with hover effects Stack: Go + Gin + PostgreSQL + Next.js 15 + React 19 + Tailwind CSS + shadcn/ui
20 lines
723 B
SQL
20 lines
723 B
SQL
-- name: ListGroups :many
|
|
SELECT id::text, name, sort_order, collapsed, created_at, updated_at
|
|
FROM groups
|
|
ORDER BY sort_order ASC, created_at ASC;
|
|
|
|
-- name: ListServices :many
|
|
SELECT id::text, group_id, name, icon_url, icon_asset_id, sort_order, created_at, updated_at
|
|
FROM services
|
|
ORDER BY group_id NULLS FIRST, sort_order ASC, created_at ASC;
|
|
|
|
-- name: ListServiceURLs :many
|
|
SELECT id::text, service_id::text, label, kind, url, sort_order, is_primary, created_at, updated_at
|
|
FROM service_urls
|
|
ORDER BY service_id, sort_order ASC, created_at ASC;
|
|
|
|
-- name: ListWidgets :many
|
|
SELECT id::text, type, title, enabled, sort_order, config, created_at, updated_at
|
|
FROM widget_instances
|
|
ORDER BY sort_order ASC, created_at ASC;
|