SQLite

5 ms·

31.
by SQLite 2y ago
Author here: My title was imprecise and unclear. I didn't mean that you should raise errors if CRLF is used as a line terminator in (for example) HTTP, only that a bare NL should be allowed as an acceptable line terminator. RFC2616 r
32.
by SQLite 2y ago
Correct. "Secure delete" is sufficient to prevent forensic traces from persisting in the database file itself. So you could, for example, send the database file over a TCP/IP link after a secure delete and no deleted data wo
33.
by SQLite 2y ago
Just to clear up the error in the parent post: SQLite has native blobs, floats, and integers, not just strings. It doesn't have a bunch of other types for things like dates and JSON - you just represent those things using the native
34.
by SQLite 2y ago
Performance analysis indicates that SQLite spends very little time doing bytecode decoding and dispatch. Most CPU cycles are consumed in walking B-Trees, doing value comparisons, and decoding records - all of which happens in compiled C co
35.
by SQLite 2y ago
Perhaps the OP means OsQuery: https://github.com/osquery/osquery OsQuery is an SQLite extension consisting of hundreds of virtual tables that provide SQL access to operating system status and configuration.
36.
by SQLite 2y ago
About 10% overall (9.96% to be precise), according to server logs over the previous 10 days. Robots hit dynamic content at about twice the rate as humans: 14.12% versus 7.8%. About 34% of traffic is from robots, from what I can tell (thou
37.
by SQLite 2y ago
That is inaccurate. Ginko's statement is closer to truth. I was inspired to write SQLite while working with Informix on DDG-79 and I saw how useful an embedded database would be in some situations, compared to a client/server sol
38.
by SQLite 3y ago
One example: Fossil ( https://fossil-scm.org ), the version control system used by SQLite itself. Fossil is Git-like in its underlying design but has a different interface. Fossil stores a complete source code repository as an S
39.
by SQLite 3y ago
Yeah - I'm very much about maintaining an immutable record. That is why, back in 2006, I started designing Fossil to control SQLite, instead of just switching to Git. I think that proper version control should be immutable. If histor
40.
by SQLite 3y ago
The document first appeared 2010-11-11. The latest change was on 2023-05-10. See https://www.fossil-scm.org/home/finfo/www/fossil-v-git.wiki for a complete change history for the document - including change
41.
by SQLite 3y ago
SQLite file format spec: https://www.sqlite.org/fileformat2.html Complete version history: https://sqlite.org/docsrc/finfo/pages/fileformat2.in Note that there have been no breaking changes s
42.
by SQLite 3y ago
No - because nobody has provided a reproducible test case to show an actual performance regression. If we can't reproduce it, then how are we suppose to fix it?
43.
by SQLite 3y ago
It does do exactly that. If you visit https://sqlite.org/src/stat , the "Schema Version" line tells you exactly what version of the database schema that the repository is using. The SQLite repository uses th
44.
by SQLite 3y ago
I dispute this claim. The underlying artifact format for Fossil is compatible back to the beginning. There have been enhancements, but nothing that would break. And there have been no reports of breakage among the countless users on the
45.
by SQLite 3y ago
Use whatever VCS you like, but do please note that Fossil does have a "cherry-pick" command. See https://fossil-scm.org/home/help?cmd=cherry-pick for the documentation. Earlier in it's history, Fossil d
46.
by SQLite 3y ago
The link is to a debugging and testing version of the document. Notice the "debug" in the URL: " https://sqlite.org/debug/matrix/whynotgit.html " The correct link is https://sqlite.o
47.
by SQLite 3y ago
That branch has been renamed "bedrock" (after its principal user) and is up-to-date.
48.
by SQLite 3y ago
The important point to keep in mind is that SQLite will read JSON5, but it never writes it. The JSON that SQLite generates is canonical JSON that is fully compliant with the original JSON spec. It turns out that there is a lot of "J
49.
by SQLite 4y ago
> SQLite is closed to outside contributions. Incorrect. Anyone is allowed to contributed to the SQLite code base. There is no religious test, nor even any code-of-conducts requirements for being able to contribute to SQLite. This has al
50.
by SQLite 4y ago
The server is on Linode. Looking at the stats, they appeared to have had an outage of some kind last night at about the time you got this message. Everything seems to be running fine now. Please try again. https://sqlite.org&#x
51.
by SQLite 4y ago
The CLI does use the relevant APIs, however I don't know of a way to reach this bug using a script input to the CLI. If there is such a path that I don't know about, it seems like it would require at least a 2GB input script.
52.
by SQLite 4y ago
There is a lot of static content on https://sqlite.org/ but also a lot of SQLite-backed dynamic content. I just checked the logs. Over the past 5 days, 12.03% of non-robot HTTP requests were against dynamically generated
53.
by SQLite 4y ago
Fossil creator here: Fossil was created for one purpose - to support the development of SQLite, a job at which it has been successful beyond all expectation. Any other use of Fossil (and there is a lot of that, though still a lot less tha
54.
by SQLite 4y ago
No. The SQLite Forum is just an instance of Fossil. Fossil is written in C.
55.
by SQLite 4y ago
RIGHT and FULL JOIN are on the trunk branch of SQLite and will (very likely) appear in the next release. Please grab a copy of the latest pre-release snapshot of SQLite ( https://sqlite.org/download.html ) and try out the ne
56.
by SQLite 4y ago
You misunderstand. It means that a single application should not use two or more copies of the SQLite library to open the same database file. As a practical matter, you really have to work hard to get an application to use two different co
57.
by SQLite 4y ago
Edit history: https://sqlite.org/docsrc/finfo?name=pages/btreemodule.in That last substantive edit to the document was in 2009. There were some spelling corrections in 2010. We finally got around to removing it f
58.
by SQLite 4y ago
Some issues with "Git the standard format": * Does not track cherry-picks * Does not track branch names * Tags must be unique. (You cannot add a "release" tag to every release, for example.) * Not
59.
by SQLite 4y ago
Documentation here: https://fossil-scm.org/home/doc/trunk/www/serverext.wiki
60.
by SQLite 5y ago
> Open Source Definition explicitly excludes [public domain] Mis-information. The Open Source Definition ( https://opensource.org/osd ) has no such exclusion. Read it for yourself.

More ›