launching for Dutch; part 1: content

Source: Dev.to

Background

I launched LangBear for Swedish as this is the language that I’m learning. So far, however, I have not been able to acquire a single customer—neither a paying nor an active one. I decided to try with the Dutch language next, as the total addressable population is supposed to be larger.

Content Quantity

To assess the current amount of Dutch content, I ran the following query:

SELECT
  data->>'level' AS level,
  COUNT(1) AS level_count,
  SUM(COUNT(1)) OVER () AS total_count
FROM exercises 
WHERE lang = 'nl' AND type = 'text_quiz'
GROUP BY data->>'level'
ORDER BY data->>'level';

The result set is:

These numbers come mainly from the translations of base copies of Swedish texts.

Target

The goal is to have around 200 texts total with an equal distribution across the proficiency levels.