Hi everyone!
I wanted to let the community know that the upcoming Percona Live Open
Source Database Conference will have a specific track for “Other Open
Source Databases”, in which anything SQLite-related will fit :)
If anyone is interested in presenting, you can use this link:
https://perconacf
From memory a file is marked as blocked by a hidden file stream attached to
the file. That’s why using cp removed the block as I guess it doesn’t
understand file streams.
Cheers
On Wed, 9 Jan 2019 at 21:49, Simon Slavin wrote:
> On 9 Jan 2019, at 9:33pm, Don V Nielsen wrote:
>
> > Is the chm f
On 9 Jan 2019, at 9:33pm, Don V Nielsen wrote:
> Is the chm file on a server? I remember this problem from years ago...I
It's a long time ago, but I seem to remember being told that if I wanted to
distribute a .chm file I should Zip it first.
Simon.
Is the chm file on a server? I remember this problem from years ago...I
haven't used a chm file in a long time. Unblocking did not fix it while it
resided on the server. However, copying it locally and unblocking it did
work.
Hope this helps,
dvn
On Wed, Jan 9, 2019 at 11:29 AM Rizzuto, Raymond
> I have three points:
Thank you, appreciate the feedback. I've updated the article with the
changes you suggested.
Rahul
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mai
When I download SQlite.NET.chm from the internet, and open it, I can see the
table of content but not the actual content. It appears to be due to a block
caused by downloading from the internet.
Googling came up with this:
https://community.spiceworks.com/topic/1961503-solved-windows-10-chm-
On 9 Jan 2019, at 2:01pm, spamh...@bluewin.ch wrote:
> In which order should VACUUM, INTEGRITY_CHECK and OPTIMIZE be executed?
If you are in any situation where INTEGRITY_CHECK should be run, do not make
any changes to the database (e.g. ANALYZE) first. Those changes might
overwrite parts of t
On 8 Jan 2019, at 3:48pm, Rahul Jayaraman wrote:
> https://www.activesphere.com/blog/2018/12/24/understanding-sqlite-busy
>
> I’d appreciate feedback on the article.
I read your article, though I did not go through all the logic and check that
it is correct. I like your choice of sections, an
Check-in https://www.sqlite.org/src/info/383437be276719ac will perhaps
silence the harmless false-positives reported by TSAN. Please let us
know if it does not solve the problem for you.
On 1/7/19, Jan Krčál wrote:
> Hi,
>
> as a Chrome developer, I've run into a data race flagged by ThreadSanit
On 1/9/19, spamh...@bluewin.ch wrote:
> In which order should VACUUM, INTEGRITY_CHECK and OPTIMIZE be executed?
I suppose that depends on what you are trying to accomplish? Why do
you execute them at all?
I suppose INTEGRITY_CHECK should be run with first opening the
database file, to ensure th
>For the OPTIMIZE the documentation states: "... run just before
>closing each database connection ...". There isn't a reason to do it
>instead after opening a connection each time?
The documentation tells you under what circumstances PRAGMA OPTIMIZE does
anything, in the current implementation.
Hello all
As I was not able to find the information I have to ask here. Maybe it is
trivial.
In which order should VACUUM, INTEGRITY_CHECK and OPTIMIZE be executed? I have
been using this one so far but I am not sure about the latter two.
For the OPTIMIZE the documentation states: "... run just b
I wrote an article about my high-level understanding of `SQLITE_BUSY` errors,
hoping it might help others understand concurrency in SQLite better. It covers
scenarios under which the error shows up, while SQLite tries to respect its
isolation guarantee.
https://www.activesphere.com/blog/2018/12
Hi,
as a Chrome developer, I've run into a data race flagged by ThreadSanitizer
in pcache1.c:
When two threads write to in-memory sqlite DBs (each to its own separate
DB), each thread has its own PCache1 with bPurgeable being false. Thus, in
both threads, pCache->pnPurgeable points to the static
14 matches
Mail list logo
