Results 1 to 4 of 4

Thread: Help me decide which ORDBMS should I use

  1. #1
    Join Date
    Dec 2014
    Location
    Cuba
    Posts
    4
    Qt products
    Qt4 Qt5
    Platforms
    Windows Android

    Default Help me decide which ORDBMS should I use

    Hi I’m working in this project by myself and I got stuck when I had to choose the ORDBMS. I have to develop an app for managing Requests for Payment Instrument (RPI), this doc is used to generate paychecks for paying bills in my company. The users that will use my app are stored in a LDAP server, so I only have to assign them roles in my database. I had planned to use MySQL as the ORDBMS but I found that in the community server, one can’t create roles. So I do some digging and found that PostgreSQL does have this feature.
    Right now I can only choose between MySQL 5.5 y PostgreSQL 8.4.9, both services are running on Centos 5.8. Would you please help me decide what service should I use for my app? For now my app will be deployed for windows, XP mostly.
    I had never used Postgre so I would have to start learning how to work with it, no problem but I will still appreciate any feedback since this is my first time developing a large project.
    I apologize if my English writing isn’t the best. I’m from Cuba, so this is not my native language.

  2. #2
    Join Date
    Dec 2009
    Location
    New Orleans, Louisiana
    Posts
    791
    Thanks
    13
    Thanked 153 Times in 150 Posts
    Qt products
    Qt5
    Platforms
    MacOS X

    Default Re: Help me decide which ORDBMS should I use

    Quote Originally Posted by batman View Post
    I had planned to use MySQL as the ORDBMS but I found that in the community server, one can’t create roles. So I do some digging and found that PostgreSQL does have this feature.
    Both are capable RDBMS systems. Since your users are in an LDAP directory, can you use LDAP group membership to map to your user's role(s)? When the user logs in for example, you could determine his/her role based on LDAP group membership and then your app checks the users' role to hide or disable functionality that is not applicable for their role, etc?

    It would be best IMHO to leave the user role out of the RDBMS...

  3. #3
    Join Date
    Mar 2008
    Location
    Kraków, Poland
    Posts
    1,521
    Thanked 278 Times in 273 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Help me decide which ORDBMS should I use

    PostgreSQL because it has a decent transaction system.
    Last edited by Lesiok; 31st December 2014 at 09:28.

  4. #4
    Join Date
    Dec 2014
    Location
    Cuba
    Posts
    4
    Qt products
    Qt4 Qt5
    Platforms
    Windows Android

    Default Help me decide which ORDBMS should I use

    I did some digging and found I can use an LDAP authentication in PostgreSQL 8.4. To do so I only have to put the users that are allowed in my app to this ORDBMS. It all fits now, I will use PostgreSQL 8.4 as my database server.
    Last edited by batman; 5th January 2015 at 21:23. Reason: reformatted to look better

Similar Threads

  1. Replies: 0
    Last Post: 11th February 2014, 18:42
  2. How to decide whether to make a separate class for widgets of a window?
    By TheIndependentAquarius in forum Qt Programming
    Replies: 4
    Last Post: 15th February 2012, 08:51
  3. Decide the arrow graphics item's docking point
    By sajis997 in forum Qt Programming
    Replies: 3
    Last Post: 16th January 2012, 23:46
  4. How to decide which SIGNAL to emit?
    By TheIndependentAquarius in forum Qt Programming
    Replies: 2
    Last Post: 22nd November 2011, 16:09

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.