Go Back   AnandTech Forums > Software > Programming

· Hardware and Technology
· CPUs and Overclocking
· Motherboards
· Video Cards and Graphics
· AMD Video Cards
· Nvidia
· Displays
· Memory and Storage
· Power Supplies
· Cases & Cooling
· SFF, Notebooks, Pre-Built/Barebones PCs
· Networking
· Peripherals
· General Hardware
· Highly Technical
· Computer Help
· Home Theater PCs
· Consumer Electronics
· Digital and Video Cameras
· Mobile Devices & Gadgets
· Audio/Video & Home Theater
· Software
· Software for Windows
· All Things Apple
· *nix Software
· Operating Systems
· Programming
· PC Gaming
· Console Gaming
· Distributed Computing
· Security
· Social
· Off Topic
· Politics and News
· Discussion Club
· Love and Relationships
· The Garage
· Health and Fitness
· Home and Garden
· Merchandise and Shopping
· For Sale/Trade
· Hot Deals with Free Stuff/Contests
· Black Friday 2015
· Forum Issues
· Technical Forum Issues
· Personal Forum Issues
· Suggestion Box
· Moderator Resources
· Moderator Discussions

Thread Tools
Old 12-05-2012, 07:50 PM   #1
Join Date: Jan 2005
Posts: 108
Default Beginner help on what to use and how to start database

I am new to database programming/management.
I was appointed to put together a contact database for our company. We've been in business for a long time with no real standard for record keeping, so names and companies are all over the place. I would need to able to query for different categories and import/export contacts and companies. There will be categories of types such as Engineers or Lawyers, with multiple subcategories.
The standard addresses of course will need to be searchable as well. I looked through a few programs/platforms and they're either too powerful or not powerful enough.

For example, Outlook has somewhat of a contacts database but cannot be categorized and exported into Excel. I tried to play around with MySQL, which seems like it is more for full websites or big content management, and overkill for what I need.

I found a program that does something quite like what I want, but I believe it hard coded in and cannot be used by me or anyone else. It has a simple interface and can query/export. A screenshot of the program can be found here: http://i.imgur.com/g22M0.jpg

I am the IT support here, and ashamed to say I am completely new to this...but I am willing to learn. I just need to get started and I will start reading more and trying things. I have no idea what platform or standard to use, and creating an application with a nice GUI is overwhelming as well.

Does anyone have suggestions for how I should start?
raygunpk is offline   Reply With Quote
Old 12-05-2012, 08:49 PM   #2
Diamond Member
Join Date: Apr 2005
Posts: 3,163

If you are using Windows, I would look at either MS SQL Server or MS Access. SQL is definitely more powerful and you will always be able to find exactly what you need in your database. SQL Server integrates pretty tightly with Excel, as does Access (which makes sense, since they are all Microsoft products). I don't have much experience with Access but it is geared towards smaller databases that aren't necessarily relational.

I recall from many years ago (1996 or so) that I used a product called ACT! that seemed decent for a contacts database. At the time, I was working for a recruiter doing data entry (I was a high school student) and it seemed to have a decent feature set.

So, in this order, I would look at:
1. MS SQL Server
2. MS Access
3. ACT!
douglasb is offline   Reply With Quote
Old 12-05-2012, 11:41 PM   #3
Leros's Avatar
Join Date: Jul 2004
Location: Austin, TX
Posts: 21,848

Do you want this to be centralized (i.e. one central server that everybody accesses)? If so, MySQL is not overkill at all.

If you want a single machine solution, look into SQLite. It's basically a SQL database that is stored in a single file on disk.
Is cheesecake pie?
Leros is offline   Reply With Quote
Old 12-06-2012, 12:32 AM   #4
Platinum Member
Join Date: Jun 2009
Posts: 2,717

It's good that you want to learn programming and databases. However I strongly advise you to do that first either on your own project(s) or by helping an existing open source project.

It's not something you can just learn it takes time to build experience and know what's wrong. It's safe to say that the first program of any one doing self-education (probably also from most who actually studied CS) will be utter crap in some way, lack of functionality, full of bugs, bad GUI, unmaintainable, not extendable...

What's the budget? How many users? While such things sound easy, they are not. And meaning your responsible does not mean you have to do it yourself meanign buy an existing product (better) or have it created (don't think thats good idea but better than DIY).
beginner99 is offline   Reply With Quote
Old 12-06-2012, 01:21 AM   #5
Elite Member
Moderator Emeritus
Markbnj's Avatar
Join Date: Sep 2005
Posts: 15,565

There are a number of really good contact management applications available off the shelf, or in an online service mode. Unless they specifically picked this as a training project for you they'd be much better off buying it as opposed to building it. Perhaps even especially if they picked this as a training project for you .
Everytime I try to tell you, the words just come out wrong

Some meaningless scribbling of no account

The 4th Realm

Arts and Letters Daily - Get some culture
Markbnj is offline   Reply With Quote
Old 12-06-2012, 02:27 AM   #6
Join Date: Jan 2005
Posts: 108

