 simon
|
32a74c611c
|
adding backupdir variable to db rotate
|
2021-05-15 21:47:08 +07:00 |
|
simon
|
497d530f64
|
showing nice social preview img on top
|
2021-05-09 12:27:51 +07:00 |
|
simon
|
b1e3b62e4b
|
auto rotating pg dump files
|
2021-05-09 12:26:38 +07:00 |
|
simon
|
e3e0f294c3
|
now directly mounting dyn folder into container instead of second root to allow php to read it from web_root
|
2021-04-14 17:29:46 +07:00 |
|
simon
|
fd28ca9ca3
|
creating aqi tables now directly with php, js just for coloring
|
2021-04-14 17:27:59 +07:00 |
|
simon
|
1a76c3633f
|
rewrote get_epoch for a more robust date dedection
|
2021-04-13 17:02:41 +07:00 |
|
simon
|
0eee8a36fc
|
added initial monthly graph to frontent
|
2021-04-03 18:52:56 +07:00 |
|
simon
|
4857960c07
|
moved last year comparison to graphs page
|
2021-04-02 18:37:35 +07:00 |
|
simon
|
4b75e880b5
|
added monthly graph and json export to backend
|
2021-04-02 18:27:18 +07:00 |
|
simon
|
6a28abcc58
|
added US AQI subtitle to cloud to make it obvious
|
2021-03-26 14:17:18 +07:00 |
|
simon
|
05a71389cd
|
improved readability in last-7.png with better date format
|
2021-03-26 14:15:45 +07:00 |
|
simon
|
d122bda8b6
|
added year comparison graph to frontent
|
2021-03-22 19:36:14 +07:00 |
|
simon
|
4b478d47a9
|
reduced to last 7days for better layout
|
2021-03-22 19:35:45 +07:00 |
|
simon
|
f7cb5ffb03
|
standard good-bad colors through front and backend
|
2021-03-21 16:58:56 +07:00 |
|
simon
|
e2b0506b9f
|
exporting table to barchart in backend
|
2021-03-21 15:53:56 +07:00 |
|
simon
|
6b187607bb
|
refactored to have color_colums in a separte reusable function
|
2021-03-21 15:52:58 +07:00 |
|
simon
|
7853a9febb
|
added year comparison table to frontent
|
2021-03-21 12:33:10 +07:00 |
|
simon
|
4d9b2ddd2f
|
closing plt to no accumulate memory over time
|
2021-03-21 12:32:39 +07:00 |
|
simon
|
360ff9422e
|
interpolate single NaN value for nicer graph
|
2021-03-20 09:44:18 +07:00 |
|
simon
|
e2d95166ba
|
creating json file in backend to populate year comp table
|
2021-03-20 09:29:08 +07:00 |
|
simon
|
da37342332
|
more useful log output with row count for each table
|
2021-03-19 13:06:07 +07:00 |
|
simon
|
a2f88a795c
|
skip if no lastThreeImg is found
|
2021-03-19 13:04:01 +07:00 |
|
simon
|
74972282af
|
refreshing current.png on an interval with query string
|
2021-03-14 12:33:02 +07:00 |
|
simon
|
1ec5023c53
|
some example postgresql commands in use
|
2021-03-13 19:13:50 +07:00 |
|
simon
|
282662d6e1
|
restructured to allow preloader to run async, for now with timeout...
|
2021-03-13 19:11:25 +07:00 |
|
simon
|
db700d07bb
|
added preloader so css can be applied properly even after dom loaded
|
2021-03-13 19:10:26 +07:00 |
|
simon
|
3c7ce744f9
|
adding helper files to sync up to deploy and update automatically
|
2021-03-11 18:10:19 +07:00 |
|
simon
|
eaa36d8e06
|
added hourly avg graph to frontend
|
2021-03-11 18:09:53 +07:00 |
|
simon
|
e3286af0cd
|
backend creating bar chart for hourly avg aqi values
|
2021-03-08 12:40:16 +07:00 |
|
simon
|
0fe1e73d17
|
context about pandas and matplotlib in the backend
|
2021-03-08 11:14:38 +07:00 |
|
simon
|
054a544ee6
|
newest updates notification via php incl into colorbox on top
|
2021-03-07 22:03:35 +07:00 |
|
simon
|
524cd8379c
|
small graph title improvements, fontsize
|
2021-03-07 12:05:43 +07:00 |
|
simon
|
5ea110e4a4
|
added pm 2.4 and pm 10 to /graphs
|
2021-03-07 11:43:01 +07:00 |
|
simon
|
af93660e03
|
new fancy cloud.png
|
2021-03-06 22:53:41 +07:00 |
|
simon
|
e78976b576
|
creating bar charts for pm2.5 and pm10 daily average compared against thresh from WHO
|
2021-03-06 22:37:16 +07:00 |
|
simon
|
02df0b4026
|
helper scripts for import, testing and backup
|
2021-03-05 18:35:53 +07:00 |
|
simon
|
91832a95c0
|
scipy for smoth interpolation
|
2021-03-05 14:31:18 +07:00 |
|
simon
|
e5a80fc0a7
|
rebuild the last_7 graph to add a daily avg ax
|
2021-03-05 14:29:56 +07:00 |
|
simon
|
d5cd7a402c
|
added og: tags and img preview
|
2021-03-01 20:25:52 +07:00 |
|
simon
|
bf5619b346
|
sticky colorbox on top and other small ui improvements
|
2021-02-28 15:16:27 +07:00 |
|
simon
|
f6ada0ff00
|
last-7 days to homepage, using flex instead of grid for graph page for better mobile comp
|
2021-02-27 15:28:01 +07:00 |
|
simon
|
c7a53f0a1a
|
added last-7 days graph to backend
|
2021-02-27 15:10:23 +07:00 |
|
simon
|
0ef353b1b9
|
small mobile ui nav bar fix
|
2021-02-25 10:15:40 +07:00 |
|
simon
|
d9c3f65cfe
|
added graph as a dedicated page
|
2021-02-24 16:33:43 +07:00 |
|
simon
|
de4d2a36e4
|
added lokesh/lightbox2 to nicely display the graphs
|
2021-02-24 15:01:04 +07:00 |
|
simon
|
fb8fe182bf
|
daily export three graphs with values from last three days
|
2021-02-24 11:52:25 +07:00 |
|
simon
|
379f0acdbb
|
wifi keeps droping, trying some wifi reconnect logic.
|
2021-02-23 18:49:36 +07:00 |
|
simon
|
71dc41bb14
|
making the build and write plt functions reusable
|
2021-02-23 14:36:29 +07:00 |
|
simon
|
ff3a6e816b
|
creating plot of last 3h values with pandas and matplotlib
|
2021-02-23 12:09:26 +07:00 |
|
simon
|
5626c48a0e
|
rewrote db_insert to db_connect to make the connection functions reusable for other queries
|
2021-02-22 20:02:07 +07:00 |