PDA

View Full Version : Database


Jimmy_r
March 18th, 2006, 08:56 AM
I'm thinking about writing a program for handling sales/cash registers/orders etc. I will probably write it in python and/or C++.
Can anyone point me to a good database for handling the product data(Barcodes/names/prices/stock etc)?

Also, i will probably use qt for the gui(for C++ and a good IDE/GUI builder). Any input on this?
Although the software will be licensed under the GPL, if i manage to get it working quite good, there might be some small local companies willing to buy it(in fact it will be eventual modifications/adaptions/installations/support they will actually be paying for as the software will be open source).
As I understand it, the open source version of qt4 allows me to sell software made with it(without paying trolltech), both to X11, mac and windows users, as long as the software is open source. Is that correct?

thumper
March 19th, 2006, 05:01 AM
The good thing about PostgreSQL is its licence - you can pretty much do what you want with respect to selling a product that uses it.

It also (apparently) has C++ classes for talking to it.

LordHunter317
March 19th, 2006, 09:40 AM
If the application is meant to be freestanding, Firebird or SQllite are embedded. The former likely being preferred over the latter at least from a DB POV.

Jimmy_r
March 20th, 2006, 01:34 PM
Thanks for the suggestions. Now the only question is if i will ever muster up enough courage to get this started... Oh, well, even if it turns out crap, it will at least give some experience... :D

mlind
March 20th, 2006, 04:02 PM
I'd go for postgreSQL too. You should check HypersonicSQL too, it's what OpenOffice
uses as its backend. HypersonicSQL offers useful in-memory database too, which
is useful for testing environment.