Re: [sqlite] Newbie question on Data Source

that is created just has an icon that looks like a sheet of paper. Dave On 11/28/2011 4:09 PM, Igor Tandetnik wrote: On 11/28/2011 5:08 PM, Dave wrote: I just checked and the 0K file that is created is the same name except it has .db3 added to it's name. Why is this suprising? Your connection

Re: [sqlite] Newbie question on Data Source

On 11/28/2011 3:59 PM, Igor Tandetnik wrote: On 11/28/2011 4:52 PM, Dave wrote: I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit

Re: [sqlite] Newbie question on Data Source

On 11/28/2011 3:59 PM, Igor Tandetnik wrote: On 11/28/2011 4:52 PM, Dave wrote: I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit

[sqlite] Newbie question on Data Source

: SQLite Error no such table: MyTableName I have the database in the project folder on my Win7 64 Pro system. The app, when run, creates an empty database file of the same name as my database file which is 13KB in size. My SQLconnect.ConnectionString = "data source =C:\Users\Dave\Docu

Re: [sqlite] Followup: Added Missing error message to past post.

Thanks Taleeb, That will get me going until the next question. :-) Dave On 11/21/2011 11:25 PM, Taleeb Anwar wrote: Download the x64 mixed-mode assembly compiled statically against the .NET Framework 3.5 (as you are using VS2010 on a 64 bit computer). Regarding targetting x86 users you can

Re: [sqlite] Followup: Added Missing error message to past post.

from VB6 Classic and finally making the move to .NET as I didn't like the looks of it when it came out and I actually bought it. It should have settled down by now. Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

[sqlite] Followup: Added Missing error message to past post.

of the installers and kept getting the following error message: Failed to Install Microsoft Visual C++ Runtime vcredist_x64_2010_SP1.exe, Asia Which download would be the correct one for me? Thanks, Dave ___ sqlite-users mailing list sqlite-users

[sqlite] SQLite and VB.Net Questions

of the installers and kept getting the following error message: Which download would be the correct one for me? Thanks, Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_analyzer

Thank you, that worked. Thanks for sqlite and fossil, two amazing pieces of software! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Suggest some Tools for Sqlite

Hi, >> I hope there should be some good Free or License Tools for using Sqlite. I recently,( two days back) went through a lot GUIs for Windows. I have it narrowed down to four from the list... http://sqlite.com/cvstrac/wiki?p=ManagementTools 1: SQLite Expert Personal 3 <-- my preferred one

Re: [sqlite] How to search the archives for [MEMO]?

On 8/16/2011 12:12 PM, Luuk wrote: > On 16-08-2011 20:15, Dave Jeremy wrote: >> Hi, >> >> New to SQLite3 and am I using Delphi-5 and Zeos. >> >> I created a database using the Text DataType but it shows up in a TDBGrid as >> [memo]. >> >> I have

[sqlite] How to search the archives for [MEMO]?

a thousand times already so how can I search the archives? Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reducing compiled size

been because I wasn't optimizing for size: $ gcc main.c sqlite3.c -lpthread -ldl -Os $ size a.out textdata bss dec hex filename 32648735881000 331075 50d43 a.out Thanks for pointing out what I missed, Dave On Mon, Jul 25, 2011 at 4:07 PM, Richard Hipp &l

Re: [sqlite] Reducing compiled size

Thanks Stephan Sorry, you're quite right. I was actually using OPTS="" but omitted it when I pasted it into my e-mail. Thanks Dave On Mon, Jul 25, 2011 at 3:55 PM, Stephan Beal <sgb...@googlemail.com> wrote: > On Mon, Jul 25, 2011 at 4:51 PM, Dave Hope <d...@hope.mx&g

Re: [sqlite] Reducing compiled size

Hi Stephan, I initially added these to the Makefile, but looking at the mailing list suggested otherwise: http://www.mail-archive.com/sqlite-users@sqlite.org/msg37813.html Thanks Dave On Mon, Jul 25, 2011 at 3:46 PM, Stephan Beal <sgb...@googlemail.com> wrote: > On Mon, Jul 25, 201

[sqlite] Reducing compiled size

