[sqlite] Feature request: import MySQL dumps in CLI

I doubt that utility would exist if they were to wander off tacking the conversion challenge for the other popular database systems. Best regards, - Larry Brasfield ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists

Re: [sqlite] Explicit "read transaction" with journal_mode=WAL.

) ) { Handle access errors // t does the rollback when it goes out of scope. } else { t.Commit(); } } This grouping of handling for different error categories is made much less convenient by the present deferral of acquiring the necessary lock(s). Best regards, - Larry

[sqlite] using System.Data.SQLite on Linux / ".Net Core 2"

Is there a build of System.Data.SQLite which runs on .Net Core 2.0 when used on a Linux platform? Using Powershell 6 installed on my Ubuntu 16 LTS box, I can do Add-Type -Path ./System.Data.SQLite.dll (which loads the assembly) without issues, (on Linux or Windows), but this $c = New-Objec

Re: [sqlite] How lock is implemented upon write?

tive ask for such information because, often, that leads to or permits a more direct solution to your actual problem. Certainly in this case, where the Pascal translation of many lines of C would take hours to generate, a more direct solution is probably going to be the only one likely to be offered

Re: [sqlite] Windows dll - Export Symbol

Keith Medcalf, (quoting Llyod), writes: >> >How can I build the dll correctly? > cl -DSQLITE_API=__declspec(dllexport) sqlite3.c -link -dll -out:sqlite3.dll I do not claim here that “correctly” building the DLL must be done as either I or Keith has suggested. However, the method using Makefil

[sqlite] Windows dll - Export Symbol

Lloyd writes: I wish to build SQLite as a dll in Windows. As per the documentation here https://www.sqlite.org/howtocompile.html, I have executed the command cl sqlite3.c -link -dll -out:sqlite3.dll on Visual Studio x86 command prompt. It seems that the dll built doesn't export any symbols! I chec

Re: [sqlite] Diagnosing stale readers

Gerlando Falauto writes: thanks for you reply. Indeed, readers are long-lived processes on a Linux system. They're threads of a Pyhon Flask application to export data, which uses uses peewee as a wrapper for SQLite. Theoretically, once a request is served, the transaction should be terminated. Howe

Re: [sqlite] Diagnosing stale readers

Gerlando Falauto writes: I'm using SQLite in WAL mode in the following scenario: - One writer which continuously writes new rows and deletes older ones - Multiple readers performing queries Writer and readers are running each in a separate process. The (Inactive) Journal Size limit is set to

[sqlite] where did my data go ? Re: Import data into a temporary table

Luuk writes: | sqlite> .import abc.csv temp.test | Error: no such table: temp.test |. . . | Where did my data go (see above)? The above command to the shell results in an attempted prepare of SQL like this, INSERT INTO “temp.text” VALUES … which fails with a “no such table” complaint. If shell.

Re: [sqlite] Sample Employee database ported to SQLite from MySQL

Jungle Boogie wrote: ➢ Anyone else have issues decompressing the file? $ bzip2 -d employees.db.bz2 bzip2: employees.db.bz2 is not a bzip2 file. bunzip2 employees.db.bz2 bunzip2: employees.db.bz2 is not a bzip2 file. $ file employees.db.bz2 employees.db.bz2: Non-ISO extended-ASCII HTML document t

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

Zydeholic wrote: ➢ I compile and get one error: Severity    Code    Description    Project    File    Line    Suppression State Error    LNK2001    unresolved external symbol _sqlite3_version    sqlite_try_3    C:\Users\DSNoS\source\repos\sqlite_try_3\sqlite_try_3\sqlite3.obj    1 That symb

Re: [sqlite] Question about floating point

Tim Streater wrote: [Responding to “There is a lot to like about BCD.”] > And do any processors/computers have hardware for that these days? The modern X86 descendent processors from AMD and Intel implement AA{A,D,M,S} instructions, which do the BCD adjustments associated with addition, subtrac

Re: [sqlite] Question about floating point

Gerry Snyder wrote: < I don't think anyone has pointed out that the "evil" is not floating point, it is the binary exponent. Disregarding the “evil” appellation, the fundamental fact is that, with modern floating point hardware (implementing the IEEE-754 standard), only that subset of rational

Re: [sqlite] Simple way to import GPX file?

Winfried wrote: < Hello, < < I need to importe a GPX file that contains a few thousand waypoints, eg. < Some name < < I tried https://mygeodata.cloud and https://geoconverter.hsr.ch, but for < some reason, the "waypoints" table doesn't contain latitude + longitude < infos. < < Before I write a Pyth

Re: [sqlite] Segmentation fault when using window function with (nested?) subquery

Gene Sacky wrote: > This query causes segmentation fault in SQLite 3.26.0 (on macOS 10.14.1). > -- > SELECT * FROM( > SELECT * FROM (SELECT 1 AS c) WHERE c IN ( > SELECT (row_number() OVER()) FROM (VALUES (0)) > ) > ) > -- > > However, no error occurs in the

[sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

The documentation at https://www.sqlite.org/geopoly.html , at 3.8. for geopoly_contains_point(), asserts that the function “returns true if and only if the coordinate X,Y is inside or on the boundary of the polygon P.” As now implemented, in the v3.26 release, it returns 1 where the point is on

[sqlite] Why not text mode for file from .output?

I notice that the file written by the CLI shell’s .output command, on the Windows platform, does not have CRLF line ends. From the code in v3.25.0 and v3.26.0 (pre-release), it appears that the file named as the .output parameter is opened in binary mode. (bTxtMode is left at its initialized v

Re: [sqlite] segmentation fault in sqlite api call

The code you provided declares and defines a pointer, named ‘db’ in main(), which is used with the SQLite API but never made to point to a valid object in memory or even to allocated memory. Hence your segmentation fault. ___ sqlite-users mailing list

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Jordy Deweer asks about alternatives to System.Data.SQLite because: “I run into errors a lot, using the System.Data.SQLite libraries. It easily crashes, trhows exceptions and similar issues...”. I’ve used that module for several projects and found it to be generally robust. I have also seen tha

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Jordy Deweer asks: “Is there a way to use a SQLite database in a C# project, without installing / configuring / depending on the System.Data.SQLite libraries? I really hope there is.” If you do a web search for the combination of terms “SQLite”, “C#” and “library”, you will find several alter

[sqlite] [EXTERNAL] (no subject)

Lars Frederiksen larshgf at dadlnet.dk wrote: < From here it was copied to a folder where my program exe-file is placed when I develop. Using flashcard.db from this folder gave the mentioned error. < I have to find out why it works like that! You apparently deploy your .exe to a location which inh

[sqlite] shell edit() trips on Windows newline kink

Upon thinking further about this bug, I realize that "correct" behavior is not obvious and might warrant some discussion. At first, I questioned whether it is appropriate to handle data differently depending upon whether it is typed as BLOB or text. Maybe the edit() function needed a flag for thi

[sqlite] When less help is more helpful

ntf(p->out, "%s", zHelp); +char * zHelp; +int nm = (nArg > 1)? strlen30(azArg[1]) : 0; +int i; +for (i = 0; 0 != (zHelp = pzHelp[i]); ++i){ + if(nm > 0 && sqlite3_strnicmp(zHelp+1, azArg[1], nm) != 0) + continu

[sqlite] shell session feature, #define awkwardness

least made more coherent. If the update-related session behavior is optional in sqlite3, it probably should be in the shell also. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

[sqlite] shell edit() trips on Windows newline kink

0; - if( x!=sz ){ + if( ftell(f)!=sz ){ sqlite3_result_error(context, "could not read back the whole file", -1); goto edit_func_end; } === (I omit line number marking because my unrelated changes make them inapplicable to source in the SQLite sources.) Ch

[sqlite] Odd question

elp, and viable alternatives, if you explain what you are trying to do.​ ​Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

ood out. (For awhile, 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' ke

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 follow

[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 messag

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 necessar

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

of SQLite'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&#

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

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

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] 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] 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 s

Re: [sqlite] WAL files and PERL question

iscovering 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 ___ sq

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

best used 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] 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] how to use sqlite in excel vba?

and a .PDF 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://sql

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

o be modified slightly 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?

ay not have any 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 interrupt a long running update without roll back?

which would be 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] Import skip first line

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-

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] numeric string quotation

t the string literal '01000', write it as a string 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] 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 A

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

