Menu

Post image 1
Post image 2
1 / 2
0

launching for Dutch; part 1: content

DEV Community·LangBear·about 1 month ago
#cPpCgkbj
Reading 0:00
15s threshold

LangBear

I launched LangBear for Swedish as this is the language that I'm myself learning. So far however, I had not been able to acquire a single customer -- neither a paying not just an active one.

I decided to try with the Dutch language next as the total addressable population is supposed to be larger.

First, I need to work on content quantity:

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';

Enter fullscreen mode Exit fullscreen mode

level level_count total_count
A1 3 55
A2 6 55
B1 35 55
B2 7 55
C1 4 55

These numbers come mainly from the translations of base copies of Swedish texts. The target is to have around 200 texts total with equal distribution among them.

Read More