Blåhaj Comments - Answer Overflow

https://c.lunish.nl/r/4hU8WT.mp4 I am kind of lost here, why are the activity.messages higher on page 1 than on page 0? (each page only adds an offset [page] * 10)

31 replies

KKysely

•Created by Blåhaj on 7/28/2023 in #help

Using `.orderBy` in JSON

thanks anyway

31 replies

KKysely

•Created by Blåhaj on 7/28/2023 in #help

Using `.orderBy` in JSON

I already paniced because I didn't know what I should do and just randomly was scrolling through the test file and found the ->>, tried it and worked lol

31 replies

KKysely

•Created by Blåhaj on 7/28/2023 in #help

Using `.orderBy` in JSON

.addColumn("activity", "json", (col)

31 replies

KKysely

•Created by Blåhaj on 7/28/2023 in #help

Using `.orderBy` in JSON

@Igal I found the issue, in your example you used the -> operator but it's ->>, it works now

31 replies

KKysely

•Created by Blåhaj on 7/28/2023 in #help

Using `.orderBy` in JSON

PostgreSQL 14.8 (Ubuntu 14.8-0ubuntu0.22.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.3.0-1ubuntu1~22.04.1) 11.3.0, 64-bit

31 replies

KKysely

•Created by Blåhaj on 7/28/2023 in #help

Using `.orderBy` in JSON

pg (npm package) or postgres on the server?

31 replies

KKysely

•Created by Blåhaj on 7/28/2023 in #help

Using `.orderBy` in JSON

31 replies

KKysely

•Created by Blåhaj on 7/28/2023 in #help

Using `.orderBy` in JSON

process crashes with

node:internal/streams/writable:303
      throw new ERR_UNKNOWN_ENCODING(encoding);
      ^

TypeError [ERR_UNKNOWN_ENCODING]: Unknown encoding: uncaughtException
    at new NodeError (node:internal/errors:399:5)
    at _write (node:internal/streams/writable:303:13)
    at Writable.write (node:internal/streams/writable:344:10)
    at process.emit (node:events:511:28)
    at process._fatalException (node:internal/process/execution:159:25) {
  code: 'ERR_UNKNOWN_ENCODING'
}

Node.js v20.1.0

node:internal/streams/writable:303
      throw new ERR_UNKNOWN_ENCODING(encoding);
      ^

TypeError [ERR_UNKNOWN_ENCODING]: Unknown encoding: uncaughtException
    at new NodeError (node:internal/errors:399:5)
    at _write (node:internal/streams/writable:303:13)
    at Writable.write (node:internal/streams/writable:344:10)
    at process.emit (node:events:511:28)
    at process._fatalException (node:internal/process/execution:159:25) {
  code: 'ERR_UNKNOWN_ENCODING'
}

Node.js v20.1.0

31 replies

KKysely

•Created by Blåhaj on 7/28/2023 in #help

Using `.orderBy` in JSON

nvm was just vs code having it's moment

31 replies

Gaming

Programming