epage (https://www.sqlite.org/)
Thanks...
Ken Naumowicz
Sr. IT Application Consultant - EMS/SCADA Application Design and Engineering
WEC Energy Group - WEC Business Services (WBS)
office: 262-544-7239
email: ken.naumow...@wecenergygroup.com
___
sqlite-u
LITE_STATIC );
rc |= sqlite3_bind_int( pStmt, 2, source );
}
// Execute the statement.
rc = sqliteUtil_exec_prepared(
_pHLFF_DB,
pStmt,
hlff_db_logfile_get_callback,
relay_args,
NULL);
return(rc);
}
Thank you
Keith,
Good point. Did not know this exists.
Ken
On 01/10/2017 09:48 PM, Simon Slavin wrote:
On 11 Jan 2017, at 1:02am, Keith Medcalf wrote:
You are correct, however, if there were a unique constraint placed on
tracks.name, then a given track could only appear once (in the first case
Domingo,
Thanks for the email, but I don't think I am your inteded recipient.
Ken
On 01/10/2017 12:11 PM, Domingo Alvarez Duarte wrote:
Hello Richard !
Now that you are dealing with this ticket
http://www.sqlite.org/src/info/c92ecff2ec5f1784 could be a good moment
to acknowledg
Keith,
"this does not allow the same track on multiple albums" with the same trackno,
but a different trackno seems to work. Thus results cannot be guaranteed valid?
Ken
On 01/08/2017 06:57 AM, Keith Medcalf wrote:
On Sunday, 8 January, 2017 05:05, Ken Wagner wrote:
Keith,
A
Yes, thanks.
The 'left join on' or 'inner join on ' removes the chance of an
erroneous key linkage.
Also makes sense to pay close attention as to which table is left and
right.
Ken
On 01/09/2017 06:46 AM, Dominique Devienne wrote:
On Sun, Jan 8, 2017 at 12:46 PM,
Keith,
Ahh, better to be specific and avoid simplistic assumptions.
For foreign keys which is better: 'trackerartist' or 'artistid' in the
track file? Does it matter? Is it personal preference?
Ken
On 01/08/2017 05:46 AM, Keith Medcalf wrote:
... join ... using
used because it is
more informative?
I.e., wherever it is seen it shows the track-artist link? But is more
demanding when coding:
'on trackerartist = artistid' vs 'using (artistid)'
Best or preferred SQLite3 practice for using which foreign reference
style 'tr
artistidINTEGER PRIMARY KEY,
artistname TEXT
Am I missing something important here?
Thanks,
Ken
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
David,
Yes. That would be a big assist. I am new to using SQLite3 and found the
GLOB function erratic in practice -- not on SQLite3 but on other web
sites using SQLite. They yielded completely opposite results.
Second the motion.
Ken
On 01/05/2017 05:23 PM, dandl wrote:
From: sqlite
Danap,
I thought so, too. But it is not the case.
I am cross-checking with the Unix/SQLite results, using Unix/SQLite as
the base reference.
Ken
On 01/05/2017 01:30 PM, dmp wrote:
Message: 21
Date: Wed, 4 Jan 2017 22:10:59 -0600
From: Ken Wagner
To: SQLite mailing list
Subject: Re
Ryan,
Thanks. I have saved the Unix GLOB reference.
When I inferred that other versions of SQLite gave the other results, it
was thru the other SQLite GUI tools and the version of SQLite that they
used.
Thanks for helping to make clear what was going on.
Ken
On 01/05/2017 02:53 AM, R
t; pattern. SQLiteTutorial.net has
already been advised. (No reply, thus far in 2 days.)
Yeah, I guess it must be the Dim Sum!!
Many thanks,
Ken
On 01/05/2017 12:46 AM, Keith Medcalf wrote:
From the (current) source code:
/*
** Compare two UTF-8 strings for equality where the first string is
**
further tomorrow.
Many thanks,
Ken
On 01/05/2017 12:29 AM, Keith Medcalf wrote:
sqlite3s < globtest.sql
select sqlite_version(), sqlite_source_id();
3.11.0|2016-02-15 17:29:24 3d862f207e3adc00f78066799ac5a8c282430a5f
create table x(x text);
insert into x values('ABC');
insert into
d also directing
them to training at a good web SQLite tutorial.
All of the above are using the 'chinook.db'. My system is Linux/Ubuntu
16.04, SQLite3 3.15.0 and 3.16.0 CLIs and the above programs. I use the
CLI in both the Terminator and Gnome-Terminal. Some minor differences
with
rence between the CLI and the GUI versions.
Where is this UNIX Glob notation spelled out? My system is Linux. I
expect the UNIX version will be somewhat different.
The Linux GLOB is used to find patterns in pathnames (not databases.) Is
the Unix version the same?
Thanks,
Ken
On 01/04/2017 11:51
not think that's a bit odd?
Rest assured, I will abide by the SQLite 3.15.0 and future upgrades.
It's just extra work and support, places a blot on the escutcheon of
efficiency. It's awkward mixing the GLOB and Regex metaphors.
Ken
On 01/04/2017 11:01 AM, Jens Alfke wrote:
On
You must have a considerable reservoir of both. Much appreciated.
Thank you for the artifact link. Very helpful.
I shall hold out for much smoother 3.16.1 rollout. My deepest empathies.
Best regards, Ken
On 01/04/2017 08:38 AM, Richard Hipp wrote:
On 1/4/17, Simon Slavin wrote:
On 4 Jan 2017,
Ryan,
Both 'AB6' or '5AB' fail the '[^1-9]' test. So, too do 'New Vol 4' and
'#1'.
Ken
On 01/04/2017 07:57 AM, R Smith wrote:
On 2017/01/04 3:43 PM, Ken Wagner wrote:
Yes, I changed the query to NOT GLOB '*[1-9]*' and then it o
Ryan,
The Regex description of '[^0-9]' states NOT any 0 thru 9 char in any
SINGLE char position. It can be amended to 1-9 or 3-7 or 1-4 as the user
sees fit.
Tested it using Ruby and Rubular, a Regex Tester.
HTH,
Ken
On 01/04/2017 07:57 AM, R Smith wrote:
On 2017/01/04 3:
.
Thanks for the info.
Ken
On 01/04/2017 07:57 AM, R Smith wrote:
On 2017/01/04 3:43 PM, Ken Wagner wrote:
Yes, I changed the query to NOT GLOB '*[1-9]*' and then it omitted
the 1-9 char-containing entries.
However the logic of 'zero or any chars, then any single char NO
or to 3.15.
It's doable. Just adds extra work requiring checking.
Thanks,
Ken
On 01/04/2017 07:54 AM, Simon Slavin wrote:
On 4 Jan 2017, at 1:43pm, Ken Wagner wrote:
There is yet another product "DB Browser for SQLite" using SQLite v 3.9.2. It,
too, omits any row where name c
Ryan,
FWIW -- I upgraded the DB Browser from v. 3.9 to v 3.11.0. This too
honors the GLOB '*[^1-9]*' by omitting any entry with a 1 thru 9 in it
in any char position.
This sqlitebrower is on git hub. It's a nice SQLite tool. (So far...)
Ken
On 01/04/2017 07:13 AM, R Smith
ame contains any char 1 thru 9. It
appears SQLite at one point did this as 'GLOB '*[^1-9]*'.
But it does not do so now. Does SQLite3 provide a detailed syntax
description of the GLOB permutations honored (and, perhaps, those
deprecated?)
Thanks.
Ken Wagner
On 01/04/2017 07
ded the SQLite Manager tool to FireFox v 50.1.0 and it, too, omits
any # 1-9 in the query results using " GLOB '*[^1-9]*' ".
How to resolve??
Thanks.
On 01/04/2017 06:53 AM, R Smith wrote:
On 2017/01/04 7:17 AM, Ken Wagner wrote:
About 2/3 the way down the page at:
Thanks, Jens.
I will do that.
- Ken
On 01/04/2017 12:29 AM, Jens Alfke wrote:
On Jan 3, 2017, at 9:17 PM, Ken Wagner wrote:
About 2/3 the way down the page at:
http://www.sqlitetutorial.net/sqlite-glob/
<http://www.sqlitetutorial.net/sqlite-glob/> Get names without [1-9]
ite.org, I think, but use
the sqlite app.)
But not in sqlite3 3.15.1 and 3.16.1.
This works as expected in sqlite3 (3.15.1 and 3.16.1 :
select trackid, name from tracks where name not GLOB '*[1-9]*'; Gets
names without [1-9].
On 01/03/2017 07:37 PM, Richard Hipp wrote:
On 1/3/1
6.04, SQLite3 (3.15.1 and 3.16.1). Also tested using
Ruby 2.3.3 with ruby-sqlite extension.
Thanks,
Ken Wagner
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Is there ADO Support for SQLite using Windows 8.1 and Windows Phone 8.1? I am
looking for a Cross-Platform ADO wrapper for iOS, Android and Win 8.1 WP 8.1?
Ken Wenyon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
Is there ADO Support for SQLite using Windows 8.1 and Windows Phone 8.1? I am
looking for a Cross-Platform ADO wrapper for iOS, Android and Win 8.1 WP 8.1?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/list
ing on a solution for debugging, more soon).
> Clemens: "What is the EXPLAIN QUERY PLAN output for this query on the
> handheld?"
0|0|0|SCAN TABLE userParameter
0|0|0|USE TEMP B-TREE FOR ORDER BY
Thank you,
Ken
ken labar | Embedded Firmware Engineer
Hach Hydromet | www.h
O3-','mg/L-N');
INSERT INTO "userParameter"
VALUES(33201,27,1,1,1000,1000,1000,1000,1000,1000,401,401,214,'NH4+','NH4+','mV');
INSERT INTO "userParameter"
VALUES(33217,28,1,1,1000,1000,1000,1000,1000,1000,404,404,214,'NO3-'
amalgamation would behave differently compiled into our
project?
System details:
- LPC2468 (ARM7)
- uCOS-II (RTOS)
- IAR C compiler
Thank you,
Ken
ken labar | Embedded Firmware Engineer
Hach Hydromet | www.hachhydromet.com<http://www.hachhydromet.com/> |
kla...@ha
Q: any plans to have a FTS3/4 WinRT extension for Metro style Win8 apps and if
so, when?
Sent from my iPhone
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Is there any way to use
SQLite/LINQ/C# - programmatically?
I'm new to the C# world and once I read
about LINQ it sure seemed the way to go.
Maybe I'm missing something but I've really
beat this to death trying to find a solution.
I'm not using Visual Studio.
DBLing is dead.
LingPad works
narrow down the cause of the problem, I want to build SQLite apart
from PHP. However, SQLite commit f70d552bcd removed the
SQLITE_FIXED_LOCKING_STYLE option. How can I build newer versions of
SQLite to always use whole-file locking?
- Ken
___
sqlite-users
--- On Tue, 11/24/09, Nicolas Rivera wrote:
> From: Nicolas Rivera
> Subject: [sqlite] multiple threads with shared cache mode
> To: sqlite-users@sqlite.org
> Date: Tuesday, November 24, 2009, 12:22 PM
> Hi,
>
> It is my understanding, per
> http://www.hwaci.com/sw/sqlite/sharedcache.html sect
point back into the list. So this would be very
problematic for page movement.
Ken
--- On Tue, 10/27/09, John Crenshaw wrote:
> From: John Crenshaw
> Subject: Re: [sqlite] Idea for improving page cache
> To: "General Discussion of SQLite Database"
> Date: Tuesday, Oct
k
> something?
I'm not sure it can be improved either. Its just an idea. Implementation and
testing would be the only definitive way to tell.
Agreed that it would degrade performance if the CPU does not have a processor
cache. This alone is reason enough to avoid the ULL for sqlite.
>
in case of page
> cache) and good
> > in getting elements by index and traversal of the
> whole list. Last two
> > operations are never executed in SQLite.
> > So looking at all this I don't see how performance can
> be improved
> > (for me it seems that it&#x
is mostly insignificant to the speed of disk i/o but every bit
helps...
Just an idea, not sure if its been considered, feasible or even worthwhile.
Ken
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Sql uses a single quote or a tick mark to delimit strings. C, C++ and other
languages use Dobule quote to delimit strings.
I think though that the column names may be double quoted to differentiate them
from data.
--- On Tue, 10/27/09, D. Richard Hipp wrote:
> From: D. Richard Hipp
> Subjec
--- On Wed, 9/30/09, Scott Hess wrote:
> From: Scott Hess
> Subject: Re: [sqlite] multiple prepare statements
> To: "General Discussion of SQLite Database"
> Date: Wednesday, September 30, 2009, 9:02 AM
> Since SQLite is an embedded database,
> it generally does not pay to
> count statements,
Interesting
Mind if we ask what the SSD device brand and model is?
Is it a disk backed type of device with equal memory in front, I recall seeing
devices like this about 7 years ago. I'm thinking that the sync call is causing
the device to write its memory contents back out to disk (ie to b
How is the SSD connected? Could it be an issue with the transport layer to the
device?
--- On Mon, 9/21/09, Dave Toll wrote:
> From: Dave Toll
> Subject: Re: [sqlite] SQLite database on a certain high-performance "SSD"
> To: "General Discussion of SQLite Database"
> Date: Monday, September 2
On additional thing.
One of the indices will not be required. Since one table will be the driving
table and will require a full scan. The other table should have the index. I
would make that the smaller of the tables.
Secondly if at all possible try not to make composit fields. A compoisit fiel
table might have columns, integer ID and BLOB entity.
But it would be better if you could fully describe the "Entity" internal types
instead of just a var arg...
--- On Thu, 9/10/09, Kavita Raghunathan wrote:
> From: Kavita Raghunathan
> Subject: [sqlite] Question on converting objects into
The key to increased concurrency is MVCC. Without MVCC concurrency is limited
to page locking, table locking etc.
Google MVCC...
--- On Tue, 9/8/09, Iker Arizmendi wrote:
> From: Iker Arizmendi
> Subject: Re: [sqlite] server process gives better concurrency - why?
> To: sqlite-users@sqlite.o
> Only problem is
> > there seems to be 1-2s freeze on the moment I create a
> new file.
>
If you are talking about creating a new database periodically with the same
tables: try creating a "template database" and copy that to the new working
version.
n for this final select
0|0|TABLE ksrcn WITH INDEX ksrcn ORDER BY
10 seconds for the new vs 14.7 seconds for the original
On linux this same query executes in 5.5 seconds. (After flushing the linux
buffer cache).
Any ideas why this is so slow on aix, where the disk d
CPU Time: user 26.321955 sys 6.498729
sqlite>
Linux:
sqlite> .timer on
sqlite> .output ken.out
sqlite> .read kdo.sql
CPU Time: user 4.648290 sys 0.888056
sqlite>
Thanks,
Ken
Adding pragma temp_store=2 does seem to help, it does red
nan-4.16
nan-4.17
Any suggestions or reason why the io test would fail?
io-3.3... Ok
io-4.1...
Expected: [3]
Got: [2]
io-4.2.1... Ok
io-4.2.2... Ok
io-4.2.3...
Expected: [3]
Got: [2]
io-4.3.1... Ok
io-4.3.2... Ok
Thanks,
Ken
___
sqlite-users
--- On Sat, 8/15/09, Dan Kennedy wrote:
> From: Dan Kennedy
> Subject: Re: [sqlite] 3.6.17 test failure
> To: "General Discussion of SQLite Database"
> Date: Saturday, August 15, 2009, 12:36 AM
>
> On Aug 15, 2009, at 2:14 AM, Ken wrote:
>
> > I'
I'm not sure if this an issue or not. make test failed with the following:
2 errors out of 40872 tests
Failures on these tests: rollback-2.3 tkt3457-1.4
All memory allocations freed - no leaks
Memory used: now 0 max 102680 max-size2800336
Page-cache used: now
--- On Tue, 8/11/09, Radcon Entec wrote:
> From: Radcon Entec
> Subject: [sqlite] Cannot insert records into a table after dropping and
> recreating it
> To: sqlite-users@sqlite.org
> Date: Tuesday, August 11, 2009, 10:50 AM
> Greetings!
>
> I have an application that uses an SQLite database
ny ideas why this is happening or how to track it
> down?
>
> Compile with SQLITE_DISABLE_DIRSYNC for AIX.
>
> Dan.
>
>
> > Thanks,
> > Ken
> >
Dan, Many thanks. That did the trick!!!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Roger,
Thats too funny. I guess I forgot posting this last year.
Ken
--- On Mon, 8/3/09, Roger Binns wrote:
> From: Roger Binns
> Subject: Re: [sqlite] Disk I/O error on AIX
> To: "General Discussion of SQLite Database"
> Date: Monday, August 3, 2009, 7:55 PM
> Ken
Thanks Dan!
I'll check this in the morning.
Ken
--- On Tue, 8/4/09, Dan Kennedy wrote:
> From: Dan Kennedy
> Subject: Re: [sqlite] Disk I/O error on AIX
> To: "General Discussion of SQLite Database"
> Date: Tuesday, August 4, 2009, 12:03 AM
>
> On A
Hi,
I'm getting a Disk I/O error when committing a transaction on an AIX system.
The file system is JFS.
The extended result code is 1290. Which i believe means that the extended code
is a SQLITE_IOERR_DIR_FSYNC error.
Any ideas why this is happening or how to track it down?
Thanks
Alex,
I've looked at your code and discussions on this list about the versioning. I
have a few questions.
1. How are you moving the data around from one master to another?
2. How are you applying the changes once moved to the master?
--- On Fri, 7/31/09, Alexey Pechnikov wrote:
> From: Ale
I like to start each of my transactions with a "Begin Immediate" that way the
database file is locked at that point. And its relatively simple to test for
the DB locked at that stage and handle waiting or returning an error.
HTH
--- On Fri, 7/17/09, Cole wrote:
> From: Cole
> Subject: [sqli
This could then be
copied and written against a target database on a remote server.
Ultimately this would be what rsync provides without the rescans... You could
also look into some form of filesystem replication as well. I think that would
be more reliable.
Just my .02
hth, ken
--- On Sat, 7/18
be
> worth
> putting begin/commit just around each batch of orders
> instead of each
> individual order. You might want to take it even
> further: by analogy
> with a non-SQL DBMS, I once wrote a logging program which
> did a COMMIT
> only just before a SELECT was needed,
at case might be
> excessive. Still, it may be worth trying that.
>
> I am using begin/commit around the writes since each order
> can require between 1 and 5 writes.
>
> Ken made a suggestion that I create separate db's for each
> thread. Since the threads don't
Ray,
Using multiple threads you will have locking contention on the database. Only
one thread is allowed to write at a time. If you need concurrent writing then
create multiple databases or maybe look into a different DB platform like
mysql, postgress or oracle.
--- On Wed, 7/8/09, Rizzuto,
Seems to me you might need a master and detail tables.
One with the dates, timestamp and one with the data
CREATE TABLE 'log_time' (
id integer primary key
datetimestring VARCHAR COLLATE NOCASE,
timestamp INTEGER,
date INTEGER,
hour INTEGER,
min INTEGER,
sec INTEGER
)
CREATE TABLE 'lo
This is by design.
The read only transaction acquires a "Read" Lock on the database file.
So if that lock has not been released your writing process will receive the
SQLITE_LOCKED error code.
a. Use a begin exclusive on your writing process and test for sqlite locked.
Using a loop and retry
Along the same lines, the buckets could be created in their own unique Sqlite
Db, thus improving concurrency as well!!!
--- On Thu, 6/25/09, Douglas E. Fajardo wrote:
> From: Douglas E. Fajardo
> Subject: Re: [sqlite] very large SQLite tables
> To: "sqlite-users@sqlite.org"
> Date: Thursday,
Also is there an index on the table B.ID field?
--- On Mon, 6/15/09, Mike Borland wrote:
> From: Mike Borland
> Subject: Re: [sqlite] sqlite3_step performance degredation
> To: "General Discussion of SQLite Database"
> Date: Monday, June 15, 2009, 4:11 PM
> Nuno, unfortunately your psychic
>
Mike,
Not 100% sure of the prior information but a write could slow things down. It
would basically gain the lock to the DB preventing the reads from happening.
But it should not be permanent.
If you are reading all of the data. Could you just execute one query instead of
iterating over all
Gene,
Im sure others have suggested, but have you tried running your code through
valgrind?
Can you remove the custom VFS ?
--- On Wed, 5/27/09, Gene Allen wrote:
> From: Gene Allen
> Subject: Re: [sqlite] corrupt database recovery
> To: mgr...@medcom-online.de, "'General Discussion of SQL
not sure really...
But threading in linux will show two processes when a thread is created.
Can you run strace and see if clone is called at thread creation?
Check your threading package and verify its internal operations. Newer versions
do not show duplicate process. But older versions do.
ibility with all
> other existing
> VFS implementations.
>
>
> -Original Message-----
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Ken
> Sent: quinta-feira, 7 de maio de 2009 13:47
> To: General Discussion of SQLite Dat
l. I
> need vfs to continue working on
> other databases but to be notified (or have possibility to
> check) when
> one particular database is no longer opened.
>
> Pavel
>
> On Thu, May 7, 2009 at 12:00 PM, Ken
> wrote:
> >
> > --- On Thu, 5/7/09, Vir
ite.org/asyncvfs.html for
> > additional information.
> >
> > This release also includes many small bug fixes and
> documentation
> > improvements.
> >
> > As always, please let me know if you encounter any
> difficulties.
&g
Upgrade your ram.
Are you sure its sqlite using all the memory and not the WebServer?
Do you have an index on Events.NotificationTime ?
--- On Tue, 5/5/09, Kalyani Phadke wrote:
> From: Kalyani Phadke
> Subject: [sqlite] Large SQLite3 Database Memory Usage
> To: sqlite-users@sqlite.org
>
> On May 4, 2009, at 10:14 PM, Ken wrote:
>
> >
> > You could just pass the sqlite3_int64 value. It is
> portable between
> > systems. Search through the sqlite3 code and there are
> routines that
> > do the conversions from the sqlite3_int64 to a native
t; string in a cross platform fashion?
> To: kennethinbox-sql...@yahoo.com, "General Discussion of SQLite Database"
>
> Date: Monday, May 4, 2009, 10:29 AM
> Ken,
>
> this is true, except that I might migrate the system to
> some other database someday that wants to
.
HTH,
Ken
--- On Sun, 5/3/09, Sam Carleton wrote:
> From: Sam Carleton
> Subject: [sqlite] OT: how best to convert sqlite3_int64 to and from string in
> a cross platform fashion?
> To: "General Discussion of SQLite Database"
> Date: Sunday, May 3, 2009, 4:21 PM
> I am
A simple thing to prevent data collisions is to design a unique name for each
client into the tables. That way you know where the data comes from.
--- On Mon, 4/20/09, Ravi Thapliyal wrote:
> From: Ravi Thapliyal
> Subject: [sqlite] How to synchronize the SQLite db - SQLite db
> To: sqlite-
also ACL's might help
--- On Mon, 4/20/09, Ravi Thapliyal wrote:
> From: Ravi Thapliyal
> Subject: [sqlite] How to secure standalone SQLite db
> To: sqlite-users@sqlite.org
> Date: Monday, April 20, 2009, 2:36 AM
> I have a windows standalone
> application with SQLite as a database, so what
>
encryption
--- On Mon, 4/20/09, Ravi Thapliyal wrote:
> From: Ravi Thapliyal
> Subject: [sqlite] How to secure standalone SQLite db
> To: sqlite-users@sqlite.org
> Date: Monday, April 20, 2009, 2:36 AM
> I have a windows standalone
> application with SQLite as a database, so what
> is the pro
I think the problem is not in the locking mode but rather:
PRAGMA journal_mode = off;
I'm not sure if rollbacks actually function with the journalling turned off.
Can you try it without the above line?
The logic implies that the rows in question should not exist since they are
rolledback.
ht
This may help: You can use the function to track all statements
associated with a database connection.
http://sqlite.org/c3ref/next_stmt.html
--- On Wed, 4/15/09, m...@mwlabs.de wrote:
> From: m...@mwlabs.de
> Subject: Re: [sqlite] step() fails with SQLITE_BUSY after
> BEGINEXCLUSIVETRANSA
As others have indicated:
1. Create the index at the end after the data is loaded.
2. Wrap the inserts in a transaction. Commiting every N transactions.
Also:
3. Instead of the sqlite3_mprintf/exec, you should prepare,bind, step.
4. If this is single threaded then maybe recompilin
This is off topic, but since sqlite list has such savvy folks I thought I'd try
here.
Does anyone know of an embedded http server that can serve and/or create pages
from a sqlite database?
Thanks,
Ken
___
sqlite-users mailing list
sqlite-
use the LIMIT clause track and re-run the query when you need the next chunk of
data.
--- On Tue, 3/17/09, baxy77bax wrote:
> From: baxy77bax
> Subject: [sqlite] control buffering of query results
> To: sqlite-users@sqlite.org
> Date: Tuesday, March 17, 2009, 6:44 AM
> hi
>
> i need help
you might want to do a search on named pipes...
Also you query could then be simplified.
attach database 'db2.sl3' as usr
select u.* from usr.user u, names n
where u.name = n.name
--- On Mon, 3/16/09, urschrei wrote:
> From: urschrei
> Subject: [sqlite] Re trieve results of a query into
Pierre,
Have you considered storing the blob data into a file?
Just keep a record of the blob in the sqlite.db if you store all the blobs in a
single file then you'll need a filename, begin, length. Or if one blob per file
just the filename..
Just an idea. Not really sure which would be faste
> select next 30 rows and do the same... and so on until you
> reach the end
>
> iteration is not such a problem but the problem is :::
>
>
> how to say: select 30 rows -> this is the actual
> question !
>
> thnx
>
>
>
>
> ken
You'll need to know something about your data. You'll need the
midpoint of each table so or at least something close.
Then create two db's attach the original. And insert the data using a select
statement with a where clause.
--- On Thu, 3/12/09, baxy77bax wrote:
> From: baxy77bax
> Subje
Calling dbh->do("BEGIN")/ dbh->do("COMMIT") should get rid of the
automatic transactions. The txn's are still attomic.
I'm just guessing but I'd suspect the dbi interface..
Can you rewrite it in C and call the sqlite API directly,
You'll get better performance by creating a statement hand
look at the sql syntax for insert or replace for sqlite.
Also you goal to handle 1 million per minute is probably going to be dependant
upon your hardware.
For instance throughput greatly increases with disk striping.
Also the faster the RPM of the drive the more transactions can be proces
.com, "General Discussion of SQLite Database"
>
> Date: Wednesday, March 4, 2009, 4:31 PM
> Ken,
>
> you are of course right that it needs some checks
> for locks and busy states. I left that out to
> simplify the code given below. My original code
> check
Marcus,
You might want to also add some checks in for sqlite_busy as on the result of
the prepare and the first call to sqlite_step.
On the inner loop test for the most common case first (SQLITE_ROW) then test
for errors... Slight performance improvement...
--- On Wed, 3/4/09, Marcus Grimm
I fully agree with DRH regarding SQLITE and single user performance. If you
need to replace fopen then sqlite is a really really great product. Even if
you have some mild concurrency sqlite still does pretty darned good.
Oracle excels when you have many users that require concurrent database
c
try finalize at the end instead of reset.
--- On Wed, 2/11/09, krishnakumar...@luckymail.com
wrote:
> From: krishnakumar...@luckymail.com
> Subject: [sqlite] Unab to close data base due to unfinalized statements
> To: sqlite-users@sqlite.org
> Date: Wednesday, February 11, 2009, 2:28 AM
> Hi
have you checked your evironment variables, such as LD_PRELOAD??
also you can try running strace to trace system calls.
--- On Wed, 2/11/09, Roberto Lumbreras wrote:
> From: Roberto Lumbreras
> Subject: Re: [sqlite] out of memory with sqlite3 shell
> To: "General Discussion of SQLite Databas
Create a connection for each thread.
--- On Wed, 1/28/09, Anatoly Stepanov wrote:
> From: Anatoly Stepanov
> Subject: [sqlite] Multi-threading problem!
> To: "sqlite-users@sqlite.org"
> Date: Wednesday, January 28, 2009, 7:58 AM
> Hello!
> I use the latest (3.6.10) version of SQLite library.
allow readers
access.
SQLITE does not have any kind of multi versioning of the database pages. Thus
you may not have one connection reading and another writing.
HTH
Ken
--- On Tue, 1/27/09, Ian Frosst wrote:
> From: Ian Frosst
> Subject: [sqlite] Transaction behavior with large numb
1 - 100 of 592 matches
Mail list logo
