[sqlite] Update trigger

values for all columns were logged but not where only changed columns were logged. Thanks, Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite.so dynamic library-linux

ble to test one of your targets too. Doug -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Udon Shaun Sent: Friday, March 18, 2011 11:47 PM To: Pavel Ivanov; SQLite Subject: Re: [sqlite] SQLite.so dynamic library-linux @Pa

Re: [sqlite] SQLite server

to the client. And if the response is large, will you page, or keep the transaction open on the server thus blocking all other clients? The devil is always in the details :) Doug -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf

Re: [sqlite] First(s) select are very slow

Adding to what Simon said, even the SQLite cache has to get filled initially as well. So those very first hits to the database are always the most expensive. Once commonly used pages (index pages?) are loaded, you're running closer to memory speed than disk speed. -Original Message-

Re: [sqlite] First(s) select are very slow

instead of the much slower disk. Doug -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Vander Clock Stephane Sent: Monday, December 20, 2010 8:43 AM To: General Discussion of SQLite Database Subject: [sqlite] First(s) select

Re: [sqlite] Windows performance problems associated with malloc()

I wonder if HeapSetInformation (which can enable a low-fragmentation heap) would be helpful too. You can set it on the process and the CRT heaps. Note that it's not available in Win2K and earlier. Doug -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun

Re: [sqlite] assert crash in wal

the complexities of interprocess communication/synchronization which is much easier to handle with threads in the same process. But you are right about the costs -- the benefits of using threads incur a cost -- a cost of being very careful. Doug ___ sqlite-us

Re: [sqlite] Backup-restore behaviour

On Dec 7, 2010, at 10:49 AM, Csom Gyula wrote: > It clarified the situation, that is backup-restore seems to be the best > choice:) Just one more question. As you put backup-restore is based upon data > pages (that could be binary a format I guess) not on plain SQL/data records. > After all:

Re: [sqlite] Just compiled SQLite in Visual Studio

++ rules. And you can mix .c and .cpp files in the same project. As for what the difference is? That's a big question. Objects exist in C++, and they don't in C. That's the tip of the iceberg. Doug -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Nov 29, 2010, at 9:37 AM, Rick Regan wrote: > "For IEEE 754 double-precision numbers and 64-bit integers roughly > 99.4% of all numbers can be processed efficiently. The remaining 0.6% are > rejected and need to be printed by a slower complete algorithm." > > Hmmm. What's involved in the

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Nov 28, 2010, at 6:19 PM, Rick Regan wrote: > On Sun, Nov 28, 2010 at 5:52 PM, Doug Currie <doug.cur...@gmail.com> wrote: > >> >> There is a new publication on this subject that may be of interest to those >> looking at providing solutions: >> >

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Nov 28, 2010, at 5:37 PM, Rick Regan wrote: > On Sun, Nov 28, 2010 at 4:01 PM, Doug Currie <doug.cur...@gmail.com> wrote: > >> On Nov 28, 2010, at 11:18 AM, Rick Regan wrote: >> >>> Michael, >>> Thanks for the very thorough analysis. >&

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Nov 28, 2010, at 11:18 AM, Rick Regan wrote: > Michael, > Thanks for the very thorough analysis. This is a difficult problem; fortunately it was solved 20 years ago... http://www.mail-archive.com/sqlite-users@sqlite.org/msg09529.html e ___

Re: [sqlite] Scaling of Cache

well thought out in SQLite so I'm wondering if anyone can comment on the why's. Thanks Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Pavel Ivanov > Sent: Monday, October 18, 2010 2:15 PM > To: Gen

Re: [sqlite] C++ Unresolved external errors from DLL

sqlite3_bind_blob sqlite3_bind_double sqlite3_bind_int sqlite3_bind_int64 sqlite3_bind_null sqlite3_bind_parameter_count sqlite3_exec sqlite3_open ... That's always worked for me. Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@s

Re: [sqlite] Run Time Error #1 in VS2008

