squeezecenter server clarification

[tomasito]

Hello,
Let me know if my understanding of the function of the squeezecenter server program is correct:

The way I see it. The squeezecenter will scan the music files to the library you set it to scan to. Then, after it completes the scanning, you hit the apply button. This will push the scan files to the player ( this will be the duet receiver).

Is this correct?

The controller has a setting in the my music menu - it gives you the option to chose the music library.

I my case I have 2 desktop computers - the other is a dual core desktop. Both have the squeezecenter server installed in it.

Now if I switch to the other computer to access the music library do I need to make it scan and then hit the apply button?

[Soulkeeper]

The squeezecenter will scan the music files to the library you set it to scan to. Then, after it completes the scanning, you hit the apply button. This will push the scan files to the player ( this will be the duet receiver).

Is this correct?

No, the Squeezebox Server (formerly called Squeezecenter and whatnot) doesn't push the files to the Squeezebox Receiver until you press "Play".

[tomasito]

OK the receiver pulls the track from the squeezecenter server.
I have a better understanding of how it works

[aubuti]

Strictly speaking, no. The Controller (or the web ui, or other remote interface) tells the server to send the track to the SB Receiver. The SBR receives the data stream and sends it to its outputs. The SBR is a slim device without enough 'brains' to 'pull' anything.

[tomasito]

question:
when the rescan button in the squeezecenter is click. And the rescan is process is completed and you click "OK" or "Apply",

where does this information go?
or What happens to this data?

[aubuti]

When you click Rescan it starts the rescan right away. After that you don't need to click Apply or OK. The scan just runs until it is finished. At least that's the way it works in Linux. It may be different in Windows with its SBS Control Panel thingy, but I don't think so.

During the scan SBS updates its database of the metadata (ie, the data that are in the tags, not the audio data itself). This database is saved on the server computer in the folder indicated in the SBS web ui under Settings > Information tab > Cache folder. It then uses that database for all of the display of artists, tracks, albums, genres, album art, etc. on the SB Controller or the SB itself. If you are familiar with MySQL you can inspect the contents of the database with standard MySQL tools.

[tomasito]

I need to learn mysql
Where do I start to learn the mysql

[pski]

I need to learn mysql
Where do I start to learn the mysql

What are you thinking of doing with mysql? It holds the data tables used by the SBS software but you don't really need to know SQL to use the software.

P

[pski]

The controller has a setting in the my music menu - it gives you the option to chose the music library.

I my case I have 2 desktop computers - the other is a dual core desktop. Both have the squeezecenter server installed in it.

Now if I switch to the other computer to access the music library do I need to make it scan and then hit the apply button?

"Scanning" builds the data tables used by the SBS program. If you are running the SBS on both computers, each will need to do this, so the answer is YES.

The scanning starts as soon as you press SCAN. APPLY is not necessary unless you are changing the Settings/Advanced/Rescan Music Library settings..

[aubuti]

I need to learn mysql
Where do I start to learn the mysql

My I ask why you need to learn MySQL? SBS also displays the contents of the database, and in a user-friendly way. As for learning MySQL, a good place to start is www.mysql.com.

If you are thinking about writing plugins or other software that accesses SBS's databases you should know that future versions of SBS (probably starting with 8.0) will be using SQLite as the default database, although MySQL will probably still be available as an option for some time.