Web-version of Suoma-Sámi-Suoma sátnegirji with PHP and SQLite. This version is still under development but published in the hope it's helpful for you. The search already works quite well but some additional features are still in progress.
The web app is very lightweight and runs well and fast for example on Raspberry Pii as I do at home.
All the work and web-hosting is done without any financial support. Please help and contribute.
If you have new words or if you spot an error(s), please e-mail me skuolfi.relay980@passmail.net
You'll also need the latest satnegirji.db SQLite database. Put it somewhere outside your web ducument root. Webserver process needs to have access to it anyway.
Modify the $db variable to suite your configuration:
// Connect to SQLite database
$db = new SQLite3('/var/www/db/satnegirji.db');
I'll suggest you to make sure your webserver is configured properly and securely. Also modify your webserver to run *.html files as PHP files or rename index.html file as index.php file.
I'll also suggest you to make sure your webserver sends some additional security related http headers (Content Security Policy CSP). With Apache, you may put the below to your Apache configuration (modify the domain skuolfi.org to suite your own domain.
Header always set Strict-Transport-Security: "max-age=63072000; includeSubDomains; preload"
Header always set X-Content-Type-Options: "nosniff"
Header always set X-Frame-Options: "DENY"
header always set Cross-Origin-Resource-Policy: "default-src 'self';"
Header always set Content-Security-Policy: "default-src 'self'; script-src 'self'; connect-src 'self';style-src 'self';base-uri 'self' https://satnegirji.skuolfi.org;frame-src 'self';frame-ancestors 'self';form-action 'self';upgrade-insecure-requests;img-src 'self' data:"
Header always set Referrer-Policy: same-origin
I'll also suggest you to force https connection. With Apache web-server, you can put this to your conficuration (modify to suite your server):
Redirect permanent / https://your.dictionary.server/
Modify the security.txt as needeed and place it on https://your.dictionary.server/.well-known/security.txt