Results 1 to 11 of 11

Thread: AES-256 encrypted SQLite databases with SQLCipher

  1. #1
    Join Date
    Jan 2006
    Location
    Germany
    Posts
    4,380
    Thanks
    19
    Thanked 1,005 Times in 913 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows Symbian S60
    Wiki edits
    5

    Default AES-256 encrypted SQLite databases with SQLCipher

    Hi,

    the «Neverending Story» about encrypted SQLite databases ends now! With SQLCipher you can add transparent, full database, AES-256 encryption with minimal performance impact to your databases. For how you can build the needed sql driver, I have wrote some wiki pages which guide you through the installation and compiling process.
    They are not fully polished yet, but they will in future... A build instruction for Mac OSX follows within the next days.

    [WIKI]Building QSQLITE driver with AES-256 encryption support[/WIKI]


    Best,

    Lykurg

  2. The following user says thank you to Lykurg for this useful post:

    berzasnon (27th August 2013)

  3. #2
    Join Date
    Mar 2009
    Location
    Brisbane, Australia
    Posts
    7,729
    Thanks
    13
    Thanked 1,610 Times in 1,537 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Wiki edits
    17

    Default Re: AES-256 encrypted SQLite databases with SQLCipher

    Thanks for this. I was planning to do exactly this but hadn't reached the stage of necessity yet. I still might have to merge it with Spatialite which no doubt will provide hours of fun.

  4. #3
    Join Date
    Jan 2006
    Location
    Warsaw, Poland
    Posts
    33,359
    Thanks
    3
    Thanked 5,015 Times in 4,792 Posts
    Qt products
    Qt3 Qt4 Qt5 Qt/Embedded
    Platforms
    Unix/X11 Windows Android Maemo/MeeGo
    Wiki edits
    10

    Default Re: AES-256 encrypted SQLite databases with SQLCipher

    Good job. I think the security of such solution is limited as you still need to have the encryption key somewhere but good job nevertheless.
    Your biological and technological distinctiveness will be added to our own. Resistance is futile.

    Please ask Qt related questions on the forum and not using private messages or visitor messages.


  5. #4
    Join Date
    Sep 2010
    Posts
    2
    Qt products
    Qt3 Qt4
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: AES-256 encrypted SQLite databases with SQLCipher

    this work for mobile app too? ( symbian ^3, Maemo / meego, Symbian s60 )

  6. #5
    Join Date
    Jan 2006
    Location
    Germany
    Posts
    4,380
    Thanks
    19
    Thanked 1,005 Times in 913 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows Symbian S60
    Wiki edits
    5

    Default Re: AES-256 encrypted SQLite databases with SQLCipher

    It should. Haven't tried so far, and the next weeks I have no time to do so. But in December I am planing to compile it for my new N8

  7. #6
    Join Date
    Jan 2006
    Location
    Warsaw, Poland
    Posts
    33,359
    Thanks
    3
    Thanked 5,015 Times in 4,792 Posts
    Qt products
    Qt3 Qt4 Qt5 Qt/Embedded
    Platforms
    Unix/X11 Windows Android Maemo/MeeGo
    Wiki edits
    10

    Default Re: AES-256 encrypted SQLite databases with SQLCipher

    Quote Originally Posted by Lykurg View Post
    But in December I am planing to compile it for my new N8
    ...that you won during DevDays. Yeay!
    Your biological and technological distinctiveness will be added to our own. Resistance is futile.

    Please ask Qt related questions on the forum and not using private messages or visitor messages.


  8. #7
    Join Date
    Sep 2010
    Posts
    2
    Qt products
    Qt3 Qt4
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: AES-256 encrypted SQLite databases with SQLCipher

    did you compile for the N8? it works? because i'm looking for something like this for my app

  9. #8
    Join Date
    Dec 2010
    Posts
    13
    Thanks
    6
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: AES-256 encrypted SQLite databases with SQLCipher

    Can one encrypt a database after creating it with another tool? i.e. I already have nameDB.db, QSQLITE will not encrypt it since it is already created.

  10. #9
    Join Date
    Jan 2006
    Location
    Germany
    Posts
    4,380
    Thanks
    19
    Thanked 1,005 Times in 913 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows Symbian S60
    Wiki edits
    5

    Default Re: AES-256 encrypted SQLite databases with SQLCipher


  11. #10
    Join Date
    Aug 2009
    Location
    Greece
    Posts
    69
    Thanks
    2
    Thanked 14 Times in 14 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: AES-256 encrypted SQLite databases with SQLCipher

    I made a simple app to act as a template for creating encrypted databases with SQLCipher. The app requires that you have a working SQLCipher driver and in no way try to build one. You can find it on:
    https://bitbucket.org/sjemens/dbkeystore

    If you use mercurial try
    hg clone https://bitbucket.org/sjemens/dbkeystore

    Any comments and suggestions are welcomed.

  12. #11
    Join Date
    Jul 2011
    Posts
    11
    Thanks
    1
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: AES-256 encrypted SQLite databases with SQLCipher

    If applying this change to QT, can I still use QT with LGPL license?

Similar Threads

  1. Loading and saving in-memory SQLITE databases
    By miraks in forum Qt Programming
    Replies: 10
    Last Post: 27th April 2010, 22:24
  2. TcpSocket encrypted() signal
    By eleanor in forum Qt Programming
    Replies: 0
    Last Post: 23rd April 2009, 07:44
  3. Qt and databases
    By gt.beta2 in forum Newbie
    Replies: 6
    Last Post: 18th February 2009, 09:39
  4. Encrypted XML in Qt?
    By viking in forum Qt Programming
    Replies: 4
    Last Post: 12th December 2007, 11:37
  5. sending encrypted data via mail using smtp
    By vermarajeev in forum General Programming
    Replies: 20
    Last Post: 14th August 2007, 20:47

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.