11000+款5星资源
8.5万+用户参与评分
10万+社区成员鼎力支持
每款资源都经过 Unity 审核
显示 1 - 10 of 20
用户评论
排序
I spent many days trying to get SQLite to work on my iPhone (it was already hard enough on macOS) – without success – even ChatGPT wasn't really helpful. I thought I’d buy this and see if it works. I ran a few tests and it worked very quickly. I’ve rewritten a lot of code and still have a lot to rewrite, but it’s definitely worth it – no more annoying DLLs.
It works fine on Unity 6000.1.12f1
PS: There’s a bug in the Demo5DB script – comment out lines 338 and 339, then it works on the iPhone without any issues.
这条评论是否有帮助?
0
0
来自发布商的回复:
回复时间 3 months ago
Thank you for pointing to the bug!, I will fix it in a new update.(but there is no promises on date)
And I'm really enjoy that that that exact same problem with DLL which force me to publish my asset, still helpful to the community! Enjoy!
Doesn't work great for webgl. We need to do additional syncfs ourselves.
HandleIO.jslib:
mergeInto(LibraryManager.library, {
//flush our file changes to IndexedDB
SyncDB: function () {
FS.syncfs(false, function (err) {
if (err) console.log("syncfs error: " + err);
});
}
});
Helper:
private SQLiteDB _db;
private FileStream _stream;
#if UNITY_WEBGL && !UNITY_EDITOR
[DllImport("__Internal")]
private static extern void SyncDB();
#endif
private void Sync()
{
#if UNITY_WEBGL && !UNITY_EDITOR
//flush our changes to IndexedDB
SyncDB();
#endif
}
Connect DB:
private async UniTask ConnectAsync()
{
_stream = new FileStream(Path.Combine(Application.persistentDataPath, "db.db"), FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite);
_db = new SQLiteDB();
_db.OpenStream("db", _stream);
var qr = new SQLiteQuery(_db, "CREATE TABLE IF NOT EXISTS test_values (id INTEGER PRIMARY KEY, str_field TEXT);");
qr.Step();
qr.Release();
}
Close DB:
private async UniTask CloseAsync()
{
_db.Close();
Sync();
MyLog("Db size " + _stream.Length +" bytes");
}
这条评论是否有帮助?
1
0
来自发布商的回复:
回复时间 2 years ago
Wow, thank you!!! I never thought that it could be done this way!
Very clever and beautiful!
I will reintegrate into the next update !!!
Thank you a lot!
This kit has everything you need to fully integrate SQLite Databases into Unity free from the headaches that come with compiling your own libraries to work with unity on the platforms that you need with really useful custom wrappers, encryption, and more!
The best part is that the developer truly stands by his product and goes above and beyond to help. I was struggling with an issue for a few days, completely due to my own error, and Pavlov immediately responded to help me troubleshoot even going so far as to help rewrite part of my scripts as a template to apply to the rest of my tables. He was not only professional, he demonstrated patience, and a willingness to help me to better understand the code. Our corresponding emails totaled over 30 messages.
Easily the best purchase I have ever made on the asset store! I wish this developer continued success and look forward to any future projects he may have for the community.
这条评论是否有帮助?
0
0
来自发布商的回复:
回复时间 3 years ago
Thank you I could better see my customers requirements! And I'll make a new example scripts for use cases like yours.
J
there are bugs but it mostly works well
8 years ago
JohnTomorrow基于上一个版本 1.9.5
Regexp don't place nice with binding if you need to have multiple queries.
This can be corrected by changing line 203 in _Custom.cs to:
if ( oRegex == null || oRegex.ToString() != zRegex )
这条评论是否有帮助?
0
0
来自发布商的回复:
回复时间 3 years ago
Thank you! Sorry to be out for 5 years :) I will fix it and upload! I'm back!
m
Great Asset :)
8 years ago
marcosocram基于上一个版本 1.9.5
I'm using it to store blobs and other stuff, works great. I totally recommend it.
这条评论是否有帮助?
0
0
C
Functional but lacking in documentation
10 years ago
Craven-Mageslayer基于上一个版本 1.9.4
This is a functional add on, but documentation is lacking. Tutorial videos available out there are often very difficult to hear and follow. SQL editing box is ridiculous. All editing must be done elsewhere and pasted into the interface. Once you get past those hurdles, it does seem to work, however. I have no exposore to similar SQLite addons. As long as I hit no issues, I won't need to explore other options for prototyping.
这条评论是否有帮助?
0
0
c
Does Not compile with Unity 5.3.2f1 on IL2CPP
10 years ago
chorusgames基于上一个版本 1.9.3
Same problem as below. Hope this is resolved soon. Will change back rating when it is working again.
这条评论是否有帮助?
0
0
来自发布商的回复:
回复时间 3 years ago
Fixed with last update
The description explicitly states this compiles for IL2CPP (iOS), but currently it does not (Unity 5.32f1).
To top it off, they do not respond to their support emails.
I will update this when/if they fix the issue, or respond to their support email.
这条评论是否有帮助?
0
0
来自发布商的回复:
回复时间 3 years ago
Fixed with last update
高品质资源
11000+款5星资源
深受用户信赖
8.5万+用户参与评分
强大的社区支持
10万+社区成员鼎力支持