in retrospect. 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 ___ sqli

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] How do I write a query

gue' tables. It lacks attributes of 'player' 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] 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] SQLite3 Bug Report: The shell accepts some dot commands ending in semicolons while rejecting others.

re easy 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 p

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] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

t has. 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, --

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

question 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, -- L

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] Multiple network connections

e a good solution. 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

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

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

ust 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] PRAGMA foreign_keys = ?, feature request

d be at a 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-us

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

[sqlite] PRAGMA foreign_keys = ?, feature request

nybody knows how 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] strange behavior with integer with where clause

ct that you will want to find 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 __

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

ic way 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

27;)|0 4|priority|integer|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 maili

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

diagrams show 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 s

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

not the latest, 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 h

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 and &

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

lowed by the syntax diagrams, and since I saw nothing to the contrary 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?

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

[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 i

Re: [sqlite] Suggested Improvement of Date Time Function

Since you (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-u

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

won't elaborate on this here, (as it is off-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] How to manage Table inside Table scenarios

structure 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. Re

[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] Denormalized view, "clumping" into length-limited groups

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 l

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

should not 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] Bug: Segmentation fault in libsqlite3.so.0.8.6[b69a4000+ac000]

uction 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

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

r just 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] light weight write barriers

e happy to become 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] How do you load a ".csv" and skip the first line?

