1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Opinions Kindly Required for Student Project

Discussion in 'Databases' started by Greg Bullock, Mar 19, 2015.

?

Is SQL Server a Suitable and Reliable Choice for Storing/Serving Data to a Web Application?

  1. Yes, I have used SQL Server and Would Recommend it for this scenario.

    1 vote(s)
    100.0%
  2. No, I have used SQL Server and Would Not Recommend it for this scenario.

    0 vote(s)
    0.0%
  1. #1
    Dear all,

    I am currently undertaking an academic project to design & build a Web Application (using HTML5 and open standards) that will require a data storage method and a means of serving the data to the Web Application.

    Data will include items such as simple statistics in numeric format and information in text format.

    I am considering using SQL Server as the technology choice for the database, to be hosted online via a suitable web server and accessed by the web application's data API.

    It is important that the data technology used is capable of providing data exports in standard formats (CSV etc.) and accepts data imports using standard methods (SQL script).

    In order to assist me with making this choice, I would be very grateful if anyone who has experience of using SQL Server with Web Applications in this way could provide brief feedback, stating if you feel SQL Server is a suitable/reliable approach.

    Thank you for your help with this.
    SEMrush
    Best wishes,

    Greg
     
    Greg Bullock, Mar 19, 2015 IP
    SEMrush
  2. scott_r

    scott_r Greenhorn

    Messages:
    42
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    23
    #2
    As with most software choices, it depends on what you're doing. And in this case, what software you're writing the web app in. While PHP and other languages and frameworks have database connection options for SQL Server, if you're going to host the app on Linux you'll need to host the database server on a Windows machine.

    Of course, if you're going to write your app in ASP.NET, go for it! It's a good database. Though to do the imports/exports you're talking about, I believe you need to use SQL Server Integrations Services--just depends on how complex the import and export process is.
     
    scott_r, Apr 23, 2015 IP
  3. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,630
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #3
    If you're using "HTML 5 and open standards" SQL Server is a poor choice. Why not just use MySQL? Or, if you don't want to use that, what about MariaDB? Any type of database that can be used for interaction with a programming language (ie, all of them), can be made to export / import in whatever format you chose.
     
    PoPSiCLe, Apr 24, 2015 IP