Re: [sqlite] Slightly unexpected behaviour when comparing date and datetime

Thanks goes out to both of you for your quick responses! For text in SQLite, delimit with single quotes, not double quotes. Double > quotes are used for tricky entity names. And you probably don't want the > quotes around the real numbers at all. I'll go off and re-read up on the quotes and

[sqlite] Slightly unexpected behaviour when comparing date and datetime

Afternoon all, I have the following schema: CREATE TABLE day ("id" INTEGER PRIMARY KEY, "timestamp" DATETIME, "value" REAL); And the following sample data: INSERT INTO day VALUES (NULL, "2012-01-01", "5.0"); INSERT INTO day VALUES (NULL, "2012-01-02", "6.0"); INSERT INTO day VALUES (NULL,

Re: [sqlite] Manual

Luuk, You're invited to write a good, simple explanation as to how to read those diagrams. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Download the Installer

Re: [sqlite] Manual

Tim, Could you just tell me where I find a good on-line manual? Thanks. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Download the Installer Maker Plugin 1.7

Re: [sqlite] Manual

John, Every diagram needs instructions about how to read it. There are no such instructions on the SQLite site. So, my question remains, where do I find a good reference manual like that of MySQL? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage

[sqlite] Manual

read diagrammes like http://sqlite.org/images/syntax/sql-stmt.gif ? Where can I find a good reference manual just like MySQL's? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK

Re: [sqlite] SELECT average timestamp to get average time of day? (C M)

on on the 'add 12 hours, do your stuff, then take it off again' method but, if you can determine the required state of After Midnight at the point of data collection, it gives you a method to persist this state to the database, rather than having to unpick each one on the fly. Hope it's of some

[sqlite] Problem compiling the c source produced by lemon

I compiled lemon with no problem and input the grammar file as stated in http://souptonuts.sourceforge.net/readme_lemon_tutorial.html. But when i compile the c source file produced by lemon i am encountering errors; syntax error : ':' from cstdio. What is the solution for this. Thanks.

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

of this SQLite mailing list "who wants to start a forum?" without starting a lengthy off-topic discussion. I'm out of this discussion now. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalk

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Hi, I know from experience that there really is no point whatsoever in discussing whether a forum is better than mail or not. People are just not going to agree. Just set up your forum and find out whether you're going to have subscribers. -- Best regards, Mark Schonewille Economy-x-Talk

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

, no forums. However, if you really want a forum, install one on your web server and find out how many people use it. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553

Re: [sqlite] Why SQLite .net connector do not use NHunspell like dll import

e dll. It's quite easy to detect your environment and call the Win32 LoadLibrary function with the correct interop DLL. In nearly all cases, however, you're better off just compiling as a 32bit assembly and using the 32bit version of SQLite. Does your program really need >4GB o

Re: [sqlite] [BUG?] unexpected effect of view nesting on type conversion

ior described in the OP is a regression. The behavior > started somewhere between versions 3.6.23 and 3.7.6.3. It can have > serious consequences in the form of calculation errors. Just thought I should add that the problem seems to be gone with the just released version 3.7.7, but it's not me

Re: [sqlite] [BUG?] unexpected effect of view nesting on type conversion

ression. The behavior started somewhere between versions 3.6.23 and 3.7.6.3. It can have serious consequences in the form of calculation errors. regards, Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] unexpected effect of view nesting on type conversion

> I've run into a phenomenon I don't understand where view nesting affects > types. > Seen in sqlite 3.7.6.3. > sqlite-3.6.23 does NOT show this behavior. I don't know though when the change happened. Mark ___ sqlite-users mailing list

[sqlite] unexpected effect of view nesting on type conversion

Hi, I've run into a phenomenon I don't understand where view nesting affects types. Seen in sqlite 3.7.6.3. The following is my attempt at a minimal case that produces this behavior. Here a real is unexpectedly converted to int. CREATE TABLE customer ( id INT, PRIMARY KEY (id) );

Re: [sqlite] Latest ADO.NET driver does not install properly?

Greetings, It sounds like you are running on a 64 bit implementation and visual studio looks for a 32 it implementation. Check which ODBC GUI sees your SQLlite ODBC driver Mark -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf

[sqlite] WAL, threads, shared cache, etc

then, that shouldn't be an extended problem.) 2. Use one thread (or on iOS probably one GCD dispatch queue) per stream of work. 3. Open a connection per thread? 4. Shared cache? Yes or no? 5. Anything else? Thanks. Mark ___ sqlite-users mailing list sql

[sqlite] fill blank fields

= '*' where (CN = '' or CN is null) and AT='xyz';mtia Mark CDN Mark wrote: > what I need to do is replace blank fields in a specific row, sort of > a double where where statement as in: > > UPDATE Aircraft SET CN = '*' where CN = '' or CN is null where (primary key) > is xyz UPDATE

[sqlite] fill blank fields

know which fields are empty/blank I'm going to have to create a statement for every column I'm not updating to, there are only 10 columns altogether and I'll typically be updating to at least 5 of them. hope this is clear and mtia Mark ___ sqlite-users

[sqlite] fill in blank fileds

Hi Simon, ran the first example, came back with lots of lines, second test with the just the 10 returned 9 lines as 0: the second line as 2:3832, don't understand the purpose/meaning of this Hi Igor, not checking for, want to fill in/replace blank or null fields with at least one character

[sqlite] fill in blank fileds

Hi Igor, worked using SQLite Database browser/execute SQL but didn't work using an .sql file which is the way I would be doing it. Tried it again and it did work using sql file, thanks for your help ___ sqlite-users mailing list

[sqlite] fill in blank fileds

Hi Simon, ran the first example, came back with lots of lines, second test with the just the 10 returned 9 lines as 0: the second line as 2:3832, don't understand the purpose/meaning of this Hi Igor, not checking for, want to fill in/replace blank or null fields with at least one character

[sqlite] fill in blank fileds

nk fields are empty or null mtia Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] tarball and directory name

On 12/08/2010 09:30 AM, Mark Brand wrote: > Hi, > > Just noticed that the format of the version in the tarball name changed, > as in "sqlite-autoconf-3070400.tar.gz". However, this unpacks to a > directory called "sqlite-3.7.4". This makes it difficult for

[sqlite] tarball and directory name

irectory name. Would it be possible to have the directory agree with tarball filename? Ideally the naming would follow the well-established tradition where "x.tar.gz" unpacks to "x", but even if there was just agreement on the format of the v

[sqlite] database question

of the database.. It woud have to only be a straight viewer, no editing features needed. I did add a column, I think successfuly, but it went before the primary key column, does this matter? Well, you can always ask mtia Mark ___ sqlite-users mailing

[sqlite] append sql file

thanks Igor, that works, but without the period at the end, as in */ Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] append sql file

Hi, was wondering if there was a way to have extra text on the end of an sql file, after the COMMIT; ? I'd like to combine two functions onto the one file, the text would be read by another programme, but how can I tell SQLite to ignore what's after the COMMIT mtia Mark

[sqlite] curent_timestamp value

Hi, Could you please tip me why the CURRENT_TIMESTAMP value would always get set to "1999-21-31 12:00:00"? Any SQLITE_OMIT flags may contribute to this? Thanks in advance, Mark Ps. building the sqlite: v.3.6.23.1 for linux (kernel 2.6.31.8) on arm. My omits: -DSQLITE_OMIT_

[sqlite] Cross Compiling & C Interface Problem

wrong or how to fix the problem! I assume it is the way I am using the C interface. Any help would be very much appreciated! Thank you for your time, Mark Jones ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ON DELETE CASCADE not working, version 3.6.23.1

of the rows in tags_product gets deleted. My application (with PRAGMA foreign_keys = ON) creates all of the rows. I used the command line sqlite3 (with PRAGMA foreign_keys = ON) to delete the product_product row. What's going on? Mark ___ sqlite

[sqlite] ON DELETE CASCADE not working, version 3.6.23.1

of the rows in tags_product gets deleted. My application (with PRAGMA foreign_keys = ON) creates all of the rows. I used the command line sqlite3 (with PRAGMA foreign_keys = ON) to delete the product_product row. What's going on? Mark ___ sqlite

[sqlite] output problem

of the programme that the INSERT / DELETE or UPDATE has been completed mtia Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] 64 bit soft heap limit feature request

The soft heap limit SQLite provides has potential uses beyond just constraining memory usage in very low memory environments. Commodity 1U servers are currently available that offer 144GB of RAM installed with a 64 bit operating system. On a system with 144GB of RAM you currently only have the

