feat: client and server api changes to accomedate DB

1 files changed, 35 insertions, 0 deletions

diff --git a/internal/server/api/database.go b/internal/server/api/database.go
new file mode 100644
index 0000000..7057393
--- /dev/null
+++ b/internal/server/api/database.go
@@ -0,0 +1,35 @@
+package api
+
+import (
+	"database/sql"
+	"log"
+
+	"github.com/kyren223/eko/pkg/assert"
+)
+
+var db *sql.DB
+
+func ConnectToDatabase() {
+	db, err := sql.Open("sqlite3", "server.db")
+	assert.NoError(err, "DB should always be accessible")
+	assert.AddFlush(db)
+	log.Println("established connection with the database")
+
+	pragmas := []string{
+		"PRAGMA journal_mode = WAL;",
+		"PRAGMA synchronous = NORMAL;",
+		"PRAGMA temp_store = MEMORY;",
+		"PRAGMA mmap_size = 30000000000;",
+	}
+	for _, pragma := range pragmas {
+		_, err := db.Exec(pragma)
+		assert.NoError(err, "DB pragmas should always execute with no errors")
+	}
+
+	log.Println("database connection ready to be used")
+}
+
+func CloseDatabase() {
+	db.Close()
+	log.Println("connection with database closed")
+}