Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

oldest get moved to the Trash > automatically. > It's all I need. With a subscription to email notifications of the sqlite-forum you can lurk in just the same way as the sqlite-users mailing list. Threaded or in date order, whatever your email client supports. Just try it, your worries wi

Re: [sqlite] notify all processes of database modification

t have that message anymore, so it is not totally clear what you need. Anyway, SQLite doesn't have such a mechanism by itself. Maybe inotify is useful to you : https://en.wikipedia.org/wiki/Inotify http://man7.org/linux/man-pages/man7/inotify.7.html -- Re

Re: [sqlite] csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines

the feature is available in another form $ cat test.csv "a";"b" "c";"d" $ sqlite3 test.db \ "DROP TABLE IF EXISTS tbl1" \ ".mode csv" \ ".separator ;" \ ".import test.csv tbl1" \ ". mode column" \ ".header

Re: [sqlite] Is there a way to yield an error when opening a nonexistent dbfile?

want > the sqlite3 to fail when the dbfile does not exist. Is there a way to > achieve this? $ sqlite3 -readonly testx.db SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. sqlite> .tables Error: unable to open database "testx.db": unabl

Re: [sqlite] Obtaining rowid of an updated row in UPSERT

tly this – a subsequent SELECT after > the > upsert; while this approach is working, it does feel suboptimal. On the source code side, yes, but you have to wrap the UPSERT and subsequent SELECT in a transaction anyway, so you can be sure the relavant index and table pages are still valid in the cache. So, performancewise, it doesn't matter much. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to pass -Dxxx compile option

shell.c ../fossil/src/linenoise.c sqlite3.c -o sqlite3 \ && make sqlite3_analyzer \ && make sqldiff \ && make scrub \ && make showdb \ && make showwal \ && make showshm \ && make

Re: [sqlite] Bug report

On Thu, 21 Nov 2019 21:02:57 +, Jose Isaias Cabrera wrote: >Kees Nuyt, on Thursday, November 21, 2019 03:48 PM, wrote... [...] >> >> I see no CVE entered by the OP, but maybe I missed something. > > Yes, you are right. After pasting it, I went through the top 5 >

Re: [sqlite] Bug report

y exists within processing of localize.php in Schneider > Electric U.motion Builder software versions prior to v1.3.4. The underlying > SQLite database query is subject to SQL injection on the username input > parameter. Application error -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug report

The mailing list strips attachemnts. Please insert them in the body text of your message, or mail them to Richard Hipp. > FYI, we have also reported the bugs for CVE > at cve.mitre.org <http://cve.mitre.org/>. Can you tell us the CVE nun

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

p while not SQLITE_DONE sqlite3_step() do-something-with-the-row https://www.sqlite.org/c3ref/free_table.html https://www.sqlite.org/c3ref/step.html -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.or

Re: [sqlite] Hello everyone, I found some strange behavior when using the Command Line Shell For SQLite.

ite> select * FROM x; é ä -- -- 1 téxt sqlite>.q ~ $ sqlite3 test.db \ ".mode column" ".head on" ".width 1 4" "SELECT * FROM x" \ | hexdump -C 0000 c3 a9 20 20 c3 a4 20 20 20 0a 2d 20 20 2d 2d 2d |.. .. .- ---| 00

Re: [sqlite] Endless loop possible with simultaneous SELECT and UPDATE?

it only works for WAL journal mode. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite: see: encryption

e is unavailable. Keep this in mind if you have a background service that could need to access your application secrets." <https://www.androidauthority.com/use-android-keystore-store-passwords-sensitive-information-623779/> It is the first hit in a search on "android keystore ap

Re: [sqlite] sqlite3 unable to open network db file in readwrite mode

detailed description. My first thought: Is the directory writable? It has to be so SQLite can create a journal file. https://www.sqlite.org/atomiccommit.html#section_3_5 Apart from that, SQLite has to be able to create files in its TMPDIR. https://www.sqlite.org/tempfiles.html#temporary_file_storage_locations -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Read/Write cycle

data, let it run and measure the read/write cycles as they occur. Hope this helps. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Built in and enabled Virtual Table extensions in SQLite CLI?