ATION -DSQLITE_OMIT_UTF16 -DSQLITE_OMIT_VACUUM -DSQLITE_OMIT_VIEW -DSQLITE_OMIT_VIRTUALTABLE -DSQLITE_OMIT_WAL -DSQLITE_OMIT_WSD -DSQLITE_OMIT_XFER_OPT" Any suggestions as to where I'm going wrong? Thanks Dave ___ sqlite-users mailing list sqlite-user

[sqlite] LARGEST_INT64 compile error with gcc versions 4.5.1 & 4.6

f)<<32)) With earlier versions of gcc this results in a warning rather than an error. I have not tried the latest version of SQLite, but I don't see any difference in the definition of LARGEST_INT64. Cheers, Dave. ___ sqlite-users

[sqlite] I havn't a clue

Can anyone out there tell me how I can take a SQLite database and open it in Microsoft Excell? I'm not stupid but I don't know servers, I don't know ODBC's all I know is according to a the software I use that my data is stored in a SQLite database with the name SlotCar30.db and their website

Re: [sqlite] vacuum and rowids

On Apr 28, 2011, at 12:41 PM, Pavel Ivanov wrote: >> After more poking, it appears that rowids might not be changed by a vacuum >> if I have an index on the table. Is this true? If so, is it something I can >> rely on going forward? > > No, it's not true. The only way to keep your rowids

[sqlite] vacuum and rowids

on going forward? Thanks! -Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Multiple Match statements per query

i Militaru wrote: > On Tue, 19 Apr 2011 14:18:05 -0600 > Dave White <dwh...@companioncorp.com> wrote: > >> For example, this works: >> SELECT T01_fts.docid FROM T01_fts JOIN T01 ON T01_fts.docid = T01.rowid >> WHERE T01.hasPic = 0 AND T01_fts.words MATCH 'SB

[sqlite] Multiple Match statements per query

It appears that I cannot use MATCH more than once per query. It also looks like I can't use it if prefaced with OR or NOT. For example, this works: SELECT T01_fts.docid FROM T01_fts JOIN T01 ON T01_fts.docid = T01.rowid WHERE T01.hasPic = 0 AND T01_fts.words MATCH 'SBNTKN*' These do

[sqlite] WAL checkpoints not working

I can't get WAL checkpoints to work, automatically or forced. The WAL file seems to grow forever until the database is shutdown. I have tried: sqlite3_wal_checkpoint() and PRAGMA wal_checkpoint (with all different options) My 84MB data file is now paired with a

[sqlite] Rowids, bit-arrays, recycling, and performance

We are considering using rowids as a unique and stable ID for all records. I know that in order to do this, we need to prevent recycling by using "primary key autoincrement". The concern is that over time, as records are added and removed, there will appear large gaps in the rowids of a

[sqlite] more OSX locking

I've tracked down the difference in behavior (between former sqlite and modern sqlite) to this #if which disappeared in the current version of sqlite. aMap[] = { { "hfs", }, { "ufs", }, { "afpfs", }, #ifdef SQLITE_ENABLE_AFP_LOCKING_SMB { "smbfs", }, #else {

Re: [sqlite] OSX locking

with osx 10.4.11 At 01:46 PM 3/2/2011, Dave Dyer wrote: >The configuration I'm interested in has: > > Database resident on a windows 7 file system > sqlite binary based on sqlite 3.7.3 > > If the host is OSX 10.6, it works. > If the host is OSX 10.4, it fails. > >I swear

[sqlite] OSX locking

The configuration I'm interested in has: Database resident on a windows 7 file system sqlite binary based on sqlite 3.7.3 If the host is OSX 10.6, it works. If the host is OSX 10.4, it fails. I swear it used to work in 10.4 too, but lacking a time machine, it's hard to prove. I'm

[sqlite] Fast rowid selection

We are currently migrating from a different type of database and I'm having a little trouble with performance. Our old selection method queries indexes and returns the equivalent of a list of rowids that we then use to access records as needed. I've managed to mimic this behavior but it is

Re: [sqlite] Problem adding SQLite.Interop.060.DLL to windows mobile project

http://www.google.com/ gave me http://sqlite.phxsoftware.com/forums/p/1569/8573.aspx which contains "This issue has been covered several times on the forum. The upshot is that Visual Studio will not deploy the Interop DLL automatically,

Re: [sqlite] Inserting BLOB values

