Usage Instructions

The search form al­lows you to search Ma­tros­ka video files by meta­da­ta.

The un­der­ly­ing data­base man­age­ment sys­tem is MySQL.

To the right of the text fields are two let­ters, rep­re­sent­ing the col­umn type (N = nu­mer­ic, S = string), and the col­umn in­dex (B = B‐​tree, F = full‐​text.

The B‐​tree in­dexed text fields are short­cuts for <col­umn> LIKE '<string>' or <col­umn> = <string> ex­pres­sions, de­pend­ing on the type (string/​nu­mer­ic) of the col­umn, where <string> is the con­tents of the text field.

The full‐​text in­dexed text fields are short­cuts for boolean full‐​text MATCH (<col­umn>) AGAINST ('<string>' IN BOOLEAN MODE) ex­pres­sions, where <string> is the con­tents of the text field.

The Ad­di­tion­al Ex­pres­sions text field can be used to en­ter ad­di­tion­al ex­pres­sions.

The ex­pres­sions of all text fields will be com­bined with an AND op­er­a­tor.

The (joined) data­base ta­ble con­tains the fol­low­ing rel­e­vant columns:

Column NameTableDisplayed NameColumn TypeIndex Type
v.pathvideo VARCHARB‐Tree
v.titlevideoTitleVARCHARB‐Tree
v.subtitlevideoSubtitleVARCHAR 
v.descriptionvideoDescriptionVARCHARFull‐Text
c.titlecollectionCollectionVARCHARB‐Tree
se.titleseasonSeason/CategoryVARCHARB‐Tree
v.episodevideoEpisode/PartTINYINT UNSIGNEDB‐Tree
v.datevideoDateVARCHARB‐Tree
g.namegenreGenreVARCHARB‐Tree
d.namedirectorDirectorVARCHARFull‐Text
p.nameproducerProducerVARCHARFull‐Text
w.namewriterWriterVARCHARFull‐Text
s.namescreenwriterScreenwriterVARCHARFull‐Text
a.nameactorActor/ArtistVARCHARFull‐Text
v.commentvideoCommentVARCHARFull‐Text
v.vcodecvideoVideo CodecCHAR(4)B‐Tree
pf.namepixformatPixel FormatVARCHARB‐Tree
v.acodecvideoAudio CodecCHAR(4)B‐Tree
v.durationvideoDurationINT UNSIGNED 

Video codecs:

NameDescription
cvidCinepak
H264H.264/MPEG‐4 AVC
RT21Intel Real Time Video 2.1
IV31Intel Indeo Video 3.1
IV32Intel Indeo Video 3.2
IV41Intel Indeo Video 4.1
IV50Intel Indeo Video 5.x
MP41Microsoft MPEG‐4 v1
MP42Microsoft MPEG‐4 v2
MP43Microsoft MPEG‐4 v3
RLE4Microsoft RLE 4 bpp
RLE8Microsoft RLE 8 bpp
CRAMMicrosoft Video 1
MJPGMotion JPEG
MPG1MPEG‐1
MPG2MPEG‐2
MPG4MPEG‐4 Part 2
rleQuickTime Animation
smcQuickTime Graphics
rpzaQuickTime Video
RGBRGB (Uncompressed)
SVQ1Sorenson Video v1
SVQ3Sorenson Video v3
WMV1WMV 7
WMV2WMV 8
WMV3WMV 9

Au­dio codecs:

NameDescription
AACAAC
AC3AC3
MAC3Apple MACE 3:1
MAC6Apple MACE 6:1
FLACFLAC
MSADMicrosoft ADPCM
MSALMicrosoft CCITT A‐Law
MSMLMicrosoft CCITT μ‐Law
MSGSMicrosoft GSM 6.10
MP2MP2
MP3MP3
PCMPCM
QclpQualcomm PureVoice
ima4QuickTime IMA ADPCM
QDMCQuickTime QDesign Music
QDM2QuickTime QDesign Music v2
VORBVorbis
WMAWMA

You can dis­play a list of unique val­ues of any col­umn by en­ter­ing the ta­ble name and the col­umn name mi­nus the pre­fix (‘v.’, ‘g.’, etc.), joined by a U+002E FULL STOP (.) and pre­ced­ed by a U+002D HY­PHEN‐​MI­NUS (-), e.g. ‘-col­lec­tion.ti­tle’, in the Ad­di­tion­al Ex­pres­sions text field.