[sqlite] Getting "chunked" output from a large SELECT operation.

the memory demands can be reduced as much as needed by going back to the well a (potentially large) number of times. Am I remembering this right? Can anyone refresh my memory on how to do it if so? Randall. ___ sqlite-users mailing list sq

[sqlite] Safe to use SQLite over a sketchy network?

any experience or insight I would appreciate it. Randall. Randall Smith BB-106G (office) BB-172D (lab) 858-775-5017 (cell) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo

[sqlite] Recursive CTE as correlated subquery?

I missing something? Thanks for any suggestions or expertise. Randall. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SuperSQLite: a supercharged Python SQLite library

this really annoying since one wants transaction handling to very simple and predictable so that the right thing happens under all circumstances. I, too, would be interested to hear from people who have real experience with it. Randall Smith ___ sql

[sqlite] Multiple ATTACHments to the same DB?

dification is attempted? How are ATTACHments different from connections? Thanks for any words of wisdom here. Randall. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Tips for index creation.

e ".expert" feature and make sqlite3 a one-stop-shop for query tuning. Randall. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] "Pickling" an in-memory SQLite database.

t later for use? My fantasy is that this could all be done in memory so the file system does not have to become involved. I feel like I am missing something obvious here, but can't quite come up with it. Thanks for any ideas or suggestions. Randall.

[sqlite] Best practices for forward conversion of database formats?

n general, or with SQLite in particular? Can anyone who has implemented this make useful suggestions? Or are there published resources I am missing? Thanks in advance for whatever you can suggest. Randall. ___ sqlite-users mailing list sqlite-users@mailinglists.

Re: [sqlite] Unsigned

o convert things back and forth. This can at least be read by a person when looking at data dumps and so on. I considered this the least bad of several bad alternatives! Obviously a native long integer type with normal arithmetic support is the proper solution.) Randall. __

Re: [sqlite] Unsigned

g., I have a common need to store software address values, which are (currently!) 64-bit unsigned, and have had to jump through ridiculous hoops in SQLite to do it. Integers in this range, and larger, seem like they are in common use today. Randall. ___

Re: [sqlite] Round-tripping SQLite back and forth between text representation.

On 2018/07/10 8:27 PM, Randall Smith wrote: > One follow-up: Do you know if the dump output is "deterministic" over > time? That is, if I diff two dumps taken at different times, will the > unchanged material be in the same order and so on? Or is the ordering > eff

[sqlite] Round-tripping SQLite back and forth between text representation.

ordering effectively random? My underlying question is "can text-comparing two DB dumps be used to determine what has changed?" Thanks again for any insights. Randall Smith ___ sqlite-users mailing list sql

[sqlite] Round-tripping SQLite back and forth between text representation.

. Randall. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] "Tagging" SQLite tables with attributes for introspection.

out. Maybe define some kind of bogus index for the table I could check for? But I'm hoping there's something with more grace and beauty. Thanks for any ideas or suggestions. Randall. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] Format of sqlite-users digests.

the product and value the community; just bringing this up as a question. Randall Smith ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Controlling the lifetime of shared-cache, in-memory SQLite databases.

after that operation and can start fresh with a virgin database? Thanks in advance for any information or ideas. Randall. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Quest for "scratch table" implementation in SQLite.

y? Thanks for any suggestions. Randall. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Foreign keys & TEMPORARY tables.

outlive the session, so the argument against allowing against foreign keys between databases doesn't (I claim) really apply. Am I getting the situation right? Is there any way to allow foreign keys from TEMP tables to persistent tables, or can this be considered a feature request? Randall Smith

[sqlite] Using a "custom" version of SQLite under Python in Ubuntu.

hat is not used by the rest of the system. I realize this is a bit vague; I would greatly appreciate any pointers, ideas, or food for thought. Randall. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org

[sqlite] REFERENCES from TEMPORARY table to main database table?

p when the DB closes? Thanks for any information and suggestions! Randall. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Managing SQLite indices.

profiling would be easier and you could quickly identify the problem spot in a complicated query instead of having to constantly play find-the-peanut. I'm no database engineer, so I have no idea how easy or hard these would be! Randall. > From: Simon Slavin <slav...@bigfraud.org> >

[sqlite] Managing SQLite indices.

I'm developing a medium-sized SQLite-based app (maybe 50 tables, 400 query, insert, and update routines). As we all know, having the right set of table indices is vital for getting decent performance from SQL. However, I'm getting to the point on this project where this is getting to be very

