Hello Damien, I use the "encrypt specific fields" method of encrypting data in sqlite. For you to use that with Basic you'd probably have to find or write a wrapper DLL which handled the field encryption. So your basic would only see unencrypted data after it sent a password to the DLL.
I know this probably makes it a non-starter for you. C Saturday, October 8, 2016, 1:46:02 AM, you wrote: DSL> Hi there, DSL> My name is Damien Lindley, and I am, among other things, an DSL> independent, hobbiest programmer. I have been blind since birth DSL> and thus all my computer work relies on screenreader software and keyboard. DSL> I have only just come through the brink of scripting into DSL> compiled programming and so I guess I am still a beginner in many DSL> respects. However I don’t work in C or C++, so most of my DSL> programming, if using a library, relies on precompiled static or DSL> dynamic libraries. Or of course libraries that are written or DSL> converted specifically for the language I work in (FreeBASIC). DSL> Recently, I decided I needed to create a piece of software that DSL> could manage family trees, since there seems to be a lack of DSL> screenreader accessible genealogy managers out there. I was DSL> advised the best way to do this is to use a database engine. I DSL> was also informed that SQLite is always a good choice for databases. DSL> I must admit, I have never worked with databases before and so DSL> now I am in the process of learning SQL. However looking at the DSL> programming API for SQLite I cannot see any means of password DSL> protecting the database without either buying a commercial DSL> extension to do this, or recompiling SQLite with the DSL> authentication extension. Due to financial constraints and DSL> unfamiliarity with compiling in C both of these are not an option DSL> for me. Also I need a secure way to do this, as I think I read DSL> that the SQLite version simply uses a table to store the user DSL> data, which of course can be read and accessed elsewhere. DSL> Are there any other options available for doing this? DSL> Any help appreciated. DSL> Thanks. DSL> Damien. DSL> _______________________________________________ DSL> sqlite-users mailing list DSL> sqlite-users@mailinglists.sqlite.org DSL> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users