Re: [sqlite] Noobie question about importing data into table

chChar = chChar.id); 1|char1|1|def1 2|char2|2|def2 2|char2|3|def3 3|char3|4|def4 4|char4|5|def5 4|char4|6|def6 5|char5|7|def7 -- Eric A. Smith I still maintain the point that designing a monolithic kernel in 1991 is a fundamental error. Be thankful you are not m

Re: [sqlite] open db cx to fork(2)d children

e calls against existing structures), then no harm will result. Thanks, Eric -- Eric A. Smith Impartial, adj.: Unable to perceive any promise of personal advantage from espousing either side of a controversy or adopting either of two conflicting opinions. -- Ambr

Re: [sqlite] sqlite query with c++ variable

of experience in C++. I strongly recommend that you read up on the language itself before attempting to write SQLite applications. Are you required to use C++? You may find it (much, much) easier to use Tcl at first. If I may ask: are you a student, or doing this for fun in your spare time, or

Re: [sqlite] Null character problem

Simo Slavin wrote: > (according to your earlier post) I'm not OP. I'm Eric. OP was someone else. In this context, I don't care about blobs or about the right way of doing anything. > Read the documentation for memset(). I know quite well how memset works. I know character

Re: [sqlite] Null character problem

he column. Is that right? Eric -- Eric A. Smith When you come to a fork in the road, take it. -- Yogi Berra ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Null character problem

ob.html I have no specific knowledge on whether sqlite handles null characters within the variables' values--but if I were a bettin man, I'd bet that it handles them quite cleanly. -- Eric A. Smith I think there's a world market for about five computers. -- attr. Thomas J. Wats

Re: [sqlite] work-arounds for (possibly buggy) nfs?

ng the lock on the attached db is released. Is that right? Eric -- Eric A. Smith I still maintain the point that designing a monolithic kernel in 1991 is a fundamental error. Be thankful you are not my student. You would not get a high grade for such a design. -- Andrew

Re: [sqlite] Reg: In Memory Database Using SQLite

s to the slave and open it using normal sqlite api calls. SQLite and your app think the db is disk-backed because the OS is faking the existence of a disk. Whether this option works well depends on how easy it is to get a ram-backed fs up and running on your slave. (In linux this is very

Re: [sqlite] work-arounds for (possibly buggy) nfs?

=EXCLUSIVE" might also be a > good idea in such a configuration. My use-case requires no concurrency whatsoever. I'll circle back if I notice any perf changes. Many thanks! Eric -- Eric A. Smith fenderberg, n.: The large glacial deposits that form on the insides of car

[sqlite] work-arounds for (possibly buggy) nfs?

4:59 EDT 2008 i386 Can anyone offer any hints? Thanks! Eric -- Eric A. Smith Furbling, v.: Having to wander through a maze of ropes at an airport or bank even when you are the only person in line. -- Rich Hall, "Sniglets" _

[sqlite] docs bug: tclsqlite.html

tclsqlite.html lists an "unlock_notify" method with no other documentation. Trying to use it gives me this: -bash-2.05b$ tcl % package require sqlite 3.6.23 % sqlite3 db /tmp/foo % db unlock_notify unlock_notify not available in this build % -- Eric A. Smith The concept is i

Re: [sqlite] Reg: In Memory Database Using SQLite

in-memory database that dies when the connection is closed: http://sqlite.org/c3ref/open.html -- Eric A. Smith More people would come here if it weren't so crowded. -- Yogi Berra ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SqLite 3.7.0 amalgamation build warnings

out it. Eric -- Eric A. Smith Peace, n.: In international affairs, a period of cheating between two periods of fighting. -- Ambrose Bierce, "The Devil's Dictionary" ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] SqLite 3.7.0 amalgamation build warnings

tml#staticanalysis for details on that. If you want action regarding the warnings you see, I recommend arguing how the relevant code will cause a real-world behavioral problem. And the best argument is to write a bit of code exercising the problem. -- Eric A. Smith Where a calcula

Re: [sqlite] ARM Cross compilation problem

ation on the target platform. If the proper shared libs exist there, then you're good to go. If not, you need to statically link libgcc as well at compile time. Do that by passing -static-libgcc to your compiler. Disclaimer: I'm not a guru in the area, so ymmv. Good luck, Eric

Re: [sqlite] ARM Cross compilation problem

