ORM for Qt

[victorzhuk]

if you need litle demo I can quick create it for you ;)

bq. Do you mean it’s slower? or it has same Qt performance?

library use only qt`s mechanisms, no boost or custom macros...and when I use it performance was the same

it`s will be great if my lib help anybody. wait for a sec, I post demo

[victorzhuk]

http://rapidshare.com/files/549905365/EOrmDemo.tar.gz please

[mbnoimi]

[quote author="victorzhuk" date="1368314480"]http://rapidshare.com/files/549905365/EOrmDemo.tar.gz please[/quote]

It's not working!!! use another sharing website please (try one.ubuntu.com)
[quote]
The download for this file has not been enabled. Only the user who uploaded it, can enable the download option.
[/quote]

[victorzhuk]

here it is http://ubuntuone.com/5wimYZQnJJlcQCBo5pDpS6

[victorzhuk]

For demo success working you should compile EOrm and add .so(.dll) and *.h files to EOrmDemo project (just replace paths in *.pro file)

[mbnoimi]

[quote author="victorzhuk" date="1368314994"]here it is http://ubuntuone.com/5wimYZQnJJlcQCBo5pDpS6[/quote]

Thanks, I successfully run the example :) it's quite easy to understand... I think eorm's performance should be as Qt's model.

Any way, I've to test it in heavy and excessive usage then compare it with the above libraries in addition to Qt standard model, this may take some time because I'm busy these days.

Do you want to share with me these tests?

I want to test:

• eorm
• QDjango
• Standard Qt model

[mbnoimi]

until that date, could you please add some exmpales to your Git repository instead of this quick example?

[victorzhuk]

sure :) how can I help you? what tests?

[mbnoimi]

[quote author="victorzhuk" date="1368317045"]sure :) how can I help you? what tests?[/quote]

I'm planning to apply some complicated queries with millions of records on stable database server (ex. MySQL or Postgresql)

[victorzhuk]

lets try :) about examples - I find a time and upload some in git, with find,model,create,delete etc.. hope its help somebody

[mbnoimi]

[quote author="victorzhuk" date="1368317891"]lets try :) about examples - I find a time and upload some in git, with find,model,create,delete etc.. hope its help somebody[/quote]

Thanks... this will ease comparing process.

[mbnoimi]

Guys, I found this library which may works too. I'll add it for performance comparison.
https://sourceforge.net/projects/qtpersistence/?source=directory

[mbnoimi]

Until now I'm planning to test:

• eorm: https://github.com/victorzhuk/eorm
• QDjango: https://code.google.com/p/qdjango/
• QsT SQL Tools: https://sourceforge.net/projects/qstsqltools/?source=directory
• QtPersistence: https://sourceforge.net/projects/qtpersistence/?source=directory
• Standard Qt model

I'm still looking for others...

[Skh1002]

Hi mbnoimi,

I wonder how your testing is going on. I am facing a similar problem, and I am undecided between ODB, QxOrm, and QDjango. For me, licensing is less of an issue, but performance and features are.

[mbnoimi]

The Best performance was for QDjango, QxOrm and Standard Qt model. All three techniques gave same result in many cases but QxOrm is the best from features prespactive while QDjango is the best from simplicity and rapid usage.

Personally I use QDjango because it fits my needs while I left QxOrm becasue of license issue (actually it's heavy by comparing to QDjango)

[Skh1002]

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?
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?

[mbnoimi]

[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]

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]

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

[Skh1002]

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.