I use SQLite3 directly from a number of VS2008 projects and have never seen that issue. Can you find the line of code causing the problem? > I am working on a project in VS2008 and I am including the sqlite3 code > directly (compared to in the past using wrappers). The program is > working

Re: [sqlite] Query suggestion?

Thenk you Gerry. After some studying I now understand that the inner SELECT is executed for each outer row -- so trimming the outer result set early seems like a very good optimization idea. Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite

Re: [sqlite] Query suggestion?

Thank you Igor. You've helped me before with what also turned out to be a similar select referencing the same table twice. I guess it's a concept that I don't fully get. If there is a name for this technique I'll go Google and study up on it. Doug > -Original Message- >

[sqlite] Query suggestion?

of: SELECT StatID, max(Date), max(Value) FROM StatData GROUP BY StatID That would give me the most recent Date, but not the Value that corresponds with that Date. None of the other aggregate functions seem appropriate either. Thanks for any ideas. Doug

Re: [sqlite] Why the deadlock?

On Aug 24, 2010, at 10:57 AM, Nikolaus Rath wrote: > Nikolaus Rath writes: >> Still no one able to clarify the issues raised in this thread? >> >> Let me try to summarize what I still don't understand: >> >> - Will SQLite acquire and release an EXCLUSIVE

Re: [sqlite] playing with triggers

On Aug 19, 2010, at 4:00 PM, David Bicking wrote: > I haven't tried RAISE(ROLLBACK... as that seems to severe. > RAISE(ABORT... removes the initial insert to Table1, which I want to avoid. > RAISE(FAIL.. on lets say the fourth record inserted in to Table2, would leave > the first three there,

Re: [sqlite] fast string prefix matching

On Aug 17, 2010, at 9:28 PM, Igor Tandetnik wrote: > Doug Reeder <reeder...@gmail.com> wrote: >> I need to search for string prefix matches; for example given the >> path 'PP', >> I need to find 'PPA', 'PPBJQ', and 'PPz'. (The character set is all >>

[sqlite] fast string prefix matching

ueDate IS NOT NULL", [project.path,nextPath], ... Is there a faster statement that does what I want (my first SQL statement above) in pure SQL? -- Doug Reeder reeder...@gmail.com http://reeder29.livejournal.com/ https://twitter.com/reeder29 https://twitter.com/ho

[sqlite] Possible Bug SQLITE 3.7.0

names in CREATE TABLE commands prior to importing into Postgres, because Postgres is case-insensitive unless the names are quoted. Possible resolution: Modify output syntax for CREATE TABLE generation for .dump and .schema to quote all table names. Cheers, Doug Campbell

Re: [sqlite] Couple of questions about WAL

ected. Also, is the reference counting per process or per connection? Thanks Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is the absence of msvcrt.dll a known issue with SQLite Windows 2000

in your app to see if something else is missing a DLL. Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What languages can include SQLite statically?

On Jun 1, 2010, at 2:24 PM, Gilles Ganault wrote: > Actually, it's a Blackfin processor, and since it's an embedded > environment, RAM and storage (NAND) are an issue. You may find eLua interesting. http://www.eluaproject.net/ The supported platforms are heavily ARM based, but in the same

Re: [sqlite] sqlite on mac os x 64 bits

On May 18, 2010, at 4:14 AM, Sylvain Pointeau wrote: > but is it 64 bits? or do I have to add a special option? Last time I built a Universal Binary sqlite3 on OS X (March 2010 3.6.22) I had to CFLAGS='-arch i686 -arch x86_64' LDFLAGS='-arch i686 -arch x86_64' ./configure

Re: [sqlite] ANN: O'Reilly book "Using SQLite" available for pre-order

can be valuable. Good luck with the book Jay. Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] round problem?

On Feb 15, 2010, at 1:43 PM, Roger Binns wrote: > Shane Harrelson wrote: >> I'm looking at how this can be improved. > > It seems that everyone else is converging on using David Gay's dtoa.c We've been "converging" for a few years!

