+ Post New Thread
Results 1 to 5 of 5
Coding Thread, Which language for database driven application in Coding and Web Development; Hi, I've always used Microsoft Access to hold my data but I don't like using it anymore. It doesn't look ...
  1. #1

    Join Date
    Sep 2007
    Posts
    21
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Which language for database driven application

    Hi,

    I've always used Microsoft Access to hold my data but I don't like using it anymore. It doesn't look or feel professional.

    I want to build an application that can allow me to query, append, delete data and produce reports. Similar features that access offers but i want it to be a standalone application.

    Any advice on how best to do this? I was thinking VB + ADO.

  2. #2

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123

    Re: Which language for database driven application

    If you've not got a lot of code already for VB/ADO then go straigh to VB.Net and ADO.Net - there's a whole raft of stuff in there which makes it very easy to work with data.

    This will talk to just about any kind of data store; you can continue to use the .mdb database if you want or you can move to a SQL database. SQL 2005 Express is free and great for most things.

    the other thing to consider is doing all this as web pages - if you're producing this for internal use then you've presumably got an IIS server that you can put it on. The benefit of this is that it will just work on any computer with a web browser - nothing to install or mess up on the client machines!

  3. #3

    Join Date
    Sep 2007
    Posts
    21
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Which language for database driven application

    I could easily do this web based, but I've never developed a desktop application before. I've done quite a bit of web work.

    I'd like to have the experience of making my own app too :P

  4. #4

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,037
    Thank Post
    209
    Thanked 425 Times in 306 Posts
    Rep Power
    144

    Re: Which language for database driven application

    If you're doing it as an application, I would choose VB.net as it's very easy to learn, and talks nicely to an SQL backend or Access if you prefer. (as also metioned above)

    If you wanted to do this Web based, which I would choose if more than a few people are likely to be using it at once, or if you're going to want to use it from multiple locations, then I'd choose PHP with a mySQL backend, mainly because I'm familure with it, but again it's easy to learn. The other big advantage of a web based application is you don't need it installed on each machine, and all the database processing is done by the backend, so it's more secure in many ways.

    I've written PHP applications to run a helpdesk system, provide extensive reporting on the helpdesk, provide asset managetment, toner cartridge management and monitoring, user logon tracking and associated reporting, an order management system for our site team and a few other things. Any problem we get, I usually end up writing a PHP solution for it!

    Mike

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,660
    Thank Post
    516
    Thanked 2,444 Times in 1,892 Posts
    Blog Entries
    24
    Rep Power
    831

    Re: Which language for database driven application

    Personally, having some formal Java training, I would choose either Java or C# for a desktop app. If it is a server app, I would go for PHP and use a bit of AJAX to make the front end more usable.

SHARE:
+ Post New Thread

Similar Threads

  1. What Language Next
    By russdev in forum Coding
    Replies: 29
    Last Post: 21st April 2008, 12:30 PM
  2. Language
    By russdev in forum General EduGeek News/Announcements
    Replies: 16
    Last Post: 29th December 2007, 01:04 PM
  3. Database driven webpage
    By DSapseid in forum Web Development
    Replies: 4
    Last Post: 22nd May 2007, 10:46 AM
  4. Language Lab
    By rusty155 in forum General Chat
    Replies: 4
    Last Post: 12th March 2007, 12:20 PM
  5. Replies: 4
    Last Post: 28th February 2007, 09:37 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •