IPB

Welcome Guest ( Log In | Register )

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





Group: Developer
Posts: 675
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
derty2
post Oct 1 2011, 01:53
Post #2





Group: Members
Posts: 580
Joined: 5-June 11
Member No.: 91257



@fbuser, interesting component, well done ++++

Would you consider adding more fingertip functionality to the context menu?
It would be nice if one could simply right-click on a node and instantly choose either "Send to [...] playlist" OR "Send to console".

@grimes, thanks a lot for sharing your scripts, very helpful +++
considering that I knew nothing about SQL scripting syntax before this plugin came along, grimes' scripts are very helpful.
I'm sure many other users feel the same way. If you have more useful scripts to share, please keep them coming, thanks.

This post has been edited by derty2: Oct 1 2011, 02:00
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: 1st August 2014 - 09:41