[sqlite] getting table notifications

goal is for having 2+ processes to connect/attach the same db.file and having 1+ process to update db records and others getting "notified" about the effected rows/columns. Thanks in advance, Mark PS. I will try using shared connectio

Re: [sqlite] crypt() as SQL core function

Hi Nikolaus, I would absolutely love that. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Download the Installer Maker plugin for Runtime Revolution at http

Re: [sqlite] Encryption

Hi Simon, Yes, I thought of that and was hoping I woudn't have to do it this way. Thanks. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Download the Installer

Re: [sqlite] Encryption

earlier post and without having to decrypt the entire file before accessing it. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Download the Installer Maker plugin

[sqlite] Encryption

to re-compile the source? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Download the Installer Maker plugin for Runtime Revolution at http://qurl.tk/ce

[sqlite] Encryption

to re-compile the source? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Download the Installer Maker plugin for Runtime Revolution at http://qurl.tk/ce

[sqlite] INSERT question

Hi there, when using INSERT, if the record is already present, will this cause any problems, does it overwrite or ignore? mtia Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] output problem

thanks, yeah sorry, what I meant to ask was, because the .read command is going away to read another file, away from this one, if you know what I mean, does it actually know to wait for that to finish, or once it's started executing the .read, does it immediately move on to the dump?

[sqlite] output problem

, but the .read could take maybe 10 seconds or more. .read UnPop.sql .output C:\done.txt .dump dbinfo .quit mtia Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] output problem

thanks Michael, my typing 2 forward slashes wasn't intentional, I realized after I posted what I'd done, but it's good to know I can a forward slash instead, so as long it it just goes to the C drive and no further, it should be OK for all users? Mark - Original Message - From

Re: [sqlite] output problem

thanks Simon, that worked, why is this? and if I wanted to send this to someone else and it had the // would it NOT work for them? Mark - Original Message - From: "Simon Davies" <simon.james.dav...@googlemail.com> To: "General Discussion of SQLite Database"

[sqlite] output problem

doesn't work at all, nothing is created. I do need it it to go to at least the C drive, and preferably a folder on C mtia, Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] INSERT questions

the relationships between this table and others in the database, should everything be OK as I want to share this but not screw up other peoples databases mtia Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] Bug Report - Documentation

Hello All: Sorry for the misdirection. The correct link is http://sqlite.org/lang_transaction.html Mark Benningfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bug Report - Documentation

ot;The rollback callback is not invoked if a transaction is rolled back because a commit callback returned non-zero." I'm thinking that it has to be one or the other, but not both. Mark Benningfield ___ sqlite-users mailing list sqlite-users@sqlite.o

Re: [sqlite] Last 3 items per ID

16 UNION SELECT 5, 16 UNION SELECT 6, 20 UNION SELECT 7, 20 UNION SELECT 8, 20 UNION SELECT 9, 20 UNION SELECT 10, 20 ; SELECT t1.entry_id, t1.person_id FROM t t1 JOIN t t2 ON t2.person_id=t

Re: [sqlite] SQLite on Windows 2003

Burnett, Joe wrote: > Hi Teg, > > UTF-8, no special characters in the file name WorkData.s3db. > > Thanks, > > Joe > > Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL > TECHNOLOGY > 2 Contra Way > Merrimack, NH 03054 > 603.791.5113 > cell: 603.289.0481 > If you can debug

[sqlite] Encryption implementation from System.Data.SQLite

on the verge of a major faux-pas, someone please let me know, and suggest possible alternatives. Thanks, Mark Benningfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] not all delete commands completed

/UPDATE/INSERT commands (will this work?) and wondered if alternating the commands might help mtia Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What's the problem with my INSERT clause?

