[sqlite] CVE-2019-16168

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

[sqlite] sqlite3_exec() on prepared/bound statement

2, source ); } // Execute the statement. rc = sqliteUtil_exec_prepared( _pHLFF_DB, pStmt, hlff_db_logfile_get_callback, relay_args, NULL); return(rc); } Thank you, ken labar | Embedded Firmware Engineer OTT Hydromet |

Re: [sqlite] Foreign key error...

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 <kmedc...@dessus.com> wrote: You are correct, however, if there were a unique constraint placed on tracks.name, then a given track could only appea

Re: [sqlite] About ticket c92ecff2ec5f1784 LEFT JOIN problem

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 acknowledge

Re: [sqlite] Foreign key error...

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 <beauco...@gma

Re: [sqlite] Foreign key error...

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 Medcalf <km

Re: [sqlite] Foreign key error...

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 (column) has nothing

Re: [sqlite] Foreign key error...

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 'trackartist' vs 'artistid'? Thanks, Ken On 01/08

[sqlite] Foreign key error...

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

Re: [sqlite] SQLite3 Tutorial error

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

Re: [sqlite] SQLite3 Tutorial error

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 <beauco...@gmail.com> To: SQLite m

Re: [sqlite] SQLite3 Tutorial error

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

Re: [sqlite] SQLite3 Tutorial error

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

Re: [sqlite] SQLite3 Tutorial error

this 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 x values('

Re: [sqlite] SQLite3 Tutorial error

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 encoding.

Re: [sqlite] SQLite3 Tutorial error

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 AM, R

Re: [sqlite] SQLite3 Tutorial error

'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 Jan 4, 2017, at 5:57 AM, R Smith <

Re: [sqlite] SQLite3 Tutorial error

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 <slav...@bigfraud.org> wrote:

Re: [sqlite] SQLite3 Tutorial error

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 omitted the 1-9 char-containing entries. However the logic

Re: [sqlite] SQLite3 Tutorial error

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:43 PM, Ken

Re: [sqlite] SQLite3 Tutorial error

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 NOT 1 thru 9, then zero

Re: [sqlite] SQLite3 Tutorial error

. 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 <beauco...@gmail.com> wrote: There is yet another product "DB Browser for SQLite" using SQLite v 3.9.2. It, too, omits an

Re: [sqlite] SQLite3 Tutorial error

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 wrote: Just one

Re: [sqlite] SQLite3 Tutorial error

ars 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:13 AM, R Smith wrote: Just one more point of clarity,

Re: [sqlite] SQLite3 Tutorial error

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: http://www.sqlitetutorial.net/sqlite-g

Re: [sqlite] SQLite3 Tutorial error

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 <beauco...@gmail.com> wrote: About 2/3 the way down the page at: http://www.sqlitetutorial.net/sqlite-glob/ <http://www.sqlitetutorial.net/sqlite-glob/>

Re: [sqlite] SQLite3 Tutorial error

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/17, Ken Wagner

[sqlite] SQLite3 Tutorial error

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

[sqlite] Cross-Platform ADO wrapper for iOS, Android and Win 8.1 WP 8.1?

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

[sqlite] ADO Support for SQLite using Windows 8.1 and Windows Phone 8.1?

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

Re: [sqlite] ORDER BY issue v3.8.2 amalgamtion

olution 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.hachhydrome

Re: [sqlite] ORDER BY issue v3.8.2 amalgamtion

723,'Barometric Pressure','BP','psi'); INSERT INTO "userParameter" VALUES(32915,9,3,1,1000,1000,1000,1000,1000,1000,14,299,724,'Barometric Pressure','BP','mbar'); select (rtTableSort < 1000) as selected, abbrString from userParameter order by abbrString; This used to work

[sqlite] ORDER BY issue v3.8.2 amalgamtion

the 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

[sqlite] Q: FTS 3-4 for WinRT

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

[sqlite] SQLite/LINQ?

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

