SQLite

8 ms·

181.
by SQLite 9y ago
I don't know who posted this story, but it is timely. Earlier today I was working on a new related article ( https://www.sqlite.org/draft/fasterthanfs.html ) claiming that it is faster to read blobs out of SQLite t
182.
by SQLite 10y ago
When adding an attachment in Fossil, if the attachment is syntactically similar to a structural artifact (such as a manifest), then the attachment is compressed prior to being hashed and stored, thus making it very dissimilar to a manifest
183.
by SQLite 10y ago
I intend to support SQLite for 33 more years. I take that commitment seriously and plan accordingly. But even if my plans do not work out, the SQLite file format is fully documented and relatively simple. See https://www.sqlite
184.
by SQLite 10y ago
Reassuring news. Thanks.
185.
by SQLite 10y ago
Go has chosen to omit assert(), because assert() is frequently misused they say. Antibiotics are also frequently misused, but that is not a good reason to prohibit them. The omission of assert() makes Go a non-starter. Rust seems more promi
186.
by SQLite 10y ago
Short answer: Write Amplification. Long answer: When the index is created first, new entries have to be inserted into the index (in sorted order) as they arrive. This involves writing various individual records at arbitrary places in the
187.
by SQLite 10y ago
> What happens if SQLite changes the way a feature behaves, even for good reason? The developers aren't beholden to browser devs, so this is within their right. Actually, we are beholden to application developers of all types. It&#x
188.
by SQLite 10y ago
https://www.sqlite.org/src/timeline?n=100&r=begin-concurrent
189.
by SQLite 10y ago
> I never could get anonymous push/user registration to work smoothly.... We are always trying to make Fossil better. Can you explain what you mean by "anonymous push/user registeration" and provide more information
190.
by SQLite 10y ago
Original author of Fossil here, with two comments: (1) Fossil was created for the single purpose of supporting SQLite development, a mission at which it has succeeded spectacularly. Fossil is therefore a success story, irregardless of its m
191.
by SQLite 10y ago
No you don't. CHECK constraints always work. Maybe you are thinking about foreign key constraints, which for backwards compatibility are off by default, unless you use a compile-time option to make then on by default.
192.
by SQLite 10y ago
Perhaps the take-away is that when the SQL engine is in-process and queries do not involve a server round-trip, the "n+1 query problem" is not really a problem.
193.
by SQLite 10y ago
An example is http://sqlite.org/src/timeline A complete log of the 200+ SQL statements used in generating the page above can be seen at http://sqlite.org/tmp/timeline-sql-log.html The list of chec
194.
by SQLite 10y ago
We are more open to patches on Fossil because (1) Fossil has a BSD license, which is easier to accept patches for than public-domain and (2) Fossil is seen (rightly or wrongly) as less "mission critical" than SQLite. And, you are
195.
by SQLite 10y ago
Patches are difficult to accept on a public-domain project. That is one real advantage of GPL over BSD-style licenses or public-domain - it is easier to accept patches. I've had a lot of help from Dan and Joe and Shane and others on S
196.
by SQLite 10y ago
"gcc -S sqlite3.c" will give you an assembly language database engine. :-) OK, maybe you meant "hand-written" assembly language. But on the other hand, SQLite claims to be written in C, yet a fair amount of that C code
197.
by SQLite 10y ago
I don't speak Finnish. But I did once hear David Axmark pronounce My's name, and to my ear it sounded like "Mih" - an "M" followed by a short vowel similar to the vowel in "bit". In other words, My&
198.
by SQLite 10y ago
TH1 (literally "Test Harness #1") was originally conceived as a minimalist reimplementation of TCL sufficient to run the TCL-based SQLite test suite on SymbianOS. That use case never materialized. But later, when I needed a smal
199.
by SQLite 10y ago
Initially, WAL mode was off by default because older versions of SQLite do not support it, and it is a property of the database file. Thus, a database created in WAL mode would be unreadable by older SQLites. But WAL has been available for
200.
by SQLite 10y ago
There is a testing checklist ( https://www.sqlite.org/checklists/3130000/index is an example). Each item on the checklist is usually just a single "button push" (really a shell command). But we have to
201.
by SQLite 10y ago
Clarification: You can have multiple connections (aka file descriptors) open on the same database file for writing at the same time. But only one can be actively writing at a time. SQLite uses file locking to serialize writes. Multiple
202.
by SQLite 10y ago
The designer of Fossil and SQLite here... Git was designed to support Linux development. Fossil was designed to support SQLite development. Those projects have very different needs. The details are the subject of a 1-hour talk and are more
203.
by SQLite 10y ago
How about allowing pointers to be compared against NULL after they have been passed to free(): "free(x); if( x!=NULL ){...}" That was completely harmless (and a useful idiom) for 45 years, and now suddenly it is flagged as UB an
204.
by SQLite 10y ago
I was not aware of kcov or its basis bcov. Thanks for pointing those out. However, a quick glance at the bcov source code leads me to believe that it only does source-line coverage, not branch coverage. So, unless my quick reading of bcov
205.
by SQLite 11y ago
Yes, I am.
206.
by SQLite 11y ago
Using "gcc -Os -m32 -c sqlite3.c; size sqlite3.o" I get 443,264 bytes using the latest SQLite source on Ubuntu. The "size" command gives a more accurate measurement of what actually ends up in a compiled and stripped bin
207.
by SQLite 11y ago
Isn't that why we have aircraft carriers?
208.
by SQLite 11y ago
> Cannot perform a "fossil diff" for just a directory and its descendants Thanks for the suggestion. I just checked in an enhancements so that this works now. https://www.fossil-scm.org/fossil/info/c
209.
by SQLite 11y ago
That won't work because the SHA1 hashes won't match up. If you accidentally check-in proprietary or sensitive content that you didn't mean to publish, you can shun that content. Shunning leaves a hole in your history. There
210.
by SQLite 11y ago
Indeed, SQLite is merely a Tcl extension that "escaped" into the wild. SQLite no longer depends on Tcl to run, but it does still depends on Tcl for its make process and for testing. The SQLite development team also depends on to

More ›