> insert into tb_appointment(GroupCalendarID, ObjectID, Subject) values( > ( > select ugc.GroupCalendarID > from TB_User_GroupCalendar ugc > join TB_User u on u.objectID = ugc.UserID > join TB_GroupCalendar gc on gc.ObjectID = ugc.GroupCalendarID > where calendarname='DEFAULT CALENDAR FOR ' ||

Re: [sqlite] Prepared statements and locking

>> > So is such behavior documented and can be used or should I still avoid >> > keeping such "live" statements in db-shared enviroment? >> >> It's documented that sqlite3_finalize AND sqlite3_reset release all >> locks acquired by the statement. So after resetting the statement you >> can keep it

Re: [sqlite] unexpected behavior with CROSS and LEFT JOIN together

> It's pretty strange how you try to join with some table not even > mentioning any column of that table in the joining condition. I bet > behavior is not defined for such cases in SQL standard and you're > getting some interpretation of such query. > I'm not aware of any requirement that a

[sqlite] unexpected behavior with CROSS and LEFT JOIN together

or CASE, but I'm curious to understand what's going on here. This SQLite 3.6.22. regards, Mark CREATE TABLE currency ( cur CHAR(3), PRIMARY KEY (cur) ); CREATE TABLE exchange ( cur1 CHAR(3), cur2 CHAR(3), rate REAL, PRIMARY KEY (cur1, cur2) ); INSERT INTO currency (cur) VALUES

Re: [sqlite] how to get the meta type of a column

I think the OP wanted to know how to find this programatically. In that case see sqlite3_column_type() function call. Cheers, Mark On Fri, 2010-02-05 at 02:47 +, Simon Slavin wrote: > On 5 Feb 2010, at 2:41am, gujx wrote: > > > Maybe I didn't express the problem clearly. >

Re: [sqlite] Q. about core SQLite library

Sorry, Mr. Gold should contact DRH and ask about the encryption extension. My error. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Q. about core SQLite library

> I was under the impression that is how SEE works. Hooking the SQLite > Virtual File System interface seems like a very straight forward method. > All you really need to do is splice your code between the VFS that > the SQLite engine sees and the native VFS layer that comes with the >

Re: [sqlite] Q. about core SQLite library

Jay A. Kreibich wrote: > On Tue, Jan 12, 2010 at 02:53:55PM -0500, Ray Gold scratched on the wall: > >> Hello. >> >> My name is Ray Gold with Berliner, Corcoran & Rowe, LLP in Washington, DC. >> >> I am writing to ask if the core SQLite library (not the proprietary >> SQLite Extensions) has

Re: [sqlite] Using incremental BLOB I/O when processing result set

rather than the BLOB itself. Thanks for the clarification anyway. Cheers, Mark On Mon, 2009-12-28 at 21:17 -0500, Igor Tandetnik wrote: > Zaher Dirkey wrote: > > If i want to extract BLOB to a file that mean it is must the whale > > blob be loaded to memory before can save it? > &

[sqlite] Using incremental BLOB I/O when processing result set

he user to code their SQL in a certain way (eg include rowid in each query), or assume anything else. Everything about using the SQlite API must be available from the SQLite API. Thanks for your time. Cheers, Mark -- * Mark Hessling, m...@rexx.org http://www.rexx.org/ * Author of THE, a Free XED

Re: [sqlite] Table within a table??

developer instincts were telling me that I was missing something important or asking the wrong questions. Thanks again for all the help. P.S. your developer vs. database perspective should be a sticky or FAQ for other newbies on this mailing list. Mark On Sat, Oct 31, 2009 at 9:32 PM, Jay

Re: [sqlite] Table within a table??

the way I described has always made it easy for me to figure things out when there was a problem. I will give this a try. Thanks very much for all the help. On Fri, Oct 30, 2009 at 4:04 PM, Darren Duncan <dar...@darrenduncan.net>wrote: > mark m wrote: > > Thanks very much!! It a

Re: [sqlite] Table within a table??

khist tables. Is it better to have only 1 and use a foriegn key like you describe to link work history records with a given case?? Is the rule generally to minimize the number of tables?? Mark On Fri, Oct 30, 2009 at 2:44 AM, Darren Duncan <dar...@darrenduncan.net>wrote: > mark m w

[sqlite] Table within a table??

would have all of the work history in it. But, I haven't found a way to do this. If this is not possible, what would be the best way to organize data such as this in a database program. Thanks for the help. Mark ___ sqlite-users mailing list sq

[sqlite] SQLite on a Windows Network

Windows shared drive uses NFS or not. Am I o.k. to use SQLite??? Thanks, Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_BUSY

think it has something to do with the BEGIN that locks the database. Are there any suggestion on how to solve this ? Server is Windows 2008 R2, Desktop is Windows Vista With kind regards, Mark Flipphi ___ sqlite-users mailing list sqlite-users

[sqlite] FTS3 performance oddity

rever" because someone included a state in the search just won't work for me. Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

fsync()" when turning >>> synchronous off? If so, I can conclusively say that >> fsync() is very slow >>> on this storage device. >> Yes, the only action of synchronous = off is to turn off >> calls to >> fsync() which is called at least twice during

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

low on this storage device. Thanks for the suggestion. Mark Pavel Ivanov wrote: > If you execute > > pragma synchronous = off; > > you'll be able to compare performance with syncs and without them. So > if you make this comparison on standard spinning disk and on SSD >

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

It's very possible, but I don't know how to tell. Is there an easy way to know if the sync() calls are taking inordinately long? Mark Thomas Briggs wrote: >Is the sync necessary to commit a transaction slow? Performance of > that sync depends on the OS, file system, hardwar, etc. II

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

Lothar Scholz wrote: > Hello Mark, > > Tuesday, September 22, 2009, 3:53:48 AM, you wrote: > > M> I've currently got a loaner high-performance flash-based "SSD" (let's > M> just say it doesn't connect to any disk controllers) that I'm testing > M>

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

> hard disk, it might be fooling the OS into treating it a one. > > Simon. It's connected directly to the PCI Express bus. It's using it's own driver, so I assume it knows it's not a hard disk :) Mark ___ sqlite-users mailing list sqlite-user

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

I've currently got a loaner high-performance flash-based "SSD" (let's just say it doesn't connect to any disk controllers) that I'm testing for performance. I've run my application against it, and I believe that I should see numbers MUCH higher than I do. When I run my test app on a normal

Re: [sqlite] Booleans in SQLite

or a "NO" means the string "NO" or false or... Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Booleans in SQLite

D. Richard Hipp wrote: > Most varints are "type varints" and type varints are almost always a > single byte (the only exceptions being for large blobs or strings). > Varints are also used to store the total number of bytes in a row > (also usually one byte). Most varints are a single byte.

Re: [sqlite] Booleans in SQLite

D. Richard Hipp wrote: > Most varints are "type varints" and type varints are almost always a > single byte (the only exceptions being for large blobs or strings). > Varints are also used to store the total number of bytes in a row > (also usually one byte). Most varints are a single byte.

Re: [sqlite] Booleans in SQLite

D. Richard Hipp wrote: > You are both right and both wrong. There are two different integer > representations used in SQLite. > > (1) "varint" or variable length integer is an encoding of 64-bit > signed integers into between 1 and 9 bytes. Negative values use the > full 9 bytes as do

Re: [sqlite] Booleans in SQLite

Jay A. Kreibich wrote: > Integer values between -128 and 127 use only a single byte of storage above > and beyond the header size that all values have. > Not quite. Values between 0 & 127 use 1 byte of storage. Negative values use the full 9 bytes in my experience. (I'm setting aside

Re: [sqlite] resource temporarily unavailable after sqlite3_open()

D. Richard Hipp , On 8/11/2009 16:39: > program is using LinuxThreads or NPTL for its threading. (SQLite has > to know which is used because there are serious bugs in LinuxThreads > that SQLite has to work around.) So pthreads gets used once, by > SQLite, even if you don't do any threading in

Re: [sqlite] resource temporarily unavailable after sqlite3_open()

D. Richard Hipp , On 8/11/2009 16:02: > > Perhaps pthreads is going goofy. Please recompile with - > DSQLITE_THREADSAFE=0 and see if that helps. > BINGO. env CC="gcc-cris -mlinux -isystem $EROOT/include"CPP="gcc-cris -mlinux -E -isystem $EROOT/include" CXX="g++-cris -mlinux -xc++

Re: [sqlite] resource temporarily unavailable after sqlite3_open()

L error: %s\n", zErrMsg); sqlite3_free(zErrMsg); } sqlite3_close(db); (Note: WriteSyslogMessage() issued a system("logger 'string'"); call) Same issue. -1 returned during read(). /m D. Richard Hipp , On 8/11/2009 15:38: > On Aug 11, 2009, at 2:53 PM, Mark Richar

Re: [sqlite] resource temporarily unavailable after sqlite3_open()

I also (just) tried 3.6.17. Same issue. /m Mark Richards , On 8/11/2009 14:53: > Environment: > Linux axis 2.6.19 #9 PREEMPT Mon Apr 6 15:44:03 EDT 2009 cris unknown > > Sqlite: > Sqlite: sqlite-3.6.14 > ./configure --host=cris-axis-linux-gnu >--prefix

[sqlite] resource temporarily unavailable after sqlite3_open()

Environment: Linux axis 2.6.19 #9 PREEMPT Mon Apr 6 15:44:03 EDT 2009 cris unknown Sqlite: Sqlite: sqlite-3.6.14 ./configure --host=cris-axis-linux-gnu --prefix=/AEMDEV/83+/devboard-R2_10/target/cris-axis-linux-gnu --enable-static=yes --enable-shared=yes

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

Stan Bielski wrote: > Hello again, > > Copying the database with Explorer and accessing it via sqlite is just > a contrived example that exhibits the same problem I'm having in my > application. The app does make a copy of the DB, but it has app-layer > locking that will prevent modifications

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

> Just to be clear, I think Windows is really the one that is at fault > here; the behavior seems very broken to me. Unfortunately, I need the > app to work on Windows without this happening, so I need to figure out > some kind of workaround in a.) Windows settings b.) the sqlite source > or c.)

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

