• Registered: 2014-08-02
  • Posts: 914

Topic: Delete picture from the base

Hello Dmitry

Let's say :

An application to manage any collection.
This application  shows pictures.
From the begining, for the DBImage, property Type was set to StoreFile.
Subsequently, we realize that with pictures embeded in the base, this one is growing and growing ....

We decide to store images in a separate file. Property Type is then set to LinkFile and we get a name for the folder
used to store pictures (using property CopyTo). And we go ahead with our new records.

As our base is already very high, we do not want to re-enter any records, we continue using LinkFile.

By taking each of the previously entered records and by applying  the button 'Delete the image from the database' from DBImage,
does this action delete really from the database the previously entered picture and therefore, is that the weight of the sql file found in all lightened ?

If not, what is the goal of the button 'Delete the image from the database' ?

Thanks for your advices ont this point.

JB

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Delete picture from the base

In fact, when you delete something from database, information from the database is not deleted, this place is marked as free, this place will be occupied by new records.


But it is possible to delete these records actually. Open your database file (sqlite.db) in SQLite Studio, then run command Vacuum.
Menu: Databases > Vacuum

Dmitry.