On Wed, 10 Apr 2019 11:05:59 +0100, you wrote: >Wednesday, April 10, 2019, 10:28:55 AM, Luuk wrote: > >> On 10-4-2019 10:28, Kees Nuyt wrote: > >>> sqlite> select * from pragma_function_list; > >> sqlite> select * from pragma_function_list; >> Error:

Re: [sqlite] Built in and enabled Virtual Table extensions in SQLite CLI?

uilt as > an external library (.dll) to be loaded by eg. .load ./csv where csv > would be csv.dll in the current directory. If the csv extension was > built-in, would I still need to load it to activate it? I don't think so. -- Regards, Kees Nuyt

[sqlite] Documentation error: USE_ZLIB versus HAVE_ZLIB

VE_ZLIB src/shell.c.in:9179:#if !defined(SQLITE_OMIT_VIRTUALTABLE) && defined(SQLITE_HAVE_ZLIB) src/shell.c.in:9268:#ifdef SQLITE_HAVE_ZLIB src/shell.c.in:9374:#if !defined(SQLITE_OMIT_VIRTUALTABLE) && defined(SQLITE_HAVE_ZLIB) src/test1.c:7181:#ifdef SQLITE_HAVE_ZLIB src/test1.c:7209:#ifd

Re: [sqlite] Checking differences in tables

27;p001', 1, 2, > (SELECT d FROM t WHERE a = 'p001' AND max(idate)), > 4, '2019-02-12'); > Error: misuse of aggregate function max() Try: insert into t (a, b, c, d, e, idate) values ('p001', 1, 2, (SELECT d FROM t WHERE a = 'p001' AND

Re: [sqlite] FOREIGN KEY constraint not respected during bulk insert using TRANSACTION

s off by default. Indeed bulk inserts are fast without it. https://sqlite.org/pragma.html#pragma_foreign_keys https://sqlite.org/pragma.html#pragma_foreign_key_check -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Windows GUI alternative to Excel?

m. If you don't want to be anonymous, you only have to login. Click the reply button to reply. That's all. No further navigation or browsing required. For me, this is a very acceptable alternative for a mailing list. YMMV, I know you post more ofte

Re: [sqlite] .exit in script is not working

On Fri, 31 Aug 2018 19:29:47 +0200, Stéphane AULERY wrote: > When I use the -init option the .exit statement > at the end of my script is never executed. > > I launch sqlite from a batch file on Windows Server 2012 and Windows 7 64 bit. > > Command line : > sqlite3.exe -init myscript.scr If you

Re: [sqlite] "Cheating" at making common tables

create tables based on this structure, and setup the PK? I guess would use good old m4 for that. Or awk. [...] -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using CTE with date comparison

uniquely identify a tuple (row). Each key is called a candidate key. Only one of those keys can be choosen to be the PRIMARY KEY. All other candidate keys can get honored by adding the UNIQUE clause, to recognize them as alternative keys. -- Regards, Kees Nuyt __

Re: [sqlite] crash dropping table

On Wed, 18 Apr 2018 15:47:47 +, Mark Wagner wrote: > Sorry for my ignorance but is there a procedure for > submitting bugs for things like this? The procedure is to mail bugs to this mailing list, including version info, so you did exactly the right thing. -- Regards, Kee

Re: [sqlite] CLI thoughts

structures etc.. > 3. the .load command does not have a complement .loaded; how does > one check? I guess the easiest way is to just load the extension again, if you are not sure it is loaded at some point. If it fails to load, an exception is raised. > Well, just thinking out loud. No problem, so do I ;) -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug? INSERT OR REPLACE not equivalent to DELETE followed by INSERT

advantage in UPSERT. My humble two cents, -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug in fsdir

ot; to reopen on a persistent database. >sqlite> SELECT name FROM fsdir('.') JOIN (VALUES(1),(2)); >. >./sqlite3.exe >./sqlite3_analyzer.exe >./sqldiff.exe >. > >Adding an ORDER BY clause seems to provide workaround for this particular >case. > Fixed by Ri

