Den 2013-04-03 10:41 skrev Dimitry Sibiryakov såhär: > 03.04.2013 10:30, Thomas Beckmann wrote: >> Aren't we talking about building something into the firebird engine? > Right. But before putting something (such big) into engine someone must > prove that a) > it works at all and b) someone needs it really, not "just in case" or "for > fun" or > "because other DBMS claim it". If there had been well-known UDF library for > this, > statistics of its usage would be the proof. No such stats - nothing to talk > about.
I understand and respect your point Dimitry, and I agree for the most part. For me, I would have use for a phonetic matching algorithm for Swedish, but probably more so in .Net code than inside FB. If it were available in FB and not .Net I'd probably make good use of it, but with my architecture a .Net function would be easier to use. I can only assume that quite a few applications could make good use of phonetic matching inside FB, but the development of such a function is probably beyond the capabilities of most developers. And I don't mean algorithmically, but linguistically - the pronunciation rules are complex and not something a regular software developer would know in detail. Not being able to write the function, the developer would try to find a ready-made algorithm like Metaphone or Soundex, but at least I have failed to find such a thing for Swedish. Failing that, I pretty much gave up. So, to be frank I'd say for many languages the problem is not if FB has support for phonetic matching or not, but if a working phonetic matching algorithm even exists (has been developed) for that language. If it does, coding it would probably be a rather straightforward task. What kind of phonetic matching support fo the other DB engines have? English only? Double Metaphone? What? Coding such a function for FB should be straightforward, and would obviously be useful for a lot of applications (many apps do have English data after all). Having that on the feature list might be good marketing wise and perhaps a rather small development effort? Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
