Indigo Rose Software

Professional Software Development Tools

 
Results 1 to 13 of 13
  1. #1
    Join Date
    May 2003
    Location
    Belarus
    Posts
    45

    SQLITE - how to secure my tables ?

    SQLITE - how to secure my tables ?
    I want to make examination program. I want to store question and answers in sqlite database. Could I secure my database against reading from anywhere (exept my auroplay)???
    Who know, please share this information for me

    Thanx

  2. #2
    Join Date
    Jul 2002
    Location
    USA
    Posts
    3,959
    Couple thought;

    1. You could encrypt the file, which would probably be a little work, and while your app was running, there would be a decrypted database somewhere that would be accessible.

    2. Encrypt the data that is being stored in the fields. Even if they open the DB with a DB editor, they wouldn't be able to understand what was there.

  3. #3
    Join Date
    Sep 2002
    Location
    Sol 3
    Posts
    3,160
    Quote Originally Posted by Worm
    2. Encrypt the data that is being stored in the fields. Even if they open the DB with a DB editor, they wouldn't be able to understand what was there.
    That was my thought. Although it may be a pain to encrypt everything. But at least it is safer.
    TJ-Tigger
    "A common mistake that people make when trying to design something completely foolproof was to underestimate the ingenuity of complete fools."
    "Draco dormiens nunquam titillandus."
    Map of IR Forum Users - IR Project CodeViewer - Online Help - TiggTV - QuizEngine

  4. #4
    Join Date
    May 2003
    Location
    Belarus
    Posts
    45

    Thanx

    Thanx,
    I thought so, I think that it is the best method for database in SQLite. Could you suggest any method for encryption. I think it will be function. But what method to put inside?
    THNX, for answer.

  5. #5
    Join Date
    Aug 2003
    Location
    Maine, USA
    Posts
    1,695
    You always have AMS' zip function as well. You could password protect the files and have AMS auto unzip with the password when called - a bit more processing, but should work.

  6. #6
    Join Date
    May 2003
    Location
    Belarus
    Posts
    45

    How to secure text string with Blowfish by Encryption Plugin ????????????????

    I think that the best way is to use Encryption plugin. But who can help me to find way to secure text string (not file, like in plugin) ???
    How to secure text string with Blowfish by Encryption Plugin ????????????????

  7. #7
    Join Date
    May 2003
    Location
    Belarus
    Posts
    45

    I found. THNX to everybody


  8. #8
    Join Date
    Nov 2003
    Posts
    35

    SQLite password?

    Does SQLite support a username/password which could be passed by the application to open the database? If not, will this be added in the future?

  9. #9
    Join Date
    Dec 2003
    Posts
    891

    encrypt the encryption

    I experimented with using the zip and crypto p/i in a similiar project. Zip encrypt a folder with crypto encypted files. At app startup, zip decrypts the folder to the users temp directory. Then as the files are needed, crypto p/i decrypts the file to ANOTHER user temp/folder (And, with a little more code, generate random temp/folder names when decrypting the crypto files). Then when the entry action is done (or a save button accessed), re-encrypt the just used file back to the zip decrypted folder using crypto p/i and deleting the just used file and temp/folder. If the data is to be saved, just have a button to save it back to the app folder, then delete the zip decrypted folder from the hard drive on app exit. If it is not to be saved, then just delete the zip decrypted folder from the hard drive on app exit.
    Sounds a little complcated. However, it's just a few lines of code. The zip is a little slower, so you only have to do it once. The crypto is fast and unless the files are huge, you wont even see a pause when it's doing it's thing. The benefit is that it gives the "hacker" two different encryptions to get through, and two different folders to find, and the crypto, with small files, can be modified and saved on the fly.
    Just a thought.

  10. #10
    Join Date
    Jun 2003
    Posts
    6
    Do you have any sample code that I can look at?

    Thanks
    Steve

  11. #11
    Corey is offline Indigo Rose Staff Alumni
    Join Date
    Aug 2002
    Posts
    9,746
    Hi. FWIW Sqlite isn't currently a terribly secure database but no doubt there will be certain security features added in future versions. That being said it seems to me that it will be a fairly large task to make it fully secure though. Best solution for critical applications today is probably a remote database such as MySQL which you can interface to via your AMS app. Any typical $10 month hosting account can provide you with a reasonably secure back end for your AMS apps, such as the 4U account from http://www.tera-byte.com for example (that's what I use). Hope that helps somewhat.

  12. #12
    Join Date
    Dec 2003
    Posts
    891

    example code

    My workbox is apart on the bench waiting for a new CPU to be delivered. Hopefully today, but for sure tomorrow. Once I get it going, I'll make a quick apz for you.

  13. #13
    Join Date
    Jun 2003
    Posts
    6
    Thanks Roboblue! Examples are much better for me to learn from.

Similar Threads

  1. Secure FTP
    By TJ_Tigger in forum AutoPlay Media Studio 5.0
    Replies: 4
    Last Post: 08-19-2008, 04:46 PM
  2. Spotlight: SQLite Actions Plugin
    By Desmond in forum AutoPlay Media Studio 5.0
    Replies: 0
    Last Post: 03-12-2004, 09:11 AM
  3. Always confusing with tables
    By arnaud in forum AutoPlay Media Studio 5.0
    Replies: 3
    Last Post: 01-25-2004, 06:33 PM
  4. Working with Tables and Files
    By Desmond in forum AutoPlay Media Studio 5.0 Examples
    Replies: 0
    Last Post: 12-23-2003, 08:22 AM
  5. Replies: 0
    Last Post: 06-22-2003, 06:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts