Minimal SQL field types

Every SQL database from the simplest to the most complex should have these fields as a Minimum:

PRIMARY KEY for storing the unique ID number of a record

TIMESTAMP DEFAULT NOW for storing the date the record was initially created. TIMESTAMP has been included since SQL:1999

CLOB for storing long character strings such as Memo fields. CLOB has been included since SQL:2008.


Prayeing for a Schizophrenic Man

Jesus says that we should pray for and bless our enemies, so that they will turn to the Light. I have a Schizo. Affective (Psychotic) man who is a housemate to me where I live. I'd prefer he not live here.

Schizophrenia is caused by the brain not developing properly. People like my housemate cannot have normal feelings like empathy, guilt, wrongdoing. They are controlled by Demon spirits who are "walk-ins". They use Human bodies so that they can use them to destroy Humanity.

We must not let them win!

Matthew 5:44:

"But I tell you, love your enemies and pray for those who persecute you,"


1 Peter 3:9:

"Don't repay evil for evil. Don't retaliate with insults when people insult you. Instead, pay them back with a blessing. That is what God has called you to do, and he will bless you for it."

So I pray Lord Jesus that Jeff's physical brain be reconfigured in its hormones and physical makeup, to render the Demons "Brian" and the Demon-creature ineffective. That Jeff's brain heal completely and that Jeff develops more and more empathy so that he is not a danger to himself, myself, or society.



Kdenlive - fedora-multimedia negativo17

For several months, after doing an update including multimedia files, I can no longer render digital video to MP4 or any other format.

I get an error

So I filed a bug report (379828) at in May 2017.

Today, someone else in this universe said they get the same error too.

Looking at my repositories, 'fedora-multimedia' is maintained by 'negativo17'.

I am wondering now, whether I could somehow backtrack out of the fedora-multimedia repo files audio and video codecs and maybe that would fix things.

But maybe it's just best to wait until I upgrade to Fedora 26 or 27.


Chocolate Milk

I love milk, chocolate milk, hot chocolate.

Cold chocolate milk comes in different brands, different fat content (1%-2%).

My favourites, from Best to Least are:
  1. Naturel - has the thickest, sweetest taste
  2. Dairyland - 
  3. Beatrice - thinest, least amount of sugar
Are there other brands?


74 Crosstown South

Someone had made a video of the 1997 era Winnipeg Transit roll-sign.

I noticed that there was a route displayed that has not yet been used.

Back then Winnipeg Transit created some new routes, based on using portions the Inner Ring Road/Suburban Beltway Expressway. This was indeed one of the Scenarios and/or Recommendations of the 1968 Winnipeg Area Transportation Study (W.A.T.S.) published by the Metropolitan Corporation of Greater Winnipeg.

Winnipeg Transit currently uses 3 of the 4 "Crosstown" routes. These are:

75 Crosstown East
77 Crosstown North
78 Crosstown West

Missing from this list, and the one that was on the 1997 rollersign was...

74 Crosstown South

If 74 Crosstown South were to be implemented it would travel between St. Vital Centre Transit Terminal and the new Outlet Collection Winnipeg mall in Tuxedo.

Currently a resident of St. Vital must travel back to Main St. - Assiniboine Ave. and then transfer to a 65 Grant Express or 66 Grant to arrive at Outlet Collection. Introducing route 74 would reduce that to two buses.

The other Suburban Beltway route, the 75 Crosstown East, provides fast service between the Univ. of Manitoba in Fort Garry, St. Vital Centre and Kildonan Place in Transcona via Bishop Grandin Blvd. (Metro Route 165) and Lagimodiere Blvd. (Metro Route 20).

However, it is not convenient to those who want a closer entrance (less walking) to St. Vital Centre because this route does not currently use the St. Vital Centre Transit Terminal. So therefore, the stop for the 75 Crosstown East that exists on Bishop Grandin on the mall's north side should be relocated to the St. Vital Centre Transit Terminal