Re: [sqlite] In Memory Usage

On Jan 4, 2010, at 6:35 AM, sasikuma...@tcs.com wrote: > I'm using SQLite DB version 3.6.12. I recently read about the feature of > In-Memory Database and tried to implement it. I was able to create a new > DB connection in memory, able to create a table and insert some set of > records into

Re: [sqlite] Unique index on REAL values and equality check

On Dec 13, 2009, at 3:16 PM, Alexey Pechnikov wrote: > As we can see, the unique index can check equlity of REAL values > but the "=" operator can not. it's fantastic I think :-) The problem is not the "=" operator... sqlite> create table test (save_date REAL unique); sqlite> insert into test

Re: [sqlite] sqlite for threads

transaction with: BEGIN IMMEDIATE; any time the database will be written to (ie an insert, update, delete, etc). That, along with looping on sqlite3_prepare_v2 and sqlite3_step any time you get SQLITE_BUSY, virtually solved the issue for me. HTH Doug _

Re: [sqlite] SQLite on PocketBook

On Nov 5, 2009, at 5:15 PM, Beau Wilkinson wrote: > I really think this warrants further discussion. Perhaps the correct > answer (that ARMs implement a non-standard FP type which is > incompatible with Sqlite) is already out there, but I think the > issues I raised with that answer should

Re: [sqlite] feature proposal - strong but dynamic typing

On Oct 30, 2009, at 10:14 AM, P Kishor wrote: > Actually, there can be one bad effect of Darren's suggestion, now that > I think of it, and that would be for those who don't care for strong > typing. They will end up getting strong typing for all non-UNIVERSAL > columns whether they like it or

Re: [sqlite] Limiting memory usage

e soft limit? Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Limiting memory usage

Yes, correct. I just showed it to indicate that all databases that are ever created use this page_size of 4KB. > > PRAGMA page_size=4096 > > This PRAGMA governs characteristics of a database you have not yet > created: it's pages on disk, not pages in memory. The page_size is a >

[sqlite] Limiting memory usage

I'm trying to figure out how to limit SQLite's memory usage while still giving it as much memory as I can. The app has about 50-60 separate database handles to 50-60 separate database files. Each handle is only used by a single thread at a time, and most are always accessed by the thread that

[sqlite] PRAGMA scope

after calling sqlite3_open each time). Temp_store and synchronous don't make any mention of files or connections. Can/should it be assumed that they are global to the SQLite library? Thanks Doug ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Fwd: sqlite3_prepare_v2

Try renaming the windows\system32\sqlite3.dll to sqlite3.lld (or anything else so you can easily find it and restore). Then see which app has problems launching (if any). Sqlite3.dll probably shouldn't be there anyway. Once you know what app needs that DLL, you can copy it into the

Re: [sqlite] one liner for insert or update ?

Wouldn't "INSERT OR REPLACE" do that for you? (which by the way, has to be one of the coolest features in SQLite of all!) http://www.sqlite.org/lang_insert.html Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sq

[sqlite] Speeding up a (simple?) GROUP BY query

); Is there any slick way to make the GROUP BY faster, since I don't really need to group by all that data? Since there is an index on StatData.StatID, I would assume the GROUP BY would work by just hitting the index, but I've been wrong before. Thanks for any ideas from the group. Doug

Re: [sqlite] Huge numbers of savepoints.

On Aug 23, 2009, at 6:46 AM, Chris Dew wrote: > Note: this is not for production code, just an experiment in keeping a > history of application 'state', allowing current state to be > recalculated if an historic input is received 'late'. See >

Re: [sqlite] (no subject)

have any issues with storing and retrieving local strings. If you don't use the wide-char (16) APIs, you would need to explicitly convert your strings to UTF-8 (which is not the same as ASCII) before handing to SQLite. Doug > -Original Message- > From: sqlite-users-boun...@sqli

Re: [sqlite] What is a Relation?