hell, or a Windows executable, or both. It has a few other changes that do not interfere with conventional use of the shell which show up in the .help response. Cheers, -- Larry Brasfield (Examples of problem cut.) This does not work? -- .separator , .impor

Re: [sqlite] EXT :Re: Multi-Thread Reads to SQLite Database

database could be read-only (such as when no writers are busy), but the cache certainly will be in flux when readers alone are busy. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] How to use SQLite on VxWorks5.5

which is likely to have done most of the work already. (Berkeley DB is layered over SQLite.) Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] C++ programming - sqlite3_column() question (doc flaw?)

if pStmt is an SQL statement that does not return data". If this includes a pStmt for which data will no longer be returned, (as appears to be the case from the OP's report), this more stringent requirement should be mentioned. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Quoting "id" versus 'id' in query

or by the ; or c) A character that is identified as a syllable in the char- acter repertoire identified by the or by the ; or d) A character that is identified as an ideograph in the char- acter repertoire identified by the or by the . -- Larr

Re: [sqlite] Quoting "id" versus 'id' in query

noticed is the least surprising behavior for those who have learned SQL as defined, and hence is not generally regarded as a nasty feature. Good luck. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Use with asp.net

e-specific is kind of off-topic here. At the abstraction level exposed by System.Data.SQLite, you will not have many SQLite-specific issues. For those that do arise, you are likely to find willing help here. Regards, -- Larry Brasfield ___ sqlite-us

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

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

y 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 maili

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

s (2, 'goofy two'); .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 Brasfiel

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 i

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

ly-To' headers filled 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

d behaviour 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

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

t what is truly irrelevant, but please do not submit pseudocode. With MS access this query work without need to insert transaction. I see no queries here at all, 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] In-memory and temporary database

d to store 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 htt

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

including aggregate functions. 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

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

one up 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] Handle multiple results using sqlite3_step

xecute one 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] question about zipvfs & performance

. cheers Tal Good luck. -- 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

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] Could/should Windows build of SQLite use #define

r translation units. Nevertheless, it 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@sqlit

  1   2   >