# SQLCipher 3.2.0 Release
**URL:** https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198
**Category:** SQLCipher
**Created:** [October 13, 2014, 4:44pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198 "2014-10-13T16:44:51Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@developernotes](https://discuss.zetetic.net/u/developernotes)
#### Post date: [October 13, 2014, 4:44pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/1 "2014-10-13T16:44:51Z")
The latest release of SQLCipher, [version 3.2.0](https://github.com/sqlcipher/sqlcipher/releases/tag/v3.2.0) which is based on the stable upstream release of SQLite 3.8.6 is now available. With this release, we would like to highlight a few specific changes that were introduced. First, a new PRAGMA, `cipher_store_pass` which allows for the source passphrase to be stored in RAM, even after key derivation. Typically the source passphrase is zeroed from memory once a key is computed. Now, if `PRAGMA cipher_store_pass` is set, operations such as an [ATTACH database](https://www.zetetic.net/sqlcipher/sqlcipher-api/#attach) command will used the passphrase stored in memory, thus the requirement to provide a KEY value are not needed unless a different value is required for the key. Note, `PRAGMA cipher_store_pass` is disabled by default and the memory is locked when supported on the given platform to prevent the memory from being paged into a swap file. When `PRAGMA cipher_store_pass` is enabled, the stored passphrase is wiped when the database is closed.
In this release we are happy to announce commercial support of [SQLCipher on Windows Phone 8.1](https://discuss.zetetic.net/sqlcipher/windows-phone). Finally, we have included a fix to the Common Crypto provider in which key derivation was occurring twice, this should reduce the first operation requiring KDF by 50%. SQLCipher for Android has been validaed on Android platforms 2.1 through Android L preview. Commercial builds for all supported platforms are available immediately. We are aware of the forthcoming SQLite 3.8.7 release, which promises to be up to 50% faster. We are planning to incorporate 3.8.7 in a follow-up release once it has been released and stabilized. We look forward to hearing your feedback with the latest release, please get in contact!
---
### Author:  [@BrendanD](https://discuss.zetetic.net/u/BrendanD)
#### Post date: [November 26, 2014, 1:09am UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/2 "2014-11-26T01:09:21Z")
Any idea when the 3.8.7 update will be out? SQLite is up to 3.8.7.2 now. Would love to get the performance enhancements.
Thanks!
Brendan
---
### Author:  [@RogerM](https://discuss.zetetic.net/u/RogerM)
#### Post date: [November 26, 2014, 4:47pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/3 "2014-11-26T16:47:12Z")
Ditto! That goes the same for me too! 🙂
---
### Author:  [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)
#### Post date: [November 28, 2014, 2:59pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/4 "2014-11-28T14:59:48Z")
We don’t have an exact date for the next release yet, but we’ll likely start merging soon since 3.8.7 appears to be stabilizing. Keep an eye out for updates!
---
### Author:  [@RogerM](https://discuss.zetetic.net/u/RogerM)
#### Post date: [December 28, 2014, 2:09pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/5 "2014-12-28T14:09:25Z")
Hi, do we have a rough timeframe when this is going to be released? It’s been a while now! Thanks!
---
### Author:  [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)
#### Post date: [December 29, 2014, 4:10pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/6 "2014-12-29T16:10:23Z")
Hello @RogerM - thanks for following up. Since the last update on this thread there were 2 more intermediate releases to SQLite upstream. There were many changes in 3.8.7, so we want to make sure things are stable before the integration process. We don’t have an exact timeline yet, but we’re going to evaluate again after the New Year Holiday.
Of note, if you’re using SQLCipher in an important commercial product and have an urgent need for updates, we do provide specialized support services, including custom builds, SLAs, etc which could accelerate a build for your required platforms. If you’re interested please feel free to get in touch at [support@zetetic.net](mailto:support@zetetic.net).
Thanks, and Happy New Year!
---
### Author:  [@jhenley](https://discuss.zetetic.net/u/jhenley)
#### Post date: [March 3, 2015, 10:12pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/7 "2015-03-03T22:12:17Z")
Hi sjlombardo,
I’m working on a Windows Phone 8.1 project in Visual Studio2015 CTP and I see the latest SQLite from SDK Extensions is version 3.8.8.3. Is there a SQLcipher release that I can try that is compatible with my environment (something newer than SQLCipher 3.2.0 perhaps?). This would help me greatly at the moment.
Thanks! -JeffH
---
### Author:  [@vikrant](https://discuss.zetetic.net/u/vikrant)
#### Post date: [July 17, 2015, 6:45am UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/8 "2015-07-17T06:45:21Z")
hi @sjlombarbo . can any one please tell me where will I find the sqlcipher libararies and give me step ny step integration in windows phone 8.1
---
### Author:  [@developernotes](https://discuss.zetetic.net/u/developernotes)
#### Post date: [July 17, 2015, 12:50pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/9 "2015-07-17T12:50:38Z")
Hello @vikrant
SQLCipher for Windows Phone is a commercial product. If you are a commercial license holder, please contact us at [support@zetetic.net](mailto:support@zetetic.net) and we can help you out. If not, licenses can be purchased [here](https://www.zetetic.net/sqlcipher/commercial-edition-ordering/).
---
### Author:  [@vikrant](https://discuss.zetetic.net/u/vikrant)
#### Post date: [July 20, 2015, 5:46am UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/10 "2015-07-20T05:46:46Z")
Are the sqlCipher sources free.Can they be used in windows phone 8.1 project in WPF(native application) @developernotes
---
### Author:  [@brodybits](https://discuss.zetetic.net/u/brodybits)
#### Post date: [July 20, 2015, 9:18am UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/11 "2015-07-20T09:18:14Z")
> Are the sqlCipher sources free.
The free version of sqlcipher sources is at:
> **[GitHub - sqlcipher/sqlcipher: SQLCipher is a standalone fork of SQLite that...](https://github.com/sqlcipher/sqlcipher)**
>
> SQLCipher is a standalone fork of SQLite that adds 256 bit AES encryption of database files and other security features. - GitHub - sqlcipher/sqlcipher: SQLCipher is a standalone fork of SQLite tha...
You may use it under its license which is BSD-style.
> Can they be used in windows phone 8.1 project in WPF(native application)
I am not personally familiar with WPF. I was able to use the sources
in a Windows/Windows Phone 8.1 Javascript application and support this
in my Cordova plugin. But you will not get support from the sqlcipher
project since they do not offer the Windows version for free. Please
do not ask again.
Also your questions demonstrate a lack of basic research and
preparation. While I do think the documentation could be improved,
people are expected to show some effort to read through the basics and
search for more information about anything that they do not understand
before asking questions.
I will try to give you some pointers in case they will help. I am also
posting these in case they will help others who may be searching for
information.
You know that sqlcipher is an adaptation of sqlite that _can_ store
your data with encryption. I suspect you know that sqlite is available
at [www.sqlite.org](http://www.sqlite.org) and is available for free under the public domain,
as described here: [SQLite Copyright](https://www.sqlite.org/copyright.html)
I suspect you know that sqlite is very widely used, and it is very
easy to find tutorials and other documentation on the Internet. If you
are not familiar with sqlite, I suggest you look for a tutorial and
try some basics.
Once you understand some basics, then take a look at
[SQLCipher - Zetetic](https://www.zetetic.net/sqlcipher/) and read through some of the linked
documents. I also suggest you try building and using sqlcipher on OSX
or Linux where it will be easiest. You may want to try sqlcipher on
Android or iOS as well.
I hope this helps.
---
### Author:  [@developernotes](https://discuss.zetetic.net/u/developernotes)
#### Post date: [July 20, 2015, 1:31pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/12 "2015-07-20T13:31:50Z")
Hello @vikrant
As @brodybits pointed out, the core [source](https://github.com/sqlcipher/sqlcipher) of SQLCipher is available as an [open source](https://www.zetetic.net/sqlcipher/open-source/) project. SQLCipher can be built to target a number of different platforms and operates well in various environments. SQLCipher can be used within a WPF application; we use it within [STRIP for Windows](https://www.zetetic.net/strip/); it also runs on Windows Phone. That said, the prebuilt binaries for the Windows platforms are part of our commercial offering, available for [purchase](https://www.zetetic.net/sqlcipher/buy/). Alternatively you can build and integrate everything from source.
---
### Author:  [@vikrant](https://discuss.zetetic.net/u/vikrant)
#### Post date: [July 21, 2015, 12:02pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/13 "2015-07-21T12:02:16Z")
thank you very much @brodybits and @developernotes
---
### Author:  [@wgray](https://discuss.zetetic.net/u/wgray)
#### Post date: [July 21, 2015, 12:58pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/14 "2015-07-21T12:58:49Z")
I would like to clear up something:
> But you will not get support from the sqlcipher project since they do not offer the Windows version for free. Please do not ask again.
Just because we do not offer the Windows binaries for free does not mean that someone can’t ask questions here about building and using SQLCipher on Windows. We answer questions here in public and for users without support contracts as best we can and as we have the time. We’re not going to provide our build scripts, but if you hit an error creating your own, go ahead and ask (after doing a little investigation, of course).
---
### Author:  [@wgray](https://discuss.zetetic.net/u/wgray)
#### Post date: [July 21, 2015, 12:59pm UTC](https://discuss.zetetic.net/t/sqlcipher-3-2-0-release/198/15 "2015-07-21T12:59:14Z")