search

HacklabJKL / visitors

Visitor data collector using DHCP leases
GNU General Public License v3.0
0 stars 1 forks source link

Support for PostgreSQL #20

Open samip5 opened 3 years ago

samip5 commented 3 years ago

I think it would be benifitical to have support for something other than sqlite, my go-to happens to be Postgres.

zouppen commented 1 year ago

PostgreSQL is a great database but this application is so lightweight and simple to work in an SQLite database so there is no point in migration. Also, it would make it harder to run on a router device.

However, patches are welcome for supporting multiple database backends.

samip5 commented 1 year ago

Using sqlite for graphing is just painful which was part of the reason for the request.

zouppen commented 1 year ago

PostgreSQL historical data dumping / streaming is easier to do, keeping the internal database as-is but dumping data for example in CSV format for easy importing of changes to PostgreSQL or even Excel. :)

samip5 commented 1 year ago

I don't agree with you on that. :)