Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - buckle

Pages: [1] 2 3 ... 5
Developers / Re: Something interesting to watch
« on: November 01, 2013, 11:02:11 pm »
CuBox-i is powered by the i.MX6 chipset.  Freescale seems to do a good job of providing docs and code for these i.MX6 chips.  It is probably the best ARM platform for linux at the moment (imho). 

That being said, you can get your hands on a Wandboard now if you wanted to experiment with that chipset. 

A gstreamer based player would be needed to get accelerated video decoding.  I think the graphics driver is there already.

Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 27, 2013, 10:35:04 pm »
I have a new query that also addressed the attribute counts issue with Jamo's version. 

I think it is about as simplified as I can make it.  I believe it was over-complicated from the beginning, at least for what the query set out to achieve.

Code: [Select]
IFNULL(B.max_psc_mod, CAST('0000-00-00 00:00:00' AS DATE)),
IFNULL(A.max_psc_mod, CAST('0000-00-00 00:00:00' AS DATE)),
IFNULL(LA.max_psc_mod, CAST('0000-00-00 00:00:00' AS DATE)),
IFNULL(PF.max_psc_mod, CAST('0000-00-00 00:00:00' AS DATE)),
CAST('0000-00-00 00:00:00' AS DATE)
) As CurrentDbAttrDate
,(1000000 * IFNULL(B.Bookmark_Count, 0)
+ 10000 * IFNULL(A.Attribute_Count, 0)
+ 100 * IFNULL(LA.Long_Attribute_Count, 0)
+ IFNULL(PF.Picture_Count, 0)
) AS CurrentDbAttrCount
,IFNULL(A.Attribute_Count,0)+IFNULL(LA.Long_Attribute_Count,0) AS HasAttributes
,F.AttrDate AS OldDbAttrDate
,F.AttrCount AS OldDbAttrCount
,F.ModificationDate AS OldFileDate
File F
LEFT JOIN (select MAX(psc_mod) as max_psc_mod,  FK_File as FK_File, count(*) as Bookmark_Count from Bookmark group by FK_File) B ON B.FK_File = F.PK_File
LEFT JOIN (select MAX(Attrib.psc_mod) as max_psc_mod, count(*) as Attribute_Count, FileAttrib.FK_File as FK_File from File_Attribute FileAttrib left join Attribute Attrib ON FileAttrib.FK_Attribute = Attrib.PK_Attribute group by FK_File) A on A.FK_File = F.PK_File
LEFT JOIN (select MAX(psc_mod) as max_psc_mod, FK_File as FK_File, count(*) as Long_Attribute_Count from LongAttribute group by FK_File) LA ON LA.FK_File = F.PK_File
LEFT JOIN (select MAX(psc_mod) as max_psc_mod, FK_File as FK_File, count(*) as Picture_Count from Picture_File group by FK_File) PF ON PF.FK_File = F.PK_File
WHERE 1 = 1
AND ( Path LIKE '/home/public/data%' OR (Path ='/home/public' AND Filename = 'data' ) 
      OR Path LIKE '/home/user_1/data%' OR (Path = '/home/user_1' AND Filename = 'data' ) 
      OR Path LIKE '/home/user_2/data%' OR (Path = '/home/user_2' AND Filename = 'data' ) 
      OR Path LIKE '/home/user_3/data%' OR (Path = '/home/user_3' AND Filename = 'data' ) 
      OR Path LIKE '/home/user_4/data%' OR (Path = '/home/user_4' AND Filename = 'data' )
      OR Path LIKE '/home/user_5/data%' OR (Path = '/home/user_5' AND Filename = 'data' ) 
      OR Path LIKE '/home/user_6/data%' OR (Path = '/home/user_6' AND Filename = 'data' ) 
      OR Path LIKE '/home/user_7/data%' OR (Path = '/home/user_7' AND Filename = 'data' ) 
      OR Path LIKE '/home/user_8/data%' OR (Path = '/home/user_8' AND Filename = 'data' ) ) 
AND Missing = 0

I used phenigma's where clause for the sake of being thorough, and because it looked nice. :)

