search

KnowledgeGarden / lite-net-3

lite-net as a web app with authentication and privacy; simplest-possible note taking app for network and non-linear thinking.
Apache License 2.0
12 stars 0 forks source link

Go ahead and experiment with migration to SQLite or similar #17

Open KnowledgeGarden opened 4 years ago

KnowledgeGarden commented 4 years ago

Right now, the platform, as a prototype, will not scale; it's running on NeDB, a simple local version of Mongo; it cannot do full text search even though the instructions suggest that's possible. SQLite is used in a number of similar projects such as Zotero, and appears easy to drop in there. That requires a bootstrap function which maps the old NeDB JSON files to SQLite tables.

In a sense, this is a prelude to other backsides for future work.

KnowledgeGarden commented 4 years ago

https://www.sqlitetutorial.net/sqlite-nodejs/

KnowledgeGarden commented 4 years ago

https://www.sqlite.org/lang.html no joins. Wonder what other sql db besides e.g. postgres is around. Do we need joins?

KnowledgeGarden commented 4 years ago

https://www.sqlitetutorial.net/sqlite-full-text-search/

KnowledgeGarden commented 4 years ago

https://www.npmjs.com/package/sqlite3 and see also https://coolaj86.com/articles/building-sqlcipher-for-node-js-on-raspberry-pi-2/

KnowledgeGarden commented 4 years ago

Started on this one today.

KnowledgeGarden commented 4 years ago

Have a driver shelled in. It compiles and runs. This task must be completed before being able to easily delete a journal entry, which can require a lot of surgery if it has wikilinks.