IPB

Welcome Guest ( Log In | Register )

foo_uie_sql_tree
fbuser
post Sep 25 2011, 21:52
Post #1





Group: Developer
Posts: 688
Joined: 26-September 07
Member No.: 47369



foo_uie_sql_tree is a foobar2000 component for viewing the media library in a tree structure using SQL queries. The component provides a panel for ColumnsUI, which is a prerequisite for using this component. The underlying database engine is SQLite and with the exception of a few restrictions for building the tree queries the whole functionality of SQLite is supported.

Prerequisites:
ColumnsUI 0.3.8.8 or higher

Download the latest version: here

This post has been edited by fbuser: Jan 14 2012, 12:02
Go to the top of the page
+Quote Post
 
Start new topic
Replies
ainz
post Jan 20 2012, 23:30
Post #2





Group: Members
Posts: 17
Joined: 28-October 11
Member No.: 94757



So the spaces/parentheses restriction was preventing the leaf nodes in my queries from working.

The cursor keys can be used to quickly expand/collapse and navigate a large tree, but the contents of the target playlist don't change unless the mouse button is clicked. Is this related to the selection-event propagation mentioned previously? It's odd for the behaviour to differ between keyboard and mouse input.

This post has been edited by ainz: Jan 20 2012, 23:34
Go to the top of the page
+Quote Post
fbuser
post Jan 21 2012, 00:05
Post #3





Group: Developer
Posts: 688
Joined: 26-September 07
Member No.: 47369



QUOTE (ainz @ Jan 20 2012, 23:30) *
The cursor keys can be used to quickly expand/collapse and navigate a large tree, but the contents of the target playlist don't change unless the mouse button is clicked.
Or <space> is pressed for the click action, respectively <ctrl>+<space> for the middle click action. It was missing in the documentation.
Go to the top of the page
+Quote Post

