[Leaplist] Data base programs

[John Kramer]

John,

PostgreSQL and mySQL are both rock solid databases and would work well for
you. If your db queries get very complicated, then you're better off with
PostgreSQL. I wrote a telecom biling app that ran on RH9 & postgresql for
over 400 days non-stop before they had to pull power - the only time I
received a problem call was when the app couldn't connect with a MS Sql
server database that was down that it pulled data from. Volume was over a
million records per month. 

Again, you'd probably be happy with either db. I think the real driver will
be what application you put between the database and the users. 

Any idea of what kind of volumes you're looking at? Also, any scanners, etc.
that might be used for data entry that might need to be factored in?

Take a look at the following and see if anything looks close:
http://sourceforge.net/search/?type_of_search=soft&words=java+inventory+mana
gement
http://sourceforge.net/search/?type_of_search=soft&words=php+inventory+manag
ement

Since you're a 501c3, I'm happy to provide some free consulting as time
permits.

Hope this helps.

John

-----Original Message-----
From: leaplist-bounces at leap-cf.org [mailto:leaplist-bounces at leap-cf.org] On
Behalf Of John Hayden
Sent: Wednesday, July 11, 2007 12:55 AM
To: 'This is the Leap Main List'
Subject: RE: [Leaplist] Data base programs

We "want" it web based, for *nix so preference is php java is not a problem
or concern (does not matter) reorder REMINDERS (it would be ordered thru a
'procurement' department as this is a 501c3 company

J.T. Hayden
   KG4BFJ

Home/office:     407.891.1835
Office/mobile:    407.922.3091

-----Original Message-----
From: leaplist-bounces at leap-cf.org [mailto:leaplist-bounces at leap-cf.org] On
Behalf Of Damien McKenna
Sent: Tuesday, July 10, 2007 17:56
To: This is the Leap Main List
Subject: RE: [Leaplist] Data base programs

> -----Original Message-----
> From: John Hayden
> Sent: Tuesday, July 10, 2007 4:14 PM
> Subject: [Leaplist] Data base programs
> 
> 
> 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.

So you want:

* items
* categories
* item attributes
* stock management

Anything else from a data point of view?  How about ordering replacement
items?  How about invoicing for such orders?  How about sales
management?

Do you want it to be a stand-along desktop app, a client-server desktop
app or a web-based system?  Do you have any OS / technology requirements
(Java, not Java, not VB, not .NET, PHP, not PHP, etc)?

You could be very quickly looking at needing an ERP system, which could
get really complicated really quickly.


Damien
_______________________________________________
Leaplist mailing list
Leaplist at leap-cf.org
http://lists.leap-cf.org/mailman/listinfo/leaplist

_______________________________________________
Leaplist mailing list
Leaplist at leap-cf.org
http://lists.leap-cf.org/mailman/listinfo/leaplist