ORM for Qt

mbnoimi · wrote on 11 Jul 2013, 22:31

[quote author="Skh1002" date="1373580970"]I am leaning towards QDjango as well, but there are still a few questions left, one of which is about relationships. QxOrm supports them, but I guess I have to implement it myself with QDjango. Do you have experience maintaing relationships with QDjango? [/quote]
I'm just like you I'm still working on it and I don't know how to connect to relationships with QDjango

bq. Also, I noticed that QDjango uses API deprecated in Qt5 (I had to specifically enable it to build the lib). Does this bother you at all?

Which version you're using? I use 0.4 which works in Qt5

P.S. for more info you can join to "QDjango mailing list":http://groups.google.com/group/qdjango

Skh1002 · wrote on 11 Jul 2013, 22:58

I have the same version as you, but in Qt5.1 (with which I compiled it) some of the now deprecated API QDjango uses are removed by default. I don't know in which version of Qt this started. I had to insert something like
@
DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x040800
@
somewhere in qdjango.pri to compile it properly.

mbnoimi · wrote on 11 Jul 2013, 23:08

Me too, but that didn't stops me to use it because it suppose to work for Qt4 and Qt5.

Skh1002 · wrote on 12 Jul 2013, 16:02

I have just looked into the test suite bundled with QDjango and there are cases for one-to-many and many-to-many relationships. So, apparently, there is support of such relationships. I will give it a spin to see how convenient it is compared to pure Qt.

Skh1002 · wrote on 15 Jul 2013, 22:24

It appears that there is no relationship support in QDjango, after all. You can only emulate relationships with query sets on foreign keys. Further on, to create a many-to-many relationship between two entities, one must create a third one (equivalent to a separate foreign key table) and then filter query sets based upon that third entity. That's all very much doable, but basically amounts to hand-coding all of relationship management.

QxOrm does provide relationship support, so it may be more convenient to use if you need to maintain many relationships and/or fiddle with them a lot. I think I am still going to try QDjango first and fall back on QxOrm if it does not work out.

Please, let me know of your experience with QDjango. I will post my impressions after I play with it.

qxorm · wrote on 14 Dec 2013, 12:15

Hi,

I'm the developer of QxOrm library.
FYI, we have released QxEntityEditor to make easier to work with QxOrm library : now, you can design your data model in few minutes and generate quickly a Qt/C++ project (and the SQL database associated).
More details here : "http://qt-project.org/forums/viewthread/35932/":http://qt-project.org/forums/viewthread/35932/

mbnoimi · wrote on 22 Dec 2015, 12:02

After years of this post, Qt still without a practical open source ORM :(

The only reliable option is QxOrm which is useless without QxEntityEditor because it's complicated without it but QxEntityEditor is commercial product so I'm still using the old way with Qt.

Cheers

michalos · wrote on 31 Jan 2018, 10:11

If anyone is still interested, ORM-Qt is on a MIT license.
https://github.com/victorzhuk/orm-qt

ElSampsa · wrote on 10 Apr 2018, 10:36

Hi,

Here are my five bucks:

https://github.com/elsampsa/cute_mongo_forms

(it's in PyQt)

SeDi · wrote on 11 Apr 2018, 13:42

I am using
https://github.com/Professi/cuteentitymanager

mwallnoefer · wrote on 1 May 2020, 16:27

I have found Nut https://marketplace.qt.io/collections/all-products/products/nut resp. https://github.com/HamedMasafi/Nut which results actively maintained.

Not sure if the one mentioned in the previous post (CuteEntityManager, https://github.com/Professi/cuteentitymanager) is still alive...

Al79 · wrote on 16 May 2022, 07:55

Hi there,

2022 here... still no integrated ORM in Qt?