1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

C# - Local SQL Database. Couple of questions!

Discussion in 'C, C++, C#' started by TheeAriGrande, Aug 23, 2013.

  1. TheeAriGrande

    TheeAriGrande Regular Member

    Joined:
    Jul 14, 2013
    Messages:
    270
    Likes Received:
    151
    Location:
    Candlestick Park
    How's everybody doing?

    I'm in the process of coding my first bot. Then next step requires an sql database. I've been reading a lot of material the past few weeks and I still have some question.

    I want the database to be a local database. It's going to consists of 3-5 tables. There's going to be a lot of reading. I'll be inserting large amounts of data once everyday or so.

    Depending on the user, the amount of data stores could be very small or very large.

    Now for the questions:

    Which type of database should I go with? SQL CE, SQL Lite, or some other sql type?

    Should I be worried about the database file becoming to large?

    Thanks for any help!

    Posted via Topify using iPhone/iPad
     
  2. neutralhatter

    neutralhatter Jr. VIP Jr. VIP Premium Member

    Joined:
    Jun 23, 2010
    Messages:
    430
    Likes Received:
    330
    Go for SQL lite, it's tiny, widely used and fast as a local database. Plus your database will only be a file. Visual studio might even support it in Server Explorer. If it doesn't search for it in the online extension, I'm quite sure there is one for free.

    Good luck.
     
    • Thanks Thanks x 1
  3. qrazy

    qrazy Senior Member

    Joined:
    Mar 19, 2012
    Messages:
    1,111
    Likes Received:
    1,712
    Location:
    Banana Republic
    • Thanks Thanks x 1
  4. kevinkrieger

    kevinkrieger Newbie

    Joined:
    Sep 5, 2013
    Messages:
    32
    Likes Received:
    3
    Occupation:
    SEO
    Location:
    India
    Home Page:
    SQLite is great and fast with widely used language its database files are also cross platform compatible.SQLite is also simple to maintain
     
  5. Panther28

    Panther28 Elite Member

    Joined:
    May 2, 2010
    Messages:
    2,268
    Likes Received:
    3,405
    Occupation:
    Internet.
    Location:
    Internet.
    i would recommend sql, unless you require micro transaction speed there is very little difference in terms of however we would measure "speed"

    sql has more commands, and you will find it easier to migrate to a decent db once you start using it more.
     
  6. botrockets

    botrockets Regular Member

    Joined:
    Mar 16, 2013
    Messages:
    272
    Likes Received:
    463
    Occupation:
    Software Developer
    Location:
    Saint T.N.
    Go for SQL CE with Entity Framework 5.0.
    You will not regret.