Re: [sqlite] about merge rows

@hello, it looks like an old sybase -ms-flatten-like export, if I understand well you got that just after splitting then pivoting the properties, am I wrong? On Thu, Apr 17, 2014 at 6:43 PM, Igor Tandetnik wrote: > On

Re: [sqlite] Any interest for open source multi-user 'SQLite database server' application?

On Tue, Apr 01, 2014 at 01:08:59PM +, Harmen de Jong - CoachR Group B.V. wrote: > We have built our own SQLite database server application and are considering > making this open source. Since there will be some time involved into making > it an open source project and maintaining it, we

[sqlite] Regarding SQLITE installation

I want to install sqlite for - Linux (X86_64) and NetBSD 6.1 (X86_64) What should be appropriate options for executing configure script to install for specified target. I don’t see any option to specify x86_64-linux and x86_64-netbsd Can anyone help me at earliest convenience… Regards, Nitin

[sqlite] printf function is shown in docs but not found when I try it

In the documentation at http://www.sqlite.org/lang_corefunc.html there's a printf function, however when I try and use it in sqlite3 (on xubuntu 13.10) it says "Error: no such function: printf". Is this because I need to load some extra library to make it work or is it just not available in the

Re: [sqlite] printf function is shown in docs but not found when I try it

On Thu, Apr 17, 2014 at 8:03 AM, wrote: > In the documentation at http://www.sqlite.org/lang_corefunc.html > there's a printf function, however when I try and use it in sqlite3 > (on xubuntu 13.10) it says "Error: no such function: printf". > > Is this because I need to load some

Re: [sqlite] Regarding SQLITE installation

On Thu, Apr 17, 2014 at 9:04 PM, Nitin Nimran wrote: > I want to install sqlite for - Linux (X86_64) and NetBSD 6.1 (X86_64) > > What should be appropriate options for executing configure script to > install for specified target. Please see

Re: [sqlite] field length retreval

On Fri, Apr 18, 2014 at 12:53 AM, Simon Slavin wrote: > On 17 Apr 2014, at 11:24pm, David Clark wrote: >> If I have a table of >> field1 varchar(25) >> field2 varchar(50) >> field3 varchar(75) > > You don't. SQLite does not support a datatype of

Re: [sqlite] Any interest for open source multi-user 'SQLite database server' application?

On Fri, Apr 18, 2014 at 6:32 AM, Christian Smith < csm...@thewrongchristian.org.uk> wrote: > On Tue, Apr 01, 2014 at 01:08:59PM +, Harmen de Jong - CoachR Group > B.V. wrote: > > We have built our own SQLite database server application and are > considering making this open source. Since

Re: [sqlite] field length retreval

On 18 Apr 2014, at 3:21pm, Dominique Devienne wrote: > On Fri, Apr 18, 2014 at 12:53 AM, Simon Slavin wrote: >> There are ways to enforce field length limits entirely within SQLite but >> they're complicated so post again if you want me to explain

Re: [sqlite] Why sqlite has no sqlite_bind_auto or similary named function

On 4/18/2014 12:29 AM, Max Vlasov wrote: The problem was with my program that automatically converts xml data into an sqilte table. It looks for an attribute and appends a column if it does not exists, but stating no particular type. All values were appended with sqlite_bind_text. Everything was

Re: [sqlite] field length retreval

On Fri, Apr 18, 2014 at 4:42 PM, Simon Slavin wrote: > On 18 Apr 2014, at 3:21pm, Dominique Devienne wrote: >> No need to resort to triggers. A simple check constraint will do > > A constraint can prevent you from putting too-long values in the field.

Re: [sqlite] field length retreval

On 18 Apr 2014, at 5:28pm, Dominique Devienne wrote: > I'm not sure where you get that declaring a column as varchar() > implicitly truncate While I can't find any reference one way or another in a SQL standard, all implementations I've seen that understand VARCHAR(n)

[sqlite] What does Installer.exe do in the binary packages?

