Android Question sqlLite journal

[DPaul]

Hi,

Each time the app creates a database, it also creates a "-journal" file.
When i read stuff about sqlLite, it says that the "-journal" file
is temporary, but even when i close the db and the app properly,
the journal remains.

Does b4a support a native command that deletes this file, or should i dive
into this "PRAGMA...." commands stuff.

I could also delete it programatically, but that is ugly :-(

thx,
paul

 

[Erel]

You shouldn't delete it. Why do want to remove it?

 

[DPaul]

Well, as it is defined as "Temporary" in the SQLlite doc, why is it still there?
I seem to have no use for it, but it may be that the system does without me knowing

The real reason is, that the user can select amongst historical databases, with data he entered before. (openFileDialog)
I do set the filter to "mydatabase.FileFilter = ".db" , but that also shows everything "beginning with" db, and that is somewhat confusing.

Paul

 

[Erel]

These are temporary files but they are managed by the SQLite engine. The journal file is important for the ability to recover from errors.

There are all kinds all file explorers available in the forum. You should find one that allows you to filter the files or list the databases yourself.

 

[DPaul]

Mmmmmm....
Or i could filter to "mydatabase.FileFilter = ".db-journal", that way i see no duplicates either.
And a quick regex.replace in the "chosenname" also does the trick

But i bet purists would not approve.

Paul