Comparison of different approaches to inserting data into an SQLite database.
#performance #sqlite #database
#performance #sqlite #database
Medium
Squeezing Performance from SQLite: Insertions
Sometimes we need to manage a lot of data in our apps. What’s the fastest way to get all of that data into your Android app’s SQLite DB?
Working with timestamps and timezones is almost always a hassle. Moreover, SQLite doesn’t have a dedicated type to store such values. However, there are some built-in functions to simplify such tasks. In this post you’ll find a good example of using them in a real production app.
P.S. Here you’ll find a funny video about general problems with dates, time and timezones.
#sqlite #db #date
P.S. Here you’ll find a funny video about general problems with dates, time and timezones.
#sqlite #db #date
Handling Dates & Times in SQLite
Handling Dates & Times in SQLite :: Ryan Harter
SQLite may not have dedicated datetime data types, but that doesn't mean we have to restort to queries filled with meaningless numbers and post-processing datasets in application code. Here we'll take a look at a real world use case for SQLite's [datetime…
Just an amazing talk about SQLite from it's creator. I can highly recommend to watch this one. Some people are just so excited to tell about what they're working on, that this excitement reaches you even through a youtube video.
#talk #sqlite #database
#talk #sqlite #database
YouTube
SQLite: The Database at the Edge of the Network with Dr. Richard Hipp
Dr. Richard Hipp—creator of SQLite—provides a great view into the history of SQLite and situations where it really shines. SQLite is a database designed to live at the edge of the network with no DBA to tend to it.
Decided to focus on SQLite this week, encountered an interesting post series.
- B-trees, pages and record format
- ACID and rollback journal
#sqlite #db
- B-trees, pages and record format
- ACID and rollback journal
#sqlite #db
Fly
SQLite Internals: Pages & B-trees
Let's open a hex editor and see what this thing is made of
New post on Android Developers: Best practices for SQLite performance. Looks good! Sad, that it hasn't been there before.
#sqlite #db #performance
#sqlite #db #performance
In a comment in SQLite sources there's this fascinating story on why temporary files prefix had to be changed to "etilqs_" (SQLite spelled backwards).
#sqlite #db #humor
#sqlite #db #humor