[sqlite] SQLite version 3.8.11 coming soon...

Will be one day support for storagefiles for Windows 10 to allow paths that are not inside the appfolder? Sent from my Windows Phone From: Richard Hipp Sent: ?14/?07/?2015 22:05 To: General Discussion of SQLite Database

[sqlite] Schema-less JSON SQLite DB?

On Tue, 14 Jul 2015 10:22:02 -0700, Hayden Livingston wrote: > Wow, this is the killer feature no-one told me about. > I can get rid of types? How does this work under-the-hood? > > SELECT * FROM TABLE WHERE FooColumn > 50 > > And I've stored "Something" in that column in some row. > What's the

[sqlite] Schema-less JSON SQLite DB?

On 14 Jul 2015, at 6:22pm, Hayden Livingston wrote: > Wow, this is the killer feature no-one told me about. I can get rid of > types? How does this work under-the-hood? > > SELECT * FROM TABLE WHERE FooColumn > 50 > > And I've stored "Something" in that column in some row. What's the

[sqlite] Fwd: Usenix paper: Korean researchers invent sqlite WALDIO mode to circumvent redundant journaling by EXT4 on eMMC

Wait, does https://www.sqlite.org/fileformat2.html say that database pages have an index number stored (so if storage messes up sequence of sectors, will SQLite notice)? Right, exactly http://www.sqlite.org/src/tktview?name=72b01a982a . And that means the underlying FS needs to make the

[sqlite] SQLite version 3.8.11 coming soon...

The plan is to release SQLite version 3.8.11 on or about the end of July. The current code is passing all tests that we have run against it. Some soak tests are still running. There are quite a few cross-platform tests (running on PPC, Sparc, etc) that have yet to be started, but which should

[sqlite] Fwd: Usenix paper: Korean researchers invent sqlite WALDIO mode to circumvent redundant journaling by EXT4 on eMMC

The ZFS filesystem Fletcher-checksums all data - perhaps together with tagging each "page" with its "page number", duno! This is awesome as it's a quite nice data integrity guarantee: this guarantees that data is in the right place (so broken sector mapping tables won't break anything) and is

[sqlite] Fwd: Usenix paper: Korean researchers invent sqlite WALDIO mode to circumvent redundant journaling by EXT4 on eMMC

On 7/13/15, Donald Griggs wrote: > There's an interesting paper at > > https://www.usenix.org/system/files/conference/atc15/atc15-paper-lee-wongun.pdf Yes, a very interesting paper. Thanks for bringing it to my attention. > > I don't know enough to evaluate it, but if I'm understanding

[sqlite] Usenix paper: Korean researchers invent sqlite WALDIO mode to circumvent redundant journaling by EXT4 on eMMC

On 14 Jul 2015, at 2:53pm, Mikael wrote: > This is awesome as it's a quite nice data integrity guarantee: this > guarantees that data is in the right place (so broken sector mapping tables > won't break anything) and is correct! > > Does SQLite do the same, what about SQLite do the same,

[sqlite] Fwd: Usenix paper: Korean researchers invent sqlite WALDIO mode to circumvent redundant journaling by EXT4 on eMMC

On Mon, 2015-07-13 at 21:25 -0400, Donald Griggs wrote: > > -- One mode does require that power not be removed abruptly from the eMMC > controller (but they still claim durability even in the face of a kernel > panic) That's true of *all* modes of operation of most MMC and SSD class devices.

[sqlite] Schema-less JSON SQLite DB?

that does indeed look interesting. Embedded DB is the only problem here. On Mon, Jul 13, 2015 at 11:01 PM, Darren Duncan wrote: > Have a look at PostgreSQL 9.4 as well and its new JSONB data type. Gives > you the goods of relational and hierarchical databases in one place, > including the

[sqlite] Schema-less JSON SQLite DB?

Wow, this is the killer feature no-one told me about. I can get rid of types? How does this work under-the-hood? SELECT * FROM TABLE WHERE FooColumn > 50 And I've stored "Something" in that column in some row. What's the behavior? I don't want to take up your time, so if there's a document I

[sqlite] Fwd: Usenix paper: Korean researchers invent sqlite WALDIO mode to circumvent redundant journaling by EXT4 on eMMC

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/14/2015 06:53 AM, Mikael wrote: > Does SQLite do the same, what about SQLite do the same, patch? The SQLite authors rejected checksumming SQLite database pages. The existing integrity check will only catch issues that happen in sufficiently

[sqlite] how to cite SQLite

On 13 Jul 2015, at 11:48pm, Roman Fleysher wrote: > What I also meant is that software often impements unique algorithms, which I > think SQLite does. These algorithms may be presented at conferences/journals. > In turn, these publications cite the URL. Thus, I was looking for such a >

[sqlite] Schema-less JSON SQLite DB?

Have a look at PostgreSQL 9.4 as well and its new JSONB data type. Gives you the goods of relational and hierarchical databases in one place, including the querying and indexing. -- Darren Duncan On 2015-07-13 5:43 PM, Hayden Livingston wrote: > Is there a concept of a schema-less JSON