Which database / programming environment to chose

This is a discussion on Which database / programming environment to chose within the databases forums in Other Databases category; Here my situation: good knowledge of programming in general, good knowledge on relational databases in general.. no specific knowledge I've worked in access, SQLServer, MySQL and php (a lot with this one), SqLite and Ruby/Python... I need to chose a practical way to develop a program for my company to manage document lists and revisions. I need something simple and good reporting capabilities.. What else apart from access and filemaker? Is reporting easy enough in visualStudio + c# ?? suggestions welcome! Luca...

Go Back   Database Forum > Other Databases > databases

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-21-2008, 12:07 PM
Default Which database / programming environment to chose

Here my situation: good knowledge of programming in general, good
knowledge on relational databases in general.. no specific knowledge

I've worked in access, SQLServer, MySQL and php (a lot with this one),
SqLite and Ruby/Python...

I need to chose a practical way to develop a program for my company to
manage document lists and revisions.
I need something simple and good reporting capabilities..
What else apart from access and filemaker? Is reporting easy enough in
visualStudio + c# ??

suggestions welcome!
Luca
Reply With Quote
  #2  
Old 08-21-2008, 01:11 PM
Default Re: Which database / programming environment to chose

On 21.08.2008 17:07, Snaggy wrote:
> Here my situation: good knowledge of programming in general, good
> knowledge on relational databases in general.. no specific knowledge
>
> I've worked in access, SQLServer, MySQL and php (a lot with this one),
> SqLite and Ruby/Python...
>
> I need to chose a practical way to develop a program for my company to
> manage document lists and revisions.
> I need something simple and good reporting capabilities..
> What else apart from access and filemaker? Is reporting easy enough in
> visualStudio + c# ??
>
> suggestions welcome!


Difficult with these rudimentary specifications. How many users are
there? Do you need to implement workflows? How large do you expect the
data set to grow? Do you need a web frontend? ...

From what you write I am pretty sure that you can buy something like
that already. Then there would be the question: why roll your own?

Kind regards

robert
Reply With Quote
  #3  
Old 08-21-2008, 01:40 PM
Default Re: Which database / programming environment to chose

no, it's not so big. Would be max 10 users with something like 100
documents, each with a few revisions..
no web interface needed

what would you do?
Reply With Quote
  #4  
Old 08-21-2008, 05:35 PM
Default Re: Which database / programming environment to chose

On 21.08.2008 18:40, Snaggy wrote:
> no, it's not so big. Would be max 10 users with something like 100
> documents, each with a few revisions..
> no web interface needed
>
> what would you do?


I'd probably use something like SqLite and a script language that
supports it. How tamper proof does your solution have to be? In that
case you need something with user management.

Depending on your reports generating them in HTML is pretty easy. If
you need charts then it's more effort.

I'd say take what you're comfortable with.

Cheers

robert
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 08:10 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.