[sqlite] doc puzzle, on-conflict clause in insert

, I thought it was a plain doc bug, until I went to a separate page to relearn how the 'OR' syntax variant works.) The other is that the railroad diagram structure does not clearly indicate the optionality except by recognizing the duplication of the 'INSERT' keyword. (I'll admit to stupidity for not

Re: [sqlite] SQLite version 3.8.4 release schedule

Jan Nijtmans wrote, in part, re Cygwin : *> *bare filenames are NOT expected to be found in the current directory This makes Cygwin unique among all operating systems with which I am familiar having support for hierarchical filesystems. Most importantly, if true, it would differ from Unixen. I

Re: [sqlite] extension search [was ... release schedule]

*Jan Nijtmans wrote:* > But not in dlopen(): > See: > > Quoting: > If filename contains a slash ("/"), then it > is interpreted as a (relative or absolute) pathname. Otherwise, the > dynamic linker searches for the library as

Re: [sqlite] Noticed crash on windows

durga.disc wrote: > We have an application on unix platform with sqlite database which > is running from last 2 years. pretty well. > > We recently ported on Windows too. Crashed at inserting record in a > small database(less than 20 records, record has 10 columns). It's not > reproducible. > >

Re: [sqlite] Is there a way to load a blob from the shell?

. (zeroblob(filesize)) -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there a way to load a blob from the shell?

's C API which allows very large BLOBs to be transferred without creating large, in-memory objects. So my shell enhancement exploits the streaming API, using only a few pages of memory. I sort of like your approach, and maybe there is a way to get the best of your's and mine. Any

Re: [sqlite] Is there a way to load a blob from the shell?

About my shell extension implementing ".blobextract" and ".blobreplace" commands, Richard Hipp writes: "apparently uses the incremental BLOB I/O interface to avoid the need to load entire images into memory." and "That is nice, but on a modern workstation with many GB of RAM, is it really

[sqlite] pls dont send so many message - once a month is enough

had an underlined, "mailto:; link. For systems/accounts which are setup to handle that "protocol", clicking the link in most modern browsers will invoke the setup email client, with the correct addressee to reach the list. (I have used that mailto: link for this message, in

Re: [sqlite] pls dont send so many message - once a month is enough

Ketil Froyn writes: > Clicking the mailto works, but it's not a proper reply-to. These two > messages have appeared as a separate thread in my mailbox, probably because > Larry's message didn't add the proper message-id reference. So if you reply > like this on a high volume list, people

Re: [sqlite] light weight write barriers

me differently educated on this subject. (perhaps via some evidence ;-) Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .dump ... [was: Please test the latest SQLite snapshot]

t the tables I wish to recreate later. Is multiple table dumping suspected to not work for some reason? If so, the .help output should lose the '...'. If not, perhaps the shell.c source should lose that "&& nArg<3" clause. Thanks, -- Larry Brasfield

Re: [sqlite] Bug: Segmentation fault in libsqlite3.so.0.8.6[b69a4000+ac000]

n scenario, and that should encourage you to start using a debug heap or sophisticated tools such as Purify to discover where your code has a stray memory write occurring. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqli

[sqlite] Denormalized view, "clumping" into length-limited groups

be as hard as I have found it to be. Thanks for any tips, (even "Give up.") -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Denormalized view, "clumping" into length-limited groups

is their numerical part so predictable, but those issues can be met in the source table design.) Thanks, too, for helping me see that I should look at 'group by' clauses more fundamentally. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite

[sqlite] multiple outstanding sqlite3_stmt objects

2. Destroy sqlite3_stmt #1 Is there any reason not to do this? (I would not be asking if I could see any hint in the API docs that sqlite3_stmt objects can be used independently, in arbitrary order, during their lifetimes.) Thanks, -- Larry Brasfield

Re: [sqlite] How to manage Table inside Table scenarios

ructure has ordering in addition to defining sets. If you wish to retain the order of the Notice object in the database, there will need to be a column in the Notices table giving its sequence number within the set which can be used to recreate the ordering in a query. Regards

Re: [sqlite] how to move around records in sqlite as the way as in CDaoRecordset of MFC??

-topic), but I doubt any sane developer could regret making that transition. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Suggested Improvement of Date Time Function

