THANX AGAIN ALL FOR YOUR MOST HELPFUL INPUT.
DAN -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, September 18, 2009 1:00 PM To: [email protected] Subject: clug-talk Digest, Vol 59, Issue 24 Send clug-talk mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://clug.ca/mailman/listinfo/clug-talk_clug.ca or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of clug-talk digest..." Today's Topics: 1. Re: data base platform (Shawn) 2. Re: data base platform (Patrick Radtke) ---------------------------------------------------------------------- Message: 1 Date: Thu, 17 Sep 2009 15:51:17 -0600 From: Shawn <[email protected]> Subject: Re: [clug-talk] data base platform To: CLUG General <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed The short answer to your question is a resounding YES. MYSQL and PostgreSQL are two of the more common database options available that can do this. But there are a good number of others options as well - ranging from SQLite to Oracle. when you say "Something where 5-6 can log into the same data base and each one of the users could change info and as that is being done it changes at the other users aswell." This doesn't really describe HOW you want to interact with the database. Almost all database systems provide an interface or shell - usually command line style - where you can enter SQL statements. Technically speaking, this command line shell would meet your described needs, but probably isn't what you are thinking and probably not suitable for your users. There are some visual tools for interacting with databases - phpMyAddmin provides a web based method for managing MYSQL databases and is relatively simple to use. There is a phpPgAdmin package for doing the same with a PostgreSQL database as well. PgAdmin III is a desktop app for managing PostgreSQL databases. But all of these visual tools require that your user be at least a little bit knowledgeable regarding SQL, databases, and the inherent risks of editing a database directly. Beyond that, there are pre-built apps, or custom apps, that put a friendly interface onto your database. You could use Open Office Base as a front end to build a friendlier interface (similar to building a form in MS Access), or you could build a custom web page. In terms of tracking customer info, you *might* want to look at a CRM package - they do this, but this is probably way overkill for what you've described thus far. HTH. Shawn Dan Mueller wrote: > Hello All. > > > > Im wondering if any of you would know of a Linux platform data base > where all of us here in the office could log on to over the internet > where we could have customers info on and variety of different things > that I can track and add/change at will. Something where 5-6 can log > into the same data base and each one of the users could change info and > as that is being done it changes at the other users aswell. Not sure of > all the mechanics behind this but any direction would be appreciated. > Also some guidance on how I get this up so we could access it through > the internet as I have zero experience with it. > > > > Thanx > > Dan > > > > > ------------------------------------------------------------------------ > > _______________________________________________ > clug-talk mailing list > [email protected] > http://clug.ca/mailman/listinfo/clug-talk_clug.ca > Mailing List Guidelines (http://clug.ca/ml_guidelines.php) > **Please remove these lines when replying ------------------------------ Message: 2 Date: Thu, 17 Sep 2009 16:41:14 -0600 From: Patrick Radtke <[email protected]> Subject: Re: [clug-talk] data base platform To: CLUG General <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset="iso-8859-1" I think you are better off using proper CRM software then setting up a DB and using gui admin tools to enter data. What may be an 'overkill' feature in CRM initially may become useful in the future. You didn't mention if you had any preference for free or open source software, so I'll assume that cheap and closed source is fine. We use high rise hq for managing contacts. http://highrisehq.com/signup They have a free option that limits you to two users, but you can just share passwords. -Patrick On Thu, Sep 17, 2009 at 8:08 AM, Dan Mueller <[email protected]> wrote: > Hello All. > > > > Im wondering if any of you would know of a Linux platform data base where > all of us here in the office could log on to over the internet where we > could have customers info on and variety of different things that I can > track and add/change at will. Something where 5-6 can log into the same data > base and each one of the users could change info and as that is being done > it changes at the other users aswell. Not sure of all the mechanics behind > this but any direction would be appreciated. Also some guidance on how I get > this up so we could access it through the internet as I have zero experience > with it. > > > > Thanx > > Dan > > > > _______________________________________________ > clug-talk mailing list > [email protected] > http://clug.ca/mailman/listinfo/clug-talk_clug.ca > Mailing List Guidelines (http://clug.ca/ml_guidelines.php) > **Please remove these lines when replying > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://clug.ca/pipermail/clug-talk_clug.ca/attachments/20090917/a151e5f6/at tachment-0001.html> ------------------------------ _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca End of clug-talk Digest, Vol 59, Issue 24 ***************************************** _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
