*** 88,93 ****
--- 88,101 ----
*:IF EXISTS function, e.g. "DROP TABLE IF EXISTS temp;"
*:a password('') function to mask some values (as used in MySQL) would be fine, I need it, if I give the db out of the house, or is there something I didn't find?
+ _::: My understanding of this request is that you want to be able to export non-public related data to external parties, thus hiding confidential information from them. I have a similar situation and it is relatively simple to export the database - just export the bits you want using the sqlite command line tool in 'insert' mode. For example :
+ sqlite info.db
+ .mode insert
+ SELECT version, date, name, summary FROM logs;
+
+ _::: Which would hide other fields that 'logs' might contain - such information as the details of the change, any private annotations or whatever you might store in other fields.
+
+ _::: This form of reconstructing the database rather than exporting it with some form of encryption ensures that no data that you didn't intend to release is given away. If the data is there, even if it's behind the best encryption in the world, it might still be got at. If it isn't even present, you can't reconstruct it :-)
(Hey, the formatting of this page was screwed up, let's see if it's better now...)
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|