oopsy - thx jay phooey... i just *knew i should have stayed in bed this morning :-| On Mon, Dec 20, 2010 at 12:47 PM, Jay A. Kreibich <j...@kreibi.ch> wrote: > On Mon, Dec 20, 2010 at 12:38:23PM -0500, Dave Watkinson scratched on the > wall: > > hey there > &

Re: [sqlite] Inserting BLOB values

hey there you seem to have an unescaped apostrophe inside your string, and the string itself isn't enclosed by matching quotes X'7801B58E41' ~~~ On Mon, Dec 20, 2010 at 12:27 PM, Dagdamor wrote: > Oh, and I forgot to add - the reply comes from PHP, from the functions

[sqlite] proxy locking

Suppose you have a sqlite DB which might be accessed over a network, and might also be accessed locally. My understanding is that it would be disastrous if one client used proxy locking and the other did not - there would effectively be no lock. The "prefer proxy locking" logic has a strange

[sqlite] improvement for the shell

The standard shell behaves very badly if you accidentally select some BLOB data or excessively long strings. I recommend this change: #define MAX_STRING_SIZE 200 static void cautious_print_string(FILE *f,char *str) { char buffer[MAX_STRING_SIZE+3]; int i; int exit = 0;

Re: [sqlite] errors after sqlite3_step

Analysis and possible solution to getting unexpected SQLITE_CANTOPEN errors from sqlite3_step In pagerSharedLock, there is a test for the journal file acessability immediatly followed by an attempt to open it. If the journal file goes away between these two actions, sqlite3OsOpen will return

Re: [sqlite] errors after sqlite3_step

I've collected a little more information about this problem. At the low level sqlite3_step is going through "pagerSharedLock" and ultimately to unixOpen, which is returning unix errno=2 for the journal file. -- presumably at this point, the journal file is known to exist, so error 2 ought to

Re: [sqlite] errors after sqlite3_step

I've collected a little more information about this problem. At the low level sqlite3_step is going through "pagerSharedLock" and ultimately to unixOpen, which is returning unix errno=2 for the journal file. -- presumably at this point, the journal file is known to exist, so error 2 ought to

Re: [sqlite] errors after sqlite3_step

> > > 2. If ignoring #1, prove that the network disk implementation is correct >before blaming SQLite. Not trying to blame anyone here, just to gather information and ultimately find a reliable solution. > 3. Watch out for other background tag-a-longs causing weird behaviour on >Windows. I'm

Re: [sqlite] errors after sqlite3_step

> >If the previous process to access the database was in the middle of a write >but crashed before the write could complete, then your "read-only" process >will still need to write to the database in order to clean up the mess left >behind by the prior process before it can start its query. So

Re: [sqlite] errors after sqlite3_step

> >If the previous process to access the database was in the middle of a write >but crashed before the write could complete, then your "read-only" process >will still need to write to the database in order to clean up the mess left >behind by the prior process before it can start its query. So

Re: [sqlite] errors after sqlite3_step

Ok, I'll settle for a list of the errors that can be returned by the standard codebase, and particularly what SQLITE_CANTOPEN means when the database clearly was already open. Also, this is coming from a SELECT query, so there should be no question of opening a transaction file.

[sqlite] errors after sqlite3_step

There ought to be a definitive list of what errors can occur after sqlite3_step, and which (if any) are recoverable. In the case in point, I sqlite_prepare_v2 returns sqlite_ok, and the initial call to sqlite_step returns sqlite_cantopen This doesn't make any sense to me, and certainly isn't

Re: [sqlite] 64 bit soft heap limit feature request

Thank you for the explanation Roger. My apologies to Mark for hijacking the thread. Cheers, Dave. -Original Message- From: Roger Binns [mailto:rog...@rogerbinns.com] Sent: Sunday, September 05, 2010 12:07 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] 64 bit soft

Re: [sqlite] 64 bit soft heap limit feature request

#endif #endif Am I missing something here? I define SQLITE_INT64_TYPE as long in order to compile. Cheers, Dave. -Original Message- From: Roger Binns [mailto:rog...@rogerbinns.com] Sent: Friday, September 03, 2010 7:05 AM To: General Discussion of SQLite Database Subject: Re: [sqlit

Re: [sqlite] bug report: data race in multi-threaded execution ofsqlite3

