|
|
| Page 1 of 1 |
[sYn]
[Moderator] Elitist
Posts: 8374
|
 Posted: Thu, 10th Aug 2006 12:33 Post subject: Database Advice |
|
 |
I'm building a HR database for the company I'm freelancing for, obviously the easiest option is access (which is also something they would like) but I was wondering about how legit an access database is? Are there any licensing issues?
Is there an open source alternative? Maybe an application that makes better use of networked database access? Or maybe just an application someone can suggest/recommend?
I am also considering doing it from scratch and programing it all myself, or possibly doing a web based system..
Thoughts?
|
|
| Back to top |
|
|
|
|
| Posted: Thu, 10th Aug 2006 16:03 Post subject: |
|
|
PostgreSQL is a pretty good open source database. Access is very easy to use but limited in the size of the database. If I remember right they only let you make databases around 2 gigs in size. So its not very scalable.
|
|
| Back to top |
|
|
[sYn]
[Moderator] Elitist
Posts: 8374
|
| Posted: Thu, 10th Aug 2006 16:20 Post subject: |
|
|
Good point that I didn't consider. I will have to do some tests to see exactly how much data we will need to be storing, from what I can gather it wont be anything like 2gb, but you never know, the company may want to use this database for years to come.
|
|
| Back to top |
|
|
|
|
| Posted: Thu, 24th Aug 2006 06:50 Post subject: |
|
|
Also consider that Access has connection limitations. I.E. if lots of people want to access the database simultaneously, there will be performance issues that would have to be overcome with a SQL Server solution. That may not be a problem for you.
Generally, if it's a smaller database with only a few concurrent connections, Access is just fine. Also, you don't need MS Access to utilize Access databases. Robust web-based or desktop solutions can be created using Access databases with simple VB programming knowledge. Let us know what you picked.
Oh, I forgot to mention SQL Server 2005 Express, which is free and is a scaled-down version of SQL Server that is faster and more secure than a standard Access solution.
|
|
| Back to top |
|
|
[sYn]
[Moderator] Elitist
Posts: 8374
|
|
| Back to top |
|
|
| Page 1 of 1 |
All times are GMT + 1 Hour |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB 2.0.8 © 2001, 2002 phpBB Group
|
|
 |
|
! Doing the site in ASP.NET 2.0.. Its going pretty well, about to start work on the actual data entry, which should be fun 
!
