Re: [sqlite] Client/Server Best Practices

On Friday, 9 January, 2015 16:43, James K. Lowden said: >On Wed, 07 Jan 2015 21:47:24 -0700 "Keith Medcalf" wrote: >Along the same lines, since you mentioned it, >> in an SQLite database you can do: >> BEGIN >> SELECT ... >> SELECT ... >>

Re: [sqlite] SQLite 3.8.8 expected in January

The pre-compiled and supplied DLL (sqlite3.dll) seem to be missing an entry point for "sqlite3_enable_load_extension" - I do not see any mention in the update text about altering or removing this feature so I am assuming this might be a compile-time omission? On 2015/01/09 19:23, Richard Hipp

Re: [sqlite] Segfault with Evolution and patched SQLite 3.8.7.4 (was: Bus error with Evolution 3.12.9 and SQLite 3.8.7.4)

On 1/9/15, Paul Menzel wrote: > Am Dienstag, den 30.12.2014, 16:15 +0100 schrieb Paul Menzel: > > With still around 1.3 GB free on the partition mounted to `/var/`, > Evolution crashed with the f received the following segmentation fault > today. Which build of

Re: [sqlite] New column in select will not mask column of the same name in having clause and sqlite won't warn

On Thu, 8 Jan 2015 08:42:25 + Hick Gunter wrote: > It is legal and well defined in SQLite. See the explain output below. > This is because of the well-documented feature of SQLite that columns > that are neither GROUPED BY nor aggregated will have a defined value. OK,

Re: [sqlite] Client/Server Best Practices

On Wed, 07 Jan 2015 21:47:24 -0700 "Keith Medcalf" wrote: > >As I said, your description (which I trust is accurate) is very > >helpful to someone who wants to understand how SQLite will act on > >the SQL provided to it. But it also protrays problematic choices > >that

Re: [sqlite] Segfault with Evolution and patched SQLite 3.8.7.4 (was: Bus error with Evolution 3.12.9 and SQLite 3.8.7.4)

Am Dienstag, den 30.12.2014, 16:15 +0100 schrieb Paul Menzel: > Am Dienstag, den 30.12.2014, 08:21 -0500 schrieb Richard Hipp: > > On Mon, Dec 29, 2014 at 10:37 AM, László Böszörményi (GCS) wrote: > > > > > it’s not obvious that these might cause such a regression. > > > > > > I'm the maintainer

Re: [sqlite] Error while executing query: no such column: t1.*B.Switch-Tower-Sector

I got it...so happy, thanks guys -- View this message in context: http://sqlite.1065341.n5.nabble.com/Error-while-executing-query-no-such-column-t1-B-Switch-Tower-Sector-tp79905p79930.html Sent from the SQLite mailing list archive at Nabble.com. ___

Re: [sqlite] SQLite 3.8.8 expected in January

On 1/9/15, Dominique Devienne wrote: > On Fri, Jan 9, 2015 at 6:23 PM, Richard Hipp wrote: > >> We hope to release SQLite version 3.8.8 sometime later this month >> (January). A change-log is available at >>

Re: [sqlite] SQLite 3.8.8 expected in January

On Fri, Jan 9, 2015 at 6:23 PM, Richard Hipp wrote: > We hope to release SQLite version 3.8.8 sometime later this month > (January). A change-log is available at > https://www.sqlite.org/draft/releaselog/current.html Could you please provide more info about stmt_scanstatus()?

Re: [sqlite] sqlite data source not available

I wish to add a confirmation to this. SQLite installation for 1.0.94.0 did not add the option for System.Data.Sqlite Database File to "Choose Data Source" dialog when adding ADO.NET Entity Data Model to my application. Using: ~ Visual Studio 2010 ~ VB.NET WinForms Application @ .NET 4.0 ~

[sqlite] SQLite 3.8.8 expected in January

We hope to release SQLite version 3.8.8 sometime later this month (January). A change-log is available at https://www.sqlite.org/draft/releaselog/current.html Please stress the code in every way you can between now and then and report any problems to this list, or directly to me. Source code

Re: [sqlite] a couple of crashing bugs from a fuzzer

The fuzzer seems to be http://lcamtuf.coredump.cx/afl/ And an interesting blog post about it is http://lcamtuf.blogspot.ca/2014/11/pulling-jpegs-out-of-thin-air.html American fuzzy lop is a security-oriented fuzzer that employs a novel type of compile-time instrumentation and genetic

Re: [sqlite] Scrolling Cursor implementation best practices (pagination and arbitrary sorting)

Hi Keith, 2015-01-09 2:02 GMT+03:00 Keith Medcalf : > > The table you are creating is called a keyset snapshot. That is how all > relational databases databases which support scrollable cursors implement > them (only navigable databases -- hierarchical or network or network

Re: [sqlite] Should .dump preserve foreign_keys pragma?

On Fri, Jan 9, 2015 at 11:57 AM, Dominique Devienne wrote: > On Fri, Jan 9, 2015 at 11:35 AM, Niall O'Reilly > wrote: > >> At Thu, 08 Jan 2015 15:55:00 -0700, >> Keith Medcalf wrote: >> > >> > when you load a dump file you need to have that foreign >>

Re: [sqlite] Should .dump preserve foreign_keys pragma?

On Fri, Jan 9, 2015 at 11:35 AM, Niall O'Reilly wrote: > At Thu, 08 Jan 2015 15:55:00 -0700, > Keith Medcalf wrote: > > > > when you load a dump file you need to have that foreign > > key enforcement off in order to be able to load the database. This > > is because the

Re: [sqlite] Should .dump preserve foreign_keys pragma?

At Thu, 08 Jan 2015 15:55:00 -0700, Keith Medcalf wrote: > > when you load a dump file you need to have that foreign > key enforcement off in order to be able to load the database. This > is because the tables and data are dumped in random order, not in > hierarchical order (parents of parents

Re: [sqlite] Client/Server Best Practices

Thanks for all the sage observations. As a server with a connection pool, I'm avoiding some of issues brought up. Every thread has their own connection handle and when done, it goes back into the pool so no sharing. I spent some hours reading everything I could find about this product and