Stan Bielski wrote: > In the course of copying a largish (20 GB) database file while > accessing it via sqlite3, the machine became very unresponsive. I > opened task manager and found that the system was using a huge amount > of virtual memory, causing it to thrash. Per-process memory usage >

[sqlite] SQL result to struct

? With kind regards, Mark Flipphi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reducing the size of executable linked with sqlite3.c

http://www.sqlite.org/compile.html There are options you can use to disable/remove unused features. Some can give significant size savings. (I did this on Windows, YMMV.) Unfortunately, you can't just use these with the amalgamated source. You will probably have to rebuild it. It's not

[sqlite] Direct row insert from C (without SQL) / Database speed

or windows ? And what about stroing the database onto a Solid state disk or on a Raid 6 array normal HD Best regards, Mark Flipphi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Shared binary plus static lib

On Sunday 07 June 2009 14:26:07 Mark Constable wrote: > Would anyone have a clue as to how I could end up with > /usr/lib/libsqlite3.so.0 > as well as /usr/bin/sqlite3 and /usr/lib/libsqlite3.a ? Another one for the list archives. I'm not sure if this is 100% correct but the result wor

Re: [sqlite] Shared binary plus static lib

Would anyone have a clue as to how I could end up with /usr/lib/libsqlite3.so.0 as well as /usr/bin/sqlite3 and /usr/lib/libsqlite3.a ? cc -DTHREADSAFE=0 -c sqlite3.c cc -DHAVE_READLINE=1 -o sqlite3 sqlite3.o shell.c -ldl -lreadline -ltermcap -I/usr/include/readline ar cru libsqlite3.a sqlite3.o