TABLE, DROP TABLE). It does seem to contradict FAQ #15. Anyone else, please feel free to correct me if I'm wrong - I use code that makes this assumption and I hope I haven't messed something up... I should mention that I am using shared cache mode. Cheers, Dave. -Original Message- From

[sqlite] Auto Reply: Re: unexpected large journal file

I am out of the office from June 13th through the July 4th. I will be back in the office on July 5th. I will only have intermittent access to email and my cell phone during that time. I will read and reply to your message when I get back to the office. If you need assistance with a Berkeley

[sqlite] Auto Reply: Bug in shell.c

I am out of the office from June 13th through the July 4th. I will be back in the office on July 5th. I will only have intermittent access to email and my cell phone during that time. I will read and reply to your message when I get back to the office. If you need assistance with a Berkeley

[sqlite] Auto Reply: Auto Reply: Locked Database Problem

I am out of the office from June 13th through the July 4th. I will be back in the office on July 5th. I will only have intermittent access to email and my cell phone during that time. I will read and reply to your message when I get back to the office. If you need assistance with a Berkeley

[sqlite] Auto Reply: Locked Database Problem

I am out of the office from June 13th through the July 4th. I will be back in the office on July 5th. I will only have intermittent access to email and my cell phone during that time. I will read and reply to your message when I get back to the office. If you need assistance with a Berkeley

Re: [sqlite] database corruption problem

s the SQLite API. The Berkeley DB write-ahead logging and recovery will ensure that the database remains consistent even in the event of application or system failure. Regards, Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] java SQLite Wrapper

The java sqlite wrapper is actually a pretty amazing piece of work. As I understand it from reading the docs: The original sqlite.c is compiled for the mips processor and unix operating system. The mips binary is translated into java byte codes, and structured into a java class, which are

Re: [sqlite] SQLite on Windows 2003

> >Alternatively use Process Monitor from sysinternals.com which will show >arguments and return codes without any need to run a debugger. Even better, use FILEMON (from sysinternals.com) for clues. It's wonderful. ___ sqlite-users mailing list

[sqlite] Oracle Berkeley DB now supports the SQLite API

nical questions and provide feedback on product direction. Space is limited. For more information or to register for an event near you, please click here <http://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_dlg_id=3335094=2931347=17>. Regards, Dave -- Oracle <http://www.oracle.com

[sqlite] More Mac problems - building 3.6.23

Attempting to build 2.6.23 command shell under osx 10.4.11 doesn't work because of unlinked symbol gethostuuid, which seems to be associated with the SQLITE_ENABLE_LOCKING_STYLE option Compiling with SQLITE_ENABLE_LOCKING_STYLE=0 links, and works on native disks, but fails immediately on

Re: [sqlite] corruption problem with attached macintosh database

> >Have you tried with this turned on: > > http://www.sqlite.org/compile.html#enable_locking_style Enabling this causes link errors under my version of OSX, due to the absence of "gethistuuid". I see some traffic on the web that suggests this comes in a later OSX. (I use 10.4.11) Also, this

Re: [sqlite] more on mac database corruption

We're not talking about reliability or robustness of networked file systems - those caveats are valid of course - but not relevant for the case in point. The case in point is a simple sequence of operations that you can execute one at a time, as slowly as you like, and results in a corrupt

Re: [sqlite] more on mac database corruption

> >AFAIK it's a general rule: don't use SQLite with database somewhere on >network shared file system, otherwise bad things can happen. That's definitely not the general rule. Generally, you can open a sqlite database from multiple processes and all of them can modify at will without corrupting

Re: [sqlite] corruption problem with attached macintosh database

> > >What journaling mode are you using? whatever is default. I compile mu own sqlite static libraries, but I don't customize the settings. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] corruption problem with attached macintosh database

> >Could you help us by adding any of the following details ? > >What OS is the Mac running ? OSX 10.4.11 for me, but also snow leopard. >What OS is the PC running ? Windows 2003 server for me, but also XP (note the file systems are all mac file systems) >What protocol is being used to access

[sqlite] more on mac database corruption

I was able to reproduce the problem using a trivial set of commands to the standard sqlite command tool: On the Mac: gorp:~/2010 yeartech/yearbook tools/resource davedyer$ /applications/utilities/sqlite3-shell actiontool2.sqlite SQLite version 3.6.10 with the Encryption Extension sqlite>

