OSSN Database - Consistency, Performance - Some Questions about it

Adrian Räuchle Posted in General Discussion 7 years ago

Hey guys.

In ossn the original Database works with MyISAM tables without FOREIGN Keys.
I was wondering what was the minor reason to go without it, because in this way the database has no real consistency and might have inconsistent datasets in its tables.
So i was wondering if theres a way to cope with it or if i can change it in my database to work with foreign keys to make it more stable.

How are you doing it? :)

Replies
German Adrian Räuchle Replied 7 years ago

Hey Zet Man.
This is just a theoretic thing i was thinking about. That a database it is more like that a database corrupt without Foreign keys.

I have not faced any real issues atm :)
I was just wondering why ossn has decided to go without them :) So i wanted to start a little discussion about it.

German Michael Zülsdorff Replied 7 years ago

> ... the database has no real consistency ...

What consistency issues are you experiencing exactly? Please provide some more background like
action in community -> resulting corruption in table(s)

Slovak Ondrej Janicko Replied 7 years ago

You may use InnoDB store engine as well instead of MyISAM. I tested this scenario and it works.

Please, do not forgot publish you code for redirecting after first login as you promissed here https://www.opensource-socialnetwork.org/discussion/view/2502/prevent-user-from-navigating-away-from-page