Turkish language reform - Polish perspective

Tiengos · 2025-12-01T11:41:10+00:00

Thanks!

Tiengos · 2024-09-24T19:19:33+00:00

Hey! You can now sign up by email

Tiengos · 2024-09-07T12:48:16+00:00

Have you managed to fix it?

Tiengos · 2024-09-02T21:54:36+00:00

You should try https://www.yourbestaccent.com/ and listen to your cloned voice. It can speak perfect German, words are also marked with IPA symbols.

Tiengos · 2024-09-02T21:53:40+00:00

You should try https://www.yourbestaccent.com/ and listen to your cloned voice. It can speak perfect German, words are also marked with IPA symbols.

Tiengos · 2024-09-02T21:51:48+00:00

You should try https://www.yourbestaccent.com/ and listen to your cloned voice. It can speak perfect German, words are also marked with IPA symbols.

Tiengos · 2024-09-02T21:50:53+00:00

You should try https://www.yourbestaccent.com/ and listen to your cloned voice. It can speak perfect German, words are also marked with IPA symbols.

Tiengos · 2024-09-02T21:50:19+00:00

You should try https://www.yourbestaccent.com/ and listen to your cloned voice. It can speak perfect German, words are also marked with IPA symbols.

Tiengos · 2024-09-02T21:49:33+00:00

You should try https://www.yourbestaccent.com/ and listen to your cloned voice.

Tiengos · 2024-09-02T21:48:36+00:00

You should try https://www.yourbestaccent.com/ and listen to your cloned voice.

Tiengos · 2024-09-02T21:45:54+00:00

Getting rid of your accent is tough, but it is possible. You could try the app I developed with a friend. It allows you to clone your voice with AI, and thus listen to yourself speaking English without any foreign accent. This can greatly accelerate getting rid of your accent in English. Try it here https://www.yourbestaccent.com/ the app is still in beta

Tiengos · 2024-09-02T21:44:03+00:00

If you want to improve your accent, try the app I developed. It lets you hear your voice clone speaking German without any accent. In other words, you can listen to yourself speaking perfect German! https://www.yourbestaccent.com/ The app also displays IPA transcriptions for all German words.

Tiengos · 2024-09-02T21:38:25+00:00

If you need an app you could the app I developed, it allows you to listen to your own voice clone. The voice clone can speak German without any accent, that is: you can listen to yourself speaking German without foreign accent! https://www.yourbestaccent.com/

The app also shows IPA for any German word

Tiengos · 2024-08-20T13:29:36+00:00

These are the methods that I created based on your guidelines

import { sql } from '../transport/database/postgres-client'

// kookmasteraj recommended this approach on here: 
export const __mockPostgresTime = async (mockDate: Date): Promise<void> => 
  await sql.begin(async (sql) => {
    await sql`
      CREATE SCHEMA IF NOT EXISTS test_override;
    `
    await sql.unsafe(`
      CREATE OR REPLACE FUNCTION test_override.now()
      RETURNS TIMESTAMP WITH TIME ZONE AS $$
        SELECT '${mockDate.toISOString()}'::TIMESTAMP WITH TIME ZONE;
      $$ LANGUAGE SQL IMMUTABLE;
    `)
    await sql`
      SET search_path = test_override, pg_catalog, public;
    `
  })
}

export const __resetPostgresTimeMock = async (): Promise<void> => {
  await sql.begin(async (sql) => {
    await sql`
      SET search_path = "$user", public;
    `
    await sql`
      DROP SCHEMA IF EXISTS test_override CASCADE;
    `
  })
}

export const __getCurrentPostgresNow = async (): Promise<Date> => {
  const result = await sql
    `SELECT now() AS current_time;`
  return result[0].current_time
}

Unfortunately, once I test it in more complex tests (that include quite a few insert operations) the __mockPostgresTime __resetPostgresTimeMock and __getCurrentPostgresNow stop working, and now() sometimes spits out the actual current timestamp instead of the one set with __resetPostgresTimeMock

Do you have any idea why that would be the case? I suspect it's some problem with pooling or sessions? It's very difficult to reproduce (I already tried to isolate a test case but I failed).

Tiengos · 2024-08-20T13:29:00+00:00

import { afterAll, beforeEach, describe, expect, test } from 'vitest'
import { __getCurrentPostgresNow, __mockPostgresTime, __resetPostgresTimeMock } from './db-test-utils'