On Jul 27, 2009, at 10:33 AM, CityDev wrote: > It's true that Codd and Date used the term 'relational' (They > championed the > N-ary Relational Model - others were around at the same time) but > it's not > easy to track the origin of the term in mathematics.

Re: [sqlite] .lib file?

haven't kept my sqlite3.def file up to date, but it's fairly recent if you want to use it. Since we can't post files to the newsgroup, I'll append it here. Doug EXPORTS sqlite3_aggregate_context sqlite3_aggregate_count sqlite3_auto_extension sqlite3_bind_blob sqlite3_bind_double sqlite3_bind_int

Re: [sqlite] SQLite: Porting to another Operating system.

On Jul 24, 2009, at 8:44 AM, D. Richard Hipp wrote: > SQLite database files are cross-platform. All you have to do is copy > the file to the new machine. There is no separate "external format". > The same database file format work on all platforms. Just make sure that if you are moving to a

Re: [sqlite] Heirarchical queries question

Wow Pavel, that's a cool approach. I understand the issue about having % in the path (which is a problem I need to work around), but what is special about '_' ? Thanks Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@s

[sqlite] Heirarchical queries question

INTEGER, Path TEXT, ParentDirID INTEGER ); and some data that represents this table structure: / /users /users/doug /users/brett /users/brett/work /users/brett/research /users/brett/research/SQL INSERT INTO Directory (DirID, Path, ParentDirID) VALUES (1, '/', 0); INSERT

Re: [sqlite] sqlite3.OperationalError: unable to open database file

On Jul 7, 2009, at 4:36 PM, nixonron wrote: > conn = sqlite3.connect('c:\Ujimadata\aid.sqlite') Perhaps you meant conn = sqlite3.connect('c:\\Ujimadata\\aid.sqlite') or conn = sqlite3.connect('c:/Ujimadata/aid.sqlite') e ___ sqlite-users mailing

Re: [sqlite] Building sqlite

You may need SQLITE_THREADSAFE depending on how you're using the library > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Robert Dailey > Sent: Monday, June 29, 2009 1:51 PM > To: General Discussion of SQLite Database >

Re: [sqlite] sqlite3_exec unresponsive for insert, delete and update

I don't know anything about xcode, but I've been burned by bugs like this in the past. It was always my fault: console was connected to one DB, and my app was connected to another. Make REALLY sure you're using the database file that you think you are. Doug > -Original Message- >

Re: [sqlite] Shortest time interval? [Was: Re: repeating events?]

On Jun 12, 2009, at 3:46 PM, Allen Fowler wrote: > sqlite> > select *, min((strftime('%s', end) - strftime('%s', start))) as > length > from > ...> events where > ...> start < datetime('now', '+1 day','start of day', > '+9 hours','+30 minutes') > ...> and end > datetime('now', '+1

Re: [sqlite] corrupt database recovery

search. Good luck either way. Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Gene Allen > Sent: Wednesday, May 27, 2009 4:52 PM > To: mgr...@medcom-online.de; 'General Discussion of SQLite Database

Re: [sqlite] error in documentation of SELECT?

On May 19, 2009, at 10:05 AM, Jean-Denis Muys wrote: > On 5/19/09 2:44 PM, "Igor Tandetnik" wrote: >> >> Wikipedia gives a definition different from yours, for what it's >> worth: >> >> http://en.wikipedia.org/wiki/Remainder#The_case_of_general_integers > > Also to

Re: [sqlite] How make atomic? Was: Sqlite as a FIFO buffer?

On May 18, 2009, at 5:32 PM, Allen Fowler wrote: >>> The simple solution would just create a race condition... i think: >>> >>> 1) INSERT INTO status_table FROM SELECT oldest task in queue >>> 2) DELETE oldest task in queue >>> >>> Right? >> >> It might work fine if you wrap it in an exclusive

Re: [sqlite] CURRENT_TIMESTAMP precision

On May 15, 2009, at 9:07 AM, Sam Carleton wrote: > I would like CURRENT_TIMESTAMP to be more accurate than just one > second, any suggestions on how I might do that once? My solution is > all a C/C++ interface, so all features are open to me. Option 1 - use: julianday('now') instead of

