search

dthonon / Client_API_VN

Export from VisioNature (Biolovision) web site to local postgresql database
GNU General Public License v3.0
3 stars 1 forks source link

Table download_log size must be limited #152

Open dthonon opened 3 years ago

dthonon commented 3 years ago

Currently, download_log extends without limitation. It should be limited to a rolling window of a number of days.

dthonon commented 3 years ago

To keep 100 rows per site, something like: delete from download_log where site = site order by download_ts desc offset 100;