[sqlite] corruption problem with attached macintosh database

I think there is a locking problem that leads to corrupt databases under quite reproducable conditions. The conditions are: database resident on a mac file sustem mounted as a drive letter on a pc the "main" database is open and shared by sqlite running on both computers. the "auxiliary"

Re: [sqlite] odd behavior for sqlite/mac

be the correct or intended behavior, but it's still unclear if it is sqlite or mac OSX that is misbehaving. -- At 04:57 PM 3/19/2010, Dave Dyer wrote: >I have an application which uses a sqlite database shared across a network. >Under conditions where the database is resident on a PC, and I

[sqlite] odd behavior for sqlite/mac

I have an application which uses a sqlite database shared across a network. Under conditions where the database is resident on a PC, and I share it from a mac, and the mac/pc are both contending for access to the database, my mac sometimes turns off it's monitor and enters system "sleep" mode. It

Re: [sqlite] Sqlite without 64-bit integers?

that will always fail on a 32-bit system. This makes debugging SQLite issues rather difficult, but does not seem to cause any serious problems. Cheers, Dave. -Original Message- From: yamada [mailto:rafael.yam...@gmail.com] Sent: Thursday, March 11, 2010 8:59 AM To: sqlite-users

[sqlite] llvm/ppc compile bug

Just a note to share a problem I ran into recently: Compiling sqlite 3.6.22 with -arch ppc -Os on the llvm that ships with Xcode 3.2.1, the sqlite3AtoF function appears to have an infinite loop. If you compile the sqlite3 command line tool in this way, just executing "select round(1234);" will

Re: [sqlite] sqlite-users Digest, Vol 25, Issue 14

for the journal file? Cheers, Dave. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of sqlite-users-requ...@sqlite.org Sent: Thursday, January 14, 2010 4:00 AM To: sqlite-users@sqlite.org Subject: sqlite-users Digest, Vol 25, Issue 14

[sqlite] SQLITE3_CANTOPEN

There is a known problem, at least with NTFS, that deleting the journal file fails unexpectedly, resulting in sqlite3_cantopen. I believe I'm the one who originally reported this problem, but the installed solution isn't quite what I recommended. I'm not sure what OS/File System you are using,

Re: [sqlite] Sqlite3.exe command line tool - winXP

ave? > sqlite> schema; > > from my mobile 434.851.1612 > > On Dec 5, 2009, at 11:31 PM, "dave lilley" <dgl...@gmail.com> wrote: > > > > > I have been trying to (without much joy) get a list of rows from a > > table > > within an sqlite3

[sqlite] Sqlite3.exe command line tool - winXP

g able to generate a list of data from an sql statement when i know the names of the tables does belong here. any help would be appreciated. dave. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Converting .dbf to SQLite

2009/11/12 Rich Shepard <rshep...@appl-ecosys.com> > On Thu, 12 Nov 2009, dave lilley wrote: > > > Not trying to be silly here but why not write a wee program that reads in > > the dbf file and for each row read in write the data into an sql file? > > Because I

Re: [sqlite] Converting .dbf to SQLite

o do this or not so what i've said maybe of no use to you. dave. 2009/11/12 Rich Shepard <rshep...@appl-ecosys.com> > Now that I have a working tool to convert from Access .mdb to sqlitedb > files, I need one for dBASE .dbf files. Or, a conversion to .csv will work, > too. Needs to run

[sqlite] Canceling a integrity check in progress (feature request)

auses the execution to return SQLITE_INTERRUPT, but this is good enough for my case. Thanks, Dave Wright ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on a Windows Network

>I have heard problems with SQLite and NFS but I have no idea if a standard >Windows shared drive uses NFS or not. Am I o.k. to use SQLite??? It's ok for low intensity uses. You'll get "database locked" errors if there is too much contention for the database.

Re: [sqlite] Ticket 3810: SQLITE_ERROR on concurrent CREATE TEMP TRIGGER and sqlite3_close()

urned from sqlite3_exec() or sqlite3_step()? Wouldn't SQLITE_SCHEMA be the more appropriate error code in this case? Cheers, Dave. -Original Message- From: Roger Binns [mailto:rog...@rogerbinns.com] Sent: Tue 10/20/2009 6:19 PM To: General Discussion of SQLite Database Subject: Re: [sqli

