Yeah, that FindDBMS tool what quite fast as I remember, and flexible, as it could search views as well as base tables.
That tool should still work if you have your data in a database - it doesn't have to be PostgreSQL/PostGIS.
The idea behind Wildcard Search was the same as the idea behind DBMS Find: Providing an easy-to-use tool that quickly can find and list records matching the entered value.
I guess the DBMS Find tool could even be improved to take advantage of some of the text comparison functions of the database.
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------
Original Message:
Sent: 03-09-2023 08:40
From: Tom Parker
Subject: Multi Search Tool
Thanks John,
MapInfo has always seemed to lack a good gazetteer search, so I'll give this a go. It's a shame that fuzzy searching is less than performant even on much smaller datasets. @Peter Møller once gave me a tool called Find DBMS that could connect to PostGIS and do the search server side (taking advantage of specialised text indexing) which was really fast. I wonder if this can do that?
Otherwise it'd be good to get a tool working that can search the OS Places API, but I'm a bit rusty on querying web services in MapBasic...
------------------------------
Tom Parker
Cambridgeshire County Council
HUNTINGDON
------------------------------