[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