[sqlite] whole-file locking with flock()

). To 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

Re: [sqlite] multiple threads with shared cache mode

--- 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 >

Re: [sqlite] Idea for improving page cache

into the list. So this would be very problematic for page movement. Ken --- On Tue, 10/27/09, John Crenshaw <johncrens...@priacta.com> wrote: > From: John Crenshaw <johncrens...@priacta.com> > Subject: Re: [sqlite] Idea for improving page cache > To: "General Dis

Re: [sqlite] Idea for improving page cache

r me it seems that it's quite the opposite). Did I > overlook > 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

Re: [sqlite] Idea for improving page cache

o save memory > > overhead (which is very questionable 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 performanc

[sqlite] Idea for improving page cache

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

Re: [sqlite] SQLite: question

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.

Re: [sqlite] multiple prepare statements

--- 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

Re: [sqlite] SQLite database on a certain high-performance "SSD"

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

Re: [sqlite] SQLite database on a certain high-performance "SSD"

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

Re: [sqlite] Any way to speed up this SQL?

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

Re: [sqlite] Question on converting objects into relational db

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

Re: [sqlite] server process gives better concurrency - why?

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

Re: [sqlite] Big performance problem with inserting lots of data

> 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.

[sqlite] Query performance on AIX

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 drives

[sqlite] AIX performance

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

[sqlite] AIX test failures for 3.6.17

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

Re: [sqlite] 3.6.17 test failure

009, 12:36 AM > > On Aug 15, 2009, at 2:14 AM, Ken wrote: > > > 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 > >

[sqlite] 3.6.17 test failure

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

Re: [sqlite] Cannot insert records into a table after dropping and recreating it

--- 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

Re: [sqlite] Disk IO ERROR on AIX

he  > > extended code is a SQLITE_IOERR_DIR_FSYNC error. > > > > Any 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

Re: [sqlite] Disk I/O error on AIX

Roger, Thats too funny. I guess I forgot posting this last year. Ken --- On Mon, 8/3/09, Roger Binns <rog...@rogerbinns.com> wrote: > From: Roger Binns <rog...@rogerbinns.com> > Subject: Re: [sqlite] Disk I/O error on AIX > To: "General Discussion of SQLite Database

Re: [sqlite] Disk I/O error on AIX

Thanks Dan! I'll check this in the morning. Ken --- On Tue, 8/4/09, Dan Kennedy <danielk1...@gmail.com> wrote: > From: Dan Kennedy <danielk1...@gmail.com> > Subject: Re: [sqlite] Disk I/O error on AIX > To: "General Discussion of SQLite Database" <sqlite

[sqlite] Disk I/O error on AIX

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, Ken

Re: [sqlite] Multi-master replication with updated Versioning extension

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

Re: [sqlite] Multiple Writers and Database is Locked Problems

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:

Re: [sqlite] SQLite3 replication

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

Re: [sqlite] multi-thread access to a db

ash-recovery are true, then it might 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 >

Re: [sqlite] multi-thread access to a db

Since the processing is supposed to > be in near-realtime, the delay in that 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 c

Re: [sqlite] multi-thread access to a db

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,

Re: [sqlite] 3 million rows, query speeds, and returning zero for rows that don't exist

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

Re: [sqlite] SQLite3: Database is sometimes locked when a reader is attached with open_v2

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

Re: [sqlite] very large SQLite tables

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:

Re: [sqlite] sqlite3_step performance degredation

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"

Re: [sqlite] sqlite3_step performance degredation

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

Re: [sqlite] corrupt database recovery

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:

Re: [sqlite] SQLite spawns multiple processes?

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.

Re: [sqlite] SQLite version 3.6.14 and async vfs

his database > handle (not all databases) to > finalize before returning, providing compatibility with all > other existing > VFS implementations. > > > -Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] >

Re: [sqlite] SQLite version 3.6.14 and async vfs

te.org> > Date: Thursday, May 7, 2009, 11:10 AM > Shutdown is not an option at all. 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, 2