Re: [sqlite] SQLite version 3.6.14

serialized by the database-level locks, but writes to other databases continue to work. But using the async feature would serialize all reads and writes to all databases, is that correct? Thanks Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-

Re: [sqlite] Sporadic freezes of sqlite

On Apr 22, 2009, at 4:38 PM, Pavel Ivanov wrote: > I've tried to set pragma synchronous = on (it's off by default for > me), but it makes application to work 5 times slower which is not > acceptable for me. I would be happy if there was some solution in > between that, i.e. for example just a

Re: [sqlite] Query Doesn't Find Record

On Mar 12, 2009, at 12:08 AM, jonwood wrote: > Doug Currie-2 wrote: >> >> Note the '/'s >> > > What does this mean? What does DATE('2009-1-1') or DATE('2009/1/1') > return? > Does DATE() simply have no effect whatsoever? Sorry to be cryptic. sqlite> select

Re: [sqlite] Query Doesn't Find Record

On Mar 12, 2009, at 12:01 AM, jonwood wrote: > PaymentDate=2009/01/05 Note the '/'s > And then I ran the following query: > > SELECT * FROM Payments WHERE FK_CustomerID=5 AND DATE(PaymentDate) >= > DATE('2009-01-01') AND DATE(PaymentDate) <= DATE('2009-03-11') Note the '-'s. '2009/' >

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

, with the caveat that some items were 'processed' but in volatile memory longer than they might have been otherwise. Doug > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of VF > Sent: Sunday, March 08, 2009 3:48 AM

Re: [sqlite] DateTime Objects

>it just seems very inefficient to store a date as a string in a database. I agree. But why would you store it as a string?? I personally store my times as ints (__time64_t, or time_t). When I read it back my app formats it however I want. Simple :) Doug > -Original Message-

Re: [sqlite] sqlite for embedded devices

On Nov 25, 2008, at 1:44 PM, Igor Augusto Guzzo wrote: > I get an ARM based embedded system (AT91SAM9260 - ATMEL), linux based, > with uclibc library and my code, developed in C with the sqlite3 > library, runs fine only in my host linux (Fedora). > > Firstly, I compiled the code on Makefile

Re: [sqlite] Performance improvement In Sqlite 3.6.4 version

On Nov 18, 2008, at 5:10 AM, Roshan Sullad wrote: > [...] > I have another Visual studio test application where I am using this > Sqlite3.dll functionality, I have linked statically to Sqlite3.dll by > including *sqlite3.c,sqlite3.h,sqlite3ext.h* , files in to my test > application project. And

Re: [sqlite] sqlite insert and delete statements not succeed

On Nov 12, 2008, at 10:31 PM, henry wrote: > my app, I opened a database handler, insert some records, delete some > records, then closed the database handler. The problem is the next > time > when I connect the Sqlite, the actions I did last time has all gone > away, it did not take any

Re: [sqlite] setting the timezone on windows xp

Hi Jay -- I used to have a problem like this a few years back. I don't remember all the hows and whys, but my apps call the following at start up and the problems are gone: _tsetlocale(LC_ALL, _T("")); _tzset(); HTH Doug > -Original Message- > From: [EMAIL PROTECTED

Re: [sqlite] CURRENT_DATE Behavior

of pain as I switched everything to UTC -- life has been good since then. Doug > -Original Message- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of jonwood > Sent: Monday, October 20, 2008 9:03 PM > To: sqlite-users@sqlite.org > Su

[sqlite] Malformed database image

too random an error to worry about, no problem. I need to get on the 3.6 series anyway. Doug Call stack (not for sqlite3, but from my app): sqlite3.dll!sqlite3GetVarint(const unsigned char * p=0x052c4227, unsigned __int64 * v=0x043b13f8) Line 14895 + 0x3 bytes sqlite3.dll!sqlite3BtreePa