It compares exactly 100% against the original query in my test environment (from tschak's script). 

It performs pretty well, too.  Let me know how it works for you.


Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 25, 2013, 04:41:40 am »
Making sure all the join conditions are indexed should help.

Code: [Select]
    ON Bookmark (FK_File);

CREATE INDEX IX_LongAttribute_FK_File
    ON LongAttribute (FK_File);

Using Thom's database on my machine I went from 20 seconds to < 3 seconds.

Typically I would check to make sure I had properly indexed anything in a where clause as well.

Adding one for Missing should also improve the query performance, although the difference for me was negligible.

Code: [Select]
ON File(Missing);

FileName and Path indexes did not yield anything for me.  Here they are anyway...
Code: [Select]
ON File;

CREATE INDEX ix_File_FileName
ON File;

Hope this helps.


Developers / Re: Building Dynamic Orbiters with JSON/AJAX/HTML5
« on: March 26, 2013, 04:52:40 pm »
Will it be fully compatible with LinuxMCE?

Can you describe the server-side architecture you are using?

What limitations, if any, should we expect to see in the finished version (relative to the current native orbiter feature set)?

Users / Re: Welcome
« on: October 26, 2012, 12:23:46 am »
Where is the source?

Users / Re: Linux MCE beating as the heart of whole house automation
« on: September 27, 2012, 08:07:17 pm »
What spec?
The protocol information for the NX-8E.  Like this:

So, can I please, please, pleeeease have a page?
I don't think you really need permission to create this.  Just log in and do it.

Users / Re: Remotely ssh into a machine behind LMCE router
« on: July 13, 2012, 08:59:48 pm »
You can forward a port (using the LMCE firefall config) to your desktop IP, which I wouldn't do.

Or, you could change your ssh tunnel to use the IP of the desktop machine, instead of the core loopback address

Code: [Select]
ssh -p 22 -L 5900:<internalIPofDesktop>:5900 <coreUser>@<externalIP>
This won't ssh straight to your desktop.  It will still ssh to the core.  But, the port forward will be to your desktop.  If you really needed to ssh to the desktop to run some commands, you could just ssh from the core to the desktop (no port forwarding req'd). 

Users / Re: MK802 Android4 MiniPC - Usage as Mediadirector
« on: July 11, 2012, 07:42:53 pm »
Where may one get one of these devices?

Try these links:

Since we are discussing Allwinner A10 are a couple devices based on the same SoC that would make nice MDs, as well.

As far as I can tell, though, all of these systems are not ready for true MD use due to VPU/GPU linux driver issues.  A lot of work needs to be done in that area (by the community at large) before it could be usable for us as an ubuntu based MD.

An all-android based solution (something like qOrbiter/qMediaPlayer) would probably provide the best performance.

Users / Re: Ill Catch yer shark...
« on: June 08, 2012, 05:54:19 pm »
he says he prefers.PSD, suggesting he wants to present the submissions (ie no screenshots)

I assumed he preferred PSD so the QML would be easier to create (exported from PS).

Developers / Re: LinuxMCE with C#
« on: March 11, 2012, 06:13:15 pm »
The socket you are sending stuff to is using the so called Proxy Orbiter. It is a kludge that was created for the web orbiter in the first place. A "real" orbiter doesn't talk to the socket of Proxy Orbiter, but sends and receives messages to dcerouter.

There is already a .NET implementation of touch orbiter, UnOrbiter.NET.  It is part of the kludge, though, so it probably doesn't help get you towards your goal.

You might be able to import the DCE libs into you C# project and go that route.

Users / Re: turn monitor touch screen on/off
« on: March 07, 2012, 06:17:23 pm »

Users / Re: NEWS: rc Time
« on: August 26, 2011, 10:03:14 pm »
What changed between 10.04 to the rc1 version in regards to networking? 

You do realize that this is a RC for 0810, right?

Feature requests & roadmap / Re: Radio Thermostat Publishes API
« on: June 29, 2011, 01:55:51 pm »
Docs available here:
(under advanced technical information)

Users / Re: PadOrbiter 2.0
« on: March 10, 2011, 07:35:28 pm »
Nice work Thom.  Your effort is appreciated.

I have the modified efi image corrected and ready to go with the LinuxMCE logo.  I'll verify it once I get my second unit (after un-bricking the first one  ;D).

because someone would like to continue listen to a movie while visiting the restroom...

It would also be very useful for watching sporting events, as you could still hear the play-by-play.

Pages: [1] 2 3 ... 5