Re: Postgres DB design Question (High Level)

2025-06-18 Thread Al Grant
Not sure if it makes a big difference to the answer, but MySQL was a typo - the edge db on the Rpi is Sqlite3. On Thu, Jun 19, 2025 at 5:00 PM Laurenz Albe wrote: > > On Thu, 2025-06-19 at 16:50 +1200, Al Grant wrote: > > I want to create a web based dashboard for all the currently detected > > s

Re: Postgres DB design Question (High Level)

2025-06-18 Thread Laurenz Albe
On Thu, 2025-06-19 at 16:50 +1200, Al Grant wrote: > I want to create a web based dashboard for all the currently detected > signals, where the dashboard contains a graph of the daily beep rate > for each channel (max 100 channels) over user selectable periods from > 1 week to 1 year - that query d

Postgres DB design Question (High Level)

2025-06-18 Thread Al Grant
Introduction: I have a question about the design of a project as it relates to databases, and the scale-ability of the design. The project is volunteer, so there is no commercial interest. But first a bit of background: Background: I have programmed a rasp pi to record radio beeps from wildlife