Re: [sqlite] Dealing with SQLITE_BUSY

gt; > Do remember when setting your timeout, that you have to set it in both > connections. Exeactly. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about threadsafe

you use threadsafe = 2 ? > > The problem is still here. Because the test uses two processes, every process is single-threaded, no risc of concurrency between threads. PRAGMA busy_timeout might be helpful. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation update

a lock leads to corruption > > Can you clarify your correction ? I don't see a difference. It used to be: 8.3. I/O while obtaining a lock leads to corruption (the word error is missing) -- Regards, Kees Nuyt ___ sqlite-users mail

Re: [sqlite] Groups in C API

feasible it would be to get SQLite doing this. ORDER BY does the job just fine, there's no need to overload GROUP BY with that functionality. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Odd question

> not the case. I want to cause some rows to be > inserted into a table but plain insert queries > don't work because they violate the application's > assumption that a result will be returned. Something like: https://sqlite.org/pragma.html#pragma_count_changes

Re: [sqlite] Unable to store 500MB size of row data even after define macro SQLITE_MAX_LENGTH

r things to look at: PRAGMA schema.journal_size_limit; https://sqlite.org/pragma.html#pragma_journal_size_limit PRAGMA soft_heap_limit; https://sqlite.org/pragma.html#pragma_soft_heap_limit HTH -- Regards, Kees Nuyt ___ sqlite-users mailing list sq

Re: [sqlite] finding the number of records until a value is different

(awk code): printf "INSERT INTO cputemp (epoch,ctemp) " \ "VALUES ( 0 + strftime('%%s','now'),%s);\n",cputemp This can also be done in other ways of course. Hope this helps. -- Regards, Kees Nuyt ___

Re: [sqlite] Many ML emails going to GMail's SPAM

mail is > doing unwanted spam filtering is to switch elsewhere. > > And there's no need for 'likes' and related nonsense on a technical list. +1 I prefer mailing lists and usenet groups. With a proper threading reader program I just press the spacebar to page through a messa

Re: [sqlite] Unexpected echo when setting locking_mode

usive The same happens for pragma journal_mode=wal; , although it's less intrusive than locking_mode , because journal_mode will typically only be issued at database creation. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-us

Re: [sqlite] Valid characters for indentifiers

On Sun, 12 Nov 2017 10:19:03 +0100, Clemens Ladisch wrote: > Kees Nuyt wrote: >> It conforms to the SQL standard, you can use the Postgresql docs >> as a reference. > > Actually, neither SQLite nor PostgreSQL conform to the SQL standard. > [...] Thanks for the heads-up!

Re: [sqlite] Valid characters for indentifiers

or an otherwise invalid word) as an identifier, you have to quote it. SQLite has its own lost of keywords. https://sqlite.org/lang_keywords.html -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglist

Re: [sqlite] shell.c no longer in SCM [WAS: [sqlite-announce] Version 3.21.0]

shell.c is now generated > from? That is ./src/shell.c.in . Have a look at ./Makefile.in for the dependencies. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite3.6 Command-line delete/update not working with large db file(>280GB)

On Sun, 15 Oct 2017 18:36:56 -0700 (MST), Fiona wrote: > Thanks for noticing that problem! Follow your instructions, now I'm sure > it's all because my db file is corrupted. Is there anything I can do to fix > it? > > Integrity check result: >

Re: [sqlite] Sqlite3.6 Command-line delete/update not working with large db file(>280GB)

f expected size. HTH -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite3.6 Command-line delete/update not working with large db file(>280GB)

KEY (tile_id)); -- could be faster -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] XOR operator

I never associated the ~ with NOT, and from the replies to this thread > it seems this knowledge may be useful to many. > >Thanks, >Ryan > > >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailingl

Re: [sqlite] Need help with SQL query

;PRIMARY KEY (ITEM_ID,KEY) > ) WITHOUT ROWID; > >John G Yes, you are right. I didn't pay enough attention typing that code. My apologies for any confusion that may have caused. -- Regards, Kees Nuyt >On 11 September 2017 at 13:11, Kees Nuyt wrote: > >>

