foo_uie_sql_tree |
foo_uie_sql_tree |
Sep 25 2011, 21:52
Post
#1
|
|
|
Group: Developer Posts: 648 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 |
|
|
|
![]() |
May 18 2012, 16:30
Post
#2
|
|
|
Group: Members Posts: 74 Joined: 8-September 11 Member No.: 93574 |
Mhh. Sorry to bother you again but i have some troubles with this component.
It have worked nicely for quite some time, but since i started working on my layouts again yesterday, i have nothing but corrupt cfgs all the time. Fortunately i have foo_jesus watching my back but i keep restoring backups. What's worse, even backups from a moment where your sql_tree was working won't necessarily restore it. Actually only backups from 2 days ago are sure to restore it (backup is done each time fb2k starts). I can get sql_tree working again simply by restoring foo_uie_sql_tree.db and foo_uie_sql_tree.dll.cfg fortunately but it's still quite annoying. I havn't been able to surely identify another component causing issues. I first thought the issue was caused by me trying to use ELplaylist but i removed it yesterday (uninstalled the component) and had to resore sql_tree again several times today. There is definitely something wrong, i hope you can find out what as it's a great component. At worst i will remove it while i'm messing with layouts and install it back after i'm done as it seems to be more stable when layout isn't edited. It would help if you include a way to export and import node queries (well, i can still copy-paste to a text file) Let me know if there is something i can do to help you find what's wrong, i realize this post is not very helpful as a bug report. |
|
|
|
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
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: 22nd May 2013 - 01:14 |