Available in Node.js 22.50 - see https://nodejs.org/api/sqlite.html
Given the Node.js release timeline, I think it will be reasonable to switch to the integrated Node.js sqlite as the default, which will avoid all the npm install kerfuffle too.
* mws authentication
* add more tests and permission checkers
* add logic to ensure that only authenticated users' requests are handled
* add custom login page
* Implement user authentication as well as session handling
* work on user operations authorization
* add middleware to route handlers for bags & tiddlers routes
* add feature that only returns the tiddlers and bags which the user has permission to access on index page
* refactor auth routes & added user management page
* fix Ci Test failure issue
* fix users list page, add manage roles page
* add commands and scripts to create new user & assign roles and permissions
* resolved ci-test failure
* add ACL permissions to bags & tiddlers on creation
* fix comments and access control list bug
* fix indentation issues
* working on user profile edit
* remove list users command & added support for database in server options
* implement user profile update and password change feature
* update plugin readme
* implement command which triggers protected mode on the server
* revert server-wide auth flag. Implement selective authorization
* ACL management feature
* Complete Access control list implementation
* Added support to manage users' assigned role by admin
* fix comments
* fix comment
Function definitions within a condition do not function as expected thanks to JS hoisting, so it is better to avoid it, and keep ESLint happy as well.
See discussion at #8622 with @pmario
Thank you @PotOfCoffee2Go I ended up taking some of your code from #8101 to get this up and running. There's still some stuff missing (like the tests!) but it gets things moving.
