foo_uie_sql_tree |
foo_uie_sql_tree |
 Sep 25 2011, 21:52
Post
#1
|
|
|
Group: Developer Posts: 650 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 |
 |
 
|
 |
|
Nov 9 2011, 18:35
Post
#2
|
|
|
Group: Developer Posts: 650 Joined: 26-September 07 Member No.: 47369 |
QUOTE (Black_Over_Bills_Mothers @ Nov 9 2011, 00:22)  Just a small reminder. Any chance of a few common context menu items such as Properties? The item for Properties is already on the todo list for the next release, but I won't add any other items.QUOTE (Zarty @ Nov 9 2011, 13:19) Using SQL tree console, when I get a result from my queries that will consist of a short-list of tracks (Artist, Album, Title), is there a way to direct these track related results to the selection Playlist, a specified Playlist and/or the Playback Queue? No, this is not the purpose of the SQL tree console, that's what the panel is for, although sending to the playback queue is not supported and won't be in the future. The result rows in the console might match tracks one by one by coincidence, but generally they don't. |
|
|
|
|
Nov 9 2011, 22:27
Post
#3
|
|
|
Group: Members Posts: 86 Joined: 30-September 11 Member No.: 94061 |
QUOTE No, this is not the purpose of the SQL tree console, that's what the panel is for, although sending to the playback queue is not supported and won't be in the future. The result rows in the console might match tracks one by one by coincidence, but generally they don't. Yes, now I see. I looked at the panel initially but didn't click on the library nodes to see the playlist that is created. This is even better than I thought. Zarty |
|
|
|
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 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 |
|
Lo-Fi Version | Time is now: 19th June 2013 - 19:24 |
