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 in Mobile Development by gaurav
• 22,040 points
23 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
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 in Mobile Development by gaurav
• 22,040 points
31 views
0 votes
0 answers

iOS: transforming a view into cylindrical shape

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

Nov 10 in Mobile Development by gaurav
• 22,040 points
27 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 in Mobile Development by gaurav
• 22,040 points
31 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 in Database by Kithuzzz
• 20,660 points
254 views
0 votes
1 answer
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,720 points
323 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