SQLite

9 ms·

151.
by SQLite 8y ago
Tcl/Tk is very much alive, and actively maintained. See the check-in history at https://core.tcl.tk/tcl/timeline (Tcl) and https://core.tcl.tk/tk/timeline (Tk). There are annual conferences
152.
by SQLite 8y ago
> SQLite [is] not a recognized standard by any body of peers to my knowledge... Well, there is this: https://www.loc.gov/preservation/resources/rfs/data.html Also, the on-disk format for SQLite has been ex
153.
by SQLite 8y ago
Not quite right. The expression "CAST('321a' AS INTEGER)" will do as you suggest and ignore the trailing 'a' character, yielding an integer 123 result. But that only happens for an explicit CAST. Automatic ty
154.
by SQLite 8y ago
I confirm your suspicions. People have been appending ZIP archives to executables, in order to hold non-code resources, for time out of mind. The appendvfs extension makes the same thing possible for SQLite databases. An SQLite database h
155.
by SQLite 8y ago
You are no doubt correct about points (2) and (5). But just to set the record straight, points (1), (3), and (4) are mistaken. The standard build of SQLite uses an OS, but there is a compile-time option to omit the OS dependency. It then
156.
by SQLite 8y ago
For reading many blobs of approx 10KB each, it is often faster to read them out of an SQLite database than from separate files on disk. See https://sqlite.org/fasterthanfs.html for details and to download code that you can
157.
by SQLite 8y ago
If we accept patches, then the person who has submitted the patch owns the copyright on that patch, and that means the software is no longer completely in the public domain. Unless, of course, the patch submitter has filled out a lot of le
158.
by SQLite 8y ago
SQLite shifted to Fossil in stages. Documentation moved in 2007. The TH3 and sqllogictest test suites started out in Fossil in 2008. I wrote Fossil specifically to support SQLite development. If Fossil does nothing else other than suppor
159.
by SQLite 8y ago
Indeed, that was then intent. The other points are serious, but then I thought "let's throw in a cartoon!" I just wrote the referenced article last night. Normally, I takes months or years before something like this gets pi
160.
by SQLite 8y ago
Thanks for reporting this. It is an interesting problem, that I'm not sure how to solve (being yet early and I without coffee). The README.md file is the homepage. It is intended to be displayed using the URL https://wapp.
161.
by SQLite 9y ago
Just to be clear: The SQLite project strives to fix UB whenever any is discovered (which is to say, "rarely"). But SQLite also focuses on testing at the machine-code level, not just at the source code level. The machine-code ge
162.
by SQLite 9y ago
SQLite was late to the party. The first code for SQLite was laid down in 2000, years after MySQL was already well-established in the LAMP stack. Also, SQLite is embedded, not client/server. That means that the application needs to ru
163.
by SQLite 9y ago
> https://www.fossil-scm.org/index.html/timeline?y=ci ... That is just a mess of unimportant info. That screen contains all and only the information I want to see. (No surprise, since I wrote that screen.) I would
164.
by SQLite 9y ago
> I haven't ever needed to look at descendants. Perhaps that's just because the limitation is deeply established in my mind... That's my theory, too. I never needed to run "bisect" until I had the capability to
165.
by SQLite 9y ago
Author of the referenced wiki post, and of SQLite and Fossil here... The other day, I had 60 minutes of free time between events and so I brainstormed a few ideas for improving Fossil while sitting in a Starbucks, and those unedited, spur-o
166.
by SQLite 9y ago
> I don't remember the original quote, but is alike: "Novices worry for code, Experts focus on data structures". The origin is Linus Torvalds on the Git mailing list. Here is a copy from LWN: https://lwn.net&#x
167.
by SQLite 9y ago
I will be happy to write a spec for a cut-down SQL language (a subset of the language understood by SQLite) for WebSQL, and provide a "strict" flag for SQLite to force it to understand all and only the spec language. The prerequi
168.
by SQLite 9y ago
> I don't know why you think it's going to be magically simplified by changing the storage method. Because ZIP is a key/value store and SQLite is relational. (Later:) Here is a slide comparing SQLite to ZIP from a talk I&#
169.
by SQLite 9y ago
If you have an image stored in an SQLite database file, you can extract it using the "sqlite3" command-line tool as described at https://www.sqlite.org/cli.html#file_i_o_functions Or, you could do it several dozen
170.
by SQLite 9y ago
Pen-testers have been hammering hard on SQLite for years. Attacks against SQLite are not as easy as you imagine. Pen-testers do still occasionally find minor problems. See https://www.sqlite.org/src/info/04925dee
171.
by SQLite 9y ago
The $6000 "license" is actually a "Warranty of Title". It is a legal document that certifies that we developers have the right to release SQLite into the public domain (in other words, we didn't copy any part of th
172.
by SQLite 9y ago
You seem to be operating under the assumption that the SQLite database file format is an ad-hoc, dodgy affair that the maintainers might change on a whim. I'd like to try to dispel that notion. The SQLite database file format has been
173.
by SQLite 9y ago
A better starting point might be the database file format description. https://www.sqlite.org/fileformat.html
174.
by SQLite 9y ago
Related articles: https://www.sqlite.org/appfileformat.html https://www.sqlite.org/aff_short.html
175.
by SQLite 9y ago
The "PRAGMA secure_delete=ON;" command will fix that for you. Or you can make secure-delete the default at compile-time using the -DSQLITE_SECURE_DELETE option. There is a (small) performance hit, since extra writes have to occu
176.
by SQLite 9y ago
I'm not sure synchronous=off qualifies as incredibly dangerous. You can corrupt the database with synchronous=off, but only if you loss power or take an OS reboot in the middle of a transaction. Even with synchronous=off, transacti
177.
by SQLite 9y ago
Fossil is the server in this case, not SQLite. It is fine to use SQLite as the local storage in the implementation of some custom server like Fossil, as there is a separate server (Fossil) that sits in between the client and the data. In f
178.
by SQLite 9y ago
FWIW, I'm presenting a talk on exactly this topic tomorrow at 12:30 at the http://www.db-tech-showcase.com/dbts/tokyo - unfortunately I do not think it will be recorded.
179.
by SQLite 9y ago
I'd never heard of "CROSS JOIN LATERAL" before. So I went and read the PostgreSQL documentation. If I understand correctly what LATERAL does, it is not needed by SQLite. The SQLite query planner will figure out on its own
180.
by SQLite 9y ago
> I keep meaning to dig into Fossil, but I have no faith I could convince a team to use it. Developer or Fossil and SQLite here: I agree. In my experience, you'd have better luck convincing the team to switch from vi to emacs. Fo

More ›