Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Store notes file-based instead of room database #164

Open
jawsh207 opened this issue Dec 18, 2024 · 5 comments
Open

Store notes file-based instead of room database #164

jawsh207 opened this issue Dec 18, 2024 · 5 comments
Labels
enhancement New feature or request

Comments

@jawsh207
Copy link

Enabled the option to store data in "android>media>com.philkes.notallyx" so that I could sync between PC via Syncthing. However, I don't seem to be able to view anything regardless of the note program or app used on Debian and I've tried many. What format is being used here? Looked for an option to just store each individual note as a txt or MD but that does not seem possible either.

@ippocratis
Copy link

However, I don't seem to be able to view anything regardless of the note program or app used on Debian and I've tried many.

Exports and database exposure to a user defined location serve as backup strategies not multiplatform note usage

Syncthing is just one example of sync local files to a remote you could use anything to do that e.g. copy your notally backup to a flashdrive

@PhilKes
Copy link
Owner

PhilKes commented Dec 18, 2024

The notes are stored in a standard Android Room database, which is essentially a SQLite DB File.
As @ippocratis stated, moving the internal database in an externally available path allows to sync the database file to multiple Android devices.

Note: the other 2 files are just metadata for the database file

Obviously that means you cant really use the database file outside of the NotallyX app, except for a SQLite browser. Storing app data in a Room database is the default approach for android apps. Moving to a file-based storage of the notes, would be neat, but it would be a huge effort

@PhilKes PhilKes changed the title Sync support Store notes file-based instead of room database Dec 18, 2024
@jawsh207
Copy link
Author

The notes are stored in a standard Android Room database, which is essentially a SQLite DB File. As @ippocratis stated, moving the internal database in an externally available path allows to sync the database file to multiple Android devices.

Note: the other 2 files are just metadata for the database file

Obviously that means you cant really use the database file outside of the NotallyX app, except for a SQLite browser. Storing app data in a Room database is the default approach for android apps. Moving to a file-based storage of the notes, would be neat, but it would be a huge effort

Thanks to you both for answering. I agree this would be neat, I'll take your word it would be a huge effort as I have no knowledge on the matter. Previously used Nextcloud to sync notes, photos, my .kdbx database and random files. Got tired of connection/sync issues after any kind of update so switched to Syncthing and Baïkal for contacts & calendar. Note syncing is proving difficult without resorting to something like Standard Notes or Joplin.

@PhilKes PhilKes added the enhancement New feature or request label Dec 19, 2024
@PhilKes
Copy link
Owner

PhilKes commented Dec 19, 2024

Integration with a Room database is very easy, it offers built-in APIs that are very convenient. Over the versions there were quite a few changes to the data model of notes/lists, to convert all that into a standard format like Markdown would be tricky, even though not impossible. Especially saving certain metadata like labels, colors, pinned status, folder the note is in, would need some workarounds since they are unique NotallyX fields not present in e.g. a Markdown file.

I too would love to have an app I can use on my phone and my computer (Windows/Linux), and I thought about migrating the project to Compose Multiplatform to provide a desktop application as well, but its just a lot of effort needed for a freetime project for a single developer atm

If I have time in the new year I will maybe evaluate what options besides the sqlite database there are and if any of them could be feasible.

@vertigo220
Copy link

Agree this would be nice. I'd really like something that functions similar to Keep, where I can access my notes anywhere, but of course open-source/private and better functionality. I wonder if maybe it could be done via some sort of web app that could basically be a NotallyX emulator. Though I wonder how or even if multi way syncing would be managed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

4 participants