-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Hello,
On 12/31/13 8:18 AM, Bob Cochran wrote:
> I'm working on a tough project that requires me to use Node.js and
> SQLite. I'm building a database with SQLite version 3.8.2.
>
> My question is, would purchasing the book "Using Sqlite" by Jay Kre
I'm working on a tough project that requires me to use Node.js and
SQLite. I'm building a database with SQLite version 3.8.2.
My question is, would purchasing the book "Using Sqlite" by Jay Kreibich
still be mostly pertinent to SQLite 3.8.x features? Would it be helpful
in the context how Node
Understood. Thanks
* Mohd Radzi Ibrahim [131229 13:54]:
> fossil is a webserver by itself with sqlite as the database engine. AFAIK,
> there's no scripting language used on the server. All written in C.
>
>
>
> On Mon, Dec 30, 2013 at 1:02 AM, Tim Johnson wrote:
>
> > * Stephan Beal [13122
Ryan Finnesey wrote:
>
> If I want to add a SQLite database to an application I am developing to
run
> on Windows Embedded Handheld 6.5 do I need to compile the SQLite Source
Code
> or do I just use System.Data.SQLite
>
Unless you need custom compilation options, it will probably be easier just
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 30/12/13 06:18, Igor Tandetnik wrote:
> sqlite3_clear_binding is very rarely needed, in my experience. In fact,
> I have not yet encountered a reason to use it.
I use it in my Python wrapper (APSW). The reason is because I have an
automatic statem
On 30 Dec 2013, at 1:08am, Fatih BURAL wrote:
> My name is Fatih, I'm having a trouble about getting data between two
> different dates in SQLite with C# code.
Things that usually trip up people trying that:
* SQLite doesn't have a DATE type. You are actually storing INTEGER REAL or
TEXT an
If I want to add a SQLite database to an application I am developing to run on
Windows Embedded Handheld 6.5 do I need to compile the SQLite Source Code or do
I just use System.Data.SQLite
http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki
The development environment is C# .net
On 12/30/2013 10:43 PM, narkewo...@gmail.com wrote:
Hi,
If I have my code compiled/linked agaist a 3.7.17 library on my development
host but run on a target that in fact installed with 3.8.2 library on my
target, will it be a problem? More specifically, will it lead to
database file corruption?
Hi,
If I have my code compiled/linked agaist a 3.7.17 library on my development
host but run on a target that in fact installed with 3.8.2 library on my
target, will it be a problem? More specifically, will it lead to
database file corruption?
Thanks in advance.
-woody
__
Hi Fatih,
not tested, but this should work and is I think what you want. Good luck.
"SELECT * from TABLE t where t.Date1 >= @0 AND t.Date2 <= @1",
date1.ToString("-MM-dd HH:mm:ss"), date2.ToString("-MM-dd HH:mm:ss")
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailt
Thanks, Igor.
On Monday, 30 December 2013, Igor Tandetnik wrote:
> On 12/30/2013 9:14 AM, narkewo...@gmail.com wrote:
>
>> If I don't call sqlite3_clear_binding but rebind every parameter with
>> sqlite3_bind_type before every sqite3_step after sqlite3_reset, will it
>> be any different?
>>
>
> N
SCHEMA :
CREATE TABLE checksums
(i INTEGER,c VARCHAR(20) PRIMARY KEY) ;
CODE :
// Generates a Random string
QByteArray Randstr_B(int len) {
char chars[36] = {'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j',
'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y',
'z', '0',
On Mon, Dec 30, 2013 at 8:56 AM, Raheel Gupta wrote:
> Sir, I tested the method of the following :
> sqlite3_exec("INSERT OR IGNORE INTO ;");
> if( sqlite3_changes()==0 ){
> sqlite3_exec("UPDATE ...");
> }
> I have seen my performance degrade from 1 records / second to 1
> records / 1
On 12/30/2013 9:14 AM,
narkewo...@gmail.com wrote:
If I don't call sqlite3_clear_binding but rebind every parameter with
sqlite3_bind_type before every sqite3_step after sqlite3_reset, will it
be any different?
No it won't be. sqlite3_clear_binding is very rarely needed, in my
experience. In f
sqlite3_clear_binding?
Reply-To:
Hi,
If I don't call sqlite3_clear_binding but rebind every parameter with
sqlite3_bind_type before every sqite3_step after sqlite3_reset, will it
be any different?
Thanks.
-woody
___
sqlite-users mailing list
sqlite-u
Sir, I tested the method of the following :
sqlite3_exec("INSERT OR IGNORE INTO ;");
if( sqlite3_changes()==0 ){
sqlite3_exec("UPDATE ...");
}
I have seen my performance degrade from 1 records / second to 1
records / 10 seconds after 3 million UNIQUE Checksums inserted. Am I doing
anyth
On Mon, Dec 30, 2013 at 7:48 AM, Richard Hipp wrote:
>
> The wordcount.c test program does the above using prepared statements and
> exceeds 348,000 inserts+updates per second on my desktop
>
Further information: My desktop is a relatively new and fast SSD machine.
A 3-year-old ubuntu machi
Fatih,
I think you'll need to show some code and what it is doing (i.e. I do "..."
and I get "...", but I want "...") before anyone can really help you.
On Sun, Dec 29, 2013 at 7:08 PM, Fatih BURAL wrote:
> Hi,
>
> My name is Fatih, I'm having a trouble about getting data between two
> differe
Hi,
My name is Fatih, I'm having a trouble about getting data between two different
dates in SQLite with C# code. I tried all the ways even I asked questions about
this situation to some MVPs but I didn't solve it. I want to use SQLite but if
I don't solve this query I will have to use SQLCE or
On Mon, Dec 30, 2013 at 5:24 AM, Raheel Gupta wrote:
> Hi,
>
> I have the following tables :
> CREATE TABLE checksums
> (i INTEGER,c VARCHAR(16) PRIMARY KEY) ;
>
> CREATE TABLE data
> (i INTEGER, data BLOB, isUnique INTEGER)
>
> My application needs to insert 1000s of rows/second into the data ta
Raheel Gupta wrote:
>INSERT INTO checksums (1000, "abcdefghijklmnop") ON CONFLICT IGNORE BUT
>UPDATE data SET isUnique = OLD.checksums.i
>
>Is this possible with HOOKS / triggers or anything at all ?
It is possible with the obvious and simple solution: check for
uniqueness with a SELECT, then exec
Hi,
I have the following tables :
CREATE TABLE checksums
(i INTEGER,c VARCHAR(16) PRIMARY KEY) ;
CREATE TABLE data
(i INTEGER, data BLOB, isUnique INTEGER)
My application needs to insert 1000s of rows/second into the data table
hence I use transactions and prepare statements.
Now is it possible
22 matches
Mail list logo
