Sqlite

Building database with Room Persistence Library

Hello everyone! Last week at Google IO 2017, Google introduced Room persistence library which allows fluent database access while harnessing the full power of SQLite. Basically, it is abstraction layer over SQLite.

7 Steps To Room

A step by step guide on how to migrate your app to Room

Squeezing Performance from SQLite: Indexes? Indexes!

Are your queries taking too long to run? In this episode of the series, I will explain how indexes work in SQLite, and how to design indexes that can take your most important queries to the next level of performance.

ANDROID DATABASE

Android app example using Room database and coroutines

Squeezing Performance from SQLite: Insertions

Sometimes we need to manage a lot of data in our apps. What’s the fastest way to…

Programming with Databases in Python using SQLite

If you are aspiring to be a data scientist you are…

Simple SQFlite database example in Flutter

Ten minutes to get a working app

Room + Time

If you’ve started using Room (and you should if you haven’t), there’s a high probability that you will need to store + retrieve some kind…

SQLite and Unity: How to do it right.

Tutorials and best practices of using databases in mobile applications, with reference to my…

Android Room Persistence Library: Relations

Room is an object mapping library that help us, the Android developers, to handle an…