We have moved to a new Sailfish OS Forum. Please start new discussions there.

Revision history [back]

click to hide/show revision 1
initial version

posted 2014-11-28 13:54:10 +0200

Resetting user databases

Hi,

Several of the databases on my Jolla are in a complete mess, and I'd like to reset them and repopulate them from my various synced accounts (which I'll also have to clean up). I could do a factory reset, but I don't want to lose absolutely everything, and I'd also like to be able to tackle each item one at a time.

I've had a poke around in /home/nemo/ but haven't managed to find the relevant files yet. So can anyone tell me where to find these databases and how to reset them, if they can't regenerate themselves after a delete.

I'd like to clear out:

  • Contacts database
  • Calendars
  • Feed items (I have months old tweets lingering at the end of the list)

Resetting user databases

Hi,

Several of the databases on my Jolla are in a complete mess, and I'd like to reset them and repopulate them from my various synced accounts (which I'll also have to clean up). I could do a factory reset, but I don't want to lose absolutely everything, and I'd also like to be able to tackle each item one at a time.

I've had a poke around in /home/nemo/ but haven't managed to find the relevant files yet. So can anyone tell me where to find these databases and how to reset them, if they can't regenerate themselves after a delete.

I'd like to clear out:

  • Contacts database

Everything seem to be in /home/nemo/.local/share/system/Contacts/qtcontacts-sqlite. I've tried removing this and rebooting, but that doesn't seem to be clearing the db. Maybe there's a service I need to stop that's writing the db out on reboot? Also in /Contacts are folders of images. Clearing those out might get rid of lingering avatars.

  • Calendars
  • Feed items (I have months old tweets lingering at the end of the list)

Resetting user databases

Hi,

Several of the If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases on my Jolla are in a complete mess, and I'd mess. Deleting things like to reset them and repopulate them contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my various synced accounts (which I'll also have to clean up). I could do a factory reset, but I don't want to lose absolutely everything, and I'd also like tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be able to tackle each item one at a time.

root to access that directory and delete the files. I've had a poke around in /home/nemo/ but haven't managed to find the relevant files yet. So can anyone tell me where to find these databases and how to reset them, if they can't regenerate themselves been rebooting after a delete.

I'd like to clear out:

  • Contacts database

Everything seem to be in /home/nemo/.local/share/system/Contacts/qtcontacts-sqlite. I've tried removing this and rebooting, deleting, but that doesn't seem to might not be clearing the db. Maybe there's necessary.

Stuff I've reset so far:

  • Contacts

Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a service I need to stop that's writing the lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet.

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db out in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on reboot? Also in /Contacts are folders of images. Clearing those out might get rid of lingering avatars.next sync. I had disabled Exchange calendar sync before I removed the mkcal files, and the calendar re-appeared when I re-enabled it, so you may have to do that.

    • Calendars
    • Feed items (I have

      Social Posts

      I had months old tweets lingering at the end of the list)in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

    • Map Locations

    • Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

Resetting user databases

If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases are in a complete mess. Deleting things like contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be root to access that directory and delete the files. I've been rebooting after deleting, but that might not be necessary.

Note that any data in these databases that is not synced from elsewhere, such as local calendars and contacts you have created on your Jolla but not synched elsewhere, will be lost if you do this. If you're not sure, make a backup of the files before you delete them, or just move them elsewhere.

Stuff I've reset so far:

  • Contacts

Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet.

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on next sync. I had disabled Exchange calendar sync before I removed the mkcal files, and the calendar re-appeared when I re-enabled it, so you may have to do that.

  • Social Posts

    I had months old tweets lingering in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

  • Map Locations

  • Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

Resetting user databases

If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases are in a complete mess. Deleting things like contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be root to access that directory and delete the files. I've been rebooting after deleting, but that might not be necessary.

Note that any data in these databases that is not synced from elsewhere, such as local calendars and contacts you have created on your Jolla but not synched elsewhere, will be lost if you do this. If you're not sure, make a backup of the files before you delete them, or just move them elsewhere.

Stuff I've reset so far:

  • Contacts

Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet.

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on next sync. I had disabled Exchange calendar sync before I removed the mkcal files, and the calendar re-appeared when I re-enabled it, so you may have to do that.

  • Social Posts

    I had months old tweets lingering in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

  • Map Locations

Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

