Alternative to deprecated sqlite pragma “default_cache_size”

The sqlite docs says that using the pragma default_cache_size is deprecated. I looked, but I couldn't see any explanation for why. Is there a reason for this? I'm working on an embedded python program, and we open and close connections a lot. Is the only alternative to use the pragma cache_size on every database connection?

Answers


As Firefox is massively using SQLite I wouldn't be surprised if this request came from their camp to prevent any kind of 3rd party interference (e.g. "trashing" with large/small/invalid/obscure values) by this kind of pragma propagating through all database connections

Hence, my strong belief is that there is no alternative and that you really need to set cache_size for each database connection


Need Your Help

Why is my Scala function returning type Unit and not whatever is the last line?

function scala

I am trying to figure out the issue, and tried different styles that I have read on Scala, but none of them work. My code is:

Rename file pattern windows batch

windows batch-file cmd file-rename

I have some files looking like following:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.