[sqlite] Using incremental BLOB functions against a BLOB column in a virtual table

defined as virtual tables vs. physical tables? Thanks in advance for any assistance provided. Randy Evans > > From: Richard Hipp > > On 2/23/15, Evans, Randall wrote: > > Can the incremental BLOB functions (sqlite_blob_open(), > > sqlite_blob_read(), > > etc) a

[sqlite] Using incremental BLOB functions against a BLOB column in a virtual table

Can the incremental BLOB functions (sqlite_blob_open(), sqlite_blob_read(), etc) access BLOB column data defined in a SQLite virtual table? If it matters, I am only interested in read-only access at this time. If the answer is yes, is there any facility in virtual table support for xColumn or

[sqlite] DML from .read in DOS Shell

I get the incomplete SQL error when I attempt to run DML command in files (INSERT, UPDATE, DELETE, SELECT) using the .read command. I am able to run any DDL statements I try (CREATE, ALTER, etc.) with no problem. I am using SQLite 3.7.11 on Windows XP. sqlite> .read x5.txt Error: incomplete SQL:

Re: [sqlite] how to ".import" an Ascii file

Sorry for the false info Ascii files have 3 character separation, including 2 chr(34 )(quote)=with space between [" "] ; that is my problem! Best, Randall; thanks for your patience. - To unsubscribe,

[sqlite] how to ".import" an Ascii file

Hi, I feel embarrased after searching the archives and syntax; Can anyone pleasae spare the time to teach me how to ".import" an Ascii file (separator is " ") I cannot get the separator to work.

Re: [sqlite] import

PS I can do vbscript readline/ writeline as a workaround, not too slow... But I would prefer not. Randall Hi, I think it is asc=10, so "LF" rather than "CRLF", but I don't want to have to re-open , say a 80Mb or 0.5gig text file with a text editor, nor re-proce

Re: [sqlite] import

K in the ".dump" for instance?.. Thanks, Randall Hello, this may sound stupid, but is it possible that you get a file with UNIX line endings instead of Windows ones? If that's the case, any decent text editor or a really simple program can do a conversion... cu, Thomas

Re: [sqlite] import

Hi, please open this again; I cannot get ".output" to work reliably to give me a correct "EOL", so, say, notepad sees the "EOL". Can anyone help? [Wrapper was not the problem, I believe] Thanks, Randall Sorry; Ignore this for now; I see ".output&

Re: [sqlite] import

Sorry; Ignore this for now; I see ".output" works OK; my wrapper was stripping something, I think; Best, Randall

[sqlite] import

Hi, Sorry for the basic queries here... If I ".output" with .mode "tabs" , "lines" etc, the resulting text file or csv file cannot be ".imported" by import, as the EOL is not read? Can I fix this easily? Thanks, Randall

Re: [sqlite] Versioning in SQL database?

Many thanks again, I'll give it a try.. Best, randall

Re: [sqlite] Versioning in SQL database?

Thanks again! I cannot see 3.3.2 at the download site..? You should be good to go if you use version 3.3.2. It doesn't have the fix that broke ".import" in version 3.3.3, but it does have the "if exists/if not exists" features introduced in version 3.3.0. HTH Dennis Cote

Re: [sqlite] Versioning in SQL database?

Thanks, Catch 22; I can't upgrade because ".import" is not working again till 3.3.4! Best, Randall

[sqlite] IF EXISTS

Hi, I acnnot get "IF EXISTS" to work for "DROP TABLE IF EXISTS tablename"; ver 3.2.8; I see "IF NOT EXISTS" started in ver 3.3.0, but "IF EXISTS" has been in the syntax page for at least months; am I doing something wrong? Randall

Re: [sqlite] Versioning in SQL database?

Hi, I acnnot get "IF EXISTS" to work for "DROP TABLE IF EXISTS tablename"; ver 3.2.8; I see "IF NOT EXISTS" started in ver 3.3.0, but "IF EXISTS" has been in the syntax page for at least months; am I doing something wrong? Randall

Re: [sqlite] Versioning in SQL database?

- Original Message - From: "Jim C. Nasby" <[EMAIL PROTECTED]> To: Sent: Wednesday, February 08, 2006 8:58 AM Subject: Re: [sqlite] Versioning in SQL database? On Tue, Feb 07, 2006 at 10:55:27AM -0500, Paul Tomblin wrote: I am putting together something

Re: [sqlite] bulk processes with dll or obj versions?

