Uses new Rust 2021
|0.24.0||Sep 30, 2022|
#69 in Database interfaces
45 downloads per month
Webserver based on rustdb database, with database browsing, password hashing, database replication, email transmission and timed jobs.
Installation and starting server
First install Rust if it is not already installed. Then install rustweb2 from a command prompt using
cargo install rustweb2
From a command prompt, change to the the directory where the database is to be stored ( the file will be named rustweb.rustdb ). Start rustweb2 using
This should start rustweb2 server, listening on port 3000 ( you can use any available port ). You should then be able to browse to http://localhost:3000/admin From there are links to a Manual, Execute SQL, a list of Schemas and other links.
Initially login security is disabled. To enable it
(1) Edit the function login.hash and change the salt string.
(2) Use the Logins Menu link to set add a login user and set password.
(3) Edit the function login.get ( see instructions included there ).
A new database is initialised from the file admin-ScriptAll.txt in the current directory.
If ScriptAll.txt does not exist a default initialisation is used.
Start Rustweb2 in the directory (folder) where you want the replicated database stored, specifying the -rep option
rustweb2 2000 --rep https://mydomain.com
If login security has been enabled, you will need to specify login details ( obtained from the login.user table ), for example:
--login "uid=1; hpw=0xaaa023850abbdff839894888dd8e8abbceaaa023855abbdff839894888dd8e8c"
If the database is very large, it may be more practical to use FTP to get an initial copy of the database, otherwise a copy will be fetched automatically.
Replication is enabled by records being inserted in the log.Transaction table.
These records can be periodically deleted, provided that all replication servers are up to date.
Email can be sent using the email schema.
(1) Create a record in email.SmtpServer
(2) Create an email in email.msg
(3) Insert it into email.Queue
(4) Call the builtin function EMAILTX()
If an email cannot be sent, and the error is temporary, it will be inserted into the email.Delayed table and retried later.
Permanent errors are logged in email.SendError
A named SQL function (with no parameters) can be called at a specified time by creating a record in timed.Job.
This is used by the email system to retry temporary email send errors.
Read Only Requests
GET requests are processed using a read-only copy of the database, any changes made are not saved. This is useful for requests that take a significant time to process, as other requests can be processed in parallel. This can be overriden by adding a query parameter "save".
POST requests are assumed to be read-write, this can be overridden by adding a query parameter "readonly".
crates.io : https://crates.io/crates/rustweb2