SQL Server Databases

MediaPIG is built on SQL Server Express 2016 or higher.

Its a fast, free, reliable, powerful database system that allows for a smooth multi-user experience.

MediaPIG could store any number of TV Shows, Episodes, Movies etc. per database, and even have many different databases each with different content. It is typically improbable to hit any performance or storage limitations under normal conditions.

Unlike other systems, MediaPIG is very portable, backup and restore friendly with some conditions.

Unlike other systems, MediaPIG can re-associate pathing should a drive be replaced, or master path be changed.

SQL Server SQL Server SQL Server SQL Server SQL Server
MediaPIG SQL Server Database Tools

Profile Based for Multiple User Support

MediaPIG features a system to create additional configurable user accounts. User accounts can be assigned the same or different levels of access. Categories must be assigned per user account, however, you can reference the same media sets. Watched and favorite flags are saved per user profile..

  • Users Created/Removed Only by Admins
  • Child Profile Access Denies System Changes
  • Separate Categories and Content by Access Level
  • Separate Content per Profile (Optionally possible)
  • Media Files Accessible by Multiple Profiles
MediaPIG User Options Overview

Video Demonstration

MediaPIG configuration demonstration

This video will demonstrate a clean installation and configuration of MediaPIG from end-to-end.

Requires SQL Server Express to be pre-installed and configured for SQL Browser access

Demonstration illustrates running and watching MediaPIG content from a windows desktop PC. Normal usage is to connect various devices supported to your TV via HDMI cable supporting small and very large 80"+ TV devices.

TVsViaHMDI LAPTOP MiniPC MS-Tablet PC TABLET

Profile Based Multi-User Support

Profile Based for Multiple User Support

MediaPIG features a system to create additional configurable user accounts. User accounts can be assigned the same or different levels of access. Categories must be assigned per user account, however, you can reference the same media sets. Watched and favorite flags are saved per user profile..

  • Users Created/Removed Only by Admins
  • Child Profile Access Denies System Changes
  • Separate Categories and Content by Access Level
  • Separate Content per Profile (Optionally possible)
  • Media Files Accessible by Multiple Profiles

Get Started in No Time

MediaPIG makes it super easy to get your media assets into the database for easy endless playback that your children cannot tamper with, delete assets, change settings or see adult content.