Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 03-30-2004, 01:22 AM   #1
LQ Newbie
Registered: Mar 2004
Location: Maine
Distribution: Lindows (4.5)
Posts: 1

Rep: Reputation: 0
Question Simple, multiuser db, is there one for Linux


I am a small business person who has tried over the years to use Linux without much success. My recent foray into the Unix / Linux world has been through Lindows and for me it has been a blessing. Loadable without a lot of agravation, similar enough to MSWin to eliminate the learning curve, all in all an enormous time saver. Don't get me wrong, I'd be a purist if I had the time. However, the business demands that my first true love, computing and figuring things out, takes a back seat to getting the job done as quickly and as effortlessly as possible. That said, Unix and Linux seem geared to big business (or universities) and the enterprise and / or the techie.

If I describe a scenario from MSWin, can anyone suggest an equivalent Linux alternative? I have a number of computers (~25) all networked without a server (peer-to-peer - and yes, I can hear you cringing now) running various flavors of MSWin (XP,ME and 98SE), and using Lotus Approach. Approach provides an incredibly simple interface for a dBase IV database in a multi-user environment that I can design and then manipulate and build queries for on the fly. All the computers in the network can be attached to one "server" at the same time using the same database, each user accessing and updating perhaps one record per minute. The network handles this very easily. The records are automatically locked and the users avoid trying to access the same records because they each work on the results of different queries designed to avoid selecting overlapping records.

It may not be elegant, in fact it may be a totally wrong way to go about it, but I can tell you it works. Unfortunately, Lotus has no plans to port their SmartSuite or Approach product over to Linux. I have tried Star Office (5.1 & 7.0) and Open Office (1.0) and have never been able to get close to duplicating what Lotus can do. Am I missing something? Is there an off the shelf product that will do what I need so I can make the transition to Linux and get back to business?

Thank you for any suggestions you may have,
Old 03-30-2004, 03:21 AM   #2
Senior Member
Registered: Sep 2002
Location: Philippines
Distribution: Slackware, RHEL&variants, AIX, SuSE
Posts: 1,127

Rep: Reputation: 49
not familiar with Lotus approach so I'm not sure if you can convert your current database to the DB services that work on linux. PostgreSQL and MySQL are two of the free choices for the Database. But Again, I'm not sure if you can do a direct import of your existing data. these servers are not that hard to configure and manage. you can even get some web based frontends to help you manage your database (ie PhpMyAdmin - mysql, PhpPgAdmin - postgres or WebMin).
Old 03-30-2004, 03:07 PM   #3
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,576

Rep: Reputation: 191Reputation: 191
Moved: This thread is more suitable in Linux - Software and has been moved accordingly to help your thread/question get the exposure it deserves.
Old 03-30-2004, 04:34 PM   #4
Registered: Jul 2003
Distribution: FreeBSD 8.2 RELEASE
Posts: 607

Rep: Reputation: 31
MySQL. I don't know much about databases on Windows but if your old one uses standard SQL then the transition should be quite easy.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiuser system? nebx Linux - General 6 07-06-2005 12:37 AM
How to use multiuser thesensei Linux - Networking 3 01-21-2005 04:59 AM
Multiuser tasking LinuxSeeker Linux - General 2 02-14-2004 05:48 PM
going multiuser (2.6.0) powadha Slackware 1 12-22-2003 02:20 AM
Linux multiuser capabilities for one user? mlhammer Linux - Newbie 4 11-10-2003 10:41 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:39 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration