cellajs / cella Goto Github PK

In auth middleware, the update of User lastSeenAt & lastVisitAt is too frequent, it's better to "update after a certain amount of time past the old timestamp".

Unnecessary updates can affect postgres performance and generate unnecessary WAL logs.

And the code is in "backend/src/middlewares/guard/auth.ts", thanks.

Overview

Create a blog section in cellajs.

Technology used

• HonoX: https://github.com/honojs/honox
• shadcn/ui: https://github.com/shadcn-ui/ui

How to create

Create a new workspace called blog since it seems to use pnpm workspace.

Questions

• I was imagining only creating a page that would be /blog/${slug}, are there any other pages that need to be created?
  • Such as a page that will allow people to search for blog categories.
• What would you like the UI to look like?

Hi,

Would you please consider replacing NanoID with UUID?

There are some points worth considering:

• Postgres & CockroachDB have native UUID type, so UUID columns can be processed in binary form and may be faster than text columns in some scenarios.
• For UUID, users can choose either time-based UUIDv7 or random-based UUIDv4, but NanoID is always randomly distributed.
• UUID PK can be easily integrated with different systems, such as financial system/CRM, etc. These systems are more likely to use UUID rather than NanoID.
• Many old systems already use UUID, if Cella uses UUID, there will be less resistance for people to adopt it.
• We don't need any libs to use UUID, even frontend can use window.crypto.randomUUID().
• Some libraries (short-uuid) can shorten the UUID, NanoID doesn't really have an advantage in this regard.

I believe that in the long run, compared with NanoID, Cella should adopt industrial standards such as UUID, which is more beneficial to its future development. After all, its target group is enterprise users.

Anyway, Cella's tech stack shows great taste, I sincerely hope it will be widely adopted, thanks.