Re: [sqlite] Ticket 3810: SQLITE_ERROR on concurrent CREATE TEMP TRIGGER and sqlite3_close()

the error with my test code. Could you point me to the test case you referred to? Cheers, Dave. -Original Message- From: Roger Binns [mailto:rog...@rogerbinns.com] Sent: Mon 10/19/2009 9:05 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Ticket 3810: SQLITE_ERROR

[sqlite] Ticket 3810: SQLITE_ERROR on concurrent CREATE TEMP TRIGGER and sqlite3_close()

* connection to database DB) can result in a subsequent DROP TRIGGER on table A failing with SQLITE_ERROR. Shared cache mode is enabled. Cheers, Dave. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Help-using Case in query

create an SQL statement. HTH. Dave. 2009/10/13 yvette roberson <yvrober...@gmail.com> > I am definitely an novice in writing but trying to practice and get up to > speed and would appreciate any help: > > In laymen terms I have a quey that I am trying to write with the followi

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

Hi Mark I've had a little experience working with flash-based filesystems - I'd recommend playing with the page_size and temp_store PRAGMAs (and of course make sure you are using transactions to minimise the number of file writes) to improve performance. Cheers, Dave. -Original Message

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

e frame is the catch - 1sec or 10 milliseconds which is acceptable)? this would give zero config setup of the DB backend but adds a little more complexity in code for the programmer to manage. cheers, dave (a not so novice DB programmer but novice to SQLite). 2009/9/10 Iker Arizmendi <i...@r

Re: [sqlite] I'm surprised what the author of web2py on web2py mailing list just said about sqlite

m trying to implement a quota system at the VFS level for an embedded platform, but it is proving tricky to manage temp files... Cheers, Dave. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Porting: Adding new VFS

_OMIT_DISKIO and you won't need a VFS at all. You may have to check whether this compile option is supported by the amalgamation source, if you use that. Cheers, Dave. -Original Message- From: mwnn [mailto:mwnn...@gmail.com] Sent: 02 September 2009 18:50 To: sqlite-users@sqlite.org Subj

[sqlite] Determining which DB a journal or temp file belongs to

to access the sqlite3_file* object corresponding to the main database file, not the journal or temp files. Cheers, Dave. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] minimum cache_size for a database connection?

it's a case I need to prevent. Many thanks for the replies, Dave. -Original Message- From: D. Richard Hipp [mailto:d...@hwaci.com] Sent: 17 June 2009 10:08 To: General Discussion of SQLite Database Subject: Re: [sqlite] minimum cache_size for a database connection? On Jun 17, 2009, at 12:5

Re: [sqlite] minimum cache_size for a database connection?

What is the correct way to specify that SQLite should perform no caching (or at least minimal caching)? PRAGMA cache_size=0 seems to have no effect - either it continues to use the default, or tries to caches everything. Cheers, Dave. -Original Message- From: D. Richard Hipp [mailto:d

[sqlite] minimum cache_size for a database connection?

ing? Does cache_size=0 mean "cache everything"? I am using SQLite 3.6.13 with the default page cache, and shared-cache enabled. Cheers, Dave. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite3 - SQL injection using ruby

customers where cust_nos = ?" when jobs == tablename stmt = end row = db.execute(stmt,uservar) again many thanks to all, Dave. 2009/6/16 John Elrick <john.elr...@fenestra.com> > dave lilley wrote: > > Many thanks John so if i take that example and push it ou

Re: [sqlite] SQlite3 - SQL injection using ruby

a parameter where in my 1st reply I didn't have it - my failure to really look at the code. dave. 2009/6/15 John Elrick <john.elr...@fenestra.com> > dave lilley wrote: > > I am using sqlite3 with ruby and hope I'm not out of place here in ask > for > > some help on

Re: [sqlite] SQlite3 - SQL injection using ruby

where #{field} = #{criteria}" row = db.execute(stmt) end and SQLite3 way would be ... make_SQL(table,field,criteria) stmt = "select * from ? where ? = ?" row = db.execute(stmt) end would this presumtion be correct? thanks. 2009/6/15 John Elrick <john.elr...@fenestra.com>

[sqlite] SQlite3 - SQL injection using ruby

ver of old). could user active record but that will be the next step and think it's nice to know how to reduce tese sort of threats anyway. My knowledge of SQL is enough to get by on. thanks, Dave. ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] TOCTOU pager bug in 3.6.14.2

