[Interest] SQLite

[Jason H]

There used to be an ORM for Qt that was promoted on this list. http://lmgtfy.com/?q=qt+orm

Aside from that, I don't use ORMs, and I just have a general "settings" table of key value pairs one of which is the schema version. However you must write your own upgrade routine. When dealing with postgres, I use a utility called appgdiff http://apgdiff.com/ It might work for SQLite, but it only does schemas. 


> Sent: Wednesday, May 27, 2015 at 3:39 AM
> From: "Graham Labdon" <Graham.Labdon at avalonsciences.com>
> To: "Interest at qt-project.org" <Interest at qt-project.org>
> Subject: [Interest] SQLite
>
> Hi
> I am planning to use a SQLite database in my application to store application data.
> The application is large and complex so we are taking a phased delivery approach. This will mean that the structure of the database will change over time and that we need to provide backwards compatibility.
> So, what I need is some way to create a versioning system and a way of converting old format databases to the current format.
> I would be grateful if anyone could suggest a good approach to this
> 
> Thanks
> _______________________________________________
> Interest mailing list
> Interest at qt-project.org
> http://lists.qt-project.org/mailman/listinfo/interest
>