In the Command Window, type buildit, and press Enter to build mksqlite (this will run the buildit.m script). Open MATLAB, and change the current path to that of the mksqlite folder Unzip the files to a folder, and note the path to that folder (e.g., /home/mksqlitefolder) Installing mksqlite in Ubuntu 14.04 LTS ¶ĭownload the latest mksqlite source files from SourceForge Information about mksqlite, such as function calls and examples, is available in the MKSQLITE: A MATLAB Interface to SQLite documentation. Also, SQLite must be installed prior to performing the following steps.
This section of the manual provides information on how to set up the mksqlite- package for use with MATLAB, and how to use the openandquery.m script.Īll code has been successfully tested with MATLAB 2013a, MATLAB 2014a, G++ 4.7 in Ubuntu 14.04 LTS, and Windows Visual C++ 2010. Instead, an open-source alternative, mksqlite, an interface between MATLAB and SQLite is used. The script does not use the MATLAB Database Manager GUI, a part of the Database Toolbox, which requires a paid license. The features, of opening, querying, and storing as an array, are made available in the MATLAB script openandquery.m. The data can then be stored in an array in the MATLAB Workspace, and then manipulated as desired. The SQLite database output by MOSAIC can be further processed using MATLAB. Once installed as described above, MosaicUtils must be imported as shown below. Returns the analysis algorithm used to process the current data set. NEvents : (optional) limit the plot to the first n entries in the databaseĪ dynamic object that allows the user to browse event time-series and fits. Plot the event-time series if stored in the database (see the Settings File section for details on saving time-series to the analysis output). Queries the metadata table using the supplied SQL query. ArgsĪ list of column types in the table metadata. Returns a list of column types from the metadata table. ArgsĪ list of column names in the table metadata. Returns a list of column headings from the metadata table. Virtualenv : name of the virtual environment configured for use with MOSAIC
If you use a virtual environment with Python, please call the SetVirtualEnv function after you install this addon.īackend : select the Mathematica (default) or Python (faster, experimental) backend to run SQLite queries. To select the Python backend, please call the SetQueryBackend function as described below.