ORM for Qt

victorzhuk · wrote on 11 May 2013, 21:53

maybe my orm desision will be helpfull ;) https://github.com/victorzhuk/eorm

mbnoimi · wrote on 11 May 2013, 22:01

[quote author="victorzhuk" date="1368309226"]maybe my orm desision will be healfull ;) https://github.com/victorzhuk/eorm[/quote]

Is there any example or demo using it?
Does the performance is quick as Qt's model or it's a slower a little bit (I'm not sure what if I used the loops instead of Qt's model the performance will be same as Qt)?

victorzhuk · wrote on 11 May 2013, 22:12

examples are placed in documentation, use Doxygen to compose html docs. I can help if you don`t know how
I think yes, but I don`t have chance to check this - I create this lib for personal use, and if you have any test results and ideas I can impove it :)

ps: sory for my english :)

mbnoimi · wrote on 11 May 2013, 22:19

[quote author="victorzhuk" date="1368310323"]examples are placed in documentation, use Doxygen to compose html docs. I can help if you don`t know how[/quote]

Oops I don't want to build the project manually... I just ask you for tiny example :)

[quote]I think yes, but I don`t have chance to check this - I create this lib for personal use, and if you have any test results and ideas I can impove it :)[/quote]

Do you mean it's slower? or it has same Qt performance?

victorzhuk · wrote on 11 May 2013, 22:25

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 · wrote on 11 May 2013, 23:21

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

mbnoimi · wrote on 11 May 2013, 23:23

[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 · wrote on 11 May 2013, 23:29

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

victorzhuk · wrote on 11 May 2013, 23:36

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 · wrote on 11 May 2013, 23:50

[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 · wrote on 11 May 2013, 23:55

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

victorzhuk · wrote on 12 May 2013, 00:04

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

mbnoimi · wrote on 12 May 2013, 00:12

[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 · wrote on 12 May 2013, 00:18

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

mbnoimi · wrote on 12 May 2013, 00:22

[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 · wrote on 27 May 2013, 03:55

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

mbnoimi · wrote on 27 May 2013, 04:07

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 · wrote on 11 Jul 2013, 21:30

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 · wrote on 11 Jul 2013, 21:51

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 · wrote on 11 Jul 2013, 22:16

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?