Re: [sqlite] basic insert questions...

it bold? Doug > -Original Message- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of D. Richard Hipp > Sent: Wednesday, October 15, 2008 3:16 PM > To: [EMAIL PROTECTED]; General Discussion of SQLite Database > Subject: Re: [sqlite] basi

[sqlite] Intermittent SQLITE_CANTOPEN on Windows

can't figure out what has changed on my system such that this would be happening now. Thanks in advance for any ideas. Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite vs. quad-cores

ptimizer" patch to correct this: http://www.amd.com/us-en/Processors/TechnicalResources/0,,30_182_871_13118,0 0.html This is backwards from your situation, but it at least demonstrates issues in a related area, so perhaps there's something there. Doug > -Original Message- &

Re: [sqlite] Detecting other connections to DB?

Great answer, thank you very much. doug Thursday, August 21, 2008, 3:42:12 PM, you wrote: ML> Doug Porter wrote: >> Is there a way to get a list of connections that are opened on a >> particular SQLite database file? >> >> Our software uses SQLite to save our data

[sqlite] Detecting other connections to DB?

), but ran into a couple places where that won't work. Any help would be greatly appreciated! doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [C++] Import sqlite3.dll and/or sqlite database as resource in project?

On Aug 10, 2008, at 2:12 PM, CAVALO SCHMIDT wrote: > salutations, using VC++ in WinXP. > > I would like to know if it's possible to import and use the > sqlite3.dll file and/or the sqlite database file as a resource in a > C++ project, so that it will be integrated to the final Win32 >

Re: [sqlite] 64bit Version

Isn't 2008 the same as Vista? In that case, are you sure you have administrative rights? I'm betting user account control is limiting them at the moment. Run cmd.exe as an administrator (right click on a shortcut and choose Run As Administrator) and then see if it works. If you don't see the

Re: [sqlite] SQLite 3.6.0 coming soon...

And Section 2.0 has: "Partually or fully disable" > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Shawn Wilsher > Sent: Saturday, July 12, 2008 4:49 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite 3.6.0 coming soon...

Re: [sqlite] Query help?

suppose creating a combined index of EventTime, ProcessID and FileName might help because the underlying record wouldn't need to be looked up. Any thoughts on that idea? Thanks Doug > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Igor

Re: [sqlite] Equivalent of mysql_real_escape_string() ?

Besides substituting ' with '' (double single-quotes) you might also want to consider trimming trailing spaces. I ended up inserting strings like 'Doug' and 'Doug ' in a unique-indexed column. SQLite let me do it and all was well. One day I exported that data to MS SQL and it complained about

Re: [sqlite] in memory or hard disk reading?

, but I'm not aware of any rules of thumb. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of L B > Sent: Friday, April 18, 2008 9:11 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] in memory or hard disk reading

Re: [sqlite] in memory or hard disk reading?

Someone correct me if I'm wrong, but ... > Could this improvement be different changing operating system? Certainly. You're benefitting from an OS that does file caching. If you switch to an OS with no file caching you'll lose the benefit. > When Is it convenient to use SQLite page-cache

Re: [sqlite] String is changing after inserting into database

Are you using the 16 bit calls? Like: sqlite3_prepare16_v2 sqlite3_column_text16 sqlite3_open16 That's what I use and I'm able to store and retrieve every non-Latin character I've tried so far. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of

[sqlite] Shared cache benefit question

/sharedcache.html but I'm not confident enough in my understanding to know whether I'll run into more or less blocking. Thanks for any insight. Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Weird locking issue Windows XP64 3.5.5

. Changing the journal file rights solved it for me. If you deleted the journal file (if there was one) that might explain it in your case. Doug > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Teg > Sent: Thursday, March 13, 2008 9:48 AM &

Re: [sqlite] compiling C program to use the shared library

he reason an import library isn't included is because you need a > different one for each compiler you use to link. Right, and with gcc on Windows (mingw/msys or cygwin), you don't need an import library at all; gcc will link against the DLL itself. e