Matheus Ledesma wrote: > "arm-none-linux-gnueabi-gcc -o balanca > balanca_simula_peso_io_paralela.c -Wall -W -O2 > -Wl,-R/home/generic/CodeSourcery/Sourcery_G++_Lite/lib -lsqlite3 > -lpthread -static" Try adding '-ldl' to your args. Eric -- Eric A. Smith Where a c

[sqlite] minor website bug (was Re: SQLite 3.7.0 coming soon....)

> Please provide feedback - positive, negative, or indifferent - to this > mailing list. Minor: the link in about.html from "fopen()" to http://man.he.net/man3/fopen is broken. Eric -- Eric A. Smith Mandelbug, n.: A bug whose underlying causes are so complex and obscur

[sqlite] open db cx to fork(2)d children

parent does? Will this still cause problems? What if I add an additional assumption that the parent process is the only process that ever accesses the database? -- Eric A. Smith Slurm, n.: The slime that accumulates on the underside of a soap bar when it sits in the dish too long.

Re: [sqlite] How accept sqlite3 commands from stdin

Peng Yu wrote: > On Thu, Jun 24, 2010 at 5:05 AM, Simon Slavin wrote: > > > > On 24 Jun 2010, at 4:50am, Peng Yu wrote: > > > >> Is there a way to use Shebang for sqlite3 script? > >> > >> http://en.wikipedia.org/wiki/Shebang_%28Unix%29 > > > > SQLite comes with a

Re: [sqlite] 64 bit libsqlite for AIX and Solaris

Black, Michael (IS) wrote: > Though I'm not sure if there's any advantage/disadvantage to 64-bit > binaries for sqlite3, is there? 64-bit SQLite can cache more than 4Gb of your db. Eric -- Eric A. Smith Finagle's First Law: If an experiment works, something has gone

Re: [sqlite] linear behavior on INSERT (was Re: unexpected large journal file)

on. 3. Consider reducing churn against OS-level caches (or the disk) by increasing sqlite's cache_size. Thanks again, everyone, for your help! Eric -- Eric A. Smith You made the fatal mistake of assuming that your friends are genuine. ___ sqlite-use

Re: [sqlite] linear behavior on INSERT (was Re: unexpected large journal file)

random shots in the > dark. I'll start doing that and reply here with an obfuscated schema. In the mean time, where can I find version 3.6.18 (whom someone claimed definitely does constant-time insertions)? -- Eric A. Smith You will never amount to much. -- Munich Schoolmaster, to Albert E

Re: [sqlite] linear behavior on INSERT (was Re: unexpected large journal file)

ear, and it improves with indices. This suggests a software algo issue. (Just got your corrections, I knew what you meant.:-) Eric -- Eric A. Smith This non-pronunciation of initial _h_ is especially common among French and British people, who can't pronounce En

Re: [sqlite] linear behavior on INSERT (was Re: unexpected large journal file)

rously are you waving? Can you describe the real algorithm, or at least a second-order approximation? Eric -- Eric A. Smith What the hell is it good for? -- Robert Lloyd (engineer of the Advanced Computing Systems Division of IBM), to colleagues who insisted that the microproce

[sqlite] where to get historical versions?

In another thread in this forum, someone says they noticed a behavior in sqlite version 3.6.18 different (better) than what I've observed in 3.6.23.1. Where can I find version 3.6.18 (or, more generally, any old version) for testing? Eric -- Eric A. Smith It's up. It sorta works

Re: [sqlite] linear behavior on INSERT (was Re: unexpected large journal file)

djustments, I want to understand why I'm linear with no indices! I'm pretty sure I'm not doing anything stupid, like setting evil compile-time options or whatever. But then again most stupid people don't think their results come from being stupid. Eric -- Eric A. Smith Aeropalmics (a

[sqlite] linear behavior on INSERT (was Re: unexpected large journal file)

defined). Can anyone explain this? Eric > time (minutes) to insert 2m records > 10 ++--+--+---+--+---+-++ >+ + + + A + + +

Re: [sqlite] unexpected large journal file

really explaining your ultimate goal... I tried to state the question as generally as possible while capturing the relevant specifics of my problem, so that gurus' answers will be useful to more people (including future Eric who is writing another application). I'll try starting off with

Re: [sqlite] unexpected large journal file

Eric Smith wrote: > I'd like to show it to the forum -- is it possible to send emails with > attachments here? It's a 60kb jpg file. God bless the gnuplot developers, who provided an ascii output option: time (minutes) to insert 2m records

Re: [sqlite] unexpected large journal file

