search

eric-hedengren / database-peak-streaming

Python program that utilizes powerful instruments designed to measure changes in tension on oil platform walls
4 stars 0 forks source link

Change Timestamp Data to a More Readable Type #1

Closed eric-hedengren closed 4 years ago

eric-hedengren commented 4 years ago

Sqlite contains a data type called date time which can store information in this format: YYYY-MM-DD HH:MM:SS.SSS, which would be easily interpreted in contrast with epoch time.

APMonitor commented 4 years ago

I like that data type better. Any cost for disk space or memory for storing?

eric-hedengren commented 4 years ago

Probably. Additionally, we would need to format dates with python which could slow it down even more.

eric-hedengren commented 4 years ago

Converting values will be simple and fast when analyzing data, so we won't worry about storing a different type in the database.