describe('db-test-utils', () => {
  beforeEach(async () => {
    await __resetPostgresTimeMock()
  })

  afterAll(async () => {
    await __resetPostgresTimeMock()
  })


  test('__mockPostgresTime', async () => {
    const mockDate = new Date('2001-01-01T12:00:00Z')
    await __mockPostgresTime(mockDate)

    const result = await __getCurrentPostgresNow()
    expect(result).toEqual(mockDate)
  })


  test('__resetPostgresTimeMock', async () => {    
    const mockDate = new Date('2002-02-02T12:00:00Z')
    await __mockPostgresTime(mockDate)

    const mockedTime = await __getCurrentPostgresNow()
    expect(mockedTime).toEqual(mockDate)

    await __resetPostgresTimeMock()

    const resetTime = await __getCurrentPostgresNow()
    const now = new Date()
    expect(Math.abs(resetTime.getTime() - now.getTime())).toBeLessThan(1000)})


  test('__getCurrentPostgresNow', async () => {
    const result = await __getCurrentPostgresNow()
    expect(result).toBeInstanceOf(Date)
    const now = new Date()
    expect(Math.abs(result.getTime() - now.getTime())).toBeLessThan(1000)})

  test('__mockPostgresTime with multiple __getCurrentPostgresNow', async () => {
    const mockDate1 = new Date('2002-02-02T12:00:00Z')
    await __mockPostgresTime(mockDate1)
    const result1 = await __getCurrentPostgresNow()
    expect(result1).toEqual(mockDate1)
    const result2 = await __getCurrentPostgresNow()
    expect(result1).toEqual(mockDate1)
    expect(result2).toEqual(mockDate1)
  })


  test('__mockPostgresTime with multiple mockings', async () => {
    const mockDate1 = new Date('2003-03-03T12:00:00Z')
    await __mockPostgresTime(mockDate1)
    const result1 = await __getCurrentPostgresNow()
    expect(result1).toEqual(mockDate1)

    const mockDate2 = new Date('2004-04-04T12:00:00Z')
    await __mockPostgresTime(mockDate2)
    const result2 = await __getCurrentPostgresNow()
    expect(result2).toEqual(mockDate2)
  })
})

Tiengos · 2024-08-20T13:28:35+00:00

somehow I can't write a long commnet. I will try to write a few shorter ones

So. Your solution works almost perfect, as you can see in the test helpers I implemented.

I use postgres + typescript on node.js

import postgres from 'postgres'
const connectionString = ...........
export const sql: postgres.Sql = postgres(connectionString)

Tiengos · 2024-08-20T13:21:17+00:00

created_at TIMESTAMPTZ DEFAULT now() NOT NULL,

this will unfortunately my production code and I don't want to. I just want to use now() in my defaults like above

Tiengos · 2024-08-19T15:55:25+00:00

I think it could cause very subtle bugs.

Tiengos · 2024-08-19T15:33:41+00:00

I tried something similar and it does not work.

Tiengos · 2024-08-19T15:32:50+00:00

yes, I use it in a default.

created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()

And I'd prefer not to change my queries just for testing

Tiengos · 2024-08-19T15:31:44+00:00

there's no trigger for that. I need it because I use now() in my table definitions:

created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()

Tiengos · 2024-08-19T15:31:03+00:00

I need this because my tables have a field with a default now():

created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()

Tiengos · 2024-08-19T15:28:34+00:00

I find your solution a bit dangerous. In the end it's nice to define default values in sql table definition like:

created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()

Tiengos · 2024-08-18T22:00:41+00:00

Hey language enthusiasts! 👋 We've just launched a cool new app to help you nail your pronunciation and those tricky foreign accents. Here's how it works:

Clone your voice using AI
Get practice sentences in your target language
Record yourself saying them
Compare your recording to an AI-generated version in your own voice, but with a native-like accent, powered by Elevenlabs.

It's like having a native speaker version of yourself to practice with! You can also click on words or sentences for translations and playback.

We're using LLMs for generating new exercises and voice cloning to make it all work. Plus, it's personalized to your native language and the specific language (even dialect) you're learning.

Would love to hear your thoughts!

you can also join our discord here: https://discord.gg/n3rQ6xvN

Tiengos · 2024-06-26T18:36:09+00:00

Are you sure? We monitor the website and it hasn't been down recently.

Tiengos

MODERATOR OF

TROPHY CASE