Skip to content

Creating the SQLite Schemas #4

@smartbsd

Description

@smartbsd

Isn't more consistent with the captured values to have the following databases:

create table temperaturess (rDatetime datetime, sensorID text, temp numeric);

create table humidities (rDatetime datetime, sensorID text, hum numeric);

although having both with the same naming structure will work I believe for consistency of the captures values they should be named as above.

I'll see in the next lecture why they were named as in you video because this is my first time working with SQLite3 :)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions