Re: [sqlite] hide sqlite database

I have backup of existing database. I just want to hide this backup database. On Thu, Mar 7, 2013 at 5:49 PM, Clemens Ladisch wrote: > dd wrote: > > I want to hide sqlite database file. > > If you hide it, SQLite will not be able to open it. > It would be easier to just

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

FreeBSD 9.1-RELEASE #0 r243826: Tue Dec 4 06:55:39 UTC 2012 r...@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC i386 %sqlite3 :memory: SQLite version 3.7.15.1 2012-12-19 20:39:10 Enter ".help" for instructions Enter SQL

Re: [sqlite] SQLite strong-typing [WAS: inner vs. outer join inconsistency]

On 9 Mar 2013, at 8:01pm, James K. Lowden wrote: > Looking at the sources, the name of the constraint would have to be > dragged from the parser through the virtual machine, where it would be > associated with the generated code that enforces the constraint. You'll be

Re: [sqlite] SQLite strong-typing [WAS: inner vs. outer join inconsistency]

On Sat, 9 Mar 2013 09:43:35 -0800 Peter Haworth wrote: > Seems like there are several ways to skin this cat. The problem I > have with CHECK is the generic error message it produces. If a table > has several columns with CHECK statements, how does my application > know which

Re: [sqlite] SQLite strong-typing [WAS: inner vs. outer join inconsistency]

Seems like there are several ways to skin this cat. The problem I have with CHECK is the generic error message it produces. If a table has several columns with CHECK statements, how does my application know which one failed? I favor the trigger approach because I can define a meaningful error

Re: [sqlite] Changed behavior in SQLite 3.7.16 beta

Please try again with the latest 3.7.16 beta. You can download an amalgamation snapshot from http://www.sqlite.org/test/download.html The testing checklist (http://www.sqlite.org/checklists/3071600) has been restarted once again on account of this issue. On Thu, Mar 7, 2013 at 7:07 PM, Peter