lin_reg_a real, lin_reg_b real, period_count long, sum_period_temp real, sum_period long, sum_temp real, sum_period_sqr long); CREATE TABLE input (sensor int8, period int8, temp real); select ...
In SQLite, creating a new database is simple because the database is just a single file. SQLite creates the database file automatically when you connect to a non-existent database. Here’s how you can ...