SpreadServe Tech Spec¶
SpreadServe is a Windows Server hosted server product with a web UI.
- OSes: any Windows desktop OS from Windows 7, and any server OS from 2003. SpreadServe has been tested on Windows 7, Windows 8, Windows Server 2008 & 2012.
- User interface: web UI built with Angular 1.5, <http://Bootstrap 3.3 and jQuery 2.2 enabling job control and spreadsheet interaction from a browser.
- Python: the best API for Web integrations, as well as rapid, ad hoc development. SpreadServe uses Python 2.7.8, 3.x is not yet supported.
- C++: the best API for high performance systems integration. For example, this is the right way to connect SpreadServe to a low latency pub sub messaging system like TibRV or Solace. Integrations should be built with MS Visual Studio 2008 or later.
- REST: external processes can drive SpreadServeEngines via the RealTimeWebServer REST API.
- Java: the best option for relational database integration with JDBC. spreadserve.jar is built with JDK 1.6.
- Core implementation: SpreadServe’s native implementation language is C++ built as 32 bit binaries with Microsoft Visual C++ 9.
- VBA: SpreadServe supports VBA macros, but does not support VBA GUI operations.
- XLL: SpreadServe supports XLL addins, and has been tested with the QuantLib 1.4.0 addin.
- RTD: SpreadServe supports RTD updates.
- Excel file formats: Excel 97-2003 .xls as well as the default Excel .xlsx format are supported.
- RDBMS: the dblog component enables logging of all SpreadSheet operations to an RDB. SpreadServe has been tested with MySQL 5.6, and should work with any RDB that has a JDBC driver.
- Sockets: The SocketServer enables connections from processes based on other hosts and implementation technologies.
- Open Source Software: SpreadServe uses several powerful OSS technologies as building blocks. They include Tornado, Python, STLport , Boost and Apache Open Office.
- Cloud ready: SpreadServe has been deployed and tested on Amazon EC2 Windows 2008 & 2012 AMIs.