[SailfishDevel] Persistent storage

[christopher.lamb at thurweb.ch]

Hi Erlend

I am slightly confused: Is there any difference between the QtQuick  
Offline Storage API / Database API, and SQLite?

My Harmattan app makes use of an SQLite database to store settings. I  
am fairly sure that I did not have to install anything on to Harmattan  
Simulator, Emulator or physical device (N9). Nor did I have to add  
anything to the .pro file.

When I started porting this app to Sailfish, the app would start, but  
the database access did not work.

Then I installed sqlite-devel to the SDK via the SDK Control Center,  
and sqlite-devel to the Emulator by means of zypper in.

After this the DB access magically worked. I made no change to my  
Sailfish .pro file.

So what is the difference between the technique you suggest, and the  
one I found?

Grüsse

Chris





Zitat von "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