SQLite Asset
SQLite Asset enables read-only SQLite database assets in Unity, automatically importing .sqlite, .sqlite2, and .sqlite3 files. Create connections to your databases with a single method call, with flexible loading from Streaming Assets or memory depending on platform requirements. Built on SQLite-net for reliable database management.
com.gilzoide.sqlite-asset 
Install via UPM
Add to Unity Package Manager using this URL
https://www.pkglnk.dev/sqlite-asset.git README Markdown
Copy this to your project's README.md
## Installation
Add **SQLite Asset** to your Unity project via Package Manager:
1. Open **Window > Package Manager**
2. Click **+** > **Add package from git URL**
3. Enter:
```
https://www.pkglnk.dev/sqlite-asset.git
```
[](https://www.pkglnk.dev/pkg/sqlite-asset)Dependencies (1)
Used By (1)
README
SQLite Asset
Warning: this package is deprecated, since SQLite-net incorporated the functionality of this package.
Read-only SQLite database assets for Unity.
Automatically imports ".sqlite", ".sqlite2" and ".sqlite3" files as SQLite database assets.
Features
- SqliteAsset: read-only SQLite database Unity assets.
- Files with the extensions ".sqlite", ".sqlite2" and ".sqlite3" will be imported as SQLite database assets.
- Use the
CreateConnection()method for connecting to the database provided by the asset. Make sure toDispose()of any connections you create. - SQLite assets may be loaded from Streaming Assets folder or from memory, depending on the value of their "Streaming Assets Path" property.
- Warning: Android and WebGL platforms don't support loading SQLite databases from Streaming Assets and will always load them in memory.
SQLiteConnection.SerializeToAssetextension method for serializing a database to an instance ofSqliteAsset.
Dependencies
- SQLite-net: library for managing SQLite databases
Optional packages
- SQLite Asset - CSV: easily import ".csv" files as read-only SQLite database assets
How to install
Either:
- Use the openupm registry and install this package using the openupm-cli:
openupm add com.gilzoide.sqlite-asset - Install using the Unity Package Manager with the following URL:
https://github.com/gilzoide/unity-sqlite-asset.git#1.0.0-preview2 - Clone this repository or download a snapshot of it directly inside your project's
AssetsorPackagesfolder.
Credits
- Database icons from Solar Icons Set, licensed under CC BY 4.0
Comments
No comments yet. Be the first!
Sign in to join the conversation
Sign In