Delete recordings from database but not from disk?

[spinnaker]

I would like to do some testing on import for a utility I am working on. Is it possible to delete the database entry without deleting the corresponding mp4 file?

[mvallevand]

Sure. However adding mp4 into the database is a bad idea since they won't stream to clients.

Martin

[spinnaker]

OK so how do you dlete from db without deleting from disk?



I noticed that NextPVR records in MEG2 TS Video.

Looks like <CE Buddy can convert to MPEG2 but says nothing about TS video. Is this the same thing?

Why is the MEG2 TS Video files so huge? Seems nearly twice the size of corresponding mp4 file. Are there other options to record in that are smaller file size?? Are there any plans to move to a more compact size?

[mvallevand]

Use any sqlite tool you want to delete rows.

You can have h264 video in ts mux that is were the size savings come for. mp4 is better outside nextpvr.

Martin

[sub]

Are there other options to record in that are smaller file size?? Are there any plans to move to a more compact size?

With digital TV, NextPVR just dumps to disk the broadcasters original bitstream. It has no say in how big that stream will be, and no chance this will be changing in the future.

NextPVR records this stream to a .ts file, since this is format digital TV is transmitted in. Those transport stream files will contain whatever audio/video streams your broadcaster transmits. North America they typically contain MPEG2 video, and one or more AC3 audio. Some other countries broadcast H.264 video in their transport stream, which is a much more efficient video compression standard, giving smaller files with better quality.

Personally, I'd just stick with the original TS files, rather than trying to recompress them. Disk is pretty cheap these days.

[bgowland]

Sure. However adding mp4 into the database is a bad idea since they won't stream to clients.

Martin

Ironically mp4 files are the only format I've been able to stream (cast) to my Chromecast device so far. If it wasn't for my PCH being the main extender for npvr, I'd consider post-processing everything to mp4 to use with the Chromecast (unless Google get their act together and start properly supporting other containers / formats).

Cheers,
Brian

[spinnaker]

Use any sqlite tool you want to delete rows.



Martin

I downloaded the sqlite plugin for firefox. I can't find any *.sqlite fires for nextpvr. Where are the db files located? Do they have another extension?

[mvallevand]

I downloaded the sqlite plugin for firefox. I can't find any *.sqlite fires for nextpvr. Where are the db files located? Do they have another extension?

You do know there is a wiki? http://www.nextpvr.com/nwiki/pmwiki.php?...alledParts

Martin

[spinnaker]

Yeah sorry. I got to get used to the lingo so I know what to look for. I probably just need to read through the whole thing to see what is there.