SQLCipher available on Homebrew

2013-01-21 11:30:07 -0500

Many of us here at Zetetic use Homebrew, a command-line tool used to build and manage various software packages on OS X. Currently there are over 2200 recipes available to be installed via Homebrew. While building SQLCipher is not difficult, installing from Homebrew is just as easy and also affords you the ability to easily upgrade your installations as updates are released, all managed within a central location. We have submitted a recipe for SQLCipher that is now available to the masses. If you already have Homebrew installed, you will want to update your current list of recipes:

brew update

To install our current release, simply run:

brew install sqlcipher

If you wish to run the bleeding edge of SQLCipher, you can request the install perform a build from our master branch:

brew install sqlcipher --HEAD

This will install what is called a keg-only package of SQLCipher to minimize conflicts with other dependencies on SQLite due to the shared binary name. In order to make SQLCipher available on your PATH you can run:

brew link sqlcipher --force

Happy brewing!

Updated convert-to-strip for 1Password

2013-01-07 11:22:21 -0500

Storage Converter

We've been notified by a few customers looking to switch to STRIP from 1Password about problems reading the 1Password export file. These ranged from blank fields to improperly processing place-holders for deleted records and an older export format. If you've had trouble using this utility, this update will probably help you out. If not, please contact us at support@zetetic.net and we'll get to work on it! This app also allows you to convert SplashID export files to a CSV you can import into STRIP.

Convert to STRIP for Windows »

Convert to STRIP for OS X »

Update: Feb 11, 2013 In response to comments below, bugs have been fixed, and the download links above have been updated/corrected.

Announcing SQLCipher 2.1.1

2012-12-07 13:24:49 -0500

We're pleased to announce the availablilty of SQLCipher 2.1.1. This is a significant release including the following improvements and new features:
  • New PRAGMAs to query the current values for all SQLCipher settings (for example, "PRAGMA cipher" will now return "AES-256-CBC" by default, with similar behavior for other SQLCipher PRAGMAs) 
  • Tracking of activation calls and OpenSSL initialization, automatically executing EVP_cleanup to free associated memory on behalf of applications
  • Fix for an issue where the page number was included in HMAC calculation using native byte order. SQLCipher now converts to little endian by default (for backwards compatibility on popular ARM, i386 and x86_64 platforms). This allow interoperability between big endian and little endian platforms. 
  • New PRAGMA cipher_hmac_pgno = ( be | le | native ) to set behavior for page number byte ordering, and to convert older databases on big-endian platforms
  • New PRAGMA (cipher_hmac_salt_mask) to change the value used to permute the database salt before HMAC key derivation. This facilitates databases upgrades from old SQLCipher 2.0-beta settings to the latests defaults. With this change all key derivation settings are changeable via PRAGMA!
  • Improvements to memory wiping to avoid compiler optimizations, constant time memory comparison routines, and detection of context initialization problems (i.e. out of memory errors)
  • Code refactoring to move custom PRAGMA handling out of pragma.c into crypo.c (to minimize differences with SQLite upstream releases) and fix compilation errors for non-amalgamation builds
  • Uses the latest SQLite 3.7.14.1 as a baseline
Community edition users can now update to the latest SQLCipher on GitHub, and a new download of SQLCipher for Android is also available.  The SQLCipher for Android library has added support for x86 Android devices in this release.
New versions of the SQLCipher Commercial Editions for iOS, MacOS, Windows, ADO.NET, MonoTouch, and MonoDroid are already on sale in the SQLCipher Store. Note: commercial users who have purchased the binaries within the past 6 months may contact us for a complementary update.

STRIP for OS X 1.2.7 Released

2012-10-26 10:33:39 -0400

Yesterday, version 1.2.7 of STRIP for OS X was released. This update provides makes a couple of minor changes:

  • Provides a warning/confirmation before deleting a label and associated fields
  • Fixes bug where main window could be duplicated on setup
  • Fixes bug where sync service would hang after attempting a restore from a database with a different key
  • New STRIP icon

You can download this update from the Mac App Store.

Known Issues:

  • Attempts to sync with a Dropbox folder stored on another volume (e.g. not the system disk) will fail
  • Multi-line text is not always displayed correctly

More fixes and new features are on the way!

SQLCipher Now Supports iPhone 5, XCode 4.5, and armv7s

2012-09-27 15:56:11 -0400

We're please to announce that SQLCipher now officially supports the new iPhone 5, XCode 4.5 and the armv7s architecture!

Community edition users can now update to the latest on the SQLCipher master branch to get the XCode project updates.

New versions of the SQLCipher Commercial Editions for iOS and MonoTouch with these same improvementsare available immediately in the SQLCipher Store! Commercial users who have purchased the binaries within the past 6 months may contact us for a complementary update.

Note: XCode 4.5 no longer supports armv6 so support for this architecture has been removed from both the community and commercial editions.