[Leaplist] Data base programs
Chris
Chris at NeptunePCTech.com
Tue Jul 10 17:57:20 EDT 2007
John Hayden wrote:
>Hi all I have read with interest many things here, but now need advice. I
>am looking for a data base inventory program I can use to inventory things
>in a ware house, and I need to be able to add/subtract items on the data
>list as well as configure what information will be displayed by the data
>base. Any help would be great.
>
>
>
J.T. - the program is a dead cinch - PostGreSQL. But that only
gets you a database - it doesn't get you an inventory system.
(Some will argue for MySQL - I can't see any advantage to
MySQL for your purposes. It's a little lighter and faster, which
matters when your web-site is getting a zillion hits a minute,
but you have a low speed, high integrity need that PostGreSQL
addresses better.)
There are probably inventory systems available that can use
a variety of database engines, but one size rarely fits all. You'll
either find something missing that you need, or features like
product aging, or aggregate breakdowns that get in the way of
what you need.
By the time you get through marginally configuring an "off-
the-rack" system, you may find, if your needs are not complex,
that you might have been better off just writing a simple
interface in something like wxPython and getting exactly
what you want.
Cheers,
Chris
More information about the Leaplist
mailing list