The Benefits of Journaling in SQLite

2min Snip

00:00

Play full episode

Summary

Transcript

Episode notes

SQLite has the option to do journaling so that there's a quicker way of writing things to disk in quotes, between air quotes here, you can't see that. The benefits of journaling are outweighed by the fact that these devices nowadays are really fast. There are pragma statements in SQLite and pragma is PRA, GMA, the way of doing functions to modify some of the internal settings ofsqlite. And if you're doing like a intensive, like large amount of data, you may have to increase like the amount of memory that the cursor size is using for inserts.

Bonus! We talked about Automattic and Apple here...

Guest

Aaron Douglas (@astralbodies)
- The Dangling Pointer (homepage)
- Core Data by Tutorials

Related Episodes

Related Links

Fetching objects from Core Data in a SwiftUI project by Donny Wals
Why NetNewsWire Is Fast by Brent Simmons
Hibernate
Libraries
Tools
- ChristianKienle/Core-Data-Editor
- SimPholders
Alternatives
- Realm
- Parse

Sponsors

AppFigures
The tools you need to monitor, optimize, and get more downloads.

If you want your app to succeed, there's never been a better time to read up on App Store Optimization and Appfigures provides that for you.

Check out their great articles and guides on app store optimization
Brand new teardowns of specific apps, like Spotify for instance or indie apps like Fotmob.
New competitor's report in the Appfigures dashboard where you are able to view competitor downloads, build performance benchmarks, and see the new trends as they happen. Check it out here.
Check out more of their resources at appfigures.com/resources.

The folks at Appfigures have easy step-by-step guides and intuitive tools to do that, which many indie developers are using to get more downloads:
https://appfigures.com/resources/aso

Also check out our episode with CEO Ariel Michaeli:
https://share.transistor.fm/s/15b7ff63

Try Appfigures for free, and if you like it use the special link to get 30% off for the next 3 months:
https://appfigures.com/account/upgrade?p=empower3030

Transistor.Fm
Your podcast's publishing platform
Transistor not only hosts your podcast but also:

Help distribute your podcast with integrations to Apple Podcasts, Spotify, Google Podcasts, YouTube, and Mailchimp
Deep analytics including average downloads per episode, popular podcast apps, number of subscribers, trends
Professional support for creatives, businesses, and professional podcasters when it comes to hosting and analytics

How do you start a podcast?
https://transistor.fm/how-to-start-a-podcast/?via=empowerapps

Try it today with this special link:
https://transistor.fm/?via=empowerapps

Why Local Storage?