Using Sqlite in Unity скачать в хорошем качестве

Using Sqlite in Unity

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.