Re: [sqlite] Create table - Error code: 21

; sqlite> select ROWID,id,tx from t1; -- ROWID not aliased 1|3|t1 sqlite> select ROWID,id,tx from t2; -- aliased as intended. 3|3|t2 sqlite> I'm afraid I don't have an answer to your original question. -- Regards, Kees Nuyt ___

Re: [sqlite] 'database disk image is malformed' only on the mac

eset and > sqlite3_finalize on all the cached statements). In case the reference count > is't 0, the connection is kept alive. [...] HTH -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Need help with SQL query

On Mon, 11 Sep 2017 14:05:25 +0200, Kees Nuyt wrote: > CREATE TABLE ATTRIBUTES ( > ITEM_ID INTEGER REFERENCES ATTRIBUTES(ID) ON DELETE CASCADE, > KEY TEXT, > VALUE TEXT, > PRIMARY KEY (ITEM_ID,KEY) > ) WITHOUT ROWID; > CREATE INDEX attr_item_id ON ATTRIBUTES(ITEM

Re: [sqlite] Need help with SQL query

forced when PRAGMA foreign_keys=on; is executed after opening the database, before any INSERT/UPDATE/DELETE statement is issued. HTH -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] acf3b9cc9c3932431979995a1dceacc06c659ab400fad95ce3728ff8895a022b : Off by one on the column names

7-09 === 18:55:29 [70096c505d] *CURRENT* Always make "column%d" column-names 1-based, never 0-based. (user: drh tags: trunk) -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] table-naming-expression impact on sqlite3_prepare

#x27;create table %s (a,b,c)',(select tablename from mytables))); It's something that can be done by any host language. No need to implement that in SQL. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org h

Re: [sqlite] foreign key cardinality

column. The shall be considered to implic- itly specify a that is identical to that . 3) The table constraint descriptor describing the whose identifies the referenced columns shall indicate that the unique constraint is n

Re: [sqlite] How to circumvent UNIQUE constraint