(Mr. Team) have apparently already created this much more accurate set of conversions, perhaps you could offer them as a plug-in replacement for the readily omitted functions. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlit

[sqlite] parameters in a view, disallowed?

With recent versions of SQLite, a prepare call fails when there are parameters in the SQL for a 'create view' statement. I stumbled into this for two reasons: The documentation for parameters and ..._prepare does not contra-indicate such usage; it seemed perfectly sensible; and it was useful

Re: [sqlite] parameters in a view, disallowed?

Igor Tandetnik wrote: On 12/20/2012 1:27 PM, Larry Brasfield wrote: > With recent versions of SQLite, a prepare call fails when there are > parameters in the SQL for a 'create view' statement. Did it ever work with any version of SQLite? Parameters in DDL statements don't make sense.

Re: [sqlite] parameters in a view, disallowed? (docs issue)

where it logically should appear (as a semantic exception to the syntax), I went ahead and tried to use them in a view. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] parameters in a view, disallowed? (docs issue)

On 12/20/2012 4:10 PM, Larry Brasfield wrote: > Igor Tandetnik wrote: >>>> [regarding where parameters allowed, "where literals are"] >> > >> > How did you discern this? >> >> I know from experience where parameters work (SELECT, INSERT an

Re: [sqlite] sqlite3.c:134542: warning: assignment from incompatible pointer type

, apparently.) 2. What patch? (Attachments are lost when posting here.) 3. What has this got to do with the referenced post "Sqllite3 dll crash on ..."? -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.or

Re: [sqlite] parameters in a view, disallowed? (docs issue)

how that, just as parameters may appear in select expressions, they may appear in a "create view xxx as select ...", and there is no *documentation* to the contrary. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-user

Re: [sqlite] strange behavior with integer with where clause

teger|1|0|0 5|repeat|integer|1|1|0 6|valid|integer|1|0|0 7|sound|integer|1|0|0 What do you get with query select * from repetition where cast(interval as integer)==0 and interval>0 ? -- Larry Brasfield ___ sqlite-users mailing list sqlite-users

Re: [sqlite] strange behavior with integer with where clause

y that only you have encountered and brought here. My money is on #1. You might to a table dump using the SQLite shell to see which case it is. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] strange behavior with integer with where clause

where/why blobs are being inserted, and get the inserted types to be closer to what is supposed to be represented. (number, string, etc.) The BLOB is really for raw data that is not to be further interpreted as anything else. Cheers, -- Larry Brasfield

[sqlite] PRAGMA foreign_keys = ?, feature request

w to solve this more easily than suggested above, I would appreciate your input. Thanks, -- Larry Brasfield * * ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA foreign_keys = ?, feature request

Larry Brasfield wrote: ... The framework opens and closes the database, presumably like it treats other DB connections. The schema that it sets up for objects related to each other relies on foreign keys. Unfortunately, foreign key enforcement in SQLite, as now specified and implemented, only

Re: [sqlite] PRAGMA foreign_keys = ?, feature request

loss even if I knew there was such an option. That event is a nice feature, and I look forward to seeing 1.0.83.0 . I really appreciate the fine work that has been done on System.Data.SQLite. Best regards, -- Larry Brasfield ___ sqlite-users mailin

[sqlite] System.Data.SQLite ".CHM" [was: PRAGMA foreign_keys ...]

just have a link, labelled "Documentation", leading to a page that says something like: Online help is a work-in-progress, but the distribution has a comprehensive Windows help file that is placed in the installation directory. -- Larry Brasfield __

Re: [sqlite] insert return -1

, you will need to show more. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Multiple network connections

on. What Jay and others warn about is that SQLite is not designed for concurrent DB operations. Also, have its file store be accessed over a network from SQLite code running remotely is a formula for database corruption. But it looks like you are not doing that. Thank you You're welcome

Re: [sqlite] Multiple network connections

. You would do well to avoid deploying such a solution. You might be interested in this "Code Project" article, and perhaps its code: http://www.codeproject.com/Articles/22416/A-SQLite-Server-Client-Implementation Thank you, You'

Re: [sqlite] useful Perl modules for working with SQLite databases?

here. That said, and without pretending it answers the question, I can say that I have found these modules handy for DB work in Perl, much of it using SQLite: use DateTime; use DBI; use DateTime::Format::DBI; use DateTime::Format::ISO8601; Cheers, -- Larry Brasf

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

