#2016/February-March Useful links

Hi, guys!

It is the last day of March and I couldn’t miss the opportunity to share all great links I’ve gathered through the last two months. There is also a “Happy Easter!” greeting which goes to all who celebrate Easter in March and May! What about links, this time the absolute winner is Game Dev, but there are a few wonderful music albums, as well as articles on design matters. Well, check out yourself!

February - March 2016 digest

Here’s the link to the previous Digest 😉
Continue reading #2016/February-March Useful links

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

#2015/12-2016/01 Useful links

Hi, guys! It’s already the begging of February (which means I haven’t posted a digest on time, oops!), and so I’m finally posting a joined digest from December and January! This time there is a bit of everything, with a slight advantage of music which I think is good, because you can start a new year with some swing 😉

I really hope you’ll find these things useful. As always, the link to the previous digest is here.

Winter 2015-2016 digest

Enjoy the articles and let me know if you liked them. Thanks 😉
Continue reading #2015/12-2016/01 Useful links

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