Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C#
  4. Local Database vs XML

Local Database vs XML

Scheduled Pinned Locked Moved C#
databasecsharpsql-servervisual-studiosysadmin
4 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L Offline
    L Offline
    Libor Tinka
    wrote on last edited by
    #1

    I saw a few imaging programs, that use local database for storing data about images and thus provide extremely fast image search (wihtout accessing files). I want to implement this: database for faster file search in my C# app, but any SQL tutorial begins with installation of some server tools. However, end user does not have these tools. I also cannot force him to install MS SQL Server, because he may not use Windows (my app should work on other platforms). So I'm confused. Is is possible to use databases as well (in app release, that does not contain huge server tools) or it is better to use some alternative (e.g. store all the data in single XML file)? Thanks a lot, Libor Tinka

    S L P 3 Replies Last reply
    0
    • L Libor Tinka

      I saw a few imaging programs, that use local database for storing data about images and thus provide extremely fast image search (wihtout accessing files). I want to implement this: database for faster file search in my C# app, but any SQL tutorial begins with installation of some server tools. However, end user does not have these tools. I also cannot force him to install MS SQL Server, because he may not use Windows (my app should work on other platforms). So I'm confused. Is is possible to use databases as well (in app release, that does not contain huge server tools) or it is better to use some alternative (e.g. store all the data in single XML file)? Thanks a lot, Libor Tinka

      S Offline
      S Offline
      Sceptic Mole
      wrote on last edited by
      #2

      Libor Tinka wrote:

      Is is possible to use databases as well (in app release, that does not contain huge server tools)

      SQLite[^] is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.

      1 Reply Last reply
      0
      • L Libor Tinka

        I saw a few imaging programs, that use local database for storing data about images and thus provide extremely fast image search (wihtout accessing files). I want to implement this: database for faster file search in my C# app, but any SQL tutorial begins with installation of some server tools. However, end user does not have these tools. I also cannot force him to install MS SQL Server, because he may not use Windows (my app should work on other platforms). So I'm confused. Is is possible to use databases as well (in app release, that does not contain huge server tools) or it is better to use some alternative (e.g. store all the data in single XML file)? Thanks a lot, Libor Tinka

        L Offline
        L Offline
        Lju2
        wrote on last edited by
        #3

        Good alternative to real database servers is so called "embedded databases"

        1 Reply Last reply
        0
        • L Libor Tinka

          I saw a few imaging programs, that use local database for storing data about images and thus provide extremely fast image search (wihtout accessing files). I want to implement this: database for faster file search in my C# app, but any SQL tutorial begins with installation of some server tools. However, end user does not have these tools. I also cannot force him to install MS SQL Server, because he may not use Windows (my app should work on other platforms). So I'm confused. Is is possible to use databases as well (in app release, that does not contain huge server tools) or it is better to use some alternative (e.g. store all the data in single XML file)? Thanks a lot, Libor Tinka

          P Offline
          P Offline
          Paul Conrad
          wrote on last edited by
          #4

          Libor Tinka wrote:

          he may not use Windows (my app should work on other platforms)

          Are you planning on having your app work with Mono?

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups