Question Locked

online database suggestions - help!

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I'm consulting for a very small (2 person) jewelry business, and they want just a bit more than excel can provide, and we want it on the web so that we can all access it. seems like most web-based databases have monthly fees that put them above $250 a year, which seems high since you can buy ACT and other contact management software for just $200. ACT is fine, really, but they don't have a web-based solution, except one that requires a server, which we don't have.

We just want something that will keep track of customers and their orders and be able to pull lists of people who ordered gold jewelry, or those who ordered a catalog but never placed an order, etc. Any ideas?

4 replies

by dr dij

if you want a customer tracking system (CRM) or an ERP or OMS (order management system). Places like salesforce.com and many others have very reasonable, starting at $20 to $50 per month per person ASPs.

Sure you can buy a copy of act. And they probably don't backup so they get wiped with next virus. Web based versions of course store it online. And it becomes reliable because stored online, you simply reformat a pc for web conx to get back into your data.

There are websites specialing in ASP reviews. Sorry I can't recommend a specific one. We use a couple ASPs but possibly not same use as you want.

by toivo talikka

If the number of people accessing the database is small, and if they do not have to access it simultaneously, maybe you can just run a VNC server on the system hosting the CRM database like ACT!.

The person accessing the computer remotely needs to run VNC Client and will see the same screen. VNC, which stands for Virtual Network Computing, was developed by AT&T Laboratories in the UK, is cross-platform, free and it comes in several flavours:

http://www.tightvnc.com/download.html
http://www.uvnc.com/download
http://www.realvnc.com/download.html

by marv732

Oracle have recently released a free version of their database called OracleXE. It runs with a web interface (Application Express) that can also be used to develop applications pretty quick.
I assume that with only 2 people in the business they won't be wanting a full blown ERP application and all the overhead that goes with it.
Oracle XE is restricted though - to 1 CPU, 1GB RAM and 4GB user data even on a multi CPU system and I run it successfully on a laptop with 512MB RAM so if you've got something around 1GB it will run great. There is plenty of help on http://www.oracle.com/technology/products/database/application_express/index.html

www.lereve.com.au is a site that's been using ApEx for a couple of years now for it's business.
May be worth a look anyway.
Greg

This discussion is closed to new replies.