nitial approach. You guys were incredibly helpful -- thanks very much! Eric -- Eric A. Smith Carperpetuation (kar' pur pet u a shun), n.: The act, when vacuuming, of running over a string at least a dozen times, reaching over and picking it up, examining it, then putting it ba

Re: [sqlite] unexpected large journal file

disk-bound again. At the moment I'm only inserting about 4k rows/second. :/ Eric -- Eric A. Smith I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. -- Bjarne Stroustrup

Re: [sqlite] unexpected large journal file

m > another ? Right, the one connection is shared. Eric -- Eric A. Smith Substitute "damn" every time you're inclined to write "very"; your editor will delete it and the writing will be just as it should be. -- Mark Twain __

Re: [sqlite] unexpected large journal file

e saved every once in a while so I don't have to re-build the db from scratch when my app comes back to life. -- Eric A. Smith Don Daniels: How stable are tense systems in languages? Tim Pulju: I'd say about a 42 on a scale from 1 to 212. -- Winter 2005 __

Re: [sqlite] unexpected large journal file

ive the INSERTs; Tcl API calls drive BEGIN/COMMIT. That all works fine, so don't worry about it. Thanks again! Eric -- Eric A. Smith Absurdity, n.: A statement or belief manifestly inconsistent with one's own opinion. -- Ambrose Bierce, "The Devil's Di

[sqlite] unexpected large journal file

and there are no indices, why does SQLite need to update existing pages in the DB? (Is it updating an auto-index based on the primary key?) Is there a way to avoid it? Thanks! Eric PS I'm using 3.6.23.1 with defaults, except PRAGMA synchronous=OFF and foreign_keys=1 (my only foreign key

Re: [sqlite] create index before or after many inserts?

Simon Slavin wrote: > The standard assumption about SQLite is that it's faster to do your > INSERTs first, then create the indices. How much of a difference this > makes depends on a lot of things. On what things does it depend? -- Eric A. Smith Sendmail may be safely run se

[sqlite] create index before or after many inserts?

Let's say my app has (only) inserts followed by (only) reads. The reads are best served by some indices. So I can create the indices before the INSERTs, or after them. In general, should I expect a run time perf difference between these two options? Eric -- Eric A. Smith Louis

[sqlite] last_insert_rowid & INTEGER PRIMARY KEY columns

ng the new row's key? -- Eric A. Smith Money is the root of all wealth. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite file Validation

t; and replaces it with a ,? And if so, any suggested code? "I have this programmer who keeps writing stupid code despite explicit guidance. I want an algorithm that converts his bad inputs into good inputs." Make sure to let us know if you come up with a general solution. Eric

Re: [sqlite] SQLite Database in Shared Memory

d.so.0 => /lib/libpthread.so.0 (0x00d26000) libc.so.6 => /lib/libc.so.6 (0x00ba9000) /lib/ld-linux.so.2 (0x00b87000) Caveat (2). I don't claim this is the best solution for the OP -- just a possibility. Eric -- Eric A. Smith I think there's a world market for about f

Re: [sqlite] Passing Value from one query to another

BareFeet wrote: > In general, I think it's much better (performance and logic) to do > all you can in SQL, without passing values out of SQL results, into > your non-SQL code, then re-injecting back into another SQL query etc. With SQLite, that's not really going to make a difference. Since it's

[sqlite] FTS3 performance rowid vs docid

index isn't in cache, and the memory usage is much higher too. I guess in one case the value is obtained directly from the index, while in the other one it's read from the fts_content table, is this correct? Thanks! Eric ___ sqlite-users mailing list sql

[sqlite] unable to backup using command line

not do the .backup command from the command-line. C:\InWork\rsm\weekly_status>sqlite3 accounts.db .backup main a.db unknown command or invalid arguments: "backup". Enter ".help" for help Any ideas why? Eric

Re: [sqlite] Building sqlite

o build manually, as you have done. (Another option might be to use one of the myriad of Dll -> Static lib converters available, though this seems like more work than it's worth.) ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqli

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

ragma_cache_size The default is around 2MB. You can decrease to as little as 10KB. Note that there are some other buffers used by SQLite (Scratch, Lookaside, etc). However, these are typically small compared to the page cache. Additional info here: http://www.sqlite.org/ma

Re: [sqlite] Near misses

Simon Slavin wrote: > On 26 Jun 2009, at 12:25pm, Alberto Simões wrote: > >> one adition, one remotion or one substitution > > I am always amazed at how well people use English. For your word > 'remotion' you probably mean 'removal' or 'omission'. You have joined > the two possibilities

Re: [sqlite] DBD::SQLite reporting corruption sqlite3 CL program does not

Craig Talbert wrote: >>From Perl, when I attempt to make a database connection using SQLite, > I get the following error: > > [Tue Jun 23 17:10:22 2009] projectory.cgi: > DBI->connect(dbname=projectory.sqlite3) failed: database disk image is > malformed at ./projectory.cgi line 1577 > > At line

Re: [sqlite] CURRENT_TIMESTAMP precision

Please ignore my previous post. Doug's suggestion is much better. ~Eric Eric Minbiole 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 featu

Re: [sqlite] CURRENT_TIMESTAMP precision

microsoft.com/en-us/library/ms724397(VS.85).aspx ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [newbie] How to upgrade sqlite3 in Ubuntu?

Derrell Lipman wrote: > The amalgamation probably installed into some directory not in your path. > You should look at where it installed (re-run ../configure and look at its > output, which should tell you where it will install to. For Ubuntu, you > almost certainly want it to install into

[sqlite] Max Value In Group By Scenario

| 15 When I'm done I want only 1 row for MfgProductID 1, where ProductID is 1 (since the combined total of rows with ProductID 1 is 20 for weight, which is greater than the single row of ProductID 2 at weight 15). Sorry for a rambling explanation for what I'm sure is a simple solution. Eric

Re: [sqlite] record order in select

d_selects" pragma may be of interest: http://sqlite.org/pragma.html#pragma_reverse_unordered_selects ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slim down join results (all fields returned)

> Currently, I return any needed data like this. > > select * from pubs,notes,publishers where pub_title like '%salem%' > and pubs.note_id=notes.note_id > and pubs.publisher_id=publishers.publisher_id > > And it works except for all fields in the matching tables being returned. > > Is

Re: [sqlite] Attach the data return an error message

you can ensure they are called at the appropriate times. ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] UTF-16 API a second class citizen?

ust? > > Thanks! I would assume the intent is that you convert your UTF-16 filename to UTF-8, and then call sqlite3_open_v2(). I don't know what platform you are running on, but you may have some conversion APIs available to you. If not, unicode.org provides some nice sample code that

Re: [sqlite] Is it using an index?

s available. You can use above to verify this. ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "-journal" file?

lite.org/tempfiles.html http://www.sqlite.org/atomiccommit.html ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Source code position out of sync debugging in VS 2008

ger can only handle 2^16 lines in a single source file. (The compiler has a more reasonable limit of 2^24 lines.) Some additional information in this thread: http://social.microsoft.com/Forums/en-US/vsdebug/thread/7d991493-06f7-45f6-8f34-165b988e266c ~Eric __

[sqlite] tool to browse a sqlite database

I'm loking for some gui tools for looking at and changing my sqlite database, the only ones I know of are the firefox extension and sqlitemanager. the firefox extension fails with: Error in opening file messages.sqlite - perhaps this is not an sqlite db file Exception Name: NS_ERROR_FAILURE

[sqlite] Case Insensitive Sorting With FTS Columns

using MATCHES, but I found a comment showing how to do it by prefixing the join on FTS field condition with a + sign. Thanks, Eric -- Be Yourself @ mail.com! Choose From 200+ Email Addresses Get a Free Account at www.mail.com ___ sqlite-users mailing

Re: [sqlite] need partial index

ger than the index update. In other words, if you are okay with the (slowish) performance of single insert per transaction, then I doubt you would notice the additional time to update an index. Of course, you should test this hypothesis. ~Eric * Assuming you haven't turned off synchronous write mo

Re: [sqlite] Saving and loading SQLite pages from a buffer

> knowing exactly which pages changed, so it has to start over again > from the beginning. That makes sense, thank you. (I wasn't sure if the individual pages had a "Change Counter", similar to the one in the File Header, that could be used.) ~Eric __

Re: [sqlite] Saving and loading SQLite pages from a buffer

tes: "If the source database is modified [...] then the backup will be transparently restarted by the next call to sqlite3_backup_step()" Does this mean that the backup is restarted *to the beginning*, or is it able to re-copy only those pages which have just been modified? T

Re: [sqlite] segmentation violation in fulltest on Mac OS X

ing a "one size fits all" approach for everyone, without knowing the details of a particular application, just seems an oversimplification to me. Sorry for my rant :) ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compressed dump SQLite3 database

enough, than I would reconsider the external compression tool. zlib, for example, is a relatively lightweight, open source compression library that may do well on your database. Hope this helps, Eric ___ sqlite-users mailing list sqlite-users@

Re: [sqlite] Adding data with periods

Mohd Radzi Ibrahim wrote: > It seems to works either way. > > I'm just wondering is there any hidden reason that single quote is > preferred? Portability? > Or is double-qoute has some kind of special meaning that we should use it > for that special purpose? If what's enclosed in the double

[sqlite] multiple tables within a database

what's the general rule for deciding when to put multiple tables within a single sqlite db file? I think the answer is something like you put tables together in one database file if they refer to different aspects of the same data element and you put them in separate database files if there's no

Re: [sqlite] Journal files

> I am looking for a way to completely turn off the creation > of journal files. Any help is much appreciated. http://www.sqlite.org/pragma.html ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how to copy a big table in limited memory

oc.html . Hope this helps, Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite 3.6.5 slow on windows

iler optimizations (above) will likely help somewhat, though not terribly much. - A faster (higher RPM) hard drive will help somewhat. ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Escaped values throws error

k that using bound parameters would eliminate your string escaping issues. I use bound parameters almost exclusively: You never have to worry about escaping or sanitizing your strings-- just let the Db engine do the work for you. A related classic: http://xkcd.com

Re: [sqlite] Escaped values throws error

nts and bound parameters? That way, you never have to worry about character escaping, or SQL injection problems. ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_bind_text problem

nvironment, I would take a very close look at your code. As Igor suggests, you may wish to post a short code sample that highlights the problem. ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_bind_text problem

nated C-string. It's possible that the char* variable is going out of scope before SQLite3 has a chance to commit the string data. Try passing SQLITE_TRANSIENT to sqlite3_bind_text(), rather than STATIC. This will cause SQLite to create a private copy of th

Re: [sqlite] Floating point numbers

> Does anyone knows why floating point numbers are truncated when they are > written or read from the database?! SQLite stores real numbers as 8 byte IEEE floats, which can hold approximately 16 significant digits. See: http://www.sqlite.org/datatype3.html You could get slightly more

Re: [sqlite] macro redefinition

> I tried the first option and i am getting the following error : > -- Build started: Project: Source Tagging System, Configuration: Debug > Win32 -- > > Compiling... > sqlite3.c > c:\Documents and Settings\Administrator\My Documents\Visual Studio > Projects\Source Tagging

Re: [sqlite] macro redefinition

de "stdafx.h", or disable precompiled headers for sqlite project file(s). The latter setting can be found in the "precompiled headers" section of the project properties. Do a search on "C1010" for more info. ~Eric ___

Re: [sqlite] SQLite 3.6.1 memory leak?

Ulric Auger wrote: > Hi, > > Since I updated to SQLite 3.6.1 I have a memory leak when my application > exits. > > If I compile using SQLite 3.5.8 I don't have the memory leak. Be sure to call sqlite3_shutdown() just before the application exits-- this should free any outstanding resources

Re: [sqlite] GCC -ffast-math safe version of sqlite3IsNaN

build-script change for a quick source code change. ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite DB backups on Windows

code to move the PENDING_BYTE location, as you propose above. Plus, it avoids the compatibility issues mentioned by DRH. ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Datetime issue with the time part

t appears you can override this default behavior when creating a 3D device. See "FpuPreserve" flag: http://msdn.microsoft.com/en-us/library/bb153282(VS.85).aspx Hope this helps, Eric ___ sqlite-users mailing list sqlite-users@sqlite.org htt

Re: [sqlite] Datetime issue with the time part

dll. Perhaps start by adding some traces to SQLite function "winCurrentTime()"? Good luck, Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] printf-8.2 test failure on Solaris on SPARC 64-bit

> printf-8.2... > Expected: [2147483647 2147483648 4294967295] > Got: [2147483647 18446744071562067968 18446744073709551615] > > The code looks like: > > > ... > do_test printf-8.2 { > sqlite3_mprintf_int {%lu %lu %lu} 0x7fff 0x8000 0x > } {2147483647 2147483648

Re: [sqlite] Segmentation Fault when using mod_python / mod_wsgi

sqlite3 module in Python 2.5 and replace it with a module that does a from pysqlite2.dbapi2 import * See the following trouble ticket for more info: * http://oss.itsystementwicklung.de/trac/pysqlite/ticket/146 I hope this helps somebody out there. Regards, Eric

Re: [sqlite] Segmentation Fault when using mod_python / mod_wsgi

> Eric Holmberg wrote: > > PyDict_GetItem (op=0x0, key=0xb7ce82cc) at Objects/dictobject.c:571 > > 571 if (!PyDict_Check(op)) > > You would need to supply more of the backtrace since the > calling routine is supplying a null pointer instead of a >

Re: [sqlite] Source code for 3.4.2

://www.sqlite.org/cvstrac/timeline?d=30=2007-Aug-14=2=sqlite; s=0=1=1). Let me know if I'm off base here. Actual command used: > cvs update -D '2007-08-13 18:00:00 UTC' Thanks, Eric Holmberg Applications Engineer, Arrow Electronics From: Eric Holmb

[sqlite] Segmentation Fault when using mod_python / mod_wsgi

if (!PyDict_Check(op)) (gdb) Thanks, Eric Holmberg Applications Engineer, Arrow Electronics Engineering Solutions Center Denver, Colorado ESC: 877-ESC-8950, [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Direct: 303-824-4537, [EMAIL PROTECTED] _

[sqlite] Source code for 3.4.2

Sorry ahead of time for a silly question, but how do I get version 3.4.2 of the source code? I didn't see any tags in CVS (but I'm not a CVS user, so that may be user error on my part). Any help with the exact command would be appreciated. Thanks, Eric Holmberg Applications Engineer, Arrow

Re: [sqlite] prepare peformances

L statement(s) into a single pre-allocated buffer, possibly avoiding slow-ish dynamic allocations. If the mem allocation time were > than statement compilation time, the "prepare" approach would appear slower. As I said, just a possibility... ~Eric

Re: [sqlite] CANTOPEN error on Windows systems running TortoiseSVN

deleted. It looks like you can configure TortoiseSVN to include / exclude specific paths during its searches. Though I've not tried it, I would think you could simply exclude any paths that contain SQLite databases. This thread had some good info: http://www.nabble.com/Disable-TSVNCache.exe

Re: [sqlite] How to speed up my queries?

similar approach would be helpful. Thanks for a good tip-- I'm sure it will come in handy at some point. ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bind arguments for insert and not null columns with default values

> I have a table like this > > CREATE TABLE foo (bar TEXT NOT NULL DEFAULT 'default_value'); > > and I'd like to create a reusable statement to do inserts into foo, like this: > > INSERT INTO foo (bar) VALUES (?); > > Sometimes I have values for bar and sometimes I don't and want the >

Re: [sqlite] 3.5.8 alot slower than 3.5.7

se. Take a look at this thread for details: http://www.mail-archive.com/sqlite-users%40sqlite.org/msg33267.html ~Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Populating and scrolling the Listbox using query

That seems like it would cut down on some of your query times. When you say it's running slow, how slow are you talking about? Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: [sqlite] OUTER JOIN and PRIMARY KEY in 3.5.8

> Your work-around until I fix this is to say > > owners.owner_id = pets.owner_id > > instead if what you have. In other words, put the > table on the left side of the join before the equals > sign instead of after it. Good idea: Swapping the terms of the JOIN expression does seem to

[sqlite] OUTER JOIN and PRIMARY KEY in 3.5.8

jumped from a couple milliseconds to a few seconds. In the meantime, I can continue using the earlier version(s). However, I wanted to let others take a look, to see if the issue was with my query (quite possible), or with the new version. Thank you, Eric

[sqlite] Virtual Tables performance

rely having a range constraint would already be enough to drastically improve the row count of xFilter (ie. "field in (40, 50, 70)" being presented as a "field>=40 and field<=70" constraint) Thanks, Eric ___ sqlite-users mailing

[sqlite] Sqlite3_exec_stmt

I love sqlite3_exec, but I also like prepared statements. Here's a function I wrote to make it easier to execute prepared statement. I have only tested with SELECT and INSERT. Hope someone finds it useful. -Eric #include "sqliteInt.h" #include "os.h" #include /*

Re: [sqlite] Having issues Loading an external

I cant find the type decleration for sqlite3_api_routines type. I greped the sqlite source directory and couldnt find a definition of it. Do you think this is the reason why I am getting a syntax error? On 9/25/07, eric higashino <[EMAIL PROTECTED]> wrote: > > I have tried th

Re: [sqlite] Having issues Loading an external

strac/wiki?p=LoadableExtensions > > You could add such a function that calls > > sqlite3RegisterExtraFunctions(sqlite3*). > > --- eric higashino <[EMAIL PROTECTED]> wrote: > > I am running sqlite 3.4.2 and I am trying to get the > extension_functions.c > > extenstion to work. I have

<    1   2   3   4   5   6   >