I just downloaded sqlite-netFx20-binary-Win32-2005-1.0.92.0.zip and in addition to the core SQLite .dll files there are a lot of other files including an installer. This is a binary package, not a setup or bundle package, so what does the installer do? I read the information on the download

Re: [sqlite] Why sqlite has no sqlite_bind_auto or similary named function

On Fri, Apr 18, 2014 at 8:08 PM, Andy Goth wrote: > On 4/18/2014 12:29 AM, Max Vlasov wrote: >> >> So it seems like if general queries allow affinity automatical >> selection while bind api does not have the corresponent function. I >> know that I can analize incoming

Re: [sqlite] field length retreval

On 18-4-2014 18:56, Simon Slavin wrote: On 18 Apr 2014, at 5:28pm, Dominique Devienne wrote: I'm not sure where you get that declaring a column as varchar() implicitly truncate While I can't find any reference one way or another in a SQL standard, all implementations

Re: [sqlite] What does Installer.exe do in the binary packages?

Drago, William @ MWG - NARDAEAST wrote: > > This is a binary package, not a setup or bundle package, so what does the > installer do? > The binary package simply includes all binaries built from the System.Data.SQLite source tree and their associated files (i.e. the ones that end up in the

Re: [sqlite] field length retreval

I know very little about Postgres, but I see this interesting page in their documentation: http://www.postgresql.org/docs/8.0/interactive/datatype-character.html Excerpt: *An attempt to store a longer string into a column of these types will result in an error, unless the excess characters are

Re: [sqlite] field length retreval

On 18 Apr 2014, at 7:29pm, Donald Griggs wrote: > I tried a simple test with recent [Postgres] (9.3.4) version (using default > settings, > if that matters) and verified that an insert with oversized string will > fail to insert, unless the overage characters are spaces

Re: [sqlite] Any interest for open source multi-user 'SQLite database server' application?

Hello, First off, agreed an ODBC interface would be more suitable and secure, don't trust today-most-web-devs to make the RPC layer secure [cruft-obfuscation open backdoor they know], not trolling around just the day to day reality; when I sit on some server-codes ... if you can call that "code"

Re: [sqlite] printf function is shown in docs but not found when I try it

Richard Hipp wrote: > On Thu, Apr 17, 2014 at 8:03 AM, wrote: > > > In the documentation at http://www.sqlite.org/lang_corefunc.html > > there's a printf function, however when I try and use it in sqlite3 > > (on xubuntu 13.10) it says "Error: no such function:

Re: [sqlite] Regarding SQLITE installation

Hello, Le jeudi 17 avril 2014 à 12:04 -0700, Nitin Nimran a écrit : > I want to install sqlite for - Linux (X86_64) and NetBSD 6.1 (X86_64) > > What should be appropriate options for executing configure script to > install for specified target. > > I don’t see any option to specify

Re: [sqlite] printf function is shown in docs but not found when I try it

On 4/18/2014 8:49 AM, c...@isbd.net wrote: Alternatively are there any other reasonably practical ways to format numeric output? Specifically I want to format floating point numbers into a fixed format like NNN.N. Your application can provide custom functions callable from queries. Tcl

Re: [sqlite] printf function is shown in docs but not found when I try it

On 18 Apr 2014, at 2:49pm, c...@isbd.net wrote: > Xubuntu 13.10 (which I'm currently using) has sqlite 3.7.17. > > Xubuntu 14.04 has sqlite 3.8.2, I'm not sure if they're likely to move > to anything newer during its lifetime. If you're writing C or C++ code then you don't need to use

Re: [sqlite] Windows Phone 8.1

Hi Lane I was wondering if you have found a solution. I am running into the same issue with Azure Mobile Services and a Windows Phone 8.1 App. Cheers Ryan -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Lane Williams

[sqlite] FTS3/4 bug with tokenize=icu and parentheses

A few days ago I suspected a bug with SQLite FTS4 parenthesis when using the ICU tokenizer. To rule out it was my slightly altered SQLite build environment to compile SQLite + ICU for the iPhone, I reproduced this issue today with the current version of SQLite on OS X. Steps to reproduce: SQLite