Hi @Ben-Lubar .
No matter what I do, I can't bring up the converted forum generated by nodebb-postgres-converter.
Honestly I am not sure what to do next... Any idea what I should check?
@stevefan1999-personal That's very very cool I'm sure there are many out there who would want to have NodeBB run on
Call me a rebel if you will but I eschew products that sold out to the dark side. Especially anything Larry has his hands in.
Side Bar: For those into MySQL'esque rdbms, Percona XtraDB Cluster is pretty sweet.
I've just finished writing code that enables the use of SQlite3 with NodeBB. It passes the test suite and seems to work pretty well. Made the necessary change to nodebb-plugin-dbsearch too. Will a pull request be considered or is SQLite support too obscure?
Well, SQlite and MySQL are similar in many ways... so theoretically, yes.
The problem isn't whether it is possible but whether the implementation is performant. We've built NodeBB around the concept of NoSQL data structures, specifically, those found in Redis (e.g. hashes, sorted sets, and to a much lesser degree, simple sets).
SQL can mimic these structures, yes. However the power of a relational database is that the schema is defined beforehand, and indexed for speed. NoSQL kind of threw that out the window, and if someone came up to us and asked us for a database schema, we'd just throw up our hands and
So whatever SQL implementation is added, it needs to take into account our need to be able to create sorted sets on-the-fly.
What that looks like in reality (and what the pgsql driver does)... is use god tables; one giant table for every sorted set in NodeBB. That is technically an anti-pattern, but it does work.
Okay, I'll send a pull request.
Yes, this is what I was afraid of... there are certain concessions that need to be made for an SQL driver when you build your software around the expectation of a schema-less data store
Nevertheless, I am looking forward to reviewing.