t failed: desktops.indexNo > >?How can I make this work? Considering there is no constraint on indexNo with respect to negative or zero values, I would suggest: INSERT INTO desktops (name,indexNo,value,waitSeconds) VALUES ('thename',(SELECT min(indexNo) FROM deskto

Re: [sqlite] Insert into with Id...

depends on the answers to my questions above. > Thanks in advance, > > Ing. Héctor F. Fiandor Rosario Hope this helps, -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Exiting SQLite3 from within a (.bat) file

mmands: > cls > SOE_sort.exe %1 > sqlite3.exe -init SOE_sortRC.sqliterc Try: cls SOE_sort.exe %1 sqlite3.exe https://www.sqlite.org/src/artifact?name=6095531aa900decd&ln=5634-5650 A script as redirected input _does_ execute .quit, it even exits witho

Re: [sqlite] Foreign key error...

ortant here? The error message is quite informative: the artist table does not have a column trackartist. Try: select artistname, trackname from artist inner join track on trackartist = artistid; HTH -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Simplify multiple use of value in a trigger

27;; > UPDATE mx_state SET _160m = 1 + (SELECT _160m FROM mx_state WHERE > state = s) WHERE state = s AND c = 'Mexico'; > UPDATE ca_prov SET _160m = 1 + (SELECT _160m FROM ca_prov WHERE > prov = s) WHERE prov = s AND c = 'Canada'; > UPDATE worl

Re: [sqlite] pragma integrity_check doesn't check constraints without indices

base file." When changing anything in the sqlite_master table you are circumventing all mechanisms SQLite has to keep the database consistent. What you did in your example is creating a table description in sqlite_master that doesn't match the physical table in the database, so yes, all be

Re: [sqlite] Trigger WHEN condition, comparing with null

On Thu, 13 Oct 2016 11:45:14 +0200, Daniel Polski wrote: That's because the expression in the WHEN clause (new.value != old.value) is not valid when one of them is NULL. HTH -- Regards, Kees Nuyt >Hello, >I guess there is something I'm missing when trying to synchro

Re: [sqlite] CREATE FUNCTION

and it is not in "SQL As Understood > By SQLite"; kind of a grey area, in my mind, for future support. Well,SQLite is supposed to be "lightweight", so I wouldn't count on future support. Plus what Clemens Ladisch and Richard Hipp said. -- Regards, Kees Nuyt ___

Re: [sqlite] Locking databases - Possibly (probably?) a dumb question

" > 4) Close the file > > From that point onwards that database is in WAL mode > and everything opening it automatically knows that. > You do the above sequence using your own software > or the SQLite command-line shell tool. > > Simon. -- Regards, Kees Nuyt ___

Re: [sqlite] Conversion failure

tworkerror.org/utf8/ > Will this help? Hope this helps. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

gi-bin/mailman/listinfo/fossil-users Several mailing list archives carry this list, e.g.: http://www.mail-archive.com/fossil-users at lists.fossil-scm.org/ -- Regards, Kees Nuyt

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

used by any databse connection - the journal of the database you are overwriting (if any) is removed. > i'll ber very grateful > Sincerely yours > Hashim -- Regards, Kees Nuyt

[sqlite] How to get 1 row with no null columns

plication could compose the WHERE clause using the output from PRAGMA table_info(AnyTable) to iterate over all columns. > Thanks, > -Bill -- Regards, Kees Nuyt

[sqlite] output from sqlite3 .dump not going where I expected

utilities that expect the forward slash as an option character (copy /b ..., dir /s ... etc.). "C:/a/valid/path/file.txt" will do fine. -- Kind Regards, Kees Nuyt

[sqlite] .DUMP output compatibility

UnxUtils and https://sourceforge.net/projects/unxutils/ -- Regards, Kees Nuyt >-Original Message- >From: Richard Hipp >Sent: Friday, May 06, 2016 1:55 AM >To: SQLite mailing list >Subject: Re: [sqlite] .DUMP output compatibility > >On 5/5/16, Tony Papadimitriou wrote: >> Is

[sqlite] autoincrement

WHERE type='table'; t1 t2 sqlite_sequence sqlite> SELECT * FROM sqlite_sequence; t2|2 sqlite> Hope this helps >> >> On Wed, Apr 13, 2016 at 4:54 AM, Igor Korot wrote: >>> Hi, >>> Is it possible to get whether the column is set to autoincrement or not? >>> >>> PRAGMA table_info() does not give such info... >>> >>> Thank you. -- Regards, Kees Nuyt

[sqlite] "Circular" order by

,1 FROM List WHERE SomeIndex == :1 > UNION ALL > SELECT Value,2 FROM List WHERE SomeIndex <> :1 >) ORDER BY Ord, V That is not needed, as http://www.sqlite.org/lang_select.html#orderby says: "The ORDER BY clause [] In a compound SELECT statement, only the last or right-most simple SELECT may have an ORDER BY clause. That ORDER BY clause will apply across all elements of the compound. If the right-most element of a compound SELECT is a VALUES clause, then no ORDER BY clause is allowed on that statement." > Easy enough, but alas!, the amount of places I have to go and change... :) HTH ;) -- Regards, Kees Nuyt

[sqlite] Multithreaded SQLite

in separated transactions. You'd have to give every thread its own connection to make them independent with respect to transaction context. -- Regards, Kees Nuyt

[sqlite] Encrypt the SQL query

7;s almost correct, you also have to buy a perpetual license for the proprietary SEE extension: http://www.sqlite.org/support.html http://www.hwaci.com/sw/sqlite/see.html -- Regards, Kees Nuyt

[sqlite] NuGet problem

checked the documentation, and they really look rather different. If all you need is the sqlite3 C API, the Precompiled Binaries for Windows on the download page provide just that: http://www.sqlite.org/download.html -- Regards, Kees Nuyt

[sqlite] a sqlite database error

on has to be more specific. - What program did you use? SQLite command line tool? - What SQL statement did you execute when the error occured? - What was the exact error message? - What is the schema of the database? - Any other related circumstances you can think of. -- Regards, Kees Nuyt

[sqlite] Performance issue with CTE

is obsolete but still works) -- Regards, Kees Nuyt

[sqlite] Odd download file names

