[clug-talk] data base platform

Shawn sgrover at open2space.com
Thu Sep 17 14:51:17 PDT 2009


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
> clug-talk at clug.ca
> http://clug.ca/mailman/listinfo/clug-talk_clug.ca
> Mailing List Guidelines (http://clug.ca/ml_guidelines.php)
> **Please remove these lines when replying



More information about the clug-talk mailing list