Playing .avi files under Linux

Got myself some .avi files but didn’t have a player under CenOS 4.2. MPlayer would appear to rate well as a media player for linux.

<br /> yum install mplayer<br /> yum install lame<br />

`

Unfortunately mplayer while registered could not be downloaded, tried the hard way

wget http://rpm.greysector.net/yum/4/i386/mplayer-1.0pre7try2-2.i386.rpm
rpm -ivh mplayer-1.0pre7try2-2.i386.rpm

lame wasn’t needed via the manual process, but just in case

#wget http://rpm.greysector.net/yum/4/i386/libmp3lame-3.96.1-4.i386.rpm
`

Surprisingly, it’s not a GUI interface, but mplayer on the command line is more then adequate.

Tagged with: General Linux

Producing Skewness statistics with SQL

Producing Skewness statistics with SQL

Skewness measures the asymmetry of a distribution. A perfectly symmetric distribution has a skewness of zero. A positive skew (right-skewed) means the tail extends to the right — a small number of high values pull the mean above the median.

Exploring the vsql-ai extension

Exploring the vsql-ai extension

The vsql-ai extension adds AI prompt capabilities and text embeddings directly in SQL queries, with support for Anthropic Claude , Google Gemini , OpenAI ChatGPT , or a local LLM such as Ollama .

Producing Chi-Squared statistics with SQL

Producing Chi-Squared statistics with SQL

The Chi-Squared test is one of the most widely used statistical tests for categorical data. It comes in two flavors: the goodness-of-fit test asks whether an observed frequency distribution matches an expected one, while the test of independence asks whether two categorical variables are associated with each other.