. Could you please try the latest trunk code and let us know if that clears the issue you are seeing? I do not see such a change anywhere in recent check-ins listed at http://www.sqlite.org/src/timeline?r=trunk . Is there a build somewhere? I would be happy to try it. Cheers, -- Larry

Re: [sqlite] SQLite3 Bug Report: The shell accepts some dot commands ending in semicolons while rejecting others.

is as one who has found reason to modify that code and who is glad that part of the task consumed little time. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite3 Bug Report: The shell accepts some dot commands ending in semicolons while rejecting others.

sy to type, the present behavior is entirely unobjectionable. As for whether an appended ';' (or any other junk not called for in the .help output) ought to produce a diagnostic instead of simply following the above logic, I would say that adherence to the GIGO principle is perfectly adequa

Re: [sqlite] Sqlite .NET 4.0 provider available?

answer, just because you post redundantly. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How do I write a query

' entries other than the primary key. I see no is_a versus has_a confusion here. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Newbie unable to get started with sqlite on Visual Studio 2012

documented, allowing me to take code which works with the SQL Server Compact Edition and use it nearly unchanged with SQLite. The developers anticipate and well support such scenarios. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Timeline for full ALTER TABLE support?

To suggest that any deceit was intended or that the statement was known to be false when made is unsupported by the evidence and indicates either ignorance of what the word "lie" means or bad faith. -- Larry Brasfield ___ sqlite-users mailin

Re: [sqlite] Order of columns in group by statement affects query performance

*Daniel Winter wrote:0* > I discovered that the order of columns in a group by affects the > performance of a query. Is this expected? Yes. > For example: > > Table: Column A int, Column B int, Column C int > One Index: A,B (combined) > > Query 1: SELECT A,B,count(*) from tableTest group by

Re: [sqlite] numeric string quotation

literal in your insert statement. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Import skip first line

thing, which I take to be interpreting them as column names. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Import skip first line

the current release (v3.7.17) changes. The file doall.btm is understood by JPSoft's TCC and the free light version, TCC/LE. The makefile may not be current. The modified shell is shell_3r7r17_mod.c . Best regards, -- Larry Brasfield ___ sqlite-users

Re: [sqlite] How to interrupt a long running update without roll back?

made durable by the update. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to use sqlite in excel vba?

such issues.) Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to use sqlite in excel vba?

ly to build with more modern tools than VisualC++ 6.0. That would not be an issue for the OP. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to use sqlite in excel vba?

of its documentation, 'litex.pdf', is at https://www.assembla.com/spaces/litex/documents/c-5hiSb6ar3y3sab7jnrAJ/download/c-5hiSb6ar3y3sab7jnrAJ . -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] sqlite3DbMallocRaw is crashing

l recognize and help cure your bug is unrealistic. You have some work to do, and use of valgrind or a similar tool is the best advice you are likely to get that will help you do that work. Best regards, -- Larry Brasfield ___ sqlite-users maili

Re: [sqlite] SQLite, .Net and Datareader: Close method is too slow.

with the 'using' construct. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL files and PERL question

whether that is so is a worthwhile experiment, and if it is so, will allow you to focus on your schema and query rather than details of SQLite implementation that should be opaque to you as a user. Best regards, -- Larry Brasfield ___ sqlite-users

[sqlite] result set column names, when row count = 0

in place now because I never want to not see a header after entering .headers ON . Even if nobody is much interested now, I'll be happy to provide this to anybody who stumbles across this post in the archives during a similar (but not so fruitless) search. Just decode my email address and use it

[sqlite] insert image into db - windows batch

one who is interested in this can decode my email address below and ask me for source or the sqlite3m.exe executable. Cheers, -- Larry Brasfield firstinitial.lastn...@something.org where my computer became something. ___ sqlite-users mailing list sqlite-user

[sqlite] Windows Thread-safe

ort, rollback, or commit transactions. Your malformed command never reaches the execution engine. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] 3.7.10 build failure on OS X 10.4: ld: Undefined symbols: _OSAtomicCompareAndSwapPtrBarrier

older OSCompareAndSwapPtr, but missing OSAtomicCompareAndSwapPtrBarrier, that would be a strong clue that the missing entry point is truly missing among the set of libraries you had hoped to use.) Good luck, -- Larry Brasfield ___ sqlite-users mai