S? ?VERSION? ?FILES...? In fact you can have multiple checkouts at the same time, each in a dedicated directory, each for a different point on the timeline, selected by the ?VERSION? (sha1-hash or symbolic name) of the checkin/commit you want to follow. -- Regards, Kees Nuyt

[sqlite] Odd download file names

sqlite3.c make tclsqlite3.c gcc ${CFLAGS} -o sqlite3 sqlite3.c \ ../../src/sqlite3/src/shell.c make sqlite3_analyzer Your build can grab the version in the generated sqlite3.h in the build directory: #define SQLITE_VERSION "3.8.12" #define SQLITE_VERSION_NUMBER 3008012 #define SQLITE_SOURCE_ID "2015-09-26 17:44:59 33404b2029120d4aabe1e25d484871810777e934" Hope this helps. -- Regards, Kees Nuyt

[sqlite] Any database unique ID across multiple connections ?

e day I need the same about >":memory:" databases, bad things are gonna to happen) >Maybe there is already a database identifier in the SQLite API and I missed it >? I think https://www.sqlite.org/pragma.html#pragma_application_id is applicable. -- Regards, Kees Nuyt

[sqlite] vdbeUnbind return occasionally Error

of RAM. What could I do here in order to free > memory after sqlite3_step() for further operations. The simplest way to reduce memory footprint is to tune page_size and cache_size with the apropriate PRAGMAs. -- Regards, Kees Nuyt

[sqlite] How to know when a sqlite3_stmt has been recompiled ?

t;rc = sqlite3_exec(db, "ALTER TABLE test ADD COLUMN data DEFAULT >'missing'", NULL, NULL, NULL); >... >rc = sqlite3_step(stmt); >// how to know that the column count is not good anymore ? http://www.sqlite.org/rescode.html#schema -- Regards, Kees Nuyt

[sqlite] Query

gt; >How can i handle this? Please let me know. I think you are looking for: INSERT INTO employee (eid,name) VALUES (3,'manash'),(2.'ram'),(1,'rahim'); http://www.sqlite.org/lang_insert.html -- Regards, Kees Nuyt

[sqlite] order by not working in combination with random()

recursive query in SQB take 6 min, > on other IDEs it would be less than 2 min. > > My $0.02 For exactly that reason I would advise everyone to use the sqlite3 command line tool for performance comparisons in this mailing list. -- Regards, Cordialement, Groet, Kees Nuyt

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

s done it), but in my opinion it does not belong in the core engine that SQLite is. It's lite for good reasons. It even would be fine to me if all ALTER TABLE features would be removed. -- Regards, Kees Nuyt

[sqlite] Enhance the SELECT statement?

i3 (seqno INTEGER PRIMARY KEY NOT NULL); WITH RECURSIVE generate AS ( SELECT 1 AS seqno UNION ALL SELECT seqno+1 FROM generate WHERE seqno < 10) INSERT INTO table_of_i3 (seqno) SELECT seqno FROM generate ORDER BY seqno; PRAGMA table_info(table_of_i3); .dump -- Regards, Cordialement, Groet, Kees Nuyt

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

On Thu, 6 Aug 2015 10:17:43 -0500, John McKown wrote: > Too bad that SQLite does not implement updatable views. Sometimes a similar construct as updatable views can be obtained with an INSTEAD OF trigger. -- Regards, Kees Nuyt

[sqlite] Schema-less JSON SQLite DB?

); INSERT INTO T1 (anint) VALUES (1); INSERT INTO T1 (anint) VALUES ('two'); > I don't want to take up your time, so if there's a document I can read > about it'd be great. https://sqlite.org/datatype3.html All docs: https://sqlite.org/docs.html -- Regards, Cordialement, Groet, Kees Nuyt

[sqlite] Compiling sqlite as as library

le the sqlite3 command line tool is build using: gcc ${CFLAGS} -o sqlite3 sqlite3.c src/shell.c More info: http://www.sqlite.org/howtocompile.html I hope this helps. If you need more detailed info, please reply with the specifications of your platform. -- Regards, Kees Nuyt

