LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 02-14-2010, 04:11 PM   #1
campanula
LQ Newbie
 
Registered: Feb 2010
Posts: 9
Blog Entries: 3

Rep: Reputation: 0
using oobase as stand-alone database vs as front-end to mysql or postgresql


I need to create a database for a small business. It won't be very big but there will be lots of one-to-many relationships between the tables. The business is aiming to expand - at the moment allowing multiple users and remote access would be useful but not necessary, but eventually (hopefully) it is going to be essential.

They want to be able to start using the database asap, with a nice simple user interface. I'm starting from absolute scratch...

As far as understanding the structure of the database goes, and creating it in sql, I don't have any problems at all. I'm working on the basis of using oobase initially as the front-end interface - possibly moving to a more tailored solution using php or whatever when I've learnt how to use them.

The eventual requirements for multiple user and remote access made me assume that mysql or postgresql would be the appropriate applications to use. However, I'm having problems trying to understand and configure all the server stuff (user access, host names, security) -it's all totally new to me.

There's also the added complication that they don't have a separate server computer - one of the desktop computers doubles as the server. They know they need to get a proper server at some point, but... If they get a big contract which requires lots of working away from the office they will sort this out quickly, otherwise it could be a year or more down the line...

I know in theory I could start just using oobase then move the data across to a full database server later - is this a practical solution or more problematic than it's worth? And would moving/reconfiguring mysql or postgresql be even worse??

Many thanks in advance for your help,
Katie
 
Old 02-14-2010, 05:13 PM   #2
coltree
LQ Newbie
 
Registered: Nov 2003
Location: Brisbane Queensland AU
Distribution: Slackware
Posts: 25
Blog Entries: 1

Rep: Reputation: 1
I got used to using postgresql, it used to be difficult to setup.
Which distro are you using ?
Debian sets up postgres to a usable default on install, you then have a fair amount of reading and learning.
What doesn't kill you makes you stronger.

But I am inherently lazy, I now mainly use sqlite which also interfaces with openoffice.

How large is the company, how large or complex could the database become, check benchmarks, will a smaller db give you what you need simpler, will your i/f language give you the required security.
I would suggest do it once, do it right, don't change horses mid-stream, you're only doubling your work load.
 
Old 02-14-2010, 05:19 PM   #3
jschiwal
Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655
If you go with mysql, I've found the mysql-administrator program makes adding and configuring user permissions a snap.

If you would like to brush up on the sql language, the book "MySQL Crash Course" by Ben Forta is excellent.

Last edited by jschiwal; 02-14-2010 at 05:23 PM.
 
Old 02-14-2010, 06:02 PM   #4
jefro
Guru
 
Registered: Mar 2008
Posts: 11,970

Rep: Reputation: 1485Reputation: 1485Reputation: 1485Reputation: 1485Reputation: 1485Reputation: 1485Reputation: 1485Reputation: 1485Reputation: 1485Reputation: 1485
OO is quite usable if you want to learn it. It is similar to many databases.

They kind of have the documentation all over the place for most of OO. See this. http://wiki.services.openoffice.org/wiki/Database
 
Old 02-14-2010, 06:15 PM   #5
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,311

Rep: Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040
I agree, if you're going to need eg MySQL, go with it upfront. Saves learning 2 systems.
You can still use OOBase as a front-end if it makes sense.
The (very good) MySQL docs & forums are here http://dev.mysql.com/doc/refman/5.0/en .
For an admin front-end, you can also look at phpMyAdmin http://www.phpmyadmin.net/home_page/index.php and see which one you prefer. It should be in your repos I believe.
Can't really get much more specific until you decide which DB to use.
Do keep a copy of the DB on another system eg at home if that's allowed. This is for recovery purposes and research.
 
Old 02-16-2010, 09:33 AM   #6
campanula
LQ Newbie
 
Registered: Feb 2010
Posts: 9
Blog Entries: 3

Original Poster
Rep: Reputation: 0
Many thanks for your replies - coming to the conclusion that I need to learn about sorting the network anyway, so then the setting up different types of access will make sense! From your replies it's sounding like moving the server to new hardware as and when that happens shouldn't be too difficult once I've worked out how this network connects to each other...

So now I have a big stack of books about networking from the library to wade through!

thanks again,
Katie
 
  


Reply

Tags
mysql, postgresql


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
Database front end for KDE4 (knoda type of program)? DiBosco Linux - Software 1 11-23-2009 10:07 PM
Apache+php => database front-end sylvaticus Linux - Server 0 01-09-2007 09:28 AM
LXer: A review of the Glom graphical database front-end LXer Syndicated Linux News 0 09-10-2006 06:21 PM
Need small database app with front end red_nexus Linux - Software 3 05-08-2006 03:10 AM
Rich Text Widget/Database Front End Stranger Programming 5 10-03-2004 07:37 PM


All times are GMT -5. The time now is 01:42 AM.

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