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

  • Thread starter Thread starter Jesse Aufiero
  • Start date Start date
J

Jesse Aufiero

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!!
 
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 said:
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.
Click to expand...

Access is not a good choice. Try Firebird embedded version:
http://firebird.sourceforge.net/

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/
"Programming is an art form that fights back"

Get your ASP.NET in gear with IntraWeb!
http://www.atozed.com/IntraWeb/
 
Back
Top