order subs in asc alphabetic order

2 files changed, 5 insertions, 2 deletions

diff --git a/flake.nix b/flake.nix
index 3677a5a..b8e13b0 100644
--- a/flake.nix
+++ b/flake.nix
@@ -41,7 +41,7 @@
             cp -R ./node_modules/* $out/node_modules
             ls -la $out/node_modules
           '';
-          outputHash = "sha256-UiD/gqwaU1+qLNkeds2i7kVgCjlrgxsTcqQDbO8+gG8=";
+          outputHash = "sha256-+4jTWcQFKd5ZxoViWabHgANIV/fi6oevqK9MiyWeF5c=";
           outputHashAlgo = "sha256";
           outputHashMode = "recursive";
         };
diff --git a/src/routes/index.js b/src/routes/index.js
index f4c0fc9..ef395ed 100644
--- a/src/routes/index.js
+++ b/src/routes/index.js
@@ -97,8 +97,11 @@ router.get(
 // GET /subs
 router.get("/subs", authenticateToken, async (req, res) => {
         const subs = db
-                .query("SELECT * FROM subscriptions WHERE user_id = $id")
+                .query(
+                        "SELECT * FROM subscriptions WHERE user_id = $id ORDER by LOWER(subreddit)",
+                )
                 .all({ id: req.user.id });
+
         res.render("subs", { subs, user: req.user });
 });