Re: [sqlite] SQLite version 3.6.14 and async vfs

; As always, please let me know if you encounter any > difficulties. > > > > D. Richard Hipp > > d...@hwaci.com > > > > Without actually looking at the async code I think that instead of using the sqlite3_close to cause a block there should be a "shutdown" that would wait for the shutdown of the async thread to complete. So maybe a better name would be sqlite3Async_close or something similar. Ken ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Large SQLite3 Database Memory Usage

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

Re: [sqlite] OT: how best to convert sqlite3_int64 to and from string in a cross platform fashion?

QLite Database" <sqlite-users@sqlite.org> > Date: Monday, May 4, 2009, 11:52 PM > > 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

Re: [sqlite] OT: how best to convert sqlite3_int64 to and from string in a cross platform fashion?

lite] OT: how best to convert sqlite3_int64 to and from > string in a cross platform fashion? > To: kennethinbox-sql...@yahoo.com, "General Discussion of SQLite Database" > <sqlite-users@sqlite.org> > Date: Monday, May 4, 2009, 10:29 AM > Ken, > > this is true,

Re: [sqlite] OT: how best to convert sqlite3_int64 to and from string in a cross platform fashion?

. HTH, Ken --- On Sun, 5/3/09, Sam Carleton <scarle...@miltonstreet.com> wrote: > From: Sam Carleton <scarle...@miltonstreet.com> > Subject: [sqlite] OT: how best to convert sqlite3_int64 to and from string in > a cross platform fashion? > To: "General Discussion of S

Re: [sqlite] How to synchronize the SQLite db - SQLite db

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

Re: [sqlite] How to secure standalone SQLite db

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

Re: [sqlite] How to secure standalone SQLite db

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 >

Re: [sqlite] Strange SAVEPOINT behaviour with locking_mode=exclusive

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.

Re: [sqlite] creating unique data takes many hours, help

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

[sqlite] httpd server ???

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-users

Re: [sqlite] control buffering of query results

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,

Re: [sqlite] Re trieve results of a query into a bash script, and use them to iterate

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:

Re: [sqlite] Advices to get max performance with SQLITE and BLOBS

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

Re: [sqlite] how to divide a database?

; 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-33 wrote: >

Re: [sqlite] how to divide a database?

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:

Re: [sqlite] SQLite Transaction Rate and speed...

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

Re: [sqlite] shared cache and SQLITE_MISUSE on sqlite3_step()

SE on sqlite3_step() > To: kennethinbox-sql...@yahoo.com, "General Discussion of SQLite Database" > <sqlite-users@sqlite.org> > Date: Wednesday, March 4, 2009, 4:31 PM > Ken, > > you are of course right that it needs some checks > for locks and busy states.

Re: [sqlite] shared cache and SQLITE_MISUSE on sqlite3_step()

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

Re: [sqlite] SQLite vs. Oracle (parallelized)

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

Re: [sqlite] Unab to close data base due to unfinalized statements

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:

Re: [sqlite] out of memory with sqlite3 shell

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

Re: [sqlite] Multi-threading problem!

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,

Re: [sqlite] Transaction behavior with large numbers of inserts

to 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 <frossto...@gmail.com> wrote: > From: Ian Frosst <frossto...@gmail.com> >

Re: [sqlite] SQLITEBUSYTIMEOUT

See the following: http://www.catb.org/~esr/faqs/smart-questions.html#beprecise The quick answer to you question is no I can not tell you why this is occurring. I can tell you, its probably a bug in your code. You need to post a specific example, that reproduces the issue. --- On Wed,

Re: [sqlite] How to turn off Indexing in SQLite?

> > I am using SQLite and C interface. > > > > How to turn off Indexing in SQLite? create the SQL so the index can not be used add an " OR ( 1 = 0) to the end of the where clause. ___ sqlite-users mailing list sqlite-users@sqlite.org

  1   2   3   4   5   6   >