Resetting user databases

If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases are in a complete mess. Deleting things like contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be root to access that directory and delete the files. I've been rebooting after deleting, but that might not be necessary.

Note that any data in these databases that is not synced from elsewhere, such as local calendars and contacts you have created on your Jolla but not synched elsewhere, will be lost if you do this. If you're not sure, make a backup of the files before you delete them, or just move them elsewhere.

Stuff I've reset so far:

  • Contacts

Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet.yet. Exchange won't sync with the new Contacts db until you remove `/home/nemo/.activesync/mfestorage.db

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on next sync. I had disabled Exchange calendar sync before I removed the mkcal files, and the calendar re-appeared when I re-enabled it, so you may have to do that.

  • Social Posts

    I had months old tweets lingering in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

  • Map Locations

Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

Resetting user databases

If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases are in a complete mess. Deleting things like contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be root to access that directory and delete the files. I've been rebooting after deleting, but that might not be necessary.

Note that any data in these databases that is not synced from elsewhere, such as local calendars and contacts you have created on your Jolla but not synched elsewhere, will be lost if you do this. If you're not sure, make a backup of the files before you delete them, or just move them elsewhere.

Stuff I've reset so far:

  • Contacts

Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet. Exchange won't sync with the new Contacts db until you remove `/home/nemo/.activesync/mfestorage.db/home/nemo/.activesync/mfestorage.db

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on next sync. I had disabled Exchange calendar sync before I removed the mkcal files, and the calendar re-appeared when I re-enabled it, so you may have to do that.

  • Social Posts

    I had months old tweets lingering in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

  • Map Locations

Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

HowTo: Resetting user databases

If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases are in a complete mess. Deleting things like contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be root to access that directory and delete the files. I've been rebooting after deleting, but that might not be necessary.

Note that any data in these databases that is not synced from elsewhere, such as local calendars and contacts you have created on your Jolla but not synched elsewhere, will be lost if you do this. If you're not sure, make a backup of the files before you delete them, or just move them elsewhere.

Stuff I've reset so far:

  • Contacts

Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet. Exchange won't sync with the new Contacts db until you remove /home/nemo/.activesync/mfestorage.db

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on next sync. I had disabled Exchange calendar sync before I removed the mkcal files, and the calendar re-appeared when I re-enabled it, so you may have to do that.

  • Social Posts

    I had months old tweets lingering in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

  • Map Locations

Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

HowTo: Resetting Reset user databases

If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases are in a complete mess. Deleting things like contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be root to access that directory and delete the files. I've been rebooting after deleting, but that might not be necessary.

Note that any data in these databases that is not synced from elsewhere, such as local calendars and contacts you have created on your Jolla but not synched elsewhere, will be lost if you do this. If you're not sure, make a backup of the files before you delete them, or just move them elsewhere.

Stuff I've reset so far:

  • Contacts

Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet. Exchange won't sync with the new Contacts db until you remove /home/nemo/.activesync/mfestorage.db

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on next sync. I had disabled Exchange calendar sync before I removed the mkcal files, and the calendar re-appeared when I re-enabled it, so you may have to do that.

  • Social Posts

    I had months old tweets lingering in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

  • Map Locations

Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

HowTo: Reset user databases

If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases are in a complete mess. Deleting things like contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be root to access that directory and delete the files. I've been rebooting after deleting, but that might not be necessary.

Note that any data in these databases that is not synced from elsewhere, such as local calendars and contacts you have created on your Jolla but not synched elsewhere, will be lost if you do this. If you're not sure, make a backup of the files before you delete them, or just move them elsewhere.

Stuff I've reset so far:

  • Contacts

    Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet. Exchange won't sync with the new Contacts db until you remove /home/nemo/.activesync/mfestorage.db

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on next sync. I had disabled Exchange If you delete the whole Calendar/mkcal directory, that will be recreated on boot too, and this seems to solve problems with the Jolla Calendar app not having permission to access the calendar sync before I removed the mkcal files, and the calendar re-appeared when I re-enabled it, so you may have to do that.files.

  • Social Posts

    I had months old tweets lingering in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

  • Map Locations

    Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

click to hide/show revision 11
No.11 Revision

HowTo: Reset user databases

