🤔 If I have a paragraph in QuestDB stored as a string, do you know how can I count the number of words inside this large string? E.g.

Hi, my name is Jon.

Should yield

5

hi, I think you would have to implement a custom function for this. it should not be that hard, have a look at for https://github.com/questdb/questdb/blob/7e0207604f61faf641553064a2a646fa69ee4067/c[…]db/griffin/engine/functions/str/ToUppercaseFunctionFactory.java for inspiration.

Thanks will check it out now 👍 🤘🏻

WordCount is actually a very good example for a tutorial on how to extend QuestDB!

By one of these custom functions, right?

yes

I confirm that the demo project is really easy to follow! Very nice. If you have already followed the Create my first dataset guide, then you can immediately use the function in queries like this:

select distinct
  city,
  wordcount(city) as word_count
from sensors
order by word_count, city;

thanks Matt! after publishing the demo I realized there could be an issue in distributions where we

jlink

JDK and QuestDB into a single image. because there is no QuestDB JAR in the first place. So for now the demo will work in MacOS and no-RT distributions. but it might be more complicated in distributions where JDK (RT) is packaged together with QuestDB.