What database are you using?

Daer Srs.

I actually would like to know what databases do you usually use..
or what would you recomend for a not very simple winapp



Answer this question

What database are you using?

  • xRuntime

    how do you mean "what database do you usually use"

    Everyone has their own way/product they use. It also depends on the type of application.

    Please tell us the type of application you are creating.

    Some people use Xml to store data locally, which is ideal for a mini mini database

    some people use MS Access locally to store data instead of using SQL Server - this would be a better approach if you are not doing major database stuff

    some people use SQL Server because not only is it industry standard but because it is good at managing and processing large amounts of data, which has more potential than MS Access, since MS Access was designed for a "small" environment, if that makes sense

     

    again, it depends on your application

     

    There is no MSDE 2005 - there is SQL Server Express 2005, a free (but limited) version of SQL Server



  • Lorry Craig

    Usually I used the Access to do some small developing, and in productive system, either Oracle or SQL

  • Wyatt Earp

    I test on MSSQL 2005, but run my company's 2 major apps on MSSQL 2000. If you're just making a small windows application, I think you can use the free MSDE 2005 for it.

    GL,
    Jasmine



  • JamesPMiller

    If you are doing lots of simple stuff and mainly data storage then XML might be the way for you.

    If you want to live on the edge and need more advanced data manipulation such as sorting and inserting then you might want to take a look at LINQ. Linq offers a fine line between simple XML and advanced databases without going into a full blown database which can be a nightmare to begin off with, especially when it comes to deploying it or giving it to your firneds or a few small businesses. I think LINQ really simplifies that if you dont need ALL of the functionality of a database.

    If you do need the fully blown power of a database then i strongly recommend MS SQL 2005. There are many versions some of which are free.

    You should probably let us know what your application is going to do and who your intended target is (who will be using it). Then we will be able to provide more accurate advice.


  • RPalmer

    I Use SQL Server Express if I can (limit is 4GB database size), since it's free and very good.

    http://msdn.microsoft.com/vstudio/express/sql/

    Otherwise, I use SQL Server.

  • What database are you using?