Posts in this topic
- fbuser   foo_uie_sql_tree   Sep 25 2011, 21:52
- - Black_Over_Bills_Mothers   Thanks fbuser. A great component. Works well and f...   Sep 27 2011, 12:57
|- - fbuser   QUOTE (Black_Over_Bills_Mothers @ Sep 27 2011...   Sep 27 2011, 18:03
- - tg2k3   any chance to get a dui version? :-)   Sep 27 2011, 20:03
|- - fbuser   QUOTE (tg2k3 @ Sep 27 2011, 20:03) any ch...   Sep 27 2011, 21:11
- - grimes   Thanks for great component, fbuser!! ...   Sep 28 2011, 12:16
|- - mobyduck   A shot in the dark, didn't test it actually:CO...   Sep 28 2011, 14:45
- - grimes   That helps a lot. Thanks. Now i have:   Sep 28 2011, 15:13
- - fbuser   QUOTE (grimes @ Sep 28 2011, 12:16) SELEC...   Sep 28 2011, 19:13
- - Falstaff   Thanx for this component, very good work fbuser...   Sep 28 2011, 21:27
- - grimes   Made some maybe useful additional SQL statements f...   Sep 28 2011, 21:36
- - fbuser   The first and the third query will normally work a...   Sep 28 2011, 22:18
|- - ainz   QUOTE (fbuser @ Sep 28 2011, 21:18) CODES...   Dec 26 2011, 22:16
- - Black_Over_Bills_Mothers   I've been using this component for a few days ...   Sep 29 2011, 12:19
- - grimes   My queries: CODE//Album length SELECT album, for...   Sep 30 2011, 09:06
- - kurtyer   I'm using the plugin with foo_popup_panels and...   Sep 30 2011, 20:42
- - fbuser   Goto View -> Popup panels -> Configure -...   Sep 30 2011, 21:12
- - derty2   @fbuser, interesting component, well done ++++ Wo...   Oct 1 2011, 01:53
- - derty2   foobar2000 crashed --> location = Module: foo_...   Oct 1 2011, 02:23
- - Canar   If there was a port of this to the Default UI, I...   Oct 1 2011, 02:53
- - marc2003   ^from earlier in the thread.... QUOTE (fbuser ...   Oct 1 2011, 04:16
|- - Canar   QUOTE (marc2003 @ Sep 30 2011, 20:16) ^fr...   Oct 1 2011, 20:24
- - zaede   Very nice component ! How can i choose from w...   Oct 1 2011, 12:57
- - grimes   You can make the selection by using a WHERE clause...   Oct 1 2011, 13:07
- - chiwou   small issue, I can't see anything if I add to ...   Oct 1 2011, 13:42
|- - fbuser   QUOTE (chiwou @ Oct 1 2011, 13:42) btw: i...   Oct 1 2011, 14:39
|- - chiwou   QUOTE (fbuser @ Oct 1 2011, 14:39) QUOTE ...   Oct 1 2011, 22:33
|- - fbuser   QUOTE (chiwou @ Oct 1 2011, 22:33) QUOTE ...   Oct 1 2011, 23:10
- - marc2003   oh right. it's just that no answer looks prett...   Oct 1 2011, 20:57
|- - Canar   QUOTE (marc2003 @ Oct 1 2011, 12:57) oh r...   Oct 2 2011, 02:48
- - grimes   Top artists played this year CODESELECT COUNT...   Oct 1 2011, 22:10
- - chiwou   I delete the database and settings from my profile...   Oct 1 2011, 23:44
- - aliendesaster   I love it. So far, did not have time to test it th...   Oct 13 2011, 18:29
- - tg2k3   is there any way to to search the library outside ...   Oct 14 2011, 00:58
- - fbuser   In the tree console you could create a real databa...   Oct 14 2011, 15:54
- - exalaskan   Just wanted to say thanks to fbuser for this fanta...   Oct 25 2011, 17:54
|- - exalaskan   QUOTE (exalaskan @ Oct 25 2011, 11:54) My...   Oct 25 2011, 20:04
- - Black_Over_Bills_Mothers   Lost all my queries! I have just updated from ...   Nov 8 2011, 13:14
|- - fbuser   QUOTE (Black_Over_Bills_Mothers @ Nov 8 2011,...   Nov 8 2011, 19:07
- - Black_Over_Bills_Mothers   fbuser Thanks for the info. I already use foo_jesu...   Nov 9 2011, 00:22
- - Zarty   Thanks for this component. I'm having fun pla...   Nov 9 2011, 13:19
- - fbuser   QUOTE (Black_Over_Bills_Mothers @ Nov 9 2011,...   Nov 9 2011, 18:35
|- - Zarty   QUOTE No, this is not the purpose of the SQL tree ...   Nov 9 2011, 22:27
- - Black_Over_Bills_Mothers   Lost all my queries ..... again! QUOTE There ...   Nov 19 2011, 08:47
|- - fbuser   QUOTE (Black_Over_Bills_Mothers @ Nov 19 2011...   Nov 19 2011, 09:25
- - Black_Over_Bills_Mothers   Hi fbuser If it helps, I noticed that only the fil...   Nov 19 2011, 09:48
- - Black_Over_Bills_Mothers   I don't mean to bother you (fbuser) and I know...   Nov 19 2011, 15:30
- - Black_Over_Bills_Mothers   Bug: The status of Start playback option for the m...   Nov 20 2011, 09:05
- - gob   I finally had a chance to test this component out....   Dec 7 2011, 07:14
- - chiwou   Hi how can I display all albums that have the genr...   Dec 13 2011, 18:56
- - fbuser   Finally, some feedback to the feature requests abo...   Dec 13 2011, 20:02
- - chiwou   thanks both tipps worked like a charm, do you know...   Dec 14 2011, 00:43
|- - ainz   QUOTE (chiwou @ Dec 13 2011, 23:43) thank...   Dec 26 2011, 18:10
- - chiwou   and after a few hours of testing the possibility t...   Dec 14 2011, 02:00
- - chiwou   okay found the option for the refresh :| I just li...   Dec 14 2011, 12:40
- - ainz   Superb component... an everything-in-one library v...   Dec 26 2011, 18:04
- - fbuser   It's mentioned in the documentation   Dec 27 2011, 12:11
|- - ainz   QUOTE (fbuser @ Dec 27 2011, 11:11) It...   Dec 27 2011, 23:11
|- - mobyduck   Perhaps something like:CODE SELECT q.rating, q.ar...   Dec 28 2011, 09:09
- - litolf   Hello fbuser, i tried, to use your component, the...   Jan 14 2012, 10:15
|- - fbuser   QUOTE (litolf @ Jan 14 2012, 10:15) After...   Jan 14 2012, 12:01
|- - litolf   QUOTE (fbuser @ Jan 14 2012, 12:01) QUOTE...   Jan 15 2012, 10:29
|- - fbuser   QUOTE (litolf @ Jan 15 2012, 10:29) sorry...   Jan 15 2012, 22:14
|- - litolf   QUOTE (fbuser @ Jan 15 2012, 22:14) Anywa...   Jan 16 2012, 10:27
- - extracampine   You know, this is maybe a CRAZY idea.... ....but ...   Jan 14 2012, 11:48
|- - fbuser   QUOTE (extracampine @ Jan 14 2012, 11:48)...   Jan 14 2012, 12:05
|- - extracampine   Lol....thanks. But still...   Jan 14 2012, 14:55
- - litolf   @fbuser ---feedback--- Being glad, SQL Tree works...   Jan 17 2012, 10:42
|- - litolf   Could'nt wait to see SQL Tree on my productive...   Jan 20 2012, 13:24
|- - fbuser   QUOTE (litolf @ Jan 20 2012, 13:24) Bug: ...   Jan 20 2012, 17:04
|- - litolf   QUOTE (fbuser @ Jan 20 2012, 16:04) QUOTE...   Jan 20 2012, 21:00
|- - fbuser   QUOTE (litolf @ Jan 20 2012, 13:24) Bug: ...   Jan 20 2012, 22:37
|- - litolf   Thanx again to fbuser and shame on me for not read...   Jan 20 2012, 23:52
- - ainz   Here are a couple of queries I'm using, for an...   Jan 19 2012, 04:09
- - ainz   So the spaces/parentheses restriction was preventi...   Jan 20 2012, 23:30
|- - fbuser   QUOTE (ainz @ Jan 20 2012, 23:30) The cur...   Jan 21 2012, 00:05
|- - ainz   QUOTE (fbuser @ Jan 20 2012, 23:05) Or ...   Jan 21 2012, 02:06
- - camperdave   Hey, I've been having some issues with this pl...   Mar 27 2012, 18:52
- - fbuser   Look here and the following.   Mar 27 2012, 19:35
|- - camperdave   QUOTE (fbuser @ Mar 27 2012, 12:35) Look ...   Mar 27 2012, 20:09
- - r0k   Hello. I'm trying to make a node to rertrieve ...   May 4 2012, 17:05
- - fbuser   Have a look at the foobar2000 console. You should ...   May 4 2012, 17:52
- - r0k   Thanks. I merged parts of several examples and los...   May 4 2012, 21:04
- - r0k   Multiple Libraries? Hello. This may be a feature ...   May 13 2012, 16:03
- - fbuser   QUOTE (r0k @ May 4 2012, 21:04) Oh, btw, ...   May 13 2012, 21:43
|- - r0k   QUOTE (fbuser @ May 13 2012, 22:43) Even,...   May 14 2012, 08:42
- - r0k   Mhh. Sorry to bother you again but i have some tro...   May 18 2012, 16:30
|- - fbuser   QUOTE (r0k @ May 18 2012, 16:30) Let me k...   Jun 3 2012, 18:41
- - D.Sync   What query should I type if I want to search for i...   May 23 2012, 09:49
|- - fbuser   QUOTE (D.Sync @ May 23 2012, 09:49) What ...   May 23 2012, 17:37
|- - D.Sync   QUOTE (fbuser @ May 23 2012, 11:37) QUOTE...   May 24 2012, 06:19
- - r0k   I have changed my totaltracks to be the grand tota...   May 23 2012, 14:18
- - r0k   Great. I have updated it and so far i can switch l...   Jun 3 2012, 20:58
|- - fbuser   QUOTE (r0k @ Jun 3 2012, 20:58) Does the ...   Jun 3 2012, 21:14
- - akispavlopoulos   Hi! I've just found this plugin. I don...   Jun 29 2012, 17:37
- - m00zikD00d   OK, I am trying to figure out how to get this comp...   Sep 14 2012, 00:28
|- - mobyduck   Can't you simply doCODE WHERE content_group_mv...   Sep 14 2012, 07:52
|- - fbuser   QUOTE (m00zikD00d @ Sep 14 2012, 00:28) C...   Sep 14 2012, 16:40
- - neothe0ne   Some questions. 1) What's the difference bet...   Oct 7 2012, 08:53
- - fbuser   QUOTE (neothe0ne @ Oct 7 2012, 08:53) 1) ...   Oct 7 2012, 09:46
2 Pages V   1 2 >


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 22nd December 2014 - 23:58