From 41039b36ec75467076ada2bb0f6f7866eafaea09 Mon Sep 17 00:00:00 2001
From: Jacob McDonnell <jacob@jacobmcdonnell.com>
Date: Sat, 25 Apr 2026 20:10:07 -0400
Subject: feat: Main Page to search for man pages

Added a main index page that uses HTMX to search for man pages and
place the contents on the page.
---
 sql.go.example | 46 ++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 46 insertions(+)
 create mode 100644 sql.go.example

(limited to 'sql.go.example')

diff --git a/sql.go.example b/sql.go.example
new file mode 100644
index 00000000..af73c7ad
--- /dev/null
+++ b/sql.go.example
@@ -0,0 +1,46 @@
+package main
+
+import (
+	"database/sql"
+	_ "modernc.org/sqlite"
+	"fmt"
+	"log"
+	_ "modernc.org/sqlite"
+)
+
+type Entry struct {
+	os      string
+	name    string
+	section int
+	path    string
+}
+
+func main() {
+	db, err := sql.Open("sqlite", "man.db")
+	if err != nil {
+		log.Fatal(err)
+	}
+
+	if err := db.Ping(); err != nil {
+		log.Fatal(err)
+	}
+
+	r, err := db.Query("SELECT * FROM manpages WHERE name == 'intro';")
+	if err != nil {
+		log.Fatal(err)
+	}
+	defer r.Close()
+
+	for r.Next() {
+		var entry Entry
+		if err := r.Scan(&entry.os, &entry.name, &entry.section, &entry.path); err != nil {
+			log.Fatal(err)
+		}
+		fmt.Println(entry.os, entry.name, entry.section, entry.path)
+	}
+
+	err = db.Close()
+	if err != nil {
+		log.Fatal(err)
+	}
+}
-- 
cgit v1.2.3