#1  
Old 20th July 2012, 03:21
uvbnserved uvbnserved is offline
Member
 
Join Date: Apr 2009
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database suggestions?

Me and my dad have a small distribution company. currently we have few enough orders that we just enter them on our separate spread sheets and check with each other periodically. We are interested in implementing a database. sort of a central "spread sheet" that we can both read and write to remotely.

I have set up apache servers before but have never looked into databases. Could anyone point me towards the right software for these needs?

Yes I am a "noob" on this topic. go easy on me
Reply With Quote
Sponsored Links
  #2  
Old 20th July 2012, 10:30
TiTex TiTex is offline
Senior Member
 
Join Date: Aug 2011
Location: Cluj-Napoca,Romania
Posts: 125
Thanks: 0
Thanked 17 Times in 17 Posts
Send a message via Skype™ to TiTex
Default

setting up an mysql database it's easy enough , and you can also connect an excel document to it http://helpdeskgeek.com/office-tips/excel-to-mysql/
if you will install mysql on a linux box you will probably install it with your linux distribution app manager like yum (redhat, fedora, centos)
for windows you can download it from here http://dev.mysql.com/downloads/
documentation http://dev.mysql.com/doc/refman/5.5/en/index.html , but you can also google search and you'll find a lot of help for mysql database design and/or usage

Last edited by TiTex; 20th July 2012 at 10:34.
Reply With Quote
  #3  
Old 20th July 2012, 11:37
Ben Ben is offline
Moderator
 
Join Date: Jul 2006
Posts: 1,029
Thanks: 7
Thanked 62 Times in 56 Posts
Default

What do you expect of setting up your database or in other words, do you plan as (your self called) "noobs" to develop a order processing system?

Did you check if there might be an "out of the box" solution that will help you with your problem? Might be that there is also some open source that fits your needs.

So you might avoid reeinventing the wheel, especially if you are currently not so sure if you need a whole wheel but later on you might do so but did some architectural mistakes in the beginning making it hard to go on.
Besides this you can also avoid doing some commong software dev. mistakes etc. and you can reduce spending your own ressources on "just" keeping your stuff up and running (consider data security, backups etc.) as the it in this case is just the tool to assist with your work

Never the less when working to gether on the same document / documents you will always have the problem of a conflict when writing to the same data source without messing all things up. So even a database by default will not just help you locking records (like you need to lock your xls) when more than one is trying to edit the same record.

To not end up with nothing just words in this post, here are two links as a result from a quick google for open source order management tools, maybe they might go in your direction. If the are good or not (in all belonging - IT and non IT) I can't tell at all.
http://phpbms.org/
http://ofbiz.apache.org/
Reply With Quote
  #4  
Old 21st July 2012, 09:26
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
 
Default

If you use ISPConfig, the ISPConfig Billing Module might be for you...
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Horde Groupware Webmail Edition ByteMe Networking Tips/Tricks/Mods 17 20th December 2012 10:12
Combination of postfix and courier failing Xaymar Server Operation 3 7th March 2012 17:28
Amavis/ClamAv problem MattJo. General 7 20th October 2010 17:18
Problems with SpamSnake ClamAV (Sanesecurity Signatures) tmaleshafske HOWTO-Related Questions 0 21st September 2010 01:59
Mail System doesnt work! crichton Installation/Configuration 3 17th September 2007 23:49


All times are GMT +2. The time now is 00:30.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.