Blog 8) Sqlite manager

What have i learnt?

Sqlite manager is an application that you can download for free that gives the user a platform to manage there tables and database through the use of a GUI interface. Eventhough you can download the application from the formal website for free the company did place some restrictions on the program. Such a restriction would be the limiting the tables stored within the Sqlite manager to 20 rows of data.

Why have i learnt this?

Being able to view the tables that you create for your applications in an environment that is specifically constructed for sql data is import for ease of use and manageability.

How have i learnt this?

In class we needed to download the Sqlite manager for the use in our assessments.At first we had no idea that there was a restriction of 20 rows of data that can be stored within each table. Luckily for the purpose of our assessment we do not need to store large amounts of data.

What do you know now that you didn’t before?

I had no idea that it would be possible to send data from a application developed in Unity3D to a database using normal sql queries that we learnt in our database courses.As we are developing an application from within Unity3D we needed a platform that we could use to view the tables for our database and Sqlite manager fitted the bill perfectly.

What is the point?

All application that gather some form of data need a place to store that data in an organized manner. Sqlite manager offers the user the necessary platform to view an manage the data gather regardless of the application.

What will i do to remember this?

Knowing now how to send and retrieve data from a database to make more meaningful applications i will continue to further my understanding so that the data being stored will become more secure and meaningful.

What new understanding/skills did i gain?

Gaining the skill to apply database services to an application created in Unity3D opens more possibility to create more exciting applications from within Unity3D.

What will i do to fill in the gaps?

Reading online documents published by both Unity3D and Sqlite. I will also continue to complete courses on the subject found on Linkedin. Repetition is the key to mastery.