2 ms·

I wonder is there is some specific use case that makes this really powerful in comparison to Postgres. Something where you have lots of dependent queries perhap

• mpcjanssen 5y ago
  In the article it describes the N+1 problem with an example of the fossil timeline. In a system using Postgres, you would select all the timeline entries and then generate one big query to get the details of all the timeline items in one sql request. With sqlite you can just iterate over the items and do the queries separately. This makes handling this scenario much simpler.