Sadly there is still no alternative to Notion (itβs not a note taking app, itβs database). Only SiYuan is somewhat close to Notion in its database capabilities, but comes with its own set of issues.
I would absolutely love to self-host real Notion alternative!
There's I sadly not a motion alternative. As the person you answered to said: notion is a fancy frontend nosql database. I'm forced to use it at work and have to admit it's need three Foss tools to handle everything my employer does with notion (documentation, task management and planning, client collaboration, project coordination, budget planning, they use the full scope).
I'd still prefer docmost (thanks btw! Didn't know it beforehand).
No sell though for the full transfer.
And they is even without the "I need someone to shout at when something goes wrong" aspect the corporate world enjoys about "SAAS" (service my as, you just don't allow me to install it myself).
My bad, I missed the part about the database. But at this point, what you're looking for is probably not an alternative to Notion, but rather an alternative to Airtable, an actual no-SQL, no-code database. Fortunately there is great FOSS & self-hostable alternative to Airtable: NocoDB