1

I want to use SQLite with TRUNCATE journal mode (PRAGMA journal_mode = TRUNCATE), but I don't want all these -journal files to be visible to the normal users. I want them to behave like the .tmp files in Ms Word (hidden).

Is there some way to make them hidden, at least in Windows?

riot_starter
  • 1,218
  • 15
  • 28

1 Answers1

1

If you set the "hidden" attribute bit on the -journal file, SQLite will keep it. (As long as nobody ever uses the DELETE journal mode on that database.)

CL.
  • 173,858
  • 17
  • 217
  • 259