yamlbase 0.7.2

A lightweight SQL server that serves YAML-defined tables over standard SQL protocols
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120

use std::sync::Arc;
use tokio::net::TcpListener;
use tracing::{error, info};

use crate::config::Config;
use crate::database::Storage;
use crate::yaml::{FileWatcher, parse_yaml_database};

mod connection_manager;
pub use connection_manager::{ConnectionManager, ConnectionStats};

#[cfg(test)]
mod tests;

pub struct Server {
    config: Arc<Config>,
    storage: Storage,
}

impl Server {
    pub async fn new(mut config: Config) -> crate::Result<Self> {
        // Parse initial database
        let (database, auth_config) = parse_yaml_database(&config.file).await?;

        // If auth is specified in YAML, override command line args
        if let Some(auth) = auth_config {
            info!(
                "Using authentication from YAML file: username={}",
                auth.username
            );
            config.username = auth.username;
            config.password = auth.password;
        } else {
            info!("Using default authentication: username={}", config.username);
        }

        let config = Arc::new(config);
        let storage = Storage::new(database);

        Ok(Self { config, storage })
    }

    pub async fn run(self) -> crate::Result<()> {
        let addr = format!(
            "{}:{}",
            self.config.bind_address,
            self.config.effective_port()
        );
        info!("Starting YamlBase server on {}", addr);

        // Set up hot reload if enabled
        if self.config.hot_reload {
            self.setup_hot_reload()?;
        }

        // Create connection manager for stable connection handling
        let connection_manager =
            ConnectionManager::new(self.config.clone(), Arc::new(self.storage.clone())).await?;

        // Start background monitoring for connection stability
        let _monitoring_handle = connection_manager.start_monitoring();

        // Start listening
        let listener = TcpListener::bind(&addr).await?;
        info!(
            "Server listening on {} with connection stability features",
            addr
        );

        // Accept connections with enhanced stability handling
        loop {
            let (stream, client_addr) = listener.accept().await?;
            let client_addr_str = client_addr.to_string();
            info!("New connection from {}", client_addr_str);

            let manager = connection_manager.clone();
            tokio::spawn(async move {
                if let Err(e) = manager
                    .handle_connection(stream, client_addr_str.clone())
                    .await
                {
                    error!("Connection error from {}: {}", client_addr_str, e);
                }
            });
        }
    }

    fn setup_hot_reload(&self) -> crate::Result<()> {
        let (watcher, mut rx) = FileWatcher::new(self.config.file.clone());
        watcher
            .start()
            .map_err(|e| crate::YamlBaseError::Io(std::io::Error::other(e)))?;

        let storage = self.storage.clone();
        let config = self.config.clone();

        tokio::spawn(async move {
            while let Some(()) = rx.recv().await {
                info!("Reloading database from file");
                match parse_yaml_database(&config.file).await {
                    Ok((new_db, _auth)) => {
                        // Note: We don't update auth on hot reload for security reasons
                        // Auth changes require a server restart
                        let db_arc = storage.database();
                        let mut db = db_arc.write().await;
                        *db = new_db;
                        drop(db);
                        storage.rebuild_indexes().await;
                        info!("Database reloaded successfully");
                    }
                    Err(e) => {
                        error!("Failed to reload database: {}", e);
                    }
                }
            }
        });

        Ok(())
    }
}