How to run sqlite commands about emby-scripterx HOT 4 CLOSED

I have created a batch file, works like a charm on windows to purge the activity log:

REM Parameters expected: None
cd C:\Users\Administrator\AppData\Roaming\Emby-Server\programdata\data
sqlite3.exe "activitylog.db" "DELETE FROM ActivityLog;" "VACUUM;" ".exit"
@echo Scheduled Task Run. >> C:\scheduledtask.log

from emby-scripterx.

Just assumes not tested:
Install the Sqlite cli binary --> https://sqlite.org/cli.html

create a shell script named like "optimize.sh":
#!/bin/sh
sqlite3 /path/to/db/foo.db 'VACUUM;'
sqlite3 /path/to/db/foo.db 'ANALYZE;'
sqlite3 /path/to/db/foo.db 'REINDEX;'

now make it executable:
chmod u+x optimize.sh

from emby-scripterx.

Would need the linux versions :P

from emby-scripterx.

Thank you so much guys for sorting this one out!

Kindest regards,
Anthony

from emby-scripterx.