Product
Introducing License Enforcement in Socket
Ensure open-source compliance with Socket’s License Enforcement Beta. Set up your License Policy and secure your software!
volttron-sqlite-historian
Advanced tools
VOLTTRON historian agent that stores data into a SQLite database
Create and activate a virtual environment.
python -m venv env
source env/bin/activate
Installing volttron-sqlite-historian requires a running volttron instance.
pip install volttron
# Start platform with output going to volttron.log
volttron -vv -l volttron.log &
Create a agent configuration file SQLite historian supports two parameters
connection - This is a mandatory parameter with type indicating the type of sql historian (i.e. sqlite) and params containing the path the database file.
tables_def - Optional parameter to provide custom table names for topics, data, and metadata.
The configuration can be in a json or yaml formatted file.
Yaml Format:
connection:
# type should be sqlite
type: sqlite
params:
# Relative to the agents data directory
database: "data/historian.sqlite"
tables_def:
# prefix for data, topics, and (in version < 4.0.0 metadata tables)
# default is ""
table_prefix: ""
# table name for time series data. default "data"
data_table: data
# table name for list of topics. default "topics"
topics_table: topics
Install and start the volttron-sqlite-historian.
vctl install volttron-sqlite-historian --agent-config <path to configuration> --start
View the status of the installed agent
vctl status
Please see the following for contributing guidelines contributing.
Please see the following helpful guide about developing modular VOLTTRON agents
This material was prepared as an account of work sponsored by an agency of the United States Government. Neither the United States Government nor the United States Department of Energy, nor Battelle, nor any of their employees, nor any jurisdiction or organization that has cooperated in the development of these materials, makes any warranty, express or implied, or assumes any legal liability or responsibility for the accuracy, completeness, or usefulness or any information, apparatus, product, software, or process disclosed, or represents that its use would not infringe privately owned rights.
Reference herein to any specific commercial product, process, or service by trade name, trademark, manufacturer, or otherwise does not necessarily constitute or imply its endorsement, recommendation, or favoring by the United States Government or any agency thereof, or Battelle Memorial Institute. The views and opinions of authors expressed herein do not necessarily state or reflect those of the United States Government or any agency thereof.
FAQs
VOLTTRON historian that store data in sqlite3 database
We found that volttron-sqlite-historian demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Product
Ensure open-source compliance with Socket’s License Enforcement Beta. Set up your License Policy and secure your software!
Product
We're launching a new set of license analysis and compliance features for analyzing, managing, and complying with licenses across a range of supported languages and ecosystems.
Product
We're excited to introduce Socket Optimize, a powerful CLI command to secure open source dependencies with tested, optimized package overrides.