Backup/export in SQLite vs JSON

[econo202]

I've recent noticed that there are 2 different data formats used to backup notes depending on which Omni Notes version is used:

• Omni Notes "standard" only saves data using SQLite file.
• Omni Notes Alpha saves all notes as separate JSON files.

Are there any plans to implement JSON backups in ON "standard" and to add automatic backup option, which is currently present in ON Alpha?

[federicoiosue]

You perfectly got the point!

This feature will be also used (I actually use it on my own build but it still needs to be tested deeply) to sync notes between devices and desktop, where I use the Omni Notes Desktop crossplatform application.

[dapgo]

is the plan to replace sqlite by json for backup? what about support both formats? would the app keep using sqlite internally?

I like the current support for backup in a sqlite file. In fact, I managed to move my previous notes from another app to Omni-notes using an SQL script..

[federicoiosue]

@dapgo replacing is the objective. Actually performing a backup just by copying the database is not that much secure and needs a lot of processing to keep database format aligned with latest app version.

Moving to JSON would help both to be fully compatible with the desktop application and to manage in a more object-oriented way the backup/restore operations.

[federicoiosue]

This version already works like that (really outdated but it helps to better understand, and works aside of the normal app): https://play.google.com/store/apps/details?id=it.feio.android.omninotes.alpha

[dapgo]

I understand that when JSON support is ready, Omni-notes automatically will convert the information in sqlite to JSON, so no worries for end-users. Am I right?

[federicoiosue]

Exactly, everything will be transparent to the users. The only drawback is that older backup will be no more compatible, inevitably