Messages

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.  http://wandboard.org/ 

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

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 Expand


SELECT
F.PK_File
,F.Path
,F.Filename
,F.Inode
,greatest(
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
,F.Source
FROM
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.

-buckle

Making sure all the join conditions are indexed should help.

Code Select Expand


CREATE INDEX IX_Bookmark_FK_File
    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 Expand


CREATE INDEX IX_File_Missing
ON File(Missing);


FileName and Path indexes did not yield anything for me.  Here they are anyway...

Code Select Expand


CREATE INDEX ix_File_Path
ON File;

CREATE INDEX ix_File_FileName
ON File;


Hope this helps.

-buckle

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)?

Where is the source?

What spec?

The protocol information for the NX-8E.  Like this: https://www.drivehq.com/folder/p9084843/049711833.aspx

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.

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 Expand

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). 

Where may one get one of these devices?

Try these links:
http://www.aliexpress.com/product-fm/563764893-Freeshipping-Rikomagic-MK802-Mini-PC-Mini-Android4-0-dongle-android-IPTV-google-tv-smart-android-box-wholesalers.html
http://www.dealextreme.com/p/android-4-0-mini-pc-google-tv-player-w-wifi-allwinner-a10-cortex-a8-tf-hdmi-white-4gb-137012?item=2

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

http://www.dealextreme.com/p/mele-1080p-android-2-3-internet-tv-set-top-box-w-wifi-optical-3-x-usb-hdmi-av-lan-sd-119913?item=2
http://www.dealextreme.com/p/mele-a2000-1080p-android-2-3-network-multi-media-player-w-sata-usb-hdmi-lan-vga-wifi-4gb-131566?item=2

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.

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).

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.  http://svn.linuxmce.org/trac.cgi/ticket/795  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.

tschak made a device for this already.  It should work for you.


http://wiki.linuxmce.org/index.php/DPMS_Monitor
http://forum.linuxmce.org/index.php/topic,8729.0.html

What changed between 10.04 to the rc1 version in regards to networking? 

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

Docs available here:
http://radiothermostat.com/latestnews.html
(under advanced technical information)

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  ).

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.