Adding SQLite Plugin - Develop Unity Apps with SQLite (1/17)

In this series you are going to learn how to add SQLite Support to your Unity Project or App. You will learn about a Third Party Plugin with which you can add SQLite Support for Android, iOS, Mac and Windows Unity apps. Also you will be learning how to add a database layer to a unity app. You will be coding the Database Connection Class to interact with the Database. You will also learning to write a Service class to serve data from Database to User Interface. In the process you will also learn how to Explore the SQLite databases with a free database browser.

Adding Support for SQLite to the Unity Project

1. Downloading and Adding the SQLite Plugin -    • Adding SQLite Plugin - Develop Unity Apps ...  
2. Tool to Browse the Database -    • DB Browser for SQLite - Develop Unity Apps...  
3. Plugin Walkthrough -    • Plugin Walkthrough - Develop Unity Apps wi...  
4. Running the Samples -    • Plugin Samples - Develop Unity Apps with S...  

UI & Classes for Hello SQLite App for Testing SQLite Features

5. Design UI for the App
6. Create a Object Class
7. DB Class to Interact with SQLite DB
8. Service Class


Adding Database Operations to Hello SQLite App

9. Create Contact Table
10. Add Single Contact
11. Add Multiple Contacts
12. Get All Contacts
13. Get All Contacts By Name
14. Get Single Contact By Name
15. Delete a Contact
16. Update Single Contact
17. Update Multiple Contacts

#unity, #sql, #sqlite, #gamdevelopment, #gamedev