LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 11-06-2003, 07:00 PM   #1
Whitehat
Senior Member
 
Registered: Feb 2003
Location: The Cold North
Distribution: SuSE 9.1
Posts: 1,289

Rep: Reputation: 45
Question about database for small number of people...


(trickykid - I wasn't sure if this should go in Software or Linux-General. Sorry if you have to move it.)

Hey all,

I have a quick question.

I have a client that would like me to build a database for them. The client has about 10 people in the whole company. I can use any software of my choice. The client is currently using Microsoft Office 2000 which includes Access 2000.

I would love to build a database for them with open souce software, and then install something on their PC's so they can use the database. I know that there are MySQL, Postgres, etc...but I thought those were compairable to Microsoft SQL. Does the Linux world have an Access type of database program?

Would you guys just build the database in Access or use something open source ?

Also, what on earth would you charge to build a database? I usually charge $50 per hour for desktop stuff and $100 per hour for server/network stuff.

Would I charge like $250 for the database or what? It would have I think about 6 fields and maybe like 15,000 records.

Any suggestions? All help appreciated THanks!


Last edited by Whitehat; 11-07-2003 at 10:44 AM.
 
Old 11-06-2003, 07:35 PM   #2
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
Re: Question about database for small number of people...

Quote:
Originally posted by Whitehat
(trickykid - I wasn't sure if this should go in Software or Linux-General. Sorry if you have to move it.)
Actually fits perfectly here in Linux - General.
 
Old 11-07-2003, 06:12 AM   #3
Whitehat
Senior Member
 
Registered: Feb 2003
Location: The Cold North
Distribution: SuSE 9.1
Posts: 1,289

Original Poster
Rep: Reputation: 45
Wow..........should I assume that I should go with Access?

Hmm....
 
Old 11-07-2003, 01:34 PM   #4
RolledOat
Member
 
Registered: Feb 2003
Location: San Antonio
Distribution: Suse 9.0 Professional
Posts: 843

Rep: Reputation: 30
Head to OpenOffice.org. You may be able to save them even more using OpenOffice with the built in database tools.

http://api.openoffice.org/docs/Devel...ets=oi3op5z3g2
http://dba.openoffice.org/testcase/t...p5z3g2#general

RO
 
Old 11-07-2003, 03:36 PM   #5
Whitehat
Senior Member
 
Registered: Feb 2003
Location: The Cold North
Distribution: SuSE 9.1
Posts: 1,289

Original Poster
Rep: Reputation: 45
It doesn't seem like there is an Open Source Database Tool like Access. It says you can open databases and stuff but it doesn't look like you can build them like you can with Access.

Hmm...

And........what would you charge? About 6 Fields and 15,000 records.
 
Old 11-08-2003, 11:46 AM   #6
Whitehat
Senior Member
 
Registered: Feb 2003
Location: The Cold North
Distribution: SuSE 9.1
Posts: 1,289

Original Poster
Rep: Reputation: 45
So........I guess it's a bust?

Nothing comes close to Access?
 
Old 11-08-2003, 12:33 PM   #7
saint
Member
 
Registered: Sep 2001
Location: India
Distribution: Red Hat 9
Posts: 55

Rep: Reputation: 15
Give them MySQL. To administer the DB give them phpmyadmin. (you will also have to run apache). But you will be stuck on how to generate reports from MySQL. I guess you will have to write some scripts to generate reports.
 
Old 11-08-2003, 01:37 PM   #8
Whitehat
Senior Member
 
Registered: Feb 2003
Location: The Cold North
Distribution: SuSE 9.1
Posts: 1,289

Original Poster
Rep: Reputation: 45
Quote:
Originally posted by saint
Give them MySQL. To administer the DB give them phpmyadmin. (you will also have to run apache). But you will be stuck on how to generate reports from MySQL. I guess you will have to write some scripts to generate reports.
Wow...

Well Thanks everyone. I'll just stick to MS Access 2002/2003. I am not going to run MySQL, Apache, and phpmyadmin just do do what Access can do by itself.

Hmm...

I really do appreciate your replies. Don't think I"m discounting them. I just don't think there is anything else out there right now to compete with Access.

I realize that MySQL competes with SQL, but that's about it.

THanks,
Whitehat.
 
Old 11-08-2003, 10:24 PM   #9
MiscGeek
Member
 
Registered: Jan 2003
Location: Georgia, US
Distribution: RHEL WS4
Posts: 189

Rep: Reputation: 30
I would really not recommend using access unless the latest version is much better than the version available a few years ago. I had the misfortune of using it once

Seemed to work fine for 2 or 3 users with fairly light traffic. But, once we went over five users and/or the usage went up, the response time became unbearably slow. It may have improved since I used it though. It has been a few years
 
Old 11-22-2003, 03:51 PM   #10
jdtiede
Member
 
Registered: Apr 2003
Location: Baton Rouge, LA
Distribution: Kubuntu 12.04, 12.10, 13.04a
Posts: 244

Rep: Reputation: 30
PostgreSQL vs. MS Access

I had the bad experience of having Access fall apart when used by more than two or three users. I tried to convince to the client to backend with SQL Server but he wouldn't. Someone else was called in and I don't know the final outcome. I do know that the client bought a few new computers and could only get a later version of Access, so we were stuck with maintaining two versions of the system or buying seven or eight new licenses! The data files were compatible but the routines needed some conversion.
Borland's Delphi works along the same lines as Access, though the learning curve is a little steeper. Kylix (the Linux version of Delphi) isn't solid. I used Paradox tables with Delphi but wasn't satisfied with them (and dBASE tables are worse--have to be reindexed often). Now that there is a way to use Postgres under Windows, that might be the best way to go. But if you try to use Access for 10 users, you'll be sorry! It just isn't an industrial-strength database--more of a toy.
 
Old 12-06-2003, 12:27 PM   #11
jdtiede
Member
 
Registered: Apr 2003
Location: Baton Rouge, LA
Distribution: Kubuntu 12.04, 12.10, 13.04a
Posts: 244

Rep: Reputation: 30
For a small installation, look at SQLite (Google for link). Small footprint, no administration (is its own server), uses standard SQL commands. There is a way to use Python instead of C++ (easier to learn) called PySQLite, which is more heavily documented than SQLite itself. Then there is PyQt, a way to access Qt (strong fro GUI programming) with Python. And the price is right!
 
  


Reply


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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get people to use Linux? I'm bad at converting people over. Mr. Hill Linux - Newbie 31 10-19-2008 09:16 AM
An idea for a survey: What country have the largest number of people prefer linux TruongAn LQ Suggestions & Feedback 2 09-11-2005 10:56 AM
Question for those IRC Chat people Reefcrazed Linux - Software 3 08-08-2004 09:48 PM
looking for a small simple database?? Teckno Linux - Software 1 06-03-2004 02:06 PM
quick ipv6 question(for people who go on efnet) notstrider Linux - Networking 4 02-07-2003 09:11 PM


All times are GMT -5. The time now is 07:53 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