Could this be the same issue as this bug I reported a while ago? http://www.sqlite.org/cvstrac/tktview?tn=3833 Cheers, Dave. -Original Message- From: Brian Dantes [mailto:bdan...@coverity.com] Sent: 28 May 2009 16:01 To: Discussion of SQLite Database Subject: [sqlite] TOCTOU pager bug

[sqlite] Concurrent sqlite3OsAccess() and sqlite3OsDelete() on journal file

obvious. A separate question - after a successful COMMIT or ROLLBACK, will the DB connection ever keep a SHARED lock on the main DB file? Or should the DB connection always fully unlock the main DB file? Cheers, Dave. ___ sqlite-users mailing list

Re: [sqlite] Validating a file is a SQLite DB

Unless they are encrypted using the encryption extension... On Thu, Apr 23, 2009 at 4:46 PM, Tommy Ocel wrote: > Great. Thanks for the tip. > > > On 4/23/09 4:24 PM, "Igor Tandetnik" wrote: > > Tommy Ocel wrote: > > Other than using

Re: [sqlite] step() fails with SQLITE_BUSY after BEGIN EXCLUSIVE TRANSACTION

Wow this sounds exactly like my post of a few days ago titled "Strange sqlite_busy deadlock behavior". On Sat, Apr 11, 2009 at 7:11 AM, wrote: > Hi, > > I'm using the latest amalgation of sqlite on Windows NTFS, compiled with > SQLITE_THREADSAFE=1, from Visual C++. > > I have

[sqlite] SQLITE_CORRUPT - database disk image is malformed

** database schema" error being returned to the user. Could this be the reason for the error I'm seeing? Is this a known issue or expected behaviour? Do I need to protect DDL calls on multiple connections to the same database, or this there some other way to protect against

Re: [sqlite] delete with an "exists" clause

>I realize your example may not reflect the specific needs of your >application, ... Yea, my actual application required a query too complex to be put in an ordinary "where" clause. I think I've figured it out - think of the "exists" clause as sort of an implied join with the table to be

[sqlite] delete with an "exists" clause

This little program deletes all rows. Is this a bug, or perhaps I misunderstand how delete with an exists clause is supposed to work. drop table if exists dummy; create table dummy ( var int ); insert into dummy (var) values (1); insert into dummy (var) values (2); insert into dummy (var)

Re: [sqlite] Strange sqlite_busy deadlock behavior

Each thread has it's own connection handle (stated this in the original email). anyone want to see a stack trace? On Wed, Apr 8, 2009 at 2:22 PM, Lawrence Gold <lawrence.g...@gmail.com>wrote: > On Apr 8, 2009, at 3:12 PM, Dave Brown wrote: > > > Thread A is in the pr

Re: [sqlite] Strange sqlite_busy deadlock behavior

e longer than a few millisecs at most. >> >> Any thoughts on my latest test with the begin exclusive method? >> >> On 4/8/09, Griggs, Donald <donald.gri...@allscripts.com> wrote: >>> >>> >>> -Original Message- >>> From: sqlite-us

Re: [sqlite] Strange sqlite_busy deadlock behavior

sqlite.org] On Behalf Of Dave Brown > Sent: Wednesday, April 08, 2009 1:16 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Strange sqlite_busy deadlock behavior > > I tried the BEGIN EXCLUSIVE method, but now the problem is that thread-A > is in the middle

Re: [sqlite] Strange sqlite_busy deadlock behavior

4/8/09, D. Richard Hipp <d...@hwaci.com> wrote: > > On Apr 8, 2009, at 2:13 AM, Dave Brown wrote: > >> But why is this deadlocking at all? I thought there shouldn't be a >> problem doing this, especially since thread B is using a transaction. >> Shouldn't either

Re: [sqlite] Strange sqlite_busy deadlock behavior

gt; On Apr 7, 2009, at 8:57 PM, Dave Brown wrote: > >> I do finalize it - the steps I wrote were just pseudocode, but yes >> after the >> thread-A statement executes I call finalize ( or reset if I'm going >> to use >> it again ). The problem is that thread-A *never*

<    1   2   3   4   5   >