▲ 3 r/sqlite+1 crossposts

SQLite integration for Android/iOS/WebGL?

Hi Gang, we would like our project to be able to read/query DB files downloaded from our CDN. We are currently using SQLite4Unity3d on Android and iOS and it seems to be working fine.

For legacy reasons we're using gilzoide/unity-sqlite-net for WebGL and it has a limitation where the only way to open a standalone db file is via a memory stream, but the issue is that the whole file has to stay resident in memory for as long as the connection is open. We will need to be able to make unpredictable reads to the DB file during our whole game, and our files are projected to be 10-20mb large, so that's out of the question.

Is there a single package that fulfills all of these requirements?

  1. open downloaded/standalone db files for read-only operations
  2. complete file contents do not need to be loaded in memory at all times
  3. works for webgl/android/ios in a single code path
reddit.com
u/jchowdown — 8 days ago

Kohler flush valve flange?

Hi, I damaged the little flange that holds the flush seal in place and I can't find the right part# to order. It has three little tabs/prongs (which I broke) and snaps onto the tank drain opening.

All the parts at my home Depot seem to require disassembling the whole tank which I can't do. Does anyone recognize this part pls?

EDIT: More pics: https://ibb.co/album/bQgxSp. We had all our toilets replaced when we moved in 8 years ago, it's possible this set is some sort of contractors-only equipment?

u/jchowdown — 22 days ago

Symbolicating an .ips file: crashlog.py fails looking for a nonexistent field

Hi, I have an .ips file (created with iOS 26.5) which I want to symbolicate using XCode 16.2.
Here are the steps I'm following:

  1. Rename .ips file and give it .crash extension

  2. Connect an ios device to my Macbook.

  3. Launch XCode, go to Device Manager, select my device

  4. go to "Open Recent Logs", select my .crash file

  5. File opens in an xcode window, but there are errors:

    "/Applications/Xcode.app/Contents/SharedFrameworks/LLDB.framework/Resources/Python/lldb/macosx/crashlog.py", line 644, in parse Failed to launch: 'Custom LLDB commands' -- Failure to create target from custom LLDB commands. self.parse_images(self.data["usedImages"] KeyError: 'usedImages'

I opened the .crash file and there is indeed no key "usedImages".

A) Can I create a dummy entry at that key?
B) If it fixes the parsing, will it symbolicate accurately?
C) If 'usedImages' contains data that is vital to symbolication, any ideas why it's missing?

reddit.com
u/jchowdown — 1 month ago

Troubleshooting: how to sample threads stacks in a running game

Hi gang, we're trying to troubleshoot a hang/freeze in our Unity game.
We think it's some sort of unhandled exception because it's not being evicted by the watchdog, but we also have no data coming from our bug reporting sdk (Bugsnag).

I was looking at sysdiagnose because it's available to end users. While it has some snapshot-related info on our process, it doesn't contain a sample of the stack trace in each thread, like I can see with Android's 'bugreport' command. Is there another tool our endusers can use on iOS that gives me that info?

reddit.com
u/jchowdown — 1 month ago
▲ 0 r/dotnet

System.Text.Json source generation

Hi, we're in an environment (Unity 6000)that is limited to .NET Framework, which means System.Text.Json 6.0.0 at most.

I need to roll my own reflection-free JsonStringEnumConverter<TEnum> because the one in System.Text.Json isn't available to us.

I know that the partial class JsonSerializerContext is filled out by source generation, but would that prevent me from using sourcegen to create custom Read/Write classes for classes derived from JsonConverter<TEnum>? The issue I worry about is that I read somewhere that the sourcegen dlls are run in a non-deterministic order.

reddit.com
u/jchowdown — 3 months ago

Backing up iPhone locally

"This iPhone needs to be unlocked"
*unlocks iPhone

"Go to your iPhone and answer Yes at the 'Trust this computer?' prompt"
*taps Trust Computer on iPhone

"This iPhone needs to be unlocked"
*unlocks iPhone

"Go to your iPhone and answer Yes at the 'Trust this computer?' prompt"
*taps Trust Computer on iPhone

Backup starts
*leave computer for 45 mins, comes back

"This iPhone needs to be unlocked"
*unlocks iPhone

reddit.com
u/jchowdown — 3 months ago

Any issues using roadside assistance or emergency dispatch?

It sounds like we can skip AAA if it's easy to use and actually works

reddit.com
u/jchowdown — 3 months ago

Police report worth it for damage free hit and run?

Both of us were backing out of our spots when we collided. He was at fault because we started our roll first but we didn't suffer any damage and don't plan to make a claim but he didn't stop. Should I still file a police report? His vanity plate makes it really easy to ID.

reddit.com
u/jchowdown — 3 months ago