Tutorial: Add SQLCipher to your Android app

Hi guys!

Today’s tutorial will be about SQLCipher and its integration in Android (with the means of Android Studio). Just to give some introduction, SQLCipher is used for a full database encryption. What full means is that the DB file is entirely encrypted, not only separate rows or tables. Zetetic, the company behind SQLCipher, provides Community and Commercial edition. You can use the former for commercial projects, though, just have to provide license doc in your app. Also, SQLCipher is not for Android only, it can be used on various platforms.

Regarding security features, SQLCipher uses 256-bit AES in CBC mode by default, with 1kB page size, and it derives the key data using PBKDF2 function. The difference in API that you instantly notice is the passphrase argument in getReadableDatabase() and getWritableDatabase() methods. Now, this passphrase should never be stored in the application, otherwise the whole point of encryption is wasted. One thing to keep in mind, is that the passphrase is not a key! Yes, the DB is encrypted using the key, but it is generated based on the passphrase (~ password) and also can be re-set using PRAGMA rekey command.
Continue reading Tutorial: Add SQLCipher to your Android app

Like and share:

Tutorial: How to easily integrate greenDAO into your Android project

[UPDATE: 20.12.2016]

This tutorial demonstrates greenDAO 2.x integration. Since greenDAO 3.x was released, its integration differs from 2.x. Now, you can either have a generation project or everything in one app’s project. There is a build-in encryption (SQLCipher underneath) which you can use if you want. There are now annotations and the package name has been changed to org.greenrobot.greendao. Here is a good article if you want to migrate to greenDAO 3.x – Updating to greenDAO 3 and annotations and here are some Code examples.


Hi, guys!

Today I want to present you my new tutorial about greenDAO integration. For those who haven’t heard, this is a great open source Android ORM solution which enables you to forget about SQLite low-level stuff and concentrate on the database’s overall lifecycle, models and how do they relate. You don’t actually need to bother how to populate the database and how the relations work, because greenDAO handles it for you. All you need to know is what you want to keep in your DB.

Sounds great, huh? But what about performance? Continue reading Tutorial: How to easily integrate greenDAO into your Android project

Like and share:

Tutorial: Scrolling background in Corona SDK

Hello!

Today I’m gonna talk about a scrolling background in Corona SDK. I’m sure you’ve seen this effect in many games and most likely the time has come to implement it in your own one. So, how is this being done?

The first question that might be asked is How many images do I need? The answer is – as many as you wish. I’ve chosen 1, because it’s super easy and fast – there is exactly one graphics and it’s enough.

The second question is In which direction it should scroll? It can be any direction, really, but this tutorial focuses on a vertical top > bottom scrolling. It’s like we’ve been flying higher and higher in sky.
Continue reading Tutorial: Scrolling background in Corona SDK

Like and share:

Tutorial: Nexus 5 ADB driver install

Hi, guys!

Today I’m gonna tell you how to deal with Nexus 5 and its driver issues with ADB. I have experienced this by myself (wasn’t able to deploy my app because ADB didn’t see my Nexus 5) and it is quite an unpleasant situation, as instead of debugging apps you have to stick for maybe 2h of troubleshooting and connecting/disconnecting the device.

This tutorial’s solution is for Windows only. See this link for Linux and Mac configuration.

Here I will actually provide a few solutions – from the easiest and most obvious ones to those more complicated and time-consuming. The best approach is to go from one to another, sequentially. This way you won’t unnecessary waste time if the problem is in USB debugging, for instance 🙂 So, lets begin!
Continue reading Tutorial: Nexus 5 ADB driver install

Like and share: