How to run sqlite3.exe from console to apply the vacuum command to the database?

Question

System administration

Good day!
Please tell me a real example of how to use the sqlite3.exe utility to free up empty space in the database (use the vacuum command), an example is needed with all the parameters, subtleties, quotes, path requirements, etc. because it is absolutely not clear how to use the utility from cmd file. I have already spent a lot of time, but I just can’t figure it out, and I’m tired of putting it off indefinitely.
Additional wishes: it is highly desirable that the temporary file be stored in RAM.
It will apply like this:

forfiles.exe /p "%PATH_TO_VACUUM%" /s /m *.sqlitedb /c "sqlite3.exe XXXXXX @path\@file XXXXXX "

Answer 1

sqlite3 -batch some.db vacuum