Mar 30, 2017

Seamonkey: How to watch Youtube video the old fashion way

Youtube is now using html5

This is great obviously, because it means by default the internet browser doesn't need any plugin.
But let say you want to read your video the old fashion way using adobe Flash
well you actually can ... just by adding the url &nohtml5=1

for example:
https://www.youtube.com/watch?v=4h_OSURFicY&nohtml5=1

This will open the video and use adobe flash (instead of html5)
if you are not sure - just right click on the video and you should see this:


Seamonkey: Enabling full-screen for Youtube video

Seamonkey default settings

For some reasons the internet browser Seamonkey decided to prevent people to open full screen YouTube video - maybe they were tired of complaints of user who couldn't not exit the video (by simply pressing Escape?!)

Anyway now by default the full-screen button on the lower-right is disabled.

Overriding the setting

in the url path type: about:config then confirm that you know what you are doing
then look for full-screen-api.enabled and set this to true

That is it

Mar 15, 2017

Sqlite: Using auto_increment and current date and time

The idea

As a good tip to get the most of the table entries - you want the user to focus on their important data - but you don't want to overwhelm them with extra typing that can be done automatically by database system.

Here is way to have an auto increment index and a default date and time of the entry done by the operator

Embedded during the table creation: 

sqlite> create table testauto (autoid integer primary key autoincrement, autodate default (datetime('now')), notes text ) ;

Operator just have to enter the notes column: 

sqlite> insert into testauto (notes) values ('this is a test of the auto increment and default date' ) ;
sqlite> insert into testauto (notes) values ('this is a second test of the auto increment and default date' ) ;
sqlite> insert into testauto (notes) values ('this is a third test of the auto increment and default date' ) ;

and as you see the index and the date are automatically filled

sqlite> select * from testauto ;
1|2017-03-15 15:34:05|this is a test of the auto increment and default date
2|2017-03-15 15:34:14|this is a second test of the auto increment and default date
3|2017-03-15 15:34:24|this is a third test of the auto increment and default date
sqlite>

Popular Posts