Requesting for a video walkthrough

[OmarFaruk-0x01]

I found this repo in Twitter, i think someone i follow like this and pops up into my timeline.
i'm long time interested how notion/linear and some other's real time sync engine works

Thank you so much for this.
I already started to reading the code, and you did a great job with docs.md, very few repo has this kind of long document about codebase.

as you wrote, i would really love to see a video walkthrough about codebase, and explaining about sync engine works

[ccorcos]

Glad you're getting value out of it. What do you want me to cover in a video that isn't in the docs? Can I answer any questions?

[OmarFaruk-0x01]

thanks for your time,
one thing i like to know about ‌‌‌‌‌‌‌‌src/server/services/Database.ts file

here we see, all the database query like getRecordQueue, getRecords , we are writing function in one class .
but as project grow, do you think you still write all db query function in one class ?

what was your experience at notion & what you recommend if you have 40/50 query.

another thing, please keep this issue open so as i go through the codebase, i can ask more question here

[ccorcos]

At Notion, instead of having all the methods on the class, the raw postgres connection was on the environment and we had one file postgresQueries with all of our queries in there. I think I like that approach better because it gives you some more flexibility for composing functions, and gives you raw access to the postgres connection for any migrations or things like that you might need to do.

type ServerEnvironment = {
  db: Postgres
  ...
} 

// postgresQueries.ts
export function getRecordValue(db: Postgres, pointer: RecordPointer) {
  ...
}

There's nothing wrong with having a big file!