Should I choose Hiberlite for integrating SQLite into my Win iOS application

0 votes
I am a composer by profession and my computer science skills are limited though I program quite a bit of the software that I use.

What are the most reasonable ways to approach SQLite integration as a file format and database in an iOS app (it also needs to run on windows, but that is a secondary concern)?

I have been researching Hiberlite, which looks fantastic, but it seems to be little used and apparently it doesn't run well on embedded systems (iOS?) and chokes up when thousands of objects are in play. I haven't been able to get a sense of how severe those bottle necks are when running under those conditions.

The settings of thousands of objects (~50,000 though that number could expand) would be read every 1-10 seconds and written periodically. Read performance is more critical as write operations can stutter with out effecting the core operation of the app.

Given those conditions, how should I approach SQLite? My understanding is that without something like Hiberlite the entire database (many millions of entries) must be read and rewritten for every entry, is that less efficient. If that is the best approach is there a good resource to follow for implementing it?

Any advice would be greatly appreciated. My current software that I rely on is beyond buggy and needs refactoring, but due to my inexperience I am having a difficult time finding information about a reasonable approach.
Nov 11, 2022 in Mobile Development by gaurav
• 23,260 points
345 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Mobile Development

0 votes
0 answers
0 votes
0 answers

How do I stop iOS from converting a small pointing right triangle character into a rectangluar boxed triangle symbol?

 I've tried entering the small pointing right ...READ MORE

Nov 16, 2022 in Mobile Development by gaurav
• 23,260 points
407 views
0 votes
0 answers
0 votes
0 answers

Swift - Find antilog for 4 digit Integer in iOS

I need to find an antilog for 5995. ...READ MORE

Nov 8, 2022 in Mobile Development by gaurav
• 23,260 points
1,085 views
0 votes
0 answers

iOS: transforming a view into cylindrical shape

With Quartz 2D we can transform our ...READ MORE

Nov 10, 2022 in Mobile Development by gaurav
• 23,260 points
789 views
0 votes
0 answers

How to open app from Twitter for iOS WebView on iOS 9

My question pertains to deeplinking from a ...READ MORE

Nov 10, 2022 in Mobile Development by gaurav
• 23,260 points
574 views
0 votes
0 answers
0 votes
0 answers

SQLite in Android How to update a specific row

For a time now, I've been attempting ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
• 38,000 points
1,692 views
0 votes
1 answer

SQLite.Net not being able to create text file in Win IoT Library!

That exception comes when access limited to ...READ MORE

answered Aug 3, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
1,001 views
0 votes
1 answer

How to get a value from SQLite to convert it?

Server side: b = BtcConverter(force_decimal=True) p1btc = b.get_latest_price('USD') p1btcr = ...READ MORE

answered Sep 6, 2018 in Blockchain by digger
• 26,740 points
750 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP