Playing .avi files under Linux

Ronald Bradford
January 22, 2006

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

Why INSERT IGNORE should not be used

Ronald Bradford
August 16, 2026

Let’s say you’re building a reference table from source data, e.g. a silver medallion table from a primary source. In this example I am using a file of random locations on the globe extracted from OpenStreetMap (OSM) as my primary source.

What Constitutes Clean Data?

Ronald Bradford
August 15, 2026

Clean data is one of those terms everyone uses and few define precisely. Row counts match? No nulls in key columns? Values within expected ranges? All useful checks — and all insufficient once you move from a table view to a visualization view.

Curated MySQL Data Sets for Realistic Testing

Ronald Bradford
August 14, 2026

Synthetic benchmarks have their place, but I have always preferred working with real data. Not client production data — that stays private — but publicly available datasets that reflect the messy shapes, skewed distributions, and indexing challenges you encounter in the wild.