[SailfishDevel] Persistent storage

[Thomas Perl]

On Jun 19, 2013, at 10:53 PM, Markus Svensson <markus.svensson at me.com> wrote:
> Does anyone know where the emulator stores the SQLite databases? I would like to inspect it manually for debugging purposes, but have not managed to find it yet (by logging into the emulator from the command line and poking around).

From https://qt-project.org/doc/qt-4.8/qdeclarativeglobalobject.html:

"These databases are user-specific and QML-specific, but accessible to all QML applications. They are stored in the Databases subdirectory of QDeclarativeEngine::offlineStoragePath(), currently as SQLite databases."

https://qt-project.org/doc/qt-4.8/qdeclarativeengine.html#offlineStoragePath-prop

~% python
Python 2.7.3 (default, Feb 10 2013, 17:47:44)
[GCC 4.6.4 20120731 (Mer 4.6.4-1)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> from PySide.QtCore import QCoreApplication
>>> from PySide.QtDeclarative import QDeclarativeEngine
>>> app = QCoreApplication([])
>>> engine = QDeclarativeEngine()
>>> engine.offlineStoragePath()
u'/home/nemo/.local/share/data///QML/OfflineStorage'

HTH :)
Thomas

> 30 maj 2013 kl. 21:04 skrev Markus Svensson <markus.svensson at me.com>:
> 
>> Cool - thanks!
>> 
>> 30 maj 2013 kl. 19:56 skrev Erlend Böe <erlendboe at yahoo.com>:
>> 
>>> Hei Markus,
>>> 
>>> It is already included in the simulator.
>>> All I had to do was to add
>>> QT+=sql to the qmake project file.
>>> Erlend 
>>> 
>>> Sent from my Jolla ;-)
>>> 
>>> On 29.05.2013, at 22:23, Joseph Crowell <joseph.w.crowell at gmail.com> wrote:
>>> 
>>>> SQLite is in use on a wide range of applications. I would assume it would be bundled on the device along with the other core Qt plugins.
>>>> 
>>>> On 5/30/2013 6:18 AM, Markus Svensson wrote:
>>>>> Hi Chris,
>>>>> 
>>>>> Thank you for your reply.
>>>>> 
>>>>> I believe QT Quick uses SQLite under the hood as well, but I have not had to add any extra packages so far. But then I haven't gotten very far with my app yet...
>>>>> 
>>>>> Is it known if SQLite will be available on production devices, or will each app have to bundle it separately?
>>>>> 
>>>>> Thanks!
>>>>> 
>>>>> Skickat från min iPhone
>>>>> 
>>>>> 29 maj 2013 kl. 21:31 skrev christopher.lamb at thurweb.ch:
>>>>> 
>>>>>> Hi Markus
>>>>>> 
>>>>>> SQLite works for me, but you need to install the packages to the SDK and Emulator first.
>>>>>> 
>>>>>> Grüsse
>>>>>> 
>>>>>> Chris
>>>>>> 
>>>>>> Zitat von "Markus Svensson" <markus.svensson at me.com>:
>>>>>> 
>>>>>>> Hi,
>>>>>>> 
>>>>>>> What is the preferred way of doing persistent database type storage in a Sailfish OS application? I'm thinking of using QT Quick's Offline Storage API - will this work, or is there a better way?
>>>>>>> 
>>>>>>> Thanks!
>>>>>>> 
>>>>>>> Regards,
>>>>>>> Markus
>>>>>>> _______________________________________________
>>>>>>> SailfishOS.org Devel mailing list
>>>>> _______________________________________________
>>>>> SailfishOS.org Devel mailing list
>>>> 
>>>> _______________________________________________
>>>> SailfishOS.org Devel mailing list
>>> _______________________________________________
>>> SailfishOS.org Devel mailing list
>> _______________________________________________
>> SailfishOS.org Devel mailing list
> _______________________________________________
> SailfishOS.org Devel mailing list