Android Create SQLite Database: A Beginner's Guide

As a newbie developing a Unity 3D app for both Android and Windows platforms, using SQLite with SQLite Browser to create my local database in Unity 3D (in C#) seems like a straightforward choice. One of the key reasons I chose SQLite is its serverless nature, which makes it free from configuration hassles.

Creating a Local Database

To start, you'll need to integrate the necessary DLLs into your project. Once that's done, you can create your local database using C#. If the database has been split due to size issues, use a for loop to reassemble it on run. This is especially important if you're dealing with devices prior to Android 2.3, which have a file size limit of 1MB.

Overwriting Empty Databases

When opening an existing database, SQLite attempts to open the file. If the database is empty, you can copy the existing database to the app data directory using a stream writer and overwrite the empty DB created by Android.

Android Metadata Table

For devices running Android 2.3 or later, creating a table called 'android_metadata' with a field called 'locale' in your database is essential. This allows you to work with different locales and languages.

Preloaded Databases

When working with preloaded databases, it's crucial to understand how Unity interfaces with Android when it comes to databases. While I'm not sure exactly how this works, my experience has shown that SQLite provides a seamless integration between the two platforms.

In conclusion, creating an SQLite database for your Android app using C# and Unity 3D is relatively straightforward once you understand the basics of SQLite and its limitations on certain devices. With these tips in mind, you'll be well on your way to creating a robust and scalable local database for your mobile application.

Android create sqlite database