[sqlite] Fault on transaction begin, end, and rollback statements

ed it from being overwritten with operator overloading the '=' sign. >I did this to ensure the safety of the prepared sqlite3_stmt*. Is there any chance the statement is _step()ped, _finalize()d and then re-used? To be able to use a statement multiple times, it should not be finalized but rather _reset(). >Thank you for your help, >Ch? HTH -- Regards, Kees Nuyt

[sqlite] Problems in reading a record containing a blob

ed the app on, but it does not work on > the seventh tablet with the same OS version? > * What is the solution to this problem? Check free RAM before extracting an image. Maybe: run garbage collection and/or push other apps to background. -- Regards, Cordialement, Groet, Kees Nuyt

[sqlite] in Linux system, 2 threads can access 2 separate databases (created by sqlite3) through sqlite3?

; miles zhang > 2015-05-21 -- Regards, Kees Nuyt

[sqlite] ALTER TABLE ADD COLUMN

On Thu, 21 May 2015 12:45:41 +0200, "Christoph P.U. Kukulies" wrote: >Am 21.05.2015 um 10:00 schrieb Kees Nuyt: >> On Thu, 21 May 2015 09:40:53 +0200, "Christoph P.U. Kukulies" >> wrote: >> >>> Am 21.05.2015 um 09:25 schrieb Hick Gunter: &

[sqlite] ALTER TABLE ADD COLUMN

sql column with your preferred layout. It is dangerous, so read the warning, make backups first and test the result thoroughly! -- Regards, Kees Nuyt

[sqlite] AUTOINC vs. UUIDs

_sequence table. $ sqlite3 t2.sqlite SQLite version 3.8.11 2015-05-20 00:15:27 Enter ".help" for usage hints. sqlite> create table t(id integer primary key autoincrement, tx text); sqlite> insert into t (tx) values ('one'),('two'); sqlite> select * from sqlite_sequence; t|2 sqlite> -- Regards, Kees Nuyt

[sqlite] Limit size of write-ahead log file

al_autocheckpoint=N; and PRAGMA database.wal_checkpoint(); ? http://www.sqlite.org/pragma.html#pragma_wal_autocheckpoint -- Regards, Kees Nuyt

[sqlite] Multiple Prepared Statements

e() the statement, you can just _reset() it to finish the _step() loop and keep the statement around for reuse (with new bindings) later. _reset() will free the resources that are allocated at the first _step(). -- Regards, Kees Nuyt

[sqlite] sqlite3 and Unicode

20 49 4e 54 4f 20 22 74 31 22 020 20 56 41 4c 55 45 53 28 31 2c 27 c3 a9 c3 a9 6e 040 27 29 3b 0a 044 -- Regards, Kees Nuyt

[sqlite] Did A Recent Windows & Update Affect SQLite???

Lightroom * Exclude directories with sqlite databases / Lightroom catalogs from all viruscanners. If that is not possible, (temporarily) disable all real-time virusscanners -- Regards, Kees Nuyt

[sqlite] Releasing a read (SHARED) lock

the state/context of a statement. Aditionally, any BEGIN TRANSACTION should be paired with a COMMIT or ROLLBACK. >Cheers, > > - Barry -- Regards, Cordialement, Groet, Kees Nuyt

Re: [sqlite] Bug in SQLite FLOAT values

sage hints. sqlite> create table t3 (id INTEGER PRIMARY KEY, lat REAL, lon REAL); sqlite> insert into t3 (id,lat,lon) VALUES (1,1.234567890123,5.6789012345678); sqlite> select printf('id:%3d, latitude: %9.6f, longitude: %9.6f',id,lat,lon) from t3; id: 1, latitude: 1.234568

Re: [sqlite] expected performance of selecting large numbers of records

version reported by SELECT sqlite_version(); has the features I mentioned above (WITHOUT ROWID and WAL mode); If necessary, compile your own library from source, http://www.sqlite.org/download.html (bottom) Hope this helps. -- Regards, Kees Nuyt

Re: [sqlite] Uncached performance

an_default; PRAGMA cache_size= .. ; -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

  1   2   3   4   5   6   7   8   9   >