Using Sqlite in Unity
Автор: Digestible
Загружено: 2020-09-07
Просмотров: 30004
An introduction to some basic SQL including instructions on where to get required dll files for Sqlite functionality in a Unity project for Windows. This video covers basics on creating a new database, table, reading from & writing to the Sqlite database from within Unity.
Chapters:
SQL Basics:
0:22 SQL - what it is, sample of what it does
1:39 Sample Database using SELECT *
2:51 Sample DB using SELECT * WHERE
3:39 adding sorting with: ORDER BY
4:37 adding records: INSERT INTO
Moving on to Unity and SQLite...
6:22 SQLite
7:10 Files you need to download from SQLite
8:10 Adding sqlite dll files to Unity project
8:47 Find & Add Mono.Data.Sqlite.dll to project (note that since this was recorded the unityjit folder is now called unityjit-win32 for example for windows)
Code in unity
11:15 Going over the script in Unity/Visual Studio
13:43 CreateDB() method (Creates the table)
18:30 AddWeapon() method (adds records to the table)
22:54 DisplayWeapons() method (reads db, displays records to the console in Unity)
26:47 Deleting the DB file if you want to start over
NOTE: This process is demonstrated for Windows and I have not tried this with other platforms (android, ios, etc) so at this point I cannot say which will work the same and what will need to change.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
