[SlimDevices: Beta] Build 7.5.0 r30050

2010-02-07 Thread Themis
I use FLAC-PCM transcoding on the server. Was there a change in the transcoding between r29xxx and r30050 ? Thanks for your help -- Themis SB3 - North Star dac 192 - Cyrus 8xp - Sonus Faber Grand Piano Domus Themis's

Re: [SlimDevices: Beta] Just installed the new 7.5 Embedded Nightly (Jan 30) and now iTunes integ. broken

2010-02-07 Thread hungarianhc
I think you're right blast - i should have just stuck with the older version! Oh well. I'll just watch that bug periodically and when it finally gets fixed, i'll get that SB nightly... -- hungarianhc 'Howto: Building a squeezebox server for under $100!'

[SlimDevices: Beta] Embedded/SQLite question for Andy

2010-02-07 Thread gharris999
I want to craft a plugin for myself that will execute a simple update query on the NAMES column of the GENRES table after every SBS scan. I used to accomplish this simply by modifying my copy of schema_optimize.sql. What would you suggest? Should I: A). call an external sqlite executable,

Re: [SlimDevices: Beta] Embedded/SQLite question for Andy

2010-02-07 Thread Andy Grundman
All you have to do is setup a callback for a 'rescan done' event, then do your query like this: Slim::Schema-dbh-do('UPDATE genres ...'); ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta

Re: [SlimDevices: Beta] Embedded/SQLite question for Andy

2010-02-07 Thread gharris999
Let me refine my 2nd question: In my plugin, is something along the lines of... Code: my $serverprefs = preferences('server'); my $dbsource = $serverprefs-get('dbsource'); my $dbconnect = sprintf($dbsource, $cachedir . 'squeezebox.db'); $dbh = DBI-connect(

Re: [SlimDevices: Beta] Embedded/SQLite question for Andy

2010-02-07 Thread gharris999
Oops. I see you've already answered me. Thanks. -- gharris999 gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115 View this thread: http://forums.slimdevices.com/showthread.php?t=75024

Re: [SlimDevices: Beta] Embedded/SQLite question for Andy

2010-02-07 Thread gharris999
Erland: thanks for that. It's long overdue for me to kick the tires on your plugins, so I'm not intimately familiar with how they work. I assume that you allow the user to enter a certain amount of raw sql to be executed by your plugin. Is that why you use the eval?...to catch syntax errors?

Re: [SlimDevices: Beta] Embedded/SQLite question for Andy

2010-02-07 Thread gharris999
erland;514995 Wrote: I don't think I've used REGEXP anywhere yet, I suspect it will work pretty fast. The situations where I've got performance problems is often when I've tried to join several tables, especially when I've been forced to join with the tracks.url column which is defined as

Re: [SlimDevices: Beta] Embedded/SQLite question for Andy

2010-02-07 Thread erland
gharris999;515050 Wrote: Didn't Andy add a urlhash column? Yes, there is one in the embedded branch, I'm just waiting for that to make its way into an official release. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader)