SQLite

7 ms·

91.
by SQLite 6y ago
That bug was fixed long ago, even before the referenced video was produced. The described attack is clever. It exploits the fact that an attacker might alter the schema so that it invokes an SQL function with side-effects when an app simpl
92.
by SQLite 6y ago
All versions of SQLite from 3.0.0 (2004-06-18) through 3.34.0 (the latest) use the same database file format. So if two applications use different versions of SQLite, it shouldn't matter. The database file will be the same. Now, if on
93.
by SQLite 6y ago
GCC 5.4.0 is what came installed by default on my Ubuntu 16.04 desktop. I might change to a different compiler except that would be a lot of work, since I would then need to rerun hundreds of historical benchmarks, and it is not clear what
94.
by SQLite 6y ago
The problem that prompted me to make this extension to SQLite was a web-page request, so it needs to be processed with low latency. I initially tried loading the graph into memory and processing it that way. But there are approx 100K node
95.
by SQLite 6y ago
I wrote https://wapp.tcl.tk/ for occasions such as this. SQLite is built-in, of course. One key feature Wapp is that identical code can be run as + CGI from Apache + SCGI from Nginx + As its own stand-alone webserver So, f
96.
by SQLite 6y ago
SQLite described (with links to details) here: https://www.sqlite.org/arch.html
97.
by SQLite 6y ago
Pikchr author here It is difficult to find the right balance between a simple language that requires "toil" and a less toilsome language that is also more complex and requires more effort to learn and master. I'm very open
98.
by SQLite 6y ago
The TH3 test harness for SQLite ( https://www.sqlite.org/th3.html ) supports a virtual filesystem in which we can create test database files that appear to be very large but that don't actually contain much data or use m
99.
by SQLite 6y ago
Author of SQLite and Fossil here - I have not forgotten monotone! Indeed, Fossil itself is inspired by monotone documentation (though not the implementation). This is credited at https://fossil-scm.org/fossil/doc&#x2F
100.
by SQLite 6y ago
Many reasons for this: (1) Because SQLite is just a function call whereas PostgreSQL is a round-trip message to a separate server process, MRigger was able to run many more test cases per second on SQLite. (2) We fixed bugs faster in SQLite
101.
by SQLite 6y ago
The attack is clever and original. AFAIK, nothing like it has ever been seen before. Since this attack came to light, SQLite has added features so that an application can ensure that views and triggers do not have side-effects (outside of
102.
by SQLite 6y ago
This concern was just raised on the SQLite Forum (probably after showing up here). See my reply at https://sqlite.org/forum/forumpost/8beceed68e for additional insights into the problem and recent SQLite enhancem
103.
by SQLite 6y ago
Storing content in SQLite is actually faster than writing the equivalent content directly to disk, in many situations. See https://www.sqlite.org/fasterthanfs.html for discussion, caveats, and links to source code where y
104.
by SQLite 6y ago
What happened: 1. OSSFuzz reports a bug against SQLite. 2. SQLite dev tries to fix the reported problem but is unable to repro the bug on his desktop 3. SQLite dev replicates the OSSFuzz build environment which uses clang-11.0.0 and is t
105.
by SQLite 6y ago
It was late at night. I didn't realize the clang-11.0.0 was unreleased until I saw this HN thread the next morning. The only reason I was using clang-11.0.0 is because the OSSFuzz bug report against SQLite used clang-11.0.0 and I cou
106.
by SQLite 6y ago
That was my business plan: Do the intense testing required for avionics, then sell the test cases to aviation manufacturers. That plan didn't work out - I've never sold the tests to any aviation manufacturer; not one. But the TH
107.
by SQLite 6y ago
On-line docs describing the design and internal operation of SQLite include: https://sqlite.org/arch.html https://sqlite.org/optoverview.html https://sqlite.org/opcode.html https:/&#
108.
by SQLite 6y ago
The issue with NFS and SQLite is that posix advisory locks do not work, or do not work well, on many NFS installations. As long as advisory locks work over NFS, or as long as there is only one client trying to access the database at a time,
109.
by SQLite 7y ago
If you will kindly send your problem query to the SQLite developers, we will do what we can to improve the query planner to make it run faster.
110.
by SQLite 7y ago
I did not. This is the first I've heard of it.
111.
by SQLite 7y ago
Just to be clear: We do not have any support contracts with the US military, nor any other US government agency, nor any other government entity, either inside or outside the US. Not that we would turn down such work if it were available,
112.
by SQLite 7y ago
I don't actually remember making that argument. But I will try to reconstruct my thinking... (1) Keeping an entire repo in a single file is a better abstraction. There is just one file to move around or rename. There is a single icon
113.
by SQLite 7y ago
"blockchain" is self-descriptive, easier to pronounce (only two syllables instead of three), and easier to spell correctly. :-)
114.
by SQLite 7y ago
My experience in developing and maintaining Fossil is that the hashing speed is not a factor, unless you are checking in huge JPEGs or MP3s or something. And even then, the relative performance of the various hash algorithms is not enough
115.
by SQLite 7y ago
> if I understand correctly then Fossil's migration is straightforward because they did not address the same issues Git chose to. I think more is at play here. (1) You can set Fossil to ignore all SHA1 artifacts using the "shun
116.
by SQLite 7y ago
Just to be clear: Every time you modify a file, the new changes get put in using SHA3. In an older repository, any given commit might have some files identified using SHA1 (assuming they have not changed in 3 years) and others identified u
117.
by SQLite 7y ago
> I only wish there was a way to open an http-fetched SQLite database from memory so I don't have to write it to disk first. The sqlite3_deserialize() interface was created for this very purpose. https://www.sqlite.org&#
118.
by SQLite 7y ago
"embedded database" does not imply "serverless database". Other embedded RDBMSes run servers; they just run the server as a separate thread rather than a separate process. SQLite is different in that there is no separate
119.
by SQLite 7y ago
Complete history of the document in question is here: https://www.sqlite.org/docsrc/finfo?name=pages/serverless.in... It was, indeed, written in 2007, but based on ideas that predate that.
120.
by SQLite 7y ago
https://fossil-scm.org/fossil/doc/trunk/www/rebaseharm.md

More ›