Someone else is doing it for me; I'll notify them; Additionally, the interpreted language using the dll is really slow for csv import; whereas the ".import" is really fast! best, Randall

Re: [sqlite] .import not working the same in sqlite3.3.3 (exe)

Thanks; so how will I know when this is fixed in the download zip? Randall - Original Message - From: <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, February 06, 2006 11:04 PM Subject: Re: [sqlite] .import not working the same in sqlite3.3.3 (exe) "

[sqlite] .import not working the same in sqlite3.3.3 (exe)

with 3.3.3? randall

[sqlite] bulk processes with dll or obj versions?

uot; is removed from version 3 on?..] (or where can i find them?...) Thanks, Randall

[sqlite] examples of syntax

umns and i may need more help if I acn't work it out. Thanks in advance, Randall

Re: [sqlite] errors compiling with MS VC++ 6.0

if it gives a different (more normal) error.. Randall Fox

Re: [sqlite] transient SQLITE_CORRUPT

rity_check; Perhaps that will tell you if you have integrity problems on the db.. Randall Fox *

[sqlite] PRAGMA user_version

I am trying to use "PRAGMA user_version;", but it doesn't seem to work with my version of Sqlite, 3.08. What version is this feature in? I also checked the pragma.c file, from the website CVS, and I didn't see any notes about it being added since 3.08.. Thanks Randall Fox

Re: [sqlite] working with dates

it to pretty formats or unix time in SQL. -- Randall Randall <[EMAIL PROTECTED]> "Are you hungry? I haven't eaten since later this afternoon." -- Aaron, _Primer_

[sqlite] Best embedded OS for Sqlite and perl

Hi All I am just looking into building some "set top" like devices for a particular business application. I would like to use Sqlite to manage the data repository and I have been a perl developer for the last few years. Does anybody have a recommendation about which embeddable linux

[sqlite] Cluster Indexes

What type of select query would benefit from cluster indexes in SQLITE3 ? If you can, an example would be nice.. I found the following in the wiki, but it doesn't explain much.. Use cluster indexes Clustered indexes are indexes that comprise more than one column. These increase the speed of

Re: [sqlite] Do _ErrMsg strings have to be freed?

On Mon, 7 Feb 2005 18:14:42 -0800, you wrote: >Does this > >var > pMsg: PChar; > >.. >pMsg := SQLite3_ErrMsg(aDB); > >necessitate this? > > if pMsg <> nil then SQLite3_Free(pMsg); It depends. If you use sqlite3_exec, then yes, if you use the other method (sqlite_prepare) then I would say

Re: [sqlite] still struggling with "Database schema has changed" errors

use a program like Examdiff and compare it to the same file in the source code. It will show the differences. I used 3.08 as the source, but I would bet the file is the same in the current version.. Randall Fox

Re: [sqlite] autoincrement weirdnesses

On Feb 6, 2005, at 1:35 AM, [EMAIL PROTECTED] wrote: Randall Randall <[EMAIL PROTECTED]> writes: sqlite> create table package (rowid integer primary key autoincrement, name text); SQL error: near "autoincrement": syntax error What am I doing wrong, here? You're putting in the

Re: [sqlite] autoincrement weirdnesses

On Feb 6, 2005, at 1:38 AM, Will Leshner wrote: On Sun, 6 Feb 2005 01:17:45 -0500, Randall Randall <[EMAIL PROTECTED]> wrote: Okay, I know there's something obvious I must be missing: sqlite> create table package (rowid integer primary key autoincrement, name text); SQL error: near "

Re: [sqlite] SQLite 3.0.8 dates

lect out of SQLITE, have it do the conversion for you. You can also convert when inserting or updating if you want. I prefer the julian because it smaller, and I have no worries about sorting by that column. Anything fancy and I use SQLITE to do the format conversions, which is rare. Randall Fox

Re: [sqlite] still struggling with "Database schema has changed" errors

and line switch for the TCL sqlite3 instruction. Randall Fox

Re: [sqlite] still struggling with "Database schema has changed" errors

s opening the database twice, and when I would create a table with one of the open instances, the other would get the schema error the next time I started a write operation. I did end up fixing it by rewriting part of the SQLITE code. Randall Fox

Re: [sqlite] quick question regarding INTEGER PRIMARY KEY default value

ite3_column_int to represent NULL. The only safe way is to either not allow zero as a key entry, or get the fkey as a text value. Randall Fox

Re: [sqlite] embedded TCL and sqlite in one app