Re: [sqlite] Mailing List Changes

> This mailing-list business is becoming a royal pain in the derriere. > Every other mailing list behaves differently... some default to the > list, others to the OP. Why can't we all get along. > Please set the list so default reply is to the list. http://www.unicom.com

RE: [sqlite] Cache for SQLite

I don't know of a daemon, but based on someone else's post where they described keeping a pool of sqlite3* handles to the database, and always reusing the most recently used handle first (so that the SQLite page cache is most likely still valid) I saw a very big jump in performance. Perhaps

Re: [sqlite] SQLite character comparisons

e pad character is a > . So, using this terminology, the SQLite default collating sequence has the NO PAD attribute, and the pad character is NUL. Jeff, can you solve your problem with a custom collating sequence? e -- Doug Currie Londonderry, NH, USA

RE: [sqlite] Date arithmetic question

Perhaps some enterprising soul could write the datediff function and put it in the wiki for everyone to use. In fact a separate area just for user-written functions might be quite helpful. For what it's worth, I have one that truncates a time (stored in time_t format) down to the start of an

[sqlite] SQLITE_CORRUPT error

he doesn't think occurred (it is Windows, and the server was rebooted at some point.) I suspect the answer is no, but is there any way to salvage any of the data? Thanks Doug

RE: [sqlite] Trying to understand SQLITE3_BUSY

:) > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 19, 2007 12:49 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Trying to understand SQLITE3_BUSY > > "Doug" <[EMAIL PROTECTED]> wrote: > > Well, I'

RE: [sqlite] Trying to understand SQLITE3_BUSY

gt; To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Trying to understand SQLITE3_BUSY > > "Doug" <[EMAIL PROTECTED]> wrote: > > I have a database file that was created with version 3.4.1. It _may_ have > > been written to at some point with 3.5.3 - can't sa

[sqlite] Trying to understand SQLITE3_BUSY

I have a database file that was created with version 3.4.1. It _may_ have been written to at some point with 3.5.3 - can't say for sure. At some point a transaction was started and the app was stopped (probably me in the debugger). I assume I was using 3.4.1 at the time it but it could

Re: [sqlite] Querying DATE column with date/time string.

Doug Van Horn wrote: > > Hi, > > I'm running into a problem with the database library in Django running > against SQLite. I'm trying to understand why the following happens: > > $ sqlite3 date_test > SQLite version 3.4.2 > Enter ".help" for instructio

[sqlite] Querying DATE column with date/time string.

lause not find the record? Thanks for any help or insights... Doug Van Horn -- View this message in context: http://www.nabble.com/Querying-DATE-column-with-date-time-string.-tf4956413.html#a14193493 Sent from the SQLite mailing l

RE: [sqlite] Suggests for improving the SQLite website

One thing I really like about the current home page is the listing of the past 4-5 versions, the date when they were released and what changed. It is so easy to see what has changed since the version that I happen to be on. That may not need to be on the front page necessarily (although I like

[sqlite] Shared cache and PRAGMA cache_size

I have a highly threaded application that writes to a number of database files. Each thread opens a database file, uses its own handle, and then closes that handle when finished. As the threads come and go, some will likely overlap with others using the same database, so it seems like the

[sqlite] Master Journal files hanging around

QL (ie a constraint not being met) to I/O errors. Hopefully I'll get some log files that will give me more insight. Thanks for any input. Doug - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Performance problem for a simple select with range

I'm not an SQL guru by any means, so seeing this made a light go on. Does that mean it is a good idea in the general case to always add "limit 1" to a select that you know should only return 1 row? I'm assuming this works because the engine can short-cut out as soon as it finds that first

RE: [sqlite] Threads in 3.5.0

I'd like to retract my last statement. The _other_ alternative is obviously separate processes as is being discussed. I need to go get some rest ... > -Original Message- > From: Doug [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 04, 2007 2:08 PM > To: 'sqlite-user

<    1   2   3   4   >