Application of Sqlite database in MediaNAS system _ MySQL

This article describes how to use the Sqlite database as the storage database of Media data in the NAS system in a Linux-based MediaNAS system to share Media files, this allows the DigitalMediaPlayer playing device

This article describes how to use the Sqlite database as the storage database of Media data in the NAS system in a Linux-based Media NAS system to share Media files, this allows the Digital Media Player to play Media files on NAS through the UPnP AV Server service.

After the Media NAS system is implemented using Sqlite, the system has high running performance and the program has good cross-platform performance.

This Media NAS service system is based on the universal plug-and-Play (UPnP) protocol.

Network Attached Storage (NAS) is a dedicated data Storage device that is centered on data and stores a large number of video, audio, and image files. The NAS server has a good data storage and protection mechanism to ensure its stability in providing multimedia services. To facilitate the effective sharing of massive media files on it, we use the UpnP protocol as the network access protocol.

The UpnP network system is an architecture designed to connect smart appliances, wireless devices, and PCs. It aims to provide easy-to-use, flexible, and standard-based connections for networks in homes, small businesses, and public places. UpnP is a distributed open network architecture that fully utilizes TCP/IP and Web technologies. in addition to full control and data transmission between devices connected to the home, office, and public places, you can also establish a seamless and close connection network.

The UpnP device does not need to use a device driver. Instead, it uses a common protocol. a device is a complete small system and can be directly connected to the UpnP network through a network port. The UpnP network does not depend on any specific operating system, programming language, or physical media. UPnP does not specify which API (application interface) the application should use. UpnP device developers can create their own APIs as needed. The UpnP device can be implemented in any programming language on any operating system. This means that a device can dynamically join a network to obtain an IP address, "zero" configuration, and plug-and-Play. it will automatically notify the device of its functional services, and understand the existence and functions of other devices. Devices in the UpnP network provide descriptions of their own services. other external devices call these services to control these UpnP devices.

UpnP makes full use of Internet components including IP, TCP, UDP, HTTP, and XML. It expresses content in XML and transmits it over HTTP. Messages in the UpnP network are formatted by using simple Service Discovery Protocol (SSDP), Universal Event Notification Architecture (GENA), and Simple Object Access Protocol (SOAP. Then, the message is transmitted through multicast or unicast HTTP running on UDP or standard HTTP running on TCP. Finally, all messages are transmitted through IP addresses.

UpnP can be used in a wide range of applications, such as home automation, printing and image processing, audio/video entertainment, kitchen equipment, automotive networks, and other applications.

Digital Media Player is a wireless bridge connecting a computer, TV, or audio system. it is also a device based on UpnP protocol. It uses standard audio/video cables to connect television and stereo sound systems. it can communicate with computers through wireless networks and transmit digital information processed by computers to television and audio systems. In this way, your digital files can no longer be played on a computer, but can be connected to a TV or audio system. as you can imagine, the playback effect will be incomparable to that of a PC computer.