it is healthy. I assume the user is smart enough to know. If you feel it is worthy, use the changes in your next release. I would prefer if you did, since I won't have to maintain the code myself.. :) Randall Fox

Re: [sqlite] $ in table and column names

database engines. This seems very odd to me. Can anybody else confirm the use of '$' in the middle of identifier names in other database engines? PostgreSQL allows it, but their documentation specifically mentions that it's not standard SQL to allow it. -- Randall Randall <[EMAIL PROTECTED]> Proper

Re: [sqlite] PHP mods was: Changing table and security

t has been in applying and repairing such mods for clients. -- Randall Randall <[EMAIL PROTECTED]> Property law should use #'EQ , not #'EQUAL .

[sqlite] ANN: cmucl-sqlite3 (Common Lisp SQLite3 interface)

, and is public domain. -- Randall Randall <[EMAIL PROTECTED]> Property law should use #'EQ , not #'EQUAL .

[sqlite] Is it possible to BIND in a CREATE TABLE

I have a CREATE TABLE sql command with DEFAULT values. I would like to BIND the default values, but it seems it is not supported. Is this so? I am using SQLITE3.. Any help appreciated. Randall Fox

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

he original poster didn't say what version, and a follow up mentioned the sqlite3 structure, so I assumed it was v3. Good to know it is not a problem. Randall Fox

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

gt;VACUUM again, that is.) This sounds like a major bug. I use Sqlite embedded in my app and an error like that could be catastrophic. Should I close and reopen the DB every time after a vacuum? Is there a fix? I was not able to recreate the error but I just upgraded to v3 today so I am still tes

Re: [sqlite] What does the first expr do in a CASE statement ?

On Fri, 17 Sep 2004 19:49:34 -0600, you wrote: >Randall Fox wrote: > >>What does the first expr do in a CASE expression ? >> >>I understand the rest of the syntax, but I don't get what the very >>first expr (after the keyword "case") does.. And I couldn'

[sqlite] What does the first expr do in a CASE statement ?

What does the first expr do in a CASE expression ? I understand the rest of the syntax, but I don't get what the very first expr (after the keyword "case") does.. And I couldn't find the answer in the documentation or wiki.. Thanks Randall Fox

[sqlite] Any speed advantage in a view

I am coding a program that uses SQLITE and I am wondering if there are any advantages (speed?) to using a preset view instead of hard coding the SELECT query into the source code? Is the view precompiled at all? Thanks Randall Fox

Re: [sqlite] Alternating Output

omewhere that I can browse? Thanks Randall Fox

Re: [sqlite] Alternating Output

The trigger is a nice idea, but renumbering the index won't work, since the index might be used as a key to link the record to another table.. I guess I could use a new index, just for this purpose but that seems to be a waste of resources.. How do you renumber an index anyway? Randall Fox

Re: [sqlite] Alternating Output

variable that toggles between two supplied strings each time. I am just wondering if it was done or there is an easy way.. Thanks Randall Fox On Wed, 21 Jul 2004 08:55:09 -0500, you wrote: >> Is there an easy way to have an "alternating" column value ...? > >No easy or relia

[sqlite] Alternating Output

row3=grey, row4 = white, etc... Thanks Randall Fox

Re: [sqlite] Another way of corrupting the database.

On Tue, 20 Jul 2004 07:21:43 -0500, you wrote: >>> Is there any way to determine the sqlite version ... ? > >Look at the first 47 bytes of the file -- or the first 48 >bytes if you want a null-terminated string. That works.. Thank you.. Randall Fox

Re: [sqlite] Another way of corrupting the database.

of my head I can't think of a way to do it easily. I guess in the end I would need to include both versions of the sqlite db engine inside the application, in order to do a conversion from 2.x to 3.x.. Randall Fox On Mon, 19 Jul 2004 09:08:47 -0400, you wrote: >George Ionescu wrote: > &

Re: [sqlite] SQLite performance with mid-size databases

age of this, or is caching it from w/in the DB itself.. Also, did you implement a integer primary key, and use indexing? Randall Fox - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Adding and subtracting decimals is not accurate

ke a special "MONEY" type for users, and every time convert it to cents.. Hmm.. Thanks Randall Fox - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Adding and subtracting decimals is not accurate

icant digits sooner or later.. Randall Fox - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Adding and subtracting decimals is not accurate

.. Is there a work around to accurately add fixed point numbers? Or more generally, has this been addressed before? I couldn't find any reference to it on the FAQ or web site.. This problem becomes more obvious when the 1.2 is interpreted as $1.20 Thank you Randall Fox