Re: [sqlite] Shared binary plus static lib

On Sunday 07 June 2009 10:51:05 Jay A. Kreibich wrote: > > > > Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary > > > > but also with a libsqlite3.a static lib. Could anyone suggest how I > > > > could alter this Makefile to support these requirements please? > > > > Is there a

Re: [sqlite] Shared binary plus static lib

On Sunday 07 June 2009 00:15:21 Jay A. Kreibich wrote: > > Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary > > but also with a libsqlite3.a static lib. Could anyone suggest how I > > could alter this Makefile to support these requirements please? > > Assuming you're using

[sqlite] Shared binary plus static lib

Howdy, I'd like to end up with a shared NON-threaded NON-TCL binary but also with a libsqlite3.a static lib. Could anyone suggest how I could alter this Makefile to support these requirements please? For x86_64 and i686, kernel 2.6.29.4, glibc 2.10.1. TOP = ../sqlite3 BCC = gcc -O2 USLEEP =

Re: [sqlite] 64 bit compatibility of sqlite 3.5.7

For 32 bits it should be a long, for 64 bites, a 64 bit integer type. For example __int64 in Windows. sqlite3_intptr_t has to be large enough to hold the larger of an integer or a pointer on each platform. We had to fix this too... Gopala Surya wrote: > Hi All > We have been using sqlite

Re: [sqlite] Db design question (so. like a tree)

than the id's of the parents. Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

<    1   2   3   4   5   6   >