Re: [sqlite] seeking database design advice

On Fri, 2 Mar 2012 13:26:23 +1100, BareFeetWare wrote: > Hi Rich, > >> I wanted to solicit some opinions about how best to layout a database table >> for a project I am working on. I have a distributed application that >> reports run time information back to a

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

The backtrace === Program received signal SIGSEGV, Segmentation fault. 0x2b657288 in sqlite3Parser (yyp=0x2d401e40, yymajor=119, yyminor=..., pParse=0x2d4035c8) at sqlite3.c:106740 106740 }while( yymajor!=YYNOCODE && yypParser->yyidx>=0 ); #0 0x2b657288 in sqlite3Parser

Re: [sqlite] seeking database design advice

On 2 Mar 2012, at 3:44am, Mario Becroft wrote: > Making schema changes, such as adding or removing attributes, is not > necessarily difficult. This is what DML is for. However one thing SQL > does not handle well is temporal schemas, i.e. ones in effect during > different

Re: [sqlite] seeking database design advice

I agree with what has been said so far regarding normalization, getting the underlying structure right, and using views to access the data. I would add a couple of points: Database refactoring is not necessarily as hard as has been suggested. In fact, a good design, separating data storage

Re: [sqlite] SQLite and Windows Metro Style

On Thu, Mar 1, 2012 at 7:41 PM, Simon Slavin wrote: > > On 2 Mar 2012, at 12:33am, Richard Hipp wrote: > > > We are told that metro style applications may not use many of the win32 > > APIs that SQLite currently does use (APIs such as LoadLibrary(), > >

Re: [sqlite] import a txt into sqlite

YAN HONG YE wrote: I have a txt file myteam.txt: ID;name;sex;match;chinese;english;phy;chem;total CY001;cred;male;54;101;101;55;99;695 CY002;rose;female;55;105;95;119;101;693 CY003;helen;male;110;95;65;50;50;613 CY004;jack;female;55;65;110;51;50;641 CY005;tonny;male;55;55;111;55;55;514 when I

Re: [sqlite] seeking database design advice

Hi Rich, > I wanted to solicit some opinions about how best to layout a database table > for a project I am working on. I have a distributed application that reports > run time information back to a central machine. Included in the report are > the parameters used during runtime... approx 25

Re: [sqlite] seeking database design advice

On Mar 2, 2012, at 1:28 AM, Rich Rattanni wrote: > I realize design A may not be "best", but I would prefer an friendly > answer and not a canned response like I get from co-workers. [warning: canned answer ahead] FWIW, there is some good wisdom in going down the "text book" way, aka

Re: [sqlite] SQLite and Windows Metro Style

On 2 Mar 2012, at 12:33am, Richard Hipp wrote: > We are told that metro style applications may not use many of the win32 > APIs that SQLite currently does use (APIs such as LoadLibrary(), > SetFilePointer(), GetFileSize(), etc.) I'll have to talk to my colleague. Is it

Re: [sqlite] SQLite and Windows Metro Style

On Thu, Mar 1, 2012 at 6:51 PM, Himadri Sarkar wrote: > Hi, > I am a newbie to the SQLite user group and was wondering if anyone has > tried to use SQLite to build the new Windows metro style applications and > if yes is there a step by step approach written down somewhere? >

Re: [sqlite] read each line in sqlite database

On 1 March 2012 18:43, Don V Nielsen wrote: > I think Simon's solution is in error, and Igor's is correct.  In Simon's > case, Slevel will be set to 1 if price1 is greater than 30. It will be set to 2, as required by OP. > However, the > original c function would set

[sqlite] seeking database design advice

All: I wanted to solicit some opinions about how best to layout a database table for a project I am working on. I have a distributed application that reports run time information back to a central machine. Included in the report are the parameters used during runtime... approx 25 or so.

Re: [sqlite] SQLite and Windows Metro Style

On 1 Mar 2012, at 11:51pm, Himadri Sarkar wrote: > I am a newbie to the SQLite user group and was wondering if anyone has > tried to use SQLite to build the new Windows metro style applications and > if yes is there a step by step approach written down somewhere? I have a

[sqlite] SQLite and Windows Metro Style

Hi, I am a newbie to the SQLite user group and was wondering if anyone has tried to use SQLite to build the new Windows metro style applications and if yes is there a step by step approach written down somewhere? Regards, -- Himadri ___ sqlite-users

[sqlite] Yum install of PHP not including sqlite3

Hello We are running Red Hat 6.2 with PHP 5.3.3 installed via yum Among other things in the ./configure section I see '--without-sqlite3' However, via phpinfo() we see a section ... sqlite3 SQLite3 supportenabled SQLite3 module version0.7-dev SQLite Library3.6.20 Directive

[sqlite] Typo in source code comment

/*** EXPERIMENTAL *** ** ** Register a function to be invoked when a transaction comments. ** If the invoked function returns non-zero, then the commit becomes a ** rollback. */ SQLITE_API void *sqlite3_commit_hook( :s/comments/commits/ ___ sqlite-users

[sqlite] Could not load file or assembly 'System.Data.SQLite'

Hello! I'm trying to use SQLite in an ASP.NET 2.0 application. I ran the x86 installer (sqlite-netFx35-setup-bundle-x86-2008-1.0.79.0.exe), then added a reference in Visual Web Developer Express and copied the version independent XML for DbProviderFactories from the included help file into my

Re: [sqlite] Constraint Error Messages

Thanks for all the responses - I seem to have opened up a can of worms! Looking into his further, I see differences in how constraint failures are reported. In the case of a NOT NULL constraint, I got an error ". may not be NULL". In the case of a UNIQUE constraint, the error was "column is

Re: [sqlite] read each line in sqlite database

Ya know, if you ever wanted to deviate from the SQL standard, a handy upgrade to the CASE statement would permit split conditions on the case and when statement, as in: Case price1 when > 12 then 1 when > 30 then 2 else 0 end dvn On Thu, Mar 1, 2012 at 12:43 PM, Don V Nielsen

Re: [sqlite] read each line in sqlite database

I think Simon's solution is in error, and Igor's is correct. In Simon's case, Slevel will be set to 1 if price1 is greater than 30. However, the original c function would set Slevel to 2 because price1 is greater than 12 and it is greater than 30. Two increments of i are executed in that

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

yes, will post the trace. Sreekumar On Mar 1, 2012 11:42 PM, "Dan Kennedy" wrote: > On 03/01/2012 10:54 PM, Sreekumar TP wrote: > >> version 3.7.7.1 >> The query works on x86, but fails on MIPS processor! >> > > Are you able to post a stack trace? Ideally generated by >

[sqlite] dcs0816

Make Income 0nIine with revoIutionary system http://incident.zxq.net/pjob4jou/httpjob4journal0129.php?netjpageID=58 Thu, 1 Mar 2012 19:14:07 __ " In modern times walls are always attacked with mortars and cannon" (c) jevaun visszaszallitasat

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On 03/01/2012 10:54 PM, Sreekumar TP wrote: version 3.7.7.1 The query works on x86, but fails on MIPS processor! Are you able to post a stack trace? Ideally generated by the gdb "where full" command. Thanks. Dan. Sreekumar On Thu, Mar 1, 2012 at 7:00 PM, Dan

Re: [sqlite] sqlite3.dll version information not available

Using the sqlite3_libversion is different, it can only be used *after* the DLL has been loaded. With Thomas' solution he can check the version without/before loading the DLL -- Jos Groot Lipman > -Original Message- > From: sqlite-users-boun...@sqlite.org >

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

version 3.7.7.1 The query works on x86, but fails on MIPS processor! Sreekumar On Thu, Mar 1, 2012 at 7:00 PM, Dan Kennedy wrote: > On 03/01/2012 05:48 PM, Sreekumar TP wrote: > >> In my system, the statement causes sqlite3parser function to crash. >> My compiler is

Re: [sqlite] Constraint error messages

On Mar 1, 2012, at 4:08 PM, Marc L. Allen wrote: >> I don't understand why you need to have constraint declaration. Do you >> have some kind of parser of table definition and your application >> relies on it to find all constraints that SQLite enforces? > > I believe it irks him that he cannot,

Re: [sqlite] Constraint error messages

On Mar 1, 2012, at 3:13 PM, Igor Tandetnik wrote: >> I would if I could. Unfortunately, in SQLite, in the case of unique >> constraints, this cannot be done as far as I know. Or? > > Just create a unique index, in lieu of unique constraint. I would rather see SQLite support some sort of USING

Re: [sqlite] Bug report: crash in selectExpander()

On Thu, Mar 1, 2012 at 10:11 AM, dead beef <0xdead.n...@gmail.com> wrote: > The following query causes a crash (null-pointer dereference): > > $ sqlite3 > SQLite version 3.7.4 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> SELECT 1 FROM ( SELECT 1 ) INNER

[sqlite] Bug report: crash in selectExpander()

The following query causes a crash (null-pointer dereference): $ sqlite3 SQLite version 3.7.4 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> SELECT 1 FROM ( SELECT 1 ) INNER JOIN ( SELECT * ) USING ( c ); Segmentation fault

Re: [sqlite] Constraint error messages

> I don't understand why you need to have constraint declaration. Do you > have some kind of parser of table definition and your application > relies on it to find all constraints that SQLite enforces? I believe it irks him that he cannot, in his own mind, provide a complete table definition. I

Re: [sqlite] Set Locale for upper() and lower() using a pragma variable

> Given that there exists a table db_locale [CREATE TABLE db_locale (locale > text)], > what lines of code would be used to query that table from inside this > function? That's a wrong approach. First, you don't need to modify functions in SQLite code, you need to create your own. Your function

Re: [sqlite] Constraint error messages

On Thu, Mar 1, 2012 at 9:01 AM, Petite Abeille wrote: > On Mar 1, 2012, at 2:51 PM, Pavel Ivanov wrote: > >>> (2) If one create an unique, named index, one cannot use an unique >>> constraint as there is no way to add constraints after the table creation >>> (i.e. no

Re: [sqlite] Set Locale for upper() and lower() using a pragma variable

I found the function that I would need to modify (see below). |static void icuCaseFunc16(sqlite3_context *p, int nArg, sqlite3_value **apArg){ const UChar *zInput; UChar *zOutput; int nInput; int nOutput; UErrorCode status = U_ZERO_ERROR; const char

Re: [sqlite] Constraint error messages

Petite Abeille wrote: > On Mar 1, 2012, at 2:27 PM, Igor Tandetnik wrote: > >> If you want to refer to an index by name, I suggest you explicitly create >> this index with the name of your choosing. > > I would if I could. Unfortunately, in SQLite, in the case of

Re: [sqlite] Constraint error messages

On Mar 1, 2012, at 2:51 PM, Pavel Ivanov wrote: >> (2) If one create an unique, named index, one cannot use an unique >> constraint as there is no way to add constraints after the table creation >> (i.e. no alter add constraint …). > > You don't need to create a unique constraint when you

Re: [sqlite] Set Locale for upper() and lower() using a pragma variable

Is there an example extension you know that I could look at that does this? (i am a novice at SQLite) From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Pavel Ivanov [paiva...@gmail.com] Sent: March 1, 2012 8:52 AM To:

Re: [sqlite] Set Locale for upper() and lower() using a pragma variable

On Thu, Mar 1, 2012 at 8:50 AM, Grace Batumbya wrote: >>You can simply register your >>own lower/upper with one argument that looks wherever you want to know >>what locale to use. > > The part of registering a function to override lower/upper I think I >

Re: [sqlite] Constraint error messages

> (2) If one create an unique, named index, one cannot use an unique constraint > as there is no way to add constraints after the table creation (i.e. no alter > add constraint …). You don't need to create a unique constraint when you created a unique index. Unique index implies that you can't

[sqlite] Set Locale for upper() and lower() using a pragma variable

>You can simply register your >own lower/upper with one argument that looks wherever you want to know >what locale to use. The part of registering a function to override lower/upper I think I understand. But if I wanted to persist the locale, so that even if I disconnect and reconnect it is

Re: [sqlite] Constraint error messages

On Mar 1, 2012, at 2:27 PM, Igor Tandetnik wrote: > If you want to refer to an index by name, I suggest you explicitly create > this index with the name of your choosing. I would if I could. Unfortunately, in SQLite, in the case of unique constraints, this cannot be done as far as I know. Or?

Re: [sqlite] Constraint error messages

Petite Abeille wrote: > For example, one can define a named unique key constraint: > > constraint header_uk unique( name ), > > This will result in SQLite automagically creating an unique index to support > the constraint. What's the name of that index? No > one

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On 03/01/2012 05:48 PM, Sreekumar TP wrote: In my system, the statement causes sqlite3parser function to crash. My compiler is mips , little endian, gcc version is 4.5.2 SQLite version? 3.7.10 seems Ok here. Dan. ___ sqlite-users mailing list

Re: [sqlite] read each line in sqlite database

YAN HONG YE wrote: > I have a sqlite database named bb: > >> NamePrice1Price2Slevel >> A123 231 NULL >> A22212 NULL >> A3 21223 NULL > > My question is: > I want to update

Re: [sqlite] sqlite3.dll version information not available

Thomas Funk wrote: >> I use the sqlite3.dll for Win32, it works fine. >> It is possible to add the version information in the next version. I >> think it helps a lot of users, so it is possible to read the version in >> my application by a windows API function, and check for

[sqlite] sqlite3.dll version information not available

Hello, I use the sqlite3.dll for Win32, it works fine. It is possible to add the version information in the next version. I think it helps a lot of users, so it is possible to read the version in my application by a windows API function, and check for the correct version. I have attached a

Re: [sqlite] Sqlite3BTreeMovetoUnpacked SQLite SELECT Statement Profiler Output

From: frank_chan...@hotmail.com To: sqlite-users@sqlite.org Subject: RE: Sqlite3BTreeMovetoUnpacked SQLite SELECT Statement Workaround is I/O Bound and uses all the Physical Memory Date: Wed, 29 Feb 2012 11:59:56 -0500 Daniel Kennedy, I tried your SQLite SELECT Statement

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

In my system, the statement causes sqlite3parser function to crash. My compiler is mips , little endian, gcc version is 4.5.2 -Sreekumar On Thu, Mar 1, 2012 at 2:59 PM, Simon Davies wrote: > On 1 March 2012 09:22, Sreekumar TP wrote: >

Re: [sqlite] Constraint error messages

On Feb 29, 2012, at 10:28 PM, Richard Hipp wrote: > But that would require a lot of > extra code space, which is not "lite". There is a fine line between being parsimonious and cutting corners. For example, one can define a named unique key constraint: constraint header_uk unique( name

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On 1 March 2012 09:34, Petite Abeille wrote: > > On Mar 1, 2012, at 10:29 AM, Simon Davies wrote: > >>> doesnt work either. >>> >> >> In what way does it fail to live up to your expectations? > > Simon? Are you impersonating Igor?!? :D > LOL :-)

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On Mar 1, 2012, at 10:29 AM, Simon Davies wrote: >> doesnt work either. >> > > In what way does it fail to live up to your expectations? Simon? Are you impersonating Igor?!? :D ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On 1 March 2012 09:22, Sreekumar TP wrote: > doesnt work either. > In what way does it fail to live up to your expectations? Regards, Simon ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On Mar 1, 2012, at 10:22 AM, Sreekumar TP wrote: > doesnt work either. Sure it does. sqlite> select count( distinct name ) from header; 899 ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] read each line in sqlite database

On 1 March 2012 08:44, YAN HONG YE wrote: > I have a sqlite database named bb: > >> Name    Price1    Price2    Slevel >> A1        23             231          NULL >> A2        22            12             NULL >> A3       21            223           NULL > > My question is:

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

doesnt work either. On Thu, Mar 1, 2012 at 2:50 PM, Petite Abeille wrote: > > On Mar 1, 2012, at 9:46 AM, Sreekumar TP wrote: > > > Is SELECT COUNT (DISTINCT column_name FROM table) syntax supported ? > > try: > > select count( distinct foo ) from bar > >

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On Mar 1, 2012, at 9:46 AM, Sreekumar TP wrote: > Is SELECT COUNT (DISTINCT column_name FROM table) syntax supported ? try: select count( distinct foo ) from bar ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] SELECT COUNT (DISTINCT column_name FROM table)

Hi, Is SELECT COUNT (DISTINCT column_name FROM table) syntax supported ? The above causes a crash in sqlite3Parser function.. -Regards, Sreekumar ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] read each line in sqlite database

I have a sqlite database named bb: > NamePrice1Price2Slevel > A123 231 NULL > A22212 NULL > A3 21223 NULL My question is: I want to update culumn Slevel by function myfunc(): int myfunc(): {int