Thanks for the replies!

This will not be centralized, it will just be handling everything. For any requests regarding contacts, they will come to me, and I should be able to query and spit out results easily.

There is essentially zero budget, hence why My SQL and SQLite appeals to me. And since it is only accessible by me, I have no issues with it being buggy or just crap in general.

This is definitely a new thing for me but I am happy to try to learn it.
raygunpk is offline   Reply With Quote
Old 12-06-2012, 09:50 AM   #7
Diamond Member
Tweak155's Avatar
Join Date: Sep 2003
Location: Michigan
Posts: 9,985

I would recommend Access since your office likely has MS Office already. A contacts DB is a very simple first project as long as you set easy to reach goals. Don't shoot for the moon on the first iteration - just get it to store all the contacts with the desired information. Then figure out how to read from them. Then add filters. Then searches, etc.
Organo Gold Coffee

Heatware 98-0-0
Tweak155 is offline   Reply With Quote
Old 12-18-2012, 12:27 PM   #8
Diamond Member
pauldun170's Avatar
Join Date: Sep 2011
Posts: 3,081

Originally Posted by raygunpk View Post
I am new to database programming/management.
For example, Outlook has somewhat of a contacts database but cannot be categorized and exported into Excel.
From within outlook
Select contacts
File>Import Export> export to a file> Excel
pauldun170 is offline   Reply With Quote
Old 12-18-2012, 10:21 PM   #9
Senior Member
ringtail's Avatar
Join Date: Mar 2012
Location: USA left coast
Posts: 884


see if your local community college has a class you can take

or if totally on your own, get a good book from your local library and work your way through that.

The thing is, although nearly all other software you're familiar with is usually pretty intuitive so you, because you're so very smart, can just dive into it and learn by clicking your way around, database is NOT like that. Not at all. Try that with database and you'll just end up with a big mess.

First off, invest some time in a paper & pencil & reading exercise that doesn't even involve touching a computer. 1st invest a week or 2 into the general subject of how to normalize a db, and in the process of doing that you'll automatically learn a lot about SQL.

Later after that, install any of the many free RDBMS. There's lots of brands, each with slightly different implementations of SQL, which means each has slight differences in command syntax.

For corporate mega-bucks systems the big daddy is Oracle. For free ones the big elephant in the room is MySQL (which Oracle took over about 2 years ago).

You should go with MySQL, at least for starters. Also, there are several little boutique forks off MySQL like Percona and MariaDB, maybe others too, each with nuanced improvements over their mother MySQL. Ignore those for starters.

A clique of group-think guys who post on this AT forum think it's "cool" to dis MySQL and insist that a MySQL alternative called PostGRE MUST BY GOD be used instead. Never mind that silliness... MySQL is by a vast margin the biggest, is the most widely used for web, etc. MySQL is where the action is, so start with MySQL. I think Amazon.com, ebay, IMDB for example all run on MySQL. In a sense the www runs on MySQL = that's THEE brand to learn on.

Absolutely DO NOT learn on Microsoft Access, which is exactly like a little kid's toy with training wheels. If you get imprinted on Access it'll cripple your SQL fluency in future.
Oracle=big multinational corporations,
MySQL=mid-sized corps down to small office multi-user situations,
Access=for an individual person alone, maybe up to around 10 users.

Start on MySQL free. Just install the free MySQL community edition installer for Windows and it knows what to do. link
Also, read the MySQL manual. link

The fat O'Reilly books are good. Better than the O'Reilly books are anything by a SQL genius in the eu, Holland I think, or maybe in Belgium, named Rick Van der Lans...he has several books in English and he is a SUPERIOR teacher of this stuff. You have to look past some weird symbolic stuff he puts in his books which nobody gets. However, his way of structuring problems in SQL is artful magic. Magic I tell you!

Now just stand back and enjoy the spectacle of all the screamers who post on AT to shout me down that you should start with PostGRE. Ignore them. This is a MySQL world.

Last edited by ringtail; 12-18-2012 at 10:35 PM. Reason: never claimed I was a competent typist!
ringtail is offline   Reply With Quote
Old 01-12-2013, 03:52 PM   #10
Golden Member
Join Date: Jun 2004
Posts: 1,237

Sounds like a smallish amount of data which doesn't change every day. Sounds like it would be nice if Outlook worked for what you need.

You can tag things into categories:

What else besides export to Excel do you need it to do?

What kind of access and security requirements does the system have to have?
Who will be able to enter data? HR people?

If you can use some of your existing MS programs, that'd probably be for the best. If using Outlook, the users could just look it up as they need it and not take up your valuable time, time which it sounds like you need to study being a System Admin.

Last edited by trexpesto; 01-12-2013 at 04:01 PM.
trexpesto is offline   Reply With Quote

Thread Tools

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

Forum Jump

All times are GMT -5. The time now is 05:16 AM.

Powered by vBulletin® Version 3.8.8 Alpha 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.