Re: [sqlite] 3.7.10 build failure on OS X 10.4: ld: Undefined symbols:_OSAtomicCompareAndSwapPtrBarrier

use the non-barrier pointer swap, always. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] replying to thread

but many other can do this. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite DBaaS

ou sometimes feel foolish when those who know more expose your naivety. Regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I'm sure I'm missing something.

or "C string functions" and "C string parsing" to see how such things are commonly done. Good luck. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3 question

programs are silly enough to insist on seeing '\' rather than the '/' the rest of the world has settled upon. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA journal_mode=WAL;

u pass to the statement preparation API as if it was SQL. It is not C. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA journal_mode=WAL;

se to which you can revert. Since the database is a file, you can keep a copy of it, as another file. Or you could put your update in a transaction. However, for a single-record update, there is no point. SQLite is pretty robust once you've set journal_mode=WAL. Best regards, --

Re: [sqlite] PRAGMA journal_mode=WAL;

opportunity, but I think I speak for more than just myself by revealing that I have other work, and a life, and consider time a scarce resource. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Error 21 on Open (C#)

of that database, somehow.) I think you need to reduce your program to something more than you've shown, that gets the DB file to some state that is different the 2nd time through. I see nothing wrong with the code you did show. (Well, swallowing exceptions so mutely is a b

Re: [sqlite] Segmentation fault on sqlite3_create_module

