www.stone-oakvalley-studios.com







                                                         



O N E   C R A Z Y   M U L T I   T A L E N T Today its Monday, November 24, 2025 @
13:00:05


Channel #1

Channel #2

Channel #3

Stone Oakvalley's Text Database Searcher (SOTDS) v2.4 released
in Software | Monday, February 08, 2016 | 18:55


Big update, now more database fields (parts) are supported, from the initial ABCD to ABCDEFGHIJKLMNO, along with another neat Apply Filter function.


::: REVISION HISTORY SOTDS CONSTRUCTOR :::
------------------------------------------
v1.5 - 08 Feb 2016

01: Added support for part IJKLMNO, where KLM is strictly numeric, the IJNO = text/numeric.
02: Compiled with PureBasic V5.41LTS just to make sure. No other changes adjusted. 1 bug fixed.
03: SOTDS_Searcher has been updated to support the same new parts added, namely IJKLMNO



::: REVISION HISTORY SOTDS SEARCHER :::
---------------------------------------
v2.4 - 08 Feb 2016

01: Added support for part IJKLMNO, where KLM is strictly numeric, the IJNO = text/numeric. It means more fields are supported in entire SOTDS Suite.

02: Tweaked some macros and added some more internally to make code cleaner and future adjustable.

03: Reduced memory usage during startup, previously 1 million items in memory for each part were pre-allocated. This was probably overkill, so adjusted down to 10000, with automatic increase of 30000 each time until results neeeded.

04: Minor GUI fixes and improvements, some bugs probably squeezed since V2.3 due to more macro coding.

05: It should be noted that databases that uses the entire range of part A1A2A3BCDEFGHIJKLMNO (17 fields) can cause memory requirements increase and disk space needed for final database is increased including slower GUI updates.

06: "Export CSV (TAB)" "Export HTML table" and "Export All Locations" where all put into a pulldown menu to save some space. Upon selection if works are before. Since I grouped the choices above into a pulldown menu, I had space for a filter feature. It will allow you to filter the entire current search hits found to add the logic of "MUST CONTAIN" for each available part.

- The new Filter Mode will remove permantly a complete line of fields in memory, so use with caution. If you need to get everything back, just do a search again and re-do the filtering, no problem.

- The new Filter Mode a little bit slower (just like Sort By Column function is), but has been fairly optimized to be useful at least. A progress bar was added too.

07: "Export By Location" changed to "Export By (ID)", which makes more sense since its only active for UNIQUE_ID_MODE or SENTENCE_MODE enabled databases .

08: Compiled with PureBasic V5.41LTS Final Release just to make sure.2

The new grouped pulldown menu of Export function (same as before, just redesign GUI).



New super neat powerful function added. When you get a lot of search results you can now also add another filter (as many times or as many as you want) on the current search hits listed on screen and memory.

To reset the filter, simply search again with your same term.



Example of a filtered result, here by typing "source" for PATH in the previous screenshot above.




Please review these related article links:
Click to open urlStone Oakvalley's Text Database Searcher (SOTDS) Dashboard


------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Posted by: Programmer, Stone Oakvalley | Publisher: Website Designer, Stone Oakvalley
Last revised: December 07, 2022 - 17:31 | Page views: 1042


Website Design by post@stone-oakvalley-studios.com - Copyright © 2025 www.stone-oakvalley-studios.com