Crate rustdb[−][src]

Expand description

ToDo List:

Test cookies.

Make sys.Function a system table. Index sys.Schema.

Implement DROP INDEX, ALTER TABLE, fully implement CREATE INDEX.

Sort out error handling for PARSEINT etc.

Work on improving/testing SQL code, browse schema, float I/O.

Features

builtin exposes an interface that allows extra SQL builtin functions to be defined.

max exposes a maximal interface, including internal details.

Database with SQL-like language. Example program:

use rustdb::{pstore::SharedPagedData, stg::SimpleFileStorage, web::WebQuery, Database, init::INITSQL};
use std::net::TcpListener;
use std::sync::Arc;
   let sfs = Box::new(SimpleFileStorage::new(
       "c:\\Users\\pc\\rust\\sftest01.rustdb",
   ));
   let spd = Arc::new(SharedPagedData::new(sfs));
   let wstg = spd.open_write();
   let db = Database::new(wstg, INITSQL);
   let listener = TcpListener::bind("127.0.0.1:3000").unwrap();
   for tcps in listener.incoming() {
       let mut tcps = tcps.unwrap();
       let mut wq = WebQuery::new(&tcps); // Reads the http request from the TCP stream into wq.
       let sql = "EXEC web.Main()";
       db.run_timed(&sql, &mut wq); // Executes SQL, http response, SQL output, (status,headers,content) is accumulated in wq.
       wq.write(&mut tcps); // Write the http response to the TCP stream.
       db.save(); // Saves database changes to disk.
   }