Go Back   AnandTech Forums > Software > Programming

Forums
· Hardware and Technology
· CPUs and Overclocking
· Motherboards
· Video Cards and Graphics
· 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
· Merchandise and Shopping
· For Sale/Trade
· Hot Deals with Free Stuff/Contests
· Black Friday 2014
· Forum Issues
· Technical Forum Issues
· Personal Forum Issues
· Suggestion Box
· Moderator Resources
· Moderator Discussions
   

Reply
 
Thread Tools
Old 12-05-2012, 06:50 PM   #1
raygunpk
Member
 
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, 07:49 PM   #2
douglasb
Diamond Member
 
Join Date: Apr 2005
Posts: 3,163
Default

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, 10:41 PM   #3
Leros
Lifer
 
Leros's Avatar
 
Join Date: Jul 2004
Location: Austin, TX
Posts: 21,481
Default

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.
Leros is offline   Reply With Quote
Old 12-05-2012, 11:32 PM   #4
beginner99
Platinum Member
 
Join Date: Jun 2009
Posts: 2,160
Default

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, 12:21 AM   #5
Markbnj
Moderator
Programming
 
Markbnj's Avatar
 
Join Date: Sep 2005
Posts: 12,379
Default

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, 01:27 AM   #6
raygunpk
Member
 
Join Date: Jan 2005
Posts: 108
Default

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, 08:50 AM   #7
Tweak155
Diamond Member
 
Tweak155's Avatar
 
Join Date: Sep 2003
Location: Michigan
Posts: 8,869
Default

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 92-0-0
Tweak155 is offline   Reply With Quote
Old 12-18-2012, 11:27 AM   #8
pauldun170
Platinum Member
 
pauldun170's Avatar
 
Join Date: Sep 2011
Posts: 2,017
Default

Quote:
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
Then
File>Import Export> export to a file> Excel
pauldun170 is offline   Reply With Quote
Old 12-18-2012, 09:21 PM   #9
ringtail
Senior Member
 
ringtail's Avatar
 
Join Date: Mar 2012
Location: USA left coast
Posts: 732
Default

raygunpk,

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 09:35 PM. Reason: never claimed I was a competent typist!
ringtail is offline   Reply With Quote
Old 01-12-2013, 02:52 PM   #10
trexpesto
Golden Member
 
Join Date: Jun 2004
Posts: 1,237
Default

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:
http://www.timeatlas.com/email/outlo...ook_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 03:01 PM.
trexpesto is offline   Reply With Quote
Reply

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 10:49 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.