If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases are in a complete mess. Deleting things like contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be root to access that directory and delete the files. I've been rebooting after deleting, but that might not be necessary.

Note that any data in these databases that is not synced from elsewhere, such as local calendars and contacts you have created on your Jolla but not synched elsewhere, will be lost if you do this. If you're not sure, make a backup of the files before you delete them, or just move them elsewhere.

Stuff I've reset so far:

  • Contacts

    Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet. Exchange won't sync with the new Contacts db until you remove /home/nemo/.activesync/mfestorage.db

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on next sync. If you delete the whole Calendar/mkcal directory, that will be recreated on boot too, and this seems to solve problems with the Jolla Calendar app not having permission to access the calendar files.

  • Social Posts

    I had months old tweets lingering in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

  • Map Locations

    Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

  • SMS and MMS

    Located in /home/nemo/.local/share/commhistory/.

click to hide/show revision 12
No.12 Revision

HowTo: Reset user databases

If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases are in a complete mess. Deleting things like contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be root to access that directory and delete the files. I've been rebooting after deleting, but that might not be necessary.

Note that any data in these databases that is not synced from elsewhere, such as local calendars and contacts you have created on your Jolla but not synched elsewhere, will be lost if you do this. If you're not sure, make a backup of the files before you delete them, or just move them elsewhere.

Stuff I've reset so far:

  • Contacts

    Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet. Exchange won't sync with the new Contacts db until you remove /home/nemo/.activesync/mfestorage.db

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on next sync. If you delete the whole Calendar/mkcal directory, that will be recreated on boot too, and this seems to solve problems with the Jolla Calendar app not having permission to access the calendar files.

  • Social Posts

    I had months old tweets lingering in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

  • Map Locations

    Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

  • SMS and MMS

    Located in /home/nemo/.local/share/commhistory/.

  • Notes

    Located in /home/nemo/.local/share/jolla-notes/QML/OfflineStorage/Databases/.

click to hide/show revision 13
No.13 Revision

HowTo: Reset user databases

If you've had your Jolla for a while, and have been syncing data with different data sources such as Facebook and Exchange, you might find that by now your databases are in a complete mess. Deleting things like contacts using the UI runs the risk of propagating those deletions elsewhere, so sometimes you just want to clear everything out and start from your synced data.

All this data is stored in /home/nemo/.local/share/system/privileged/, and in all my tests so far they all tolerate being deleted (or at least moved to an 'old' subdirectory). You need to be root to access that directory and delete the files. I've been rebooting after deleting, but that might not be necessary.

Note that any data in these databases that is not synced from elsewhere, such as local calendars and contacts you have created on your Jolla but not synched elsewhere, will be lost if you do this. If you're not sure, make a backup of the files before you delete them, or just move them elsewhere.

Stuff I've reset so far:

  • Contacts

    Stored in /home/nemo/.local/share/system/privileged/Contacts/qtcontacts-sqlite/ as an sqlite3 database. Remove and reboot to reset your address book. My original db file was 10MB, with many duplicated phone numbers in some contacts. The new file after sync is 16MB. The People app loads a lot faster now. There are also lots of avatar images cached in the /Contacts folder, but I haven't removed those yet. Exchange won't sync with the new Contacts db until you remove /home/nemo/.activesync/mfestorage.db

  • Calendars

    I found Caldav, Facebook and Google calendars in /home/nemo/.local/share/system/privileged/Calendars/ and another db in /home/nemo/.local/share/system/privileged/Calendar/mkcal. Remove and reboot, and the calendars will be recreated on next sync. If you delete the whole Calendar/mkcal directory, that will be recreated on boot too, and this seems to solve problems with the Jolla Calendar app not having permission to access the calendar files.

  • Social Posts

    I had months old tweets lingering in my Posts from when I recreated my twitter account. I found the db as /home/nemo/.local/share/system/privileged/Posts/twitter.db. After I deleted that and rebooted, the db was recreated and after a while new tweets started appearing. There's a facebook.db in there too.

  • Map Locations

    Located in /nemo/.local/share/system/privileged/Location. I haven't needed to reset this. No iphone/android style tracking data was found :D

  • SMS and MMS

    Located in /home/nemo/.local/share/commhistory/.

  • Sailfish Notes

    Located in /home/nemo/.local/share/jolla-notes/QML/OfflineStorage/Databases/.