Edit search tab listing

There is no such thing as a stupid question here as long as it pertains to using NewsBin. Newbies feel free to get help getting started or asking questions that may be obvious. Regular users are asked to be gentle. :-)

Moderators: Quade, dexter

Edit search tab listing

Postby dane » Thu Jan 27, 2022 2:36 pm

Is there a way to edit the drop-down listing of searches on the search tab. There are searches that I rerun from time to time, but they keep rolling off the bottom of the list due to less important, transitory searches. Are the items in the list stored in an editable file? or accessible somehow?

Thanks,
DaDane
dane
Seasoned User
Seasoned User
 
Posts: 200
Joined: Sat Mar 26, 2005 7:47 pm

Registered Newsbin User since: 03/25/05

Re: Edit search tab listing

Postby Quade » Thu Jan 27, 2022 4:41 pm

They're stored in "GuiItems.db3" in your user tree but you'd need some tool to edit Sqlite databases.

When you use a search it bubbles to the top again but, if it sits unused long enough new searches can push the old out.
User avatar
Quade
Eternal n00b
Eternal n00b
 
Posts: 44981
Joined: Sat May 19, 2001 12:41 am
Location: Virginia, US

Registered Newsbin User since: 10/24/97

Re: Edit search tab listing

Postby dane » Fri Jan 28, 2022 5:46 pm

That's very kewl! Had to find some tools (sqlite studio) which provides a graphical interface. Had some trouble installing, but eventually got it. Took a little time to find how to edit the database, and now...it works. Thanks, that'll be a big help.

btw, is the filestructure (db3) from the old pc database tool dbase III? I know they went out of business many years ago, but they had built some good tools along the way. I wouldn't be surprised if their data structures outlived them.

Thanks for the help,
DaDane
dane
Seasoned User
Seasoned User
 
Posts: 200
Joined: Sat Mar 26, 2005 7:47 pm

Registered Newsbin User since: 03/25/05

Re: Edit search tab listing

Postby Quade » Sat Jan 29, 2022 12:23 pm

Sqlite is the most popular database probably in the world. It's used everywhere including android phones and I believe IOS. It's a format that works the same under Linux as Windows.

The ".db3" is just my own name for the extension. From when I switched to Sqlite version 3.
User avatar
Quade
Eternal n00b
Eternal n00b
 
Posts: 44981
Joined: Sat May 19, 2001 12:41 am
Location: Virginia, US

Registered Newsbin User since: 10/24/97

Re: Edit search tab listing

Postby dane » Sat Jan 29, 2022 4:10 pm

Ah! You had me in a flashback there.

In the guiitems file, what's the difference between the various items - from list, filter list, download history, search list? I get not to fool with sizes and age, but what about the others?

Also, for every .db3 file there seems to be a .db3-shm & .db3-wal. Sqlite doesn't want anything to do with these - are they backups, indexes, or something?

Thanks for being so open about this.
DaDane
dane
Seasoned User
Seasoned User
 
Posts: 200
Joined: Sat Mar 26, 2005 7:47 pm

Registered Newsbin User since: 03/25/05

Re: Edit search tab listing

Postby itimpi » Sat Jan 29, 2022 5:23 pm

dane wrote:Also, for every .db3 file there seems to be a .db3-shm & .db3-wal. Sqlite doesn't want anything to do with these - are they backups, indexes, or something?
DaDane

Those files are created automatically as part of the way SQLite commits updates. Most of the time they are transient and then disappear once all the database updates are fully committed.
The Newsbin Online documentation
The Usenettools for tutorials, useful information and links
User avatar
itimpi
Elite NewsBin User
Elite NewsBin User
 
Posts: 12607
Joined: Sat Mar 16, 2002 7:11 am
Location: UK

Registered Newsbin User since: 03/28/03

Re: Edit search tab listing

Postby Quade » Sun Jan 30, 2022 12:17 am

In the guiitems file, what's the difference between the various items - from list, filter list, download history, search list? I get not to fool with sizes and age, but what about the others?


The search tab has a distinct list from the post list, files list and download list. The one you probably want to monitor is the "search list".
User avatar
Quade
Eternal n00b
Eternal n00b
 
Posts: 44981
Joined: Sat May 19, 2001 12:41 am
Location: Virginia, US

Registered Newsbin User since: 10/24/97

Re: Edit search tab listing

Postby dane » Sun Jan 30, 2022 9:47 am

Thanks Quade and thanks too to you itimpi

DaDane
dane
Seasoned User
Seasoned User
 
Posts: 200
Joined: Sat Mar 26, 2005 7:47 pm

Registered Newsbin User since: 03/25/05


Return to Newbie Forum

Who is online

Users browsing this forum: No registered users and 1 guest