[SailfishDevel] Persistent storage

[christopher.lamb at thurweb.ch]

Hi Markus

http://flyingsheeponsailfish.blogspot.ch/2013/06/where-is-my-sqlite-db-on-sailfish.html

Chris

Zitat von "Markus Svensson" <markus.svensson at me.com>:

> Thank you, Thomas. I probably should read the docs more closely. :)
>
> Regards,
> Markus
>
> 20 jun 2013 kl. 00:27 skrev Thomas Perl <th.perl at gmail.com>:
>
>> 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
>>
> _______________________________________________
> SailfishOS.org Devel mailing list