Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2007
    Posts
    1

    Question What Database server do you recommend for my point of sale software?

    I'm in the process of developing a Point of sale solution for independent retailers.

    This is, in essence, an integrated solution that has two elements: one or more tills and one backoffice system

    The backoffice portion of the software is being written in C++/MFC for Windows. Through this interface, the user adds products to the system and is given reports on sales and so forth.

    The till(s) run Linux and Qtopia.

    I'm trying to decide what database server I should use. So far, I've looked at MySQL, PostgresQL and firebird. They all seem to have there pros and cons. MySQL has a nice C++ API called MySQL++, but I'll have to spend a few hundred dollars on a commercial licence for each unit. Postgresql has the advantage of being free as in beer, and of having a BSD licence that won't force me to adopt the GPL, which I'd rather avoid doing, but it doesn't have great windows support and the API seems very complicated to me. Firebird doesn't seem very popular, which is probably indicative of its quality.

    Please advise.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Quote Originally Posted by sternocera
    I'm in the process of developing a Point of sale solution for independent retailers.

    This is, in essence, an integrated solution that has two elements: one or more tills and one backoffice system

    The backoffice portion of the software is being written in C++/MFC for Windows. Through this interface, the user adds products to the system and is given reports on sales and so forth.

    The till(s) run Linux and Qtopia.

    I'm trying to decide what database server I should use. So far, I've looked at MySQL, PostgresQL and firebird. They all seem to have there pros and cons. MySQL has a nice C++ API called MySQL++, but I'll have to spend a few hundred dollars on a commercial licence for each unit. Postgresql has the advantage of being free as in beer, and of having a BSD licence that won't force me to adopt the GPL, which I'd rather avoid doing, but it doesn't have great windows support and the API seems very complicated to me. Firebird doesn't seem very popular, which is probably indicative of its quality.

    Please advise.
    Granted, the Libpq.dll api is more difficult to work with. However, the Windows ODBC driver for PostgreSQL works fine - install it along with your client app.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Mar 2009
    Posts
    24
    Quote Originally Posted by sternocera
    Firebird doesn't seem very popular, which is probably indicative of its quality
    firebird is good database for your requirement

    Look at c++ drivers here : ibpp [www.ibpp.org]

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    I'd be willing to bet that if the OP (original poster) is still looking for a database after eighteen months, they have other more serious issues demanding their attention!

    -PatP

  5. #5
    Join Date
    Mar 2009
    Posts
    24
    Before posting, best way is to make google search before...
    So if it is not good for him : it can be good for another forum user

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •