SQLite

10 ms·

211.
by SQLite 11y ago
I wrote lemon in the late 1980's on a Sun4, while a graduate student. There was also a program called "lime" that generated an LL(1) parser, but I've long since lost that code. Lemon was intended as a yacc-replacement.
212.
by SQLite 11y ago
(1) Consistent, repeatable results across all platforms - the library will not fail or degrade because of a platforms dodgy printf() implementation. (2) SQLite's printf includes extensions like %q and %Q that help prevent SQL injection
213.
by SQLite 11y ago
OT but important: We do not normally accept patches at SQLite because (1) that would endanger the "public domain" status of the project unless the patch is accompanied by a lot of paperwork and the sender resides in a British Com
214.
by SQLite 11y ago
SQLite is a TCL extension that escaped into the wild.... I think many people have trouble with TCL because it looks a lot like C and so they expect it to behave roughly like C. But TCL is a fundamentally different language. It is better t
215.
by SQLite 11y ago
The JSON support in SQLite is in a very early stage of design and development still. There is a lot of cool stuff coming. But there is also still a lot of work to do. Please check back in a few weeks. If you would like to leave comments d
216.
by SQLite 12y ago
The sqllogictest suite ( https://www.sqlite.org/sqllogictest ) only has to be run on all the various servers when the tests themselves change, in order to validate the tests. Otherwise, those tests only need to be run on the
217.
by SQLite 12y ago
The minimum set of tests needed to provide 100% branch coverage takes about 3 minutes on a fast machine. To run all of the tests under various compile-time options and on all supported platforms usually takes two to three days, assuming eve
218.
by SQLite 12y ago
I received a gracious reply from the Hankinsoft developers. They have already added a disclaimer to the website and are promising to make the distinction between their product and SQLite even clearer over the next few days. Hopefully any
219.
by SQLite 12y ago
It is a violation of the SQLite trademark, I believe. I have sent a gentle email to the "sqlitepro.com" company pointing this out to them and suggesting some simply changes that will avoid the trademark violation. Hopefully they
220.
by SQLite 12y ago
The cycle-counts returned by cachegrind are repeatable, to 7 or 8 significant figures. That means that I can make a small change and rerun the test and know whether or not the change helped or hurt even if the difference is only 0.01%. I
221.
by SQLite 12y ago
I'd like to improve the document so that reference to the SQLite source code is not required. Can you explain (perhaps via private email) what the file format document did not describe sufficiently for you to implement a reader in Go?
222.
by SQLite 12y ago
The underlying problem is that POSIX Advisory Locks are broken by design. They are per-process, rather than per-file-descriptor locks. So, if you have two file descriptors open on the same file in the same process, a lock on one file descr
223.
by SQLite 13y ago
Used to be true. But recent versions of SQLite fix this.
224.
by SQLite 13y ago
When designing a file format, it is always a good idea to plan for enhancements. There were originally 36 bytes of unused space in the 100-byte header of the SQLite 3.0.0 file format, back in 2004 - bytes set aside specifically to deal wit
225.
by SQLite 13y ago
There are currently 24 contiguous bytes of unused space in the SQLite header. If need be, and if SQLite catches on for use as a portable image format, I will be willing to allocate some or all of those 24 bytes to an identifier string for
226.
by SQLite 13y ago
Not if you set "PRAGMA secure_delete=ON;" See http://www.sqlite.org/pragma.html#pragma_secure_delete for additional information.
227.
by SQLite 14y ago
We found it is much easier to handle exceptions without risking stack leaks using a 3-address register machine. Code generation is also simplified in a register machine compared to a stack machine (at least in the case of a VM designed spe