HydroShare stores all time series resources in SQLite files. Each Time Series resource has a single SQLite file. If you upload a CSV file to a time series resource, HydroShare will read your CSV file and transfer the data into a SQLite database. The CSV file will remain in your resource unless you remove it.
SQLite is a self-contained, relational database file. It is an efficient way to put a relational database into a single file that doesn’t require a server. SQLite files are also cross platform compatible and can be read using a variety of software and programming languages.
HydroShare uses SQLite to store time series because it is an efficient way to store one or more Time Series together in the same file. It also makes it easier to make sure the metadata for Time Series datasets can be stored and accessed consistently.
Time Series SQLite files in HydroShare use the ODM2 information model for their structure. You can read more about the ODM2 information model in the following locations:
- ODM2 GitHub repository (https://github.com/ODM2/ODM2)
- ODM2 Paper in Environmental Modelling & Software (http://dx.doi.org/10.1016/j.envsoft.2016.01.010)
The following are examples of software programs that can read and interact with SQLite database files:
- DB Browser for SQLite - A visual graphical user interface and open source software tool for creating, designing, viewing and editing SQLite database files (http://sqlitebrowser.org/).
- SQLite Manager - A free plugin for the Firefox Internet Broswer that enables you to view and manage any SQLite file (https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/).
- SQLite3 - A Python application programmer’s interface for SQLite (https://docs.python.org/2/library/sqlite3.html).
- RSQLite - an R package for accessing and managing SQLite databases (https://cran.r-project.org/web/packages/RSQLite/index.html).