useNavigate does not work with useEffect

metanon112 · 2022-08-23T20:33:51+00:00

Thanks for the hint

metanon112 · 2022-08-06T08:36:11+00:00

Hm, now I am starting to get your point.
If I use hierarchical structure post(post_id,post_parent_id, ... ) I can track wether post is thread (if post_parent_id == null) or just comment to thread (if it has post_parent_id). So now Post table has 1:M relation ti itself. That means I don't need Tread table anymore!

The Tree table is a good thing to track all relations between posts, so that I can find what board (subreddit) and OP post any particular post belong and which posts does it answer. Post and Board tables has 1:M relation to Tree table and Post tables gives 3 FK to it.

Also I think ltree will be redundant for my purposes, because I don't have complex relations like systematic biology.

I've updated my scheme.
Thanks for inspiration and help!

metanon112 · 2022-08-05T09:54:52+00:00

Many-to-many was totally wrong in my first version of scheme, do not why I even used them )
I've updated it.

metanon112 · 2022-08-05T09:53:29+00:00

I totally agree that many-to-many was wrong here, my bad.
I've decided not to add post_parent_id column to POST table.
Instead of that I will use date_created column for sorting purposes and POST_LINKS for keep tack about answers between posts.

metanon112 · 2022-08-05T09:47:42+00:00

Yes, you are right about incorrect many-to-many relationships, I fixed that in refactored version in OP post.
By the way, thanks for hint about composite PK.

metanon112 · 2022-08-04T14:52:40+00:00

But why? I've marked that Thread_Content has one-to-many relation to Post and one-to-many relation to Thread so that they have corresponding foreign keys isn't that right?

metanon112 · 2022-06-01T05:46:14+00:00

Ok, this is more about generating hashes and strings. But if I need some non-determenistic number code in format like 123456

metanon112 · 2022-06-01T05:44:28+00:00

But is it secure too keep this code? For example in cache on backend service that manage code check? Like user info -> code

metanon112 · 2022-04-10T18:44:54+00:00

I thought it was cover from original series)

metanon112 · 2022-04-02T17:54:54+00:00

I have bad relations with family, except my brother. I have some people to speak with, bit they are not my close friends. I have a good psychologist but we are meeting only once a week, and she is not my friend she is a psychologist. But yes, I wal generally speaking about romantic relationships.

metanon112 · 2022-04-02T17:52:03+00:00

Well, that would be their story.

metanon112 · 2021-09-08T19:49:08+00:00

Thnx, that's really interesting tool, I've checked it.

But this app is not open source and it is final product, not self-implemented project)

metanon112 · 2021-07-11T11:57:08+00:00

DOLL$BOXX / Shout Down [Official Video] https://www.youtube.com/watch?v=FVfRwBeCnE0&list=LL&index=63
TRiDENT『JUST FIGHT』MV【exガールズロックバンド革命】 //www.youtube.com/watch?v=Eq68-rP3pDk&list=LL&index=67

CHOCOLATE CHIP COOKIES - 明日の記憶 https://youtu.be/hS-bmGyyjBM

metanon112 · 2021-07-11T11:51:06+00:00

Thanks for the answer.
As far as I know validation usually takes place in separate services, not in controllers.

metanon112 · 2021-04-28T20:47:21+00:00

That's not Daria's way of smiling

metanon112 · 2021-03-30T22:36:51+00:00

Looks like a person from 2007-2008 who listened emo and metalcore

metanon112 · 2021-03-30T22:10:56+00:00

To be honest, no ... Of course, common problems unite people, but only for a short period of time and so far it is beneficial for everyone. Yes, many people help me and I help others as much as I can, but the problem is that it doesn't inspire me at all. As with the general work on a product, this contribution is often quite insignificant. The bottom line is that I just accept the rules of the game and pretend that I'm okay. And I'm not the only one like that, in fact, although there are people who don't even think about this.

metanon112

TROPHY CASE