Support for SQLite

[kseistrup]

Please consider support for SQLite (or ODBC/DBI) so that the app can run with something else than PostgreSQL.

Thanks!

[navigator8]

I second this. - as I would like to run the TopicDB Library on mobile using an app like Pythonista to create a personal knowledge graph.

I recall - you used to a NoteMapper app on Google store.

Get Outlook for iOShttps://aka.ms/o0ukef

---

From: Klaus Alexander Seistrup notifications@github.com Sent: Monday, May 11, 2020 8:44:04 AM To: brettkromkamp/contextualise contextualise@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: [brettkromkamp/contextualise] Support for SQLite (#66)

Please consider support for SQLite (or ODBC/DBI) so that the app can run with something else than PostgreSQL.

Thanks!

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/brettkromkamp/contextualise/issues/66, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABZW4U6RHD64WSFS2MIHGW3RQ4GZJANCNFSM4M5MUA5A.

[brettkromkamp]

@navigator8 Yes, I had an Android app called NotesMappr on the Play Store. Blast from the past... must be close to 9-10 years ago, now.

With regards to a SQLite-based topic maps engine, it wouldn’t be too difficult to port TopicDB. I could get the ball rolling...

[navigator8]

🙂 I actually bought a cheap android device to test how NoteMapper works. I could not find and still cannot find TopicMaps/Graph based apps on ios.

---

From: Brett Alistair Kromkamp notifications@github.com Sent: Monday, 11 May 2020 7:29 AM To: brettkromkamp/contextualise contextualise@noreply.github.com Cc: Farayi Chambati flchambati@hotmail.com; Mention mention@noreply.github.com Subject: Re: [brettkromkamp/contextualise] Support for SQLite (#66)

@navigator8https://github.com/navigator8 Yes, I had an Android app called NotesMappr on the Play Store. Blast from the past... must be close to 9-10 years ago, now.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/brettkromkamp/contextualise/issues/66#issuecomment-626392581, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABZW4U2IFZBVPGRQLQTCIKDRQ4MEJANCNFSM4M5MUA5A.

[brettkromkamp]

@kseistrup Why wouldn’t you just use the application at https://contextualise.dev/? Or, do you want to run it locally so as to not have to depend on having internet access?

[kseistrup]

@brettkromkamp Yes, I intended to self-host the app.

[brettkromkamp]

@kseistrup Contextualise can be run with Docker. Have you given that a try?

[kseistrup]

@brettkromkamp I can't say that I have (I'm not a big fan of dockerizing everything). But even if it ran in Docker I would still have to deal with PostgreSQL, wouldn't I? That's what I would like to avoid.

[brettkromkamp]

@kseistrup You wouldn't really have to deal with PostgreSQL, no. Docker Compose allows for defining and running multi-container Docker applications. In the case of Contextualise, the docker-compose.yml has configured the PostgreSQL container and how it interacts with the rest of the application for you. Running Contextualise in Docker will set up everything including Contextualise's dependencies (like PostgreSQL).

[kseistrup]

@brettkromkamp I know that I am an old geezer and an outlier, but that doesn't sound appealing to me at all. Before even considering dockerizing everything, I would look for alternatives to Contextualise.

You shouldn't spend your valuable time on me. I will certainly love to see this issue closed and have Contextualise run with SQLite, but it's also too easy for me to suggest such a change because I don't know the inner workings of Contextualise and have no idea how much work will be involved. But I also don't want you to squander your resources.

[brettkromkamp]

@kseistrup No worries. You are definitely not squandering my resources. I would just like for you to be able to self-host the app and Docker allows for that. With regards to a SQLite version of TopicDB and by extension Contextualise, you are definitely not the first person to ask for something along those lines so I am considering how I would go about that. Obviously, this would take some time so I wouldn't want you to hold your breath :) But, I insist... you are not taking up any of my time and I will keep this issue open so that other people can see it and comment on it and we take things from there.

[kseistrup]

@brettkromkamp I'm glad to hear that. I won't hold my breath, but I will certainly keep an eye on the project. Thanks for your time so far, I really appreciate it.

[brettkromkamp]

@kseistrup Take a look here (if you haven't already) for a list of knowledge management applications that could be of interest for you: https://github.com/brettkromkamp/knowledge-graph-radar#applications. Several of them are open-source and I imagine can be self-hosted.

[kseistrup]

@brettkromkamp That's an impressive collection. Thanks a lot!

[brettkromkamp]

@kseistrup @navigator8

Contextualise and the underlying topic maps engine, TopicDB, have been migrated to SQLite. Self-hosting is the way forward. The plan is to remove the Contextualise web application hosted at https://contextualise.dev, soon. Check out the Contextualise README (https://github.com/brettkromkamp/contextualise) for instructions on how to install Contextualise on your own machine (Python 3.7+ with Pip is required). If you encounter any issues, please let me know (i.e., create an issue: https://github.com/brettkromkamp/contextualise/issues).

[kseistrup]

Amazing!!