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
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
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
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
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(),
> >
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
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
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
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
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?
>
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
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.
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
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
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
/*** 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
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
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
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
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
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
>
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
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
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
>
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
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,
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
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
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
> 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
> 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
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
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
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
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
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:
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
>
> (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
>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
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?
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
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
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
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
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
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
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:
>
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
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 :-)
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
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
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
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:
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
>
>
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
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
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
57 matches
Mail list logo