On Ubuntu, we can use this command It will output something like After this, we can use ssh-add Explain “eval $(ssh-agent -s)” The command eval $(ssh-agent -s) is a convenient way to start the SSH agent and set up the necessary environment variables in the current shell session. Here’s a breakdown of what each part […]

Read More »

The values of the column like “[‘a’, ‘b’]”, “[‘a’]”, “[‘c’, ‘a’]” json_each(json_column): This function is used to expand the JSON array into a set of key-value pairs, where the key is the index or key within the array, and the value is the corresponding element. So that for each record of you_table, it will expand […]

Read More »

SQLite does NOT have a native ENUM data type like some other database systems such as MySQL. However, you can simulate enums in SQLite using a combination of a CHECK constraint and a TEXT or INTEGER column. Here’s an example using a TEXT column: If you need to add new values to your “enum” or […]

Read More »

This can be done by using the ‘opencv-python’ library. Install opencv-python Take the first frame of a video To capture a screenshot at 95% of the video duration To capture a screenshot at specific time like 3:24 Percentage to Screenshot time conversion To capture a snapshot at 95% of the video duration and then compute […]

Read More »