SQLite

9 ms·

121.
by SQLite 7y ago
Indeed. Explanation at https://fossil-scm.org/fossil/doc/trunk/www/rebaseharm.md
122.
by SQLite 7y ago
I do. My argument is here: https://www.fossil-scm.org/home/doc/trunk/www/blockchain.md
123.
by SQLite 7y ago
Yeah. See https://www.sqlite.org/serverless.html
124.
by SQLite 7y ago
Thanks for this. I did not realize that fileSize() was a performance issue on Windows. I'll attempt to update kvtest.c to deal with that, rerun the tests, and update the page, as I have opportunity.
125.
by SQLite 7y ago
Only in ROLLBACK journalling mode. Set "PRAGMA journal_mode=WAL" and this does not happen.
126.
by SQLite 7y ago
SQLite supports multiple simultaneous connections to the database from separate processes. It just does not let more than one connection write at a time. SQLite takes care of serializing access for you - you don't have to put any syn
127.
by SQLite 7y ago
The 100% MC/DC testing in SQLite does not force the code to be well-architected, but it does help us to improve the architecture. (1) The 100% branch test coverage requirement forces us to remove unreachable code, or else convert that
128.
by SQLite 7y ago
"Test what you fly and fly what you test" is what we live by at SQLite. Testing is done three times: (1) One test uses compiler and preprocessor options set up to measure coverage. This is not so much a test of SQLite itself as i
129.
by SQLite 8y ago
I never thought I needed bisect, until I had it. Now I can't live without it.
130.
by SQLite 8y ago
I've recently added the ability to associate a wiki page in Fossil with an individual check-in or with a branch - as additional documentation about that branch or check-in. This is similar to your concept, if I understand you correct.
131.
by SQLite 8y ago
Here is an attempt to clarify why I think implementation does matter: https://www.sqlite.org/whynotgit.html#git_makes_it_difficult... When the design of a system makes something difficult, people tend to avoid doing that th
132.
by SQLite 8y ago
Some data: The fossil-scm.org server gets between 1500 and 2000 distinct human visitors per day on weekdays. (Lower traffic on weekends. Robots are excluded from the count. "distinct" means visitors having different IP addresses.
133.
by SQLite 8y ago
Perhaps the OP is referring to this: https://www.sqlite.org/whynotgit.html#the_mental_model_for_g...
134.
by SQLite 8y ago
Additional links for the curious: https://fossil-scm.org/fossil/doc/trunk/www/quotes.wiki https://www.sqlite.org/whynotgit.html
135.
by SQLite 8y ago
I'm not sure what you mean by "stream" here. However, there are two APIs designed to facilitate sending SQLite database files over a socket. The sqlite3_serialize() interface ( https://www.sqlite.org/c3ref&#x
136.
by SQLite 8y ago
c:\WINDOWS\System32\winsqlite3.dll
137.
by SQLite 8y ago
Two points: (1) The coverage testing used by SQLite is very good at finding problems that occur when the system is used as it was intended. Fuzz testing is better for finding vulnerabilities that can be exploited by a hacker. The 100% MC&#
138.
by SQLite 8y ago
Right. The actual standard is called "modified condition/decison coverage" or MC/DC. In languages like C, MC/DC and branch coverage, though not exactly the same, are very close. Achieving 100% MC/DC does not
139.
by SQLite 8y ago
Correct. The primary error is that corrupt "shadow tables" used by the FTS3 full-text search extension could cause RCE. The fix for that specific problem is here: https://www.sqlite.org/src/info/d44318f
140.
by SQLite 8y ago
Excellent summary, nneonneo. I think everything you said here is correct. The vulnerability only exists in applications that allow a potential attacker to run arbitrary SQL. If an application allows that, it is usually called an "SQL
141.
by SQLite 8y ago
If the Hellerstein/Stonebraker/Hamilton paper is the kind of overview you are looking for, then a better link for the SQLite equivalent is https://sqlite.org/arch.html
142.
by SQLite 8y ago
https://www.sqlite.org/cpu.html
143.
by SQLite 8y ago
Yeah. Sometimes you have to do what you have to do. See the rules: 23 Do not nurse a grudge. 34 Be Not Proud. 71 Make peace with your adversary before the sun sets. And so forth.
144.
by SQLite 8y ago
> you can't put religious things in the code of conduct. Why not? Isn't the whole point of a code-of-conduct to describe the ethical values of a community? And isn't all ethics a kind of religion, even if it does not alw
145.
by SQLite 8y ago
I haven't seen -C only DO-178B, though I'm told there isn't much difference. It is not a page-turner. It took me about a year to really understand it.
146.
by SQLite 8y ago
Correct. The key word is "inspired". Multiple companies have run a DO-178B cert on SQLite, I am told, but the core developers did not get to participate, and I think the result was level-C or -D. While all that was happening 10+
147.
by SQLite 8y ago
SQLite can use multiple indexes if there are OR terms in the WHERE clause. SQLite tries to only uses indexes in situations where they help the query run faster. SQLite is not limited in its use of indexes. It is just that the use of multipl
148.
by SQLite 8y ago
Suppose your query is: SELECT * FROM tab WHERE key1=1 AND key2 IN (2,3,4,5); SQLite starts by doing a single b-tree lookup on the index on (1,2) - composed from the key1 field and the first possibility of the key2 field. If that wo
149.
by SQLite 8y ago
> it only has one index per-table source I don't know for sure what this means, but it sounds like it is incorrect.
150.
by SQLite 8y ago
Yes. And there is code in the SQLite source tree (currently on a branch) that supports OFD locks. The problem we have is that SQLite is so widely deployed and is in so many systems and on so many platforms, that we have to continue to sup

More ›