As SignalSQL is currently undergoing active development, it does have some limitations.
- SignalSQL has a limitation where only one database is supported, and it does not allow the use of the
CREATE DATABASEcommand. Upon installation, a single database named “main” is present by default. - Currently, SignalSQL does not support the creation of views using the
CREATE VIEWstatement. - TLS connections are not currently supported in SignalSQL. The transmission of usernames and passwords involves relatively weak scrambling over the network. It is essential to be aware of potential security implications in your setup due to this limitation. Consider implementing additional security measures if necessary for your specific use case.
- The SQL query processor in SignalSQL is basic and lacks optimizations for execution plans. If your application involves the storage and processing of substantial amounts of data, it is advisable to switch to a standard database designed for such tasks. However, it’s worth noting that the query processing in SignalSQL meets the requirements for signal processing, especially given that most of the data is kept in memory.