persistent data source (light footprint, secure, supports sql query engine)

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jesse Aufiero

    #1

    persistent data source (light footprint, secure, supports sql query engine)

    I am creating a vb.net app that displays historical financial data in
    various ways (grids, charts, etc.). This data is sensitive and should only
    be accessible through the vb.net application. The vb.net application must
    also be able to issue sql select stmnts against the persistant data source
    in order to get a wide variety of result sets back, for use in the
    application's grids and charts.

    How can I have my data in a completely secure place, and still have the
    ability to issue sql stmnts against it?

    SQL Server is not an option because the installation of my application must
    be simple and 'lightweight'.. . and we're not talking about a massive amount
    of data here.

    Can an access database be embedded into the vb.net application? I would
    rather not keep the .mdb outside the vb.net application because that is an
    invitation to tampering and hacks.

    Thanks!!


  • Marina

    #2
    Re: persistent data source (light footprint, secure, supports sql query engine)

    You can't embed it in an application, since you would have no way of writing
    to it.

    If you have simple SQL statements, maybe you can use an XML file and use
    XPath to perform queries on it? An XML file can be encrypted and stored
    securely.

    "Jesse Aufiero" <jaufiero@moabo il.com> wrote in message
    news:%23OFb0uKf FHA.1416@TK2MSF TNGP09.phx.gbl. ..[color=blue]
    >I am creating a vb.net app that displays historical financial data in
    >various ways (grids, charts, etc.). This data is sensitive and should only
    >be accessible through the vb.net application. The vb.net application must
    >also be able to issue sql select stmnts against the persistant data source
    >in order to get a wide variety of result sets back, for use in the
    >application' s grids and charts.
    >
    > How can I have my data in a completely secure place, and still have the
    > ability to issue sql stmnts against it?
    >
    > SQL Server is not an option because the installation of my application
    > must be simple and 'lightweight'.. . and we're not talking about a massive
    > amount of data here.
    >
    > Can an access database be embedded into the vb.net application? I would
    > rather not keep the .mdb outside the vb.net application because that is an
    > invitation to tampering and hacks.
    >
    > Thanks!!
    >[/color]


    Comment

    • Chad Z. Hower aka Kudzu

      #3
      Re: persistent data source (light footprint, secure, supports sql query engine)

      "Jesse Aufiero" <jaufiero@moabo il.com> wrote in
      news:#OFb0uKfFH A.1416@TK2MSFTN GP09.phx.gbl:[color=blue]
      > SQL Server is not an option because the installation of my application
      > must be simple and 'lightweight'.. . and we're not talking about a
      > massive amount of data here.
      >
      > Can an access database be embedded into the vb.net application? I
      > would rather not keep the .mdb outside the vb.net application because
      > that is an invitation to tampering and hacks.[/color]

      Access is not a good choice. Try Firebird embedded version:
      Download Firebird for free. A powerful, cross platform, SQL database system. Firebird RDBMS offers ANSI SQL features & runs on Linux, Windows & several Unix platforms. Features excellent concurrency & performance & powerful stored procedure & trigger language.


      You ship just ONE DLL - thats it.

      Its free BTW,and open source.


      --
      Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
      "Programmin g is an art form that fights back"

      Get your ASP.NET in gear with IntraWeb!

      Comment

      Working...