IPB

Welcome Guest ( Log In | Register )

16 Pages V   1 2 3 > »   
Reply to this topicStart new topic
Database Search, Please post comments here
foosion
post Mar 27 2003, 00:15
Post #1





Group: FB2K Moderator (Donating)
Posts: 4409
Joined: 24-February 03
Member No.: 5153



Stable version: 1.3.1
Beta version: 1.4 beta 2
See my 0.9 components page for download links.



Original post follows:

I have made a database search plugin B) (go to the third party plugins topic for details and download link).

I don't think it's perfect yet (search window is not resizable), but it's working. Any comments, problems, suggestions?
Have a look at the configuration page for it contains hints about the usage.

This post has been edited by foosion: Jun 2 2006, 15:20


--------------------
http://foosion.foobar2000.org/ - my components for foobar2000
Go to the top of the page
+Quote Post
musicmusic
post Mar 27 2003, 00:41
Post #2


Columns UI developer


Group: Developer
Posts: 3034
Joined: 20-December 02
From: United Kingdom
Member No.: 4177



nice:) its working quite well, i used to use album list as my database explorer but now ive got this too smile.gif It is extremely handy for building playlists. the search is also a hella lot faster than the normal playlist search.

bug: (unicode) xp - wierd title.


--------------------
.
Go to the top of the page
+Quote Post
foosion
post Mar 27 2003, 00:47
Post #3





Group: FB2K Moderator (Donating)
Posts: 4409
Joined: 24-February 03
Member No.: 5153



QUOTE
bug: (unicode) xp - wierd title.


I guess, I'm setting the window title to an ANSI string. At least this will be easy to fix.


--------------------
http://foosion.foobar2000.org/ - my components for foobar2000
Go to the top of the page
+Quote Post
musicmusic
post Mar 27 2003, 00:57
Post #4


Columns UI developer


Group: Developer
Posts: 3034
Joined: 20-December 02
From: United Kingdom
Member No.: 4177



QUOTE (foosion @ Mar 26 2003 - 11:47 PM)
I guess, I'm setting the window title to an ANSI string. At least this will be easy to fix.

Maybe, but it actually displays garbage, sometimes amongst it references to songs in my database, but not the search results. What is it supposed to display?

Also, an option to initially display the entire database would be useful (for me wink.gif )


--------------------
.
Go to the top of the page
+Quote Post
ssamadhi97
post Mar 27 2003, 01:06
Post #5





Group: Developer (Donating)
Posts: 1203
Joined: 10-February 02
From: Endless Water
Member No.: 1305



QUOTE (musicmusic @ Mar 27 2003 - 12:57 AM)
sometimes amongst it references to songs in my database, but not the search results.

It actually displays readily formatted playlist entries here every now and then, just for giggles ph34r.gif


--------------------
A riddle is a short sword attached to the next 2000 years.
Go to the top of the page
+Quote Post
Curi0us_George
post Mar 27 2003, 01:14
Post #6





Group: Members
Posts: 992
Joined: 17-March 03
Member No.: 5544



Damn you. smile.gif I was going to write (err, finish writing) that plugin. biggrin.gif (Actually, I still plan to finish it.)
Go to the top of the page
+Quote Post
ssamadhi97
post Mar 27 2003, 01:44
Post #7





Group: Developer (Donating)
Posts: 1203
Joined: 10-February 02
From: Endless Water
Member No.: 1305



*sniff sniff* a fix'd version must be just around the corner.

ph34r.gif


--------------------
A riddle is a short sword attached to the next 2000 years.
Go to the top of the page
+Quote Post
foosion
post Mar 27 2003, 01:44
Post #8





Group: FB2K Moderator (Donating)
Posts: 4409
Joined: 24-February 03
Member No.: 5153



QUOTE
What is it supposed to display?


"Database search - x found" substitute x with a number wink.gif

QUOTE
Also, an option to initially display the entire database would be useful (for me  wink.gif )


Not hard to implement, the empty string is contained in all strings tongue.gif but it will be quite slow - that's why I decided to display an empty list.

Btw., you can download the updated version now.

EDIT: If you're interested, you can get the source code (foo_dbsearch.src.zip).

@Curi0us_George: Have you started? What are your ideas for this kind of plugin? I thought about making it more like the albumlist plugin (display-wise), but a listbox was easier to do smile.gif .

This post has been edited by foosion: Mar 27 2003, 01:57


--------------------
http://foosion.foobar2000.org/ - my components for foobar2000
Go to the top of the page
+Quote Post
Curi0us_George
post Mar 27 2003, 02:10
Post #9





Group: Members
Posts: 992
Joined: 17-March 03
Member No.: 5544



I hadn't gotten far, honestly. I was having trouble with the database accessing. I finally found some little code snippets which made the database use clearer (it was mostly unclear because I was dead tired the only time I worked on it), but I haven't done anything with it since then.

Here's the reason I want this plugin:
Every time I want to play some files, I open the album list and send everything to the playlist. (And then it auto-plays and I have to hit the stop button). Then I open the playlist search and narrow it down. I basically just want to have a plugin with the playlist search functionality, and the album list buttons.

(I've also considered doing a folder monitoring plugin, but it's not really a priority right now, so I haven't done any work on that at all.)
Go to the top of the page
+Quote Post
musicmusic
post Mar 27 2003, 18:11
Post #10


Columns UI developer


Group: Developer
Posts: 3034
Joined: 20-December 02
From: United Kingdom
Member No.: 4177



QUOTE (foosion @ Mar 27 2003 - 12:44 AM)
Btw., you can download the updated version now.

thanks smile.gif

QUOTE
but it will be quite slow


no, still instant smile.gif


--------------------
.
Go to the top of the page
+Quote Post
anza
post Mar 27 2003, 18:39
Post #11





Group: Members
Posts: 1317
Joined: 4-January 03
From: Finland
Member No.: 4418



QUOTE (musicmusic @ Mar 27 2003 - 07:11 PM)
QUOTE
but it will be quite slow


no, still instant smile.gif

How come everyone keeps on saying this is faster than the playlist search thing? For me at least, this plugin is waaaay slower than the pl-search, which indeed is instant with me. But nice plugin though, I like this smile.gif
Go to the top of the page
+Quote Post
musicmusic
post Mar 27 2003, 19:21
Post #12


Columns UI developer


Group: Developer
Posts: 3034
Joined: 20-December 02
From: United Kingdom
Member No.: 4177



QUOTE (anza @ Mar 27 2003 - 05:39 PM)
QUOTE (musicmusic @ Mar 27 2003 - 07:11 PM)
QUOTE
but it will be quite slow


no, still instant smile.gif

How come everyone keeps on saying this is faster than the playlist search thing?

its not really.

in that quote i meant it still loads up instantly, but it is slow if you clear the string subsequently.

when i said it was fast before it wasn't a fair comparison because the playlist search was searching though more than artist/title/album.

after putting the search strings the same, the speed is the same. but for some reason the playlist search is instally slow for me, i.e. when you first enter a character.

edit: ok the new 0.2 version is instant wink.gif

This post has been edited by musicmusic: Mar 27 2003, 19:25


--------------------
.
Go to the top of the page
+Quote Post
foosion
post Mar 27 2003, 19:27
Post #13





Group: FB2K Moderator (Donating)
Posts: 4409
Joined: 24-February 03
Member No.: 5153



Get the new version! Search window is now resizable and searching is a bit faster.

Any ideas for improvements (like "Remember window position" - I think that I will add this)?


--------------------
http://foosion.foobar2000.org/ - my components for foobar2000
Go to the top of the page
+Quote Post
musicmusic
post Mar 27 2003, 20:30
Post #14


Columns UI developer


Group: Developer
Posts: 3034
Joined: 20-December 02
From: United Kingdom
Member No.: 4177



i just realised the (annoying) search logic. first it would only search one field so i changed "%artist%|%album%|%title%" to "%artist% - %album% - %title%" (i prefer the dashes than just a space)

ok that makes sense. but say artist is "123" and title is "blah (remix)". search for "123 remix" you wont get any results sad.gif

It seems to treat the search as one string, playlist search doesn't behave like this, it will separate the strings at spaces.

Maybe this could be a option?

This post has been edited by musicmusic: Mar 27 2003, 20:39


--------------------
.
Go to the top of the page
+Quote Post
foosion
post Mar 27 2003, 22:54
Post #15





Group: FB2K Moderator (Donating)
Posts: 4409
Joined: 24-February 03
Member No.: 5153



QUOTE (musicmusic @ Mar 27 2003 - 08:30 PM)
It seems to treat the search as one string, playlist search doesn't behave like this, it will separate the strings at spaces.

Maybe this could be a option?

blink.gif To be honest, I didn't realize that playlist search behaved like this. I guess this should be changed.

Unluckily, I won't have much time until after the weekend. So if someone else wants to add this, do it. All I ask for, is that you send me your changes, so I can update the official version tongue.gif . Of course you will get credits.

EDIT: reminder: link to source code

This post has been edited by foosion: Mar 27 2003, 22:57


--------------------
http://foosion.foobar2000.org/ - my components for foobar2000
Go to the top of the page
+Quote Post
Curi0us_George
post Mar 28 2003, 01:45
Post #16





Group: Members
Posts: 992
Joined: 17-March 03
Member No.: 5544



You just need to tokenize the input. It's going to increase search time, though. You might want to add a "search for exact string" checkbox (checked by default).

P.S. I've gotten fairly far along with my code now. I'm looking at changing the core logic, though. I think I've got a couple of ideas that could drastically speed up searches, but I think the memory overhead might be high.

This post has been edited by Curi0us_George: Mar 28 2003, 01:46
Go to the top of the page
+Quote Post
Curi0us_George
post Mar 28 2003, 06:39
Post #17





Group: Members
Posts: 992
Joined: 17-March 03
Member No.: 5544



"Damn you Visual Studio!"

I've been searching for a bug for about an hour. For whatever reason, VS wasn't properly linking the most recent versions of some files. A rebuild fixed it. Arg. I couldn't implemented useful things in that hour, instead of inserting debug code everywhere.
Go to the top of the page
+Quote Post
anza
post Mar 29 2003, 16:41
Post #18





Group: Members
Posts: 1317
Joined: 4-January 03
From: Finland
Member No.: 4418



The "dedicated display/sorting formatting" strings can't be longer than the box you write them to, would it be possible to fix this?

This post has been edited by anza: Mar 29 2003, 16:41
Go to the top of the page
+Quote Post
Curi0us_George
post Apr 3 2003, 17:12
Post #19





Group: Members
Posts: 992
Joined: 17-March 03
Member No.: 5544



I noticed that the "auto-search" toggle isn't doing anything. (I was comparing the memory use and speed of your plugin compared to mine.) This is with foo_dbsearch 0.4 and foobar2000 0.6b6.
Go to the top of the page
+Quote Post
foosion
post Apr 3 2003, 18:42
Post #20





Group: FB2K Moderator (Donating)
Posts: 4409
Joined: 24-February 03
Member No.: 5153



QUOTE (Curi0us_George @ Apr 3 2003 - 06:12 PM)
I noticed that the "auto-search" toggle isn't doing anything.  (I was comparing the memory use and speed of your plugin compared to mine.)  This is with foo_dbsearch 0.4 and foobar2000 0.6b6.

Also happens with the ANSI version. I was sure it worked before. Expect a fix later.


--------------------
http://foosion.foobar2000.org/ - my components for foobar2000
Go to the top of the page
+Quote Post
foosion
post Apr 6 2003, 19:17
Post #21





Group: FB2K Moderator (Donating)
Posts: 4409
Joined: 24-February 03
Member No.: 5153



[BLAH]
What has started as a simple and lightweight plugin, now evolved into what would more likely be called "geek toy". Yes, that's right, a new version of foo_dbsearch is out, and it rises high above its predecessors in a blinding flash of light! Download it, and unleash its fierce power upon your unsuspecting database! ph34r.gif
[/BLAH]

Sorry, I just had to say this... tongue.gif

A note about the change log: Even it is says that the search sematics have changed, the default display string is set to compensate for that.
I'm waiting for your comments now.


--------------------
http://foosion.foobar2000.org/ - my components for foobar2000
Go to the top of the page
+Quote Post
skwire
post Apr 7 2003, 11:25
Post #22





Group: Members
Posts: 7
Joined: 7-April 03
Member No.: 5868



I'm using the latest Foobar (b7) and the latest DB Search plugin. I love the new, quicker search but I'm having a problem with it. It seems that if I try to close Foobar with the DB Search window visible, Foobar will hang. Can anybody confirm/duplicate this?
Go to the top of the page
+Quote Post
Melomane
post Apr 7 2003, 11:41
Post #23





Group: Members
Posts: 643
Joined: 13-January 03
From: Marseille
Member No.: 4552



yes , same problem

win98 se
foobar 0.6 b7
DB Search plugin 0.6 ansi


--------------------
Music is my first love.
Go to the top of the page
+Quote Post
ssamadhi97
post Apr 7 2003, 11:46
Post #24





Group: Developer (Donating)
Posts: 1203
Joined: 10-February 02
From: Endless Water
Member No.: 1305



confirmed:

winxp
fb2k0.6b7 nt version + dbsearch unicode
fb2k0.6b7 nt version + dbsearch ansi
fb2k0.6b7 9x version + dbsearch ansi


--------------------
A riddle is a short sword attached to the next 2000 years.
Go to the top of the page
+Quote Post
foosion
post Apr 7 2003, 12:52
Post #25





Group: FB2K Moderator (Donating)
Posts: 4409
Joined: 24-February 03
Member No.: 5153



Evil deadlock is fixed. Silly me, I thought I could use semaphores for mutual exclusion... concurrency is wonderful. I did not increase the version number, as it was really a tiny change to the source.


--------------------
http://foosion.foobar2000.org/ - my components for foobar2000
Go to the top of the page
+Quote Post

16 Pages V   1 2 3 > » 
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: 24th July 2014 - 17:48