mysql order negative number

In a table (chronological) if you have dates stored as text you could have problem to order your data.

I.g. you coud have this (wrong) order:

-13.600.000.000, -13.700.000.000,-4.600.000.000

To get the right order you can try with

cast(data as int)

Where “data” is the column of data (as the above values). In this way you will get the correct order:

-13.700.000.000, -13.600.000.000,-4.600.000.000

Flatpack and the space of the hard disk

Flatpack has the big advantage that you can a) run apps that couldn’t run the “normal” way (integrated with the system), because of lack of dependencies or b) have automatic updates of apps otherwise upgradable only via ppa or manually.

But its big disadvantage is the space occupied on your hard disk: indeed any app in Flatpack is a “world” in itself, regardless not only of the system, but also other apps in Flatpack itself.

Therefore, be careful to add Flatpack apps, unless you need really them (and them via Flatpack).

Create a video with a static image from an audio file

In Linux this is possible in a terminal, with the following command:

ffmpeg -loop 1 -i image.jpg -i audio.mp3 -c:v libx264 -tune stillimage -c:a aac -b:a 192k -vf "scale='iw-mod(iw,2)':'ih-mod(ih,2)',format=yuv420p" -shortest -movflags +faststart out.mp4