Software Development Suggesstion

Question

1.00/5 (2 votes)

See more:

I am going to build a Accounting and Inventory based Software for My Printing Press office. I was thing to use JDBC and Excel at the back-end. The Entries was huge, sometimes thousands entries has to be made in a week. this software will show us the current inventory, sales, expenses, and on the base of sale and expenses, it will help us to forecast future sales and employees or inventory performance.

I want some Suggestion of all you experience software developer whether or not should i use this platform or any-other. I only knows J2SE, JDBC, PHP, MySQL Assembly and Ms Access and Excel.

Posted 20-May-13 3:48am

Taqi_Shah

Add a Solution

Comments

Prasad Khandekar 20-May-13 9:52am

If you also know JSP & Servelet then you can use J2SE/JDBC And MySQL otherwise stick to PHP & MySQL. For Java version you will also require a Servlet Container like Tomcat and for PHP you will require Apache Httpd.

Regards,

Taqi_Shah 20-May-13 9:58am

Yes I know about JSP & Servelet little bit. I also wanted to secure my source code of software, cna PHP & MySQL can do that.

Ron Beyer 20-May-13 10:19am

Please stay away from Access or Excel as a back-end data source, Access is a little better than Excel, but Excel was never meant to be a back-end source.

enhzflep 21-May-13 0:41am

Seconded. My thoughts precisely.
Unless one was into BDSM, why oh why would you inflict an MS Office back-end on any database based app.

Richard MacCutchan 20-May-13 10:45am

Search Google, there are lots of tried and tested solutions to this problem, which you could implement in days. As opposed to taking months (or even longer) to write such a package.

Taqi_Shah 21-May-13 14:01pm

I am Using Excel at the back-end because there are thousand of records to store and i don't want to use access tables, relationship to make it complex. just a simple database in excel and some front end java GUI using JDBC and J2SE.
If any of you know to make it easier and simpler please suggest. or if you have any other idea.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nagy Vilmos · Accepted Answer · 2013-05-23T02:37:00

Solution 1

Do not, under any circumstances, try to use a spreadsheet as a database!

Please, the suggestions you are getting are all very sensible and will work. Using Excel would be like using a vole as pack animal - it might be able to do something but the load will cripple it.

Here is some advice, that is free, what I am giving to you. Gratis.

Search for "free PHP based inventory system", as you profess knowledge of that. Use that as a starting point. It really is that simple.

As for Excel? Forget it.

Posted 23-May-13 2:37am

Nagy Vilmos

Comments

Taqi_Shah 24-May-13 2:59am

That's a nice suggesstion From Mr. Nagy Vilmos. But for php my concern is to also secure my source code also. Don't you think that as I mentioned that my Records sometimes extends more than 1000 entries and at some stage When i used MySql as the Database, There will be huge Sql database for 2,3 months.

Taqi_Shah 24-May-13 7:22am

What if?! if i use java with sql.?

Nagy Vilmos 24-May-13 7:29am

Same applies. A little research will give you the basics of what you want and then go on from there. Re-inventing the wheel is mostly a pointless exercise.