ot; {" wrappers around its declarations, guarded by "#ifdef __cplusplus", so this is not an issue. It is perfectly reasonable to call into the SQLite code from C++. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Segmentation fault on sqlite3_create_module

e c-library that the function pointer is compiled within a c++ frame. Yes, that's a good point. (To the O.P.:) It would be a good idea to wrap the same 'extern "C" { }' around forward declarations for your functions that are going into that v-table (as pointers), and be sure that the

Re: [sqlite] Segmentation fault on sqlite3_create_module

terpret_cast when that is going to produce problems. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3 windows command line: writing the sql errors to a file (and not to the screen)

Gert, Why do you post the exact same question on Feb 14 and Feb 16, 46 hours apart? You got several worthy answers before. Were they somehow inadequate? -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] undefined reference to `sqlite3_db_release_memory'

it to see what is making the unsatisfied reference and to see where it might be satisfied. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Lifetime of an sqlite_value object

s returned are valid until a type conversion occurs as described above, or until sqlite3_step() or sqlite3_reset() or sqlite3_finalize() is called. Your assumption is therefor not safe. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] Reference error

is most diagnostic here. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there way to modify table structure after initial definition ?

. Is there any instrument to meet my need directly. Best Regards -- tom You need to study the ALTER TABLE statement and its limitations. See http://www.sqlite.org/lang_altertable.html . Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users

Re: [sqlite] import a txt into sqlite

d. It can be found at: https://docs.google.com/viewer?a=v=explorer=true=0BzRwojdN0G2UMWY2MTg2NzgtNDU3YS00Y2RiLWI5MTktMDZiMDYxZGU5MGEx=en_US=1 (Watch line wrap -- that's a one line URL.) Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] DISTINCT bug with 3.7.10

wn resolution, you might try eliminating optimizations. I would want to review docs for the preprocessor settings if this was my problem. Good luck, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DISTINCT bug with 3.7.10

On 3 Mar 2012, at 12:29am, Larry Brasfield wrote: > That's approaching a pretty good "bug" report. However, I would suggest a little more to promote a resolution of this problem. You do not state the compilation options. Optimization settings and preprocessor variable settings

Re: [sqlite] DISTINCT bug with 3.7.10

s may very well be relevant here, and that providing them up front will help resolve this if that is the case. To Simon: I do not claim here that these settings *are* the problem, just that if they are, they will need to be made evident to enable progress to be made toward

Re: [sqlite] Elegant printout of table (with header) via TCL (solved)

ot;right" header output when the result set is empty than when there is at least one row (that would have sufficed to trigger header emission with the original code). Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

ointer aliasing might be counted as a compiler bug, it is generally better for code to not create the opportunity. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On March 5, Richard Hipp wrote: On Mon, Mar 5, 2012 at 1:39 PM, Larry Brasfield wrote: > On March 5, Richard Hipp wrote: > > On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP >> wrote: >> >> > The crash is a result of -O3 flag used during compiling the libr

Re: [sqlite] import a txt into sqlite

;55;55;111;55;55;514 when I import the txt to my sqlite table, could I import the the first row contains columnnames, not data. like odbc "HDR=Yes" You posted this 8 days ago, and got a useful reply then. Do you expect more? -- Larry Brasfield ___ sq

Re: [sqlite] import a text to sqlite

ll is one written by people who understand the programmer's task, unlike cmd.exe which is one of the sorriest excuses for a shell ever allowed to live so long. Good luck, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VIsual Studio 2005. slow and high CPU in debug

n of the C runtime will be slower, and assertions are in much of its code. Thank you very much in advance. You're welcome -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select null values in python

th appreciation for Igor's contributions, especially that he often *does* answer the question not asked when that is more germane than simply answering the OP's question. I often find his replies instructive. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Could/should Windows build of SQLite use #define WIN32_LEAN_AND_MEAN?

n.) If I was more cantankerous, I would be tempted to say there is no real reason to complicate a build script for this 110mS time saving. Of course, if you are building on some ancient machine, you might save more time. Cheers, -- Larry Brasfield

Re: [sqlite] Could/should Windows build of SQLite use #define

would help head off such issues to #include no more than is necessary, and a "#define WINDOWS_LEAN_AND_MEAN" would get partway there. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mai

Re: [sqlite] Could/should Windows build of SQLite use #define

On March 24, Roger Binns wrote: [I am the author of APSW] Thanks for that, BTW. On 24/03/12 14:22, Larry Brasfield wrote: > Except for its clever hiding of SQLite's C API names (via "#define > SQLITE_API static"), There is nothing "clever" about it - SQLite e

Re: [sqlite] question about zipvfs & performance

Good luck. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Handle multiple results using sqlite3_step

e then the other? At this point, I doubt anybody can help without better information as to what the objective is. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to export to html file with table

p on HTML, or do some study of HTML instances that have tables in them, and figure out how to put a sqlite shell generated table into one which otherwise says what you want. (For example, tables usually have a title, or something explaining what they are.) --

Re: [sqlite] Using SQL or C for data analysis?

. The aggregate functions might produce some output other than what is returned to SQLite. What I think will be unreasonable or unduly limiting is making it happen in bare SQLite. You will need more. Thanks, Simon Have fun! -- Larry Brasfield

Re: [sqlite] In-memory and temporary database

data in a table very quickly." might mean only "I need the thread which accepts the data for storage to be quickly available for other work.") Regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:

Re: [sqlite] Update problem with Sqlite (one PC one single operation) Vb.net

l, so I cannot judge what "this query work" means. How I can solve this problem ? Too little information to guess. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite and pooling problem

or a bug? I can try to come up with a test case that reproduces this if needed. It's not really intended behavior but intent cannot cure this problem unless SQLite's finalizing API is used. Thanks Greg. ... Best regards, -- Larry Brasfield ___ sqlit

[sqlite] Replying to posts here, threaded [was: SQLITE3 64-bit version]

in. The latter is what allows the replies to be usefully arranged in the threaded view. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite and pooling problem

On 27 April, Greg Carter wrote: On 27 April 2012 11:39, Larry Brasfield wrote: [snip] > You "works as it should" is only assured (inasmuch as any > software can) when you use the .Net framework's assured disposition > mechanism ("using ..." and properly im

Re: [sqlite] store db from sqlite to online mysql or online sqlite

.quit echo .dump | sqlite3 mydb.sldb > mkdb.sql sqlite3 dupe.sldb < mkdb.sql With suitable DDL or a simple transformation of the DDL generated by .dump, that SQL can be used to "export it into online mysql" or some such. Cheers, -- Larry Brasfield

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

arly infer that it addresses only how SQLite source is presented to the compiler. Whether the compiler's output is embedded in its own object file, a DLL, or directly into a calling program is not addressed. -- Larry Brasfield ___ sqlite-users mailing list sq

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

On May 24, Dan Kennedy wrote: On 05/24/2012 10:53 PM, Larry Brasfield wrote: >> On the support page http://www.sqlite.org/howtocompile.html, it says: >> >> "The use of the amalgamation is recommended for all applications." >> >> Is this a general recom

  1   2   >