Blog 2) SQLite with Unity

What have i learnt?

Sqlite is a open source database that is widely use for a wide range of applications across the world. The database is powerful but small enough to work on mobile devices with ease and is self contained meaning that it does not require a server to operate such as other similar databases.

The database is stable,cross-platform and backwards compatible. SQLite is a c based library that makes this database a great choice for applications developed in the Unity environment.

Why have i learnt this?

This database is widely used by a large number of both well known and not so known companies throughout the world. As potential software developers we need to be aware of such popular software that may find its way into a work flow.

How have i learnt this?

So far we have some resources provided to us though the Nmit online web application known as Moodle. Through Moodle we have some great documentation and useful youtube tutorials that we can follow. The lecture has provided a demonstration on the installation and configuration on Sqlite with Unity development engine where we are developing an application of our choosing.

What is the point?

The point is to demonstrate that there are a number of great software available for all to use, regardless of the size of the project or for what purpose.

What will i do to remember this learning?

The best way to retain information especially if it is new, is to apply the knowledge to a practical exercise. For our milestone 2 we have to apply a database to the Unity application we are currently development as all software needs to have a connection to a database regardless if it is a game or web based program.

What are the real world applications?

Having the knowledge to attach a database to a wide range of applications developed for all platforms opens the possibility to deploy those applications outside of the local scope of the host machine that they were created on.