Author Topic: Ok Programmers... Need some help! (Read 627 times)

Bodhi · « **on:** March 31, 2005, 05:18:53 PM »

I need to set up a new inventory program for our warbird shop. Those of you that are good at programming I would like to solicit help from.

So here's the deal. Email me through this board, and I will tell you what I need. You can tell me if you are interested.

Sandman · « **Reply #1 on:** March 31, 2005, 05:33:22 PM »

Hmmm... inventory... which means database, right?

Plenty of off the shelf, right out of the box solutions I think.

Of course, if none of those fit your liking, you could look to someone that understands MySQL and PHP.

Skuzzy · « **Reply #2 on:** March 31, 2005, 05:42:33 PM »

Depends Sandman. Off the shelf software usualy requires getting some contracter to make the off-the-shelf solution work in your particular business.

I would shy away from PHP, unless the solution requires a WEB based front end.
MySQL is hard to beat for database work in business and scales pretty well too. The price performance ratio is definately off the charts.

Pretty easy to work with too. Just wrapper MySQL on the server with a C front end, then do a message based GUI for Windows for a simple and fast inventory program.
Of course, if it needs to be tied to various bar code readers it gets more involved.

Panzzer · « **Reply #3 on:** March 31, 2005, 05:49:14 PM »

What's wrong with Linux-server with Java (jsp) and MySQL? It's cheap and quite easy...

edit: Sorry, Skuzzy, should've read your post through first.. But for WEB solutions jsp and MySQL are quite simple to do... Well, Apache and Tomcat might require a little tweaking on a Linux, but not too much.. And you can get them to run on a Windows server too. Ofcourse, php and MySQL might work too, I haven't had that much experience with php...

Skuzzy · « **Reply #4 on:** March 31, 2005, 07:30:31 PM »

If I am running a Linux (or any other UNIX variant), then I go with the native languages of those operating systems for the sake of stability.
Java is not stable. It is still evolving and the libraries are a mess right now due to the security problems with it. The Java comittee keeps whacking commands from the language for scripts due to the security problems.
I have used both C and Java. For this type of application I would go with C all the way due to API's and libraries available. C would also blow the doors off of Java in this scenario, in terms of size and performance.

I'll always put my money on a nice stable conservative approach to a business solution. Less chance of getting burned for the business and the programmer. Unless it is a programmer wanting a long term contract for support. I don't play that game though.

And no way would I ever use Windows for a server platform.

Panzzer · « **Reply #5 on:** March 31, 2005, 07:48:31 PM »

Rgr that Skuzzy.

I've been adminstrating a Linux/MySQL/Java-system (with web frontend for customers made with jsp-pages) for a couple of years now.

Sandman · « **Reply #6 on:** March 31, 2005, 09:23:43 PM »

Quote

Originally posted by Skuzzy
Depends Sandman. Off the shelf software usualy requires getting some contracter to make the off-the-shelf solution work in your particular business.

I would shy away from PHP, unless the solution requires a WEB based front end.
MySQL is hard to beat for database work in business and scales pretty well too. The price performance ratio is definately off the charts.

Pretty easy to work with too. Just wrapper MySQL on the server with a C front end, then do a message based GUI for Windows for a simple and fast inventory program.
Of course, if it needs to be tied to various bar code readers it gets more involved.

Sorry... you're right. Bodhi did not indicate the need for a web-based solution.

LePaul · « **Reply #7 on:** March 31, 2005, 09:41:27 PM »

Access Database stuff isnt bad, I havent dealt with SQL/MySQL stuff yet. In the process of doing the MSCE with SQL now.

Skuzzy · « **Reply #8 on:** March 31, 2005, 09:51:31 PM »

Unfortunately LePaul, the MSCE will teach you all about how MS thinks SQL should work. MS does deviate from the SQL standards. But, businesses do not know it, and could care less.

Just stay away from Oracle or you will be confused after MS gets through with you.

AKS\/\/ulfe · « **Reply #9 on:** March 31, 2005, 09:56:20 PM »

The thing about inventory programs is that if you can't find it, the inventory program isn't worth ****.
-SW

LePaul · « **Reply #10 on:** March 31, 2005, 10:04:03 PM »

Quote

Originally posted by Skuzzy
Unfortunately LePaul, the MSCE will teach you all about how MS thinks SQL should work. MS does deviate from the SQL standards. But, businesses do not know it, and could care less.

Just stay away from Oracle or you will be confused after MS gets through with you.

Dunno, Skuzzy. Several of the bank's systems use MS SQL and they're footing the bill for my training.

Heater · « **Reply #11 on:** April 01, 2005, 04:31:58 AM »

Get a real data base -> Teradata

how much data are you talking about and what do you want to do with it?

AS for MCSE & SQL like Skuzzy stated the MS way is not the way the real world works...

Rolex · « **Reply #12 on:** April 01, 2005, 06:49:35 AM »

MySQL is certainly easy to manage and reliable with abundant documentation, information and tricks floating around the ether.

I don't think having a browser-based interface is such a bad thing. It would be easy and unintimidating to a new user - a familar face, so to speak. PHP with MySQL are indeed the simple way to ensure upgrade continuity since PHP is so easy to learn or modify. It's child's play. C++ writers are fewer and more expensive for no added benefit in this application.

Where did this "web-based" stuff come from? What does the web have to do with this? Anyway, it isn't a difficult thing to set up, Bodhi.

Bodhi · « **Reply #13 on:** April 01, 2005, 10:08:48 AM »

Well, we have around a million parts (hardware included) and it is difficult tracking it in Excel like I do now.

For those thinking web... NO! absolutely not. These computers will be isolated from the web to keep any unwanted problems out, and people seeking data out. There is no reason that this would be shared outside our company anyway.

I basically would like to set it up like the standard US parts book, whereby you can type in a part nubmer and it goes to that page, shows how many parts we have and what condition they are in. If it is a high end part, like a Merlin Head, or Bank, have the ability to look at pictures of different ones that are sub numbered. I would also like the IP (Illustrated Parts breakdown) to be available as well.

Sound like a major ordeal or what?

Sandman · « **Reply #14 on:** April 01, 2005, 12:10:03 PM »

Quote

Originally posted by Bodhi
Well, we have around a million parts (hardware included) and it is difficult tracking it in Excel like I do now.

For those thinking web... NO! absolutely not. These computers will be isolated from the web to keep any unwanted problems out, and people seeking data out. There is no reason that this would be shared outside our company anyway.

Ahem... web-based doesn't necessarily mean internet. There is also intranet.... and I'm off topic. Move along.