Re: [sqlite] Does VACUUM imply REINDEX?

> Le 19 févr. 2020 à 17:26, Simon Slavin a écrit : > > On 19 Feb 2020, at 4:18pm, Richard Hipp wrote: > >> There is no benefit to running >> ANALYZE after running VACUUM if the ANALYZE data (the content of the >> sqlite_stat1 table) is still up-to-date. > > However, if you have a yearly mainte

[sqlite] Does VACUUM imply REINDEX?

Hello, As part of a rare database "maintenance"... Does VACUUM, in essence, implies whatever actions REINDEX would do? Would REINDEX before VACUUM make any more sense? And what about ANALYZE? Would it be wise or useless, to run it after VACUUM? So... Would "VACUUM; REINDEX; ANALYZE;" make any se

Re: [sqlite] Where is the journal file for locking_mode=EXCLUSIVE?

ocking_mode=persist, which does not exists. ⏤ Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit freundlichen Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.30.0 in about two weeks.

still says: • The target database may not contain indexes on expressions. — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org htt

Re: [sqlite] SQLITE and the memory

Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] char(0) with SQLite

lleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SHARED lock vs READ transaction

, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia (from mobile device) Le 12 août 2019 à 13:19, Kira Backes a écrit : >> There is no such thing as a "READ transaction". > > Could you please open the following google query: > > https://www.google.com/sea

Re: [sqlite] SHARED lock vs READ transaction

-simplified view at the subject, but it should get you the big picture. The documentation has all the details. — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users

Re: [sqlite] COMMIT, what locking behaviour when current lock is merely SHARED?

that part. In that case, it just drops the > SHARED lock. > -- > D. Richard Hipp > d...@sqlite.org Thanks for the confirmation. :) — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia __

[sqlite] COMMIT, what locking behaviour when current lock is merely SHARED?

Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with int and DateTime types with EntityFrameWorkCore.Sqlite

, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] THREADSAFE (1, SERIALIZED) vs (2, MULTITHREAD)

d in WAL all day long, that I tend to forget the details when not using WAL. You did well to correct my assertion which without context, is misleading, another word for wrong. Thanks. :) — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___

Re: [sqlite] 3.29.0 .recover command

recover after the 3.29.0 release, so I might first have to rebuild using head of trunk. — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists

Re: [sqlite] THREADSAFE (1, SERIALIZED) vs (2, MULTITHREAD)

IN. And this will last until they COMMIT (or ROLLBACK as they are anyway supposed to be readers). If not using explicit transactions, each statement will run independently in an auto BEGIN [DEFERRED] / auto COMMIT transaction. — Best Regards, Meilleures salutations, Met

Re: [sqlite] Probable bug with SQLITE_DQS=0 regarding shell .schema command?

> Le 6 août 2019 à 12:45, Richard Hipp a écrit : > > On 8/6/19, Olivier Mascia wrote: >> Using 3.29.0 with SQLITE_DQS. > > Is this the problem that was fixed here: > https://www.sqlite.org/src/timeline?c=fcd937d9786a82ef Indeed. — Best Regards, Meilleures salut

[sqlite] 3.29.0 .recover command

st exercising the .recover feature for learning, using a db I'm not suspecting of anything. — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.

Re: [sqlite] Probable bug with SQLITE_DQS=0 regarding shell .schema command?

> Le 6 août 2019 à 10:27, Olivier Mascia a écrit : > > Using 3.29.0 with SQLITE_DQS. > > sqlite3 test1.db "create table A(I integer);" > sqlite3 test2.db "create table B(J integer);" > > sqlite3 test1.db > sqlite> .schema > CREATE TABLE

[sqlite] Probable bug with SQLITE_DQS=0 regarding shell .schema command?

etach cloud; sqlite> I don't know yet if anything else than shell .schema command is affected. At least, I can run statements referencing cloud.B without issue. BTW, just removed my -DSQLITE_DQS=0 and things back to normal with 3.29. — Best Regards, Meilleures saluta

Re: [sqlite] mode insert dumps

mude_anno, mude_numero from catdaemo; > INSERT INTO table VALUES(2019,1161); Besides the other answers focused on using .mode insert more precisely, the .dump command might prove useful too. — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen

Re: [sqlite] Large database backup

on when outputting through a custom VFS. — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

alutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] sqlite3_exec without ubiqitous text conversions

ly store the string 'something' because it can't be converted back and forth between text and integer. — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

; BEGIN and its first read? What do I miss here? — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia https://www.integral.be ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://maili

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

busy handler when executing BEGIN IMMEDIATE. Even PASSIVE checkpointing will run free (albeit not as completely) with readers ongoing. — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I can insert multiple rows with the same primary key when one of the value of the PK is NULL ...

esman") > ) WITHOUT ROWID; You might prefer adding an explicit NOT NULL on both "client" and "salesman" columns. There is an historical reason why SQLite accepts NULL for primary key column(s). https://www.sqlite.org/quirks.html#primary_keys_can_somet

[sqlite] INSERT INTO ... ON CONFLICT(...) DO UPDATE ...

vriendelijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [SPAM?] Re: [EXTERNAL] Re: Should SQLite distinguish between +0.0 and -0.0 on output?

delijke groeten, Mit besten Grüßen, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting the week of the month from strftime or date functions

ar when stating, for instance, "expect delivery within week #13". — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia https://www.integral.be ___ sqlite-users mailing list sqlite-users@maili

Re: [sqlite] Feature request, sqlite3_stmt_action

need that I did not grasp reading this request. What stops you from parsing the beginning of the statement text to decide if it is a select, update, delete or insert? -- Best regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia (fro

Re: [sqlite] Developer questions about the Online Backup API

etection of writes by other connections kicks in anyway and force the backup to needlessly restart? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ON CONFLICT with partial indexes

/validation procedure. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Minor concern with alter table .. rename to ..

xist, though I do not yet understand why. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

default journal mode might be perfectly adequate. But surely you chose WAL mode for some specific reason. I just don't instantly spot which one from your report. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia _

Re: [sqlite] SQLITE gives incorrect results for 'NOT IN' query if partial index exists

rom bar WHERE x NOT IN (SELECT y from foo WHERE 1); -- OK, no results -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Strange query results.

4 > 3|6|4 > > While it should only have returned the first row. Just like this? select config_package, config_flags, (config_flags & 4) from config where (config_flags & 4) != 4; 1|2|0 -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivie

Re: [sqlite] sqlite3 Asynchronous I/O

right thing to use, would help people understand and guide you to a proper solution. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Segmentation Fault When Using Window Function

Hello, Without me knowing if it is related to your problem, I wonder what's the intent here? > SELECT `artists`.* > FROM `artists` > INNER JOIN `artists` AS 'b' ON (`b`.`id` = `artists`.`id`) -- Best Regards, Meilleures salutations, Met vriendelijke

Re: [sqlite] Optmize queries on ranges

e from ranges > where (? between start and end) becomes: SELECT value FROM ranges where (? between start AND start+range); -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] INSERT OR REPLACE and foreign keys

(not REPLACE) and you have lead to think the OR REPLACE implemented by SQLite is that feature. It is not. The more general ON CONFLICT ... DO ... is what you're after. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia _

[sqlite] SQLITE_ENABLE_DBSTAT_VTAB

Hello, Does compiling SQLite with SQLITE_ENABLE_DBSTAT_VTAB has a performance impact of any sort? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing list sqlite-users

Re: [sqlite] segmentation fault in sqlite api call

gards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia > sqlite3 *mod_init() { > >/* Open database */ >//rc = sqlite3_open("test.db", &dbObj->db); >lastError = sqlite3_open_v2("test.db", &db, SQLITE_OPEN_READWRITE | > SQL

Re: [sqlite] segmentation fault in sqlite api call

ers at each run (step). Hope it will help. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia > Le 21 oct. 2018 à 18:54, Ratheendran R a écrit : > > Hi, > > I am a embedded engineer and new to sqlite,we want to use sqlite for our > local storage

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT

> Le 16 oct. 2018 à 16:39, Olivier Mascia a écrit : > > https://www.sqlite.org/compile.html#enable_update_delete_limit ... > I can manage to run the build tools properly, for the target sqlite3.c or > sqlite_analyzer.exe for instance. I'm just not confident yet as to where

[sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT

utations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unsigned

rds, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia (from mobile device) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] No unicode characters in sqlite3 console prg

onfirming the actuel text file data is UTF-8 (which you could validate by other ways, using a text editor properly supporting the encoding). -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] column types and constraints

t; upgrade. SQLite is the only "fire-and-forget" weapon out there, I feel like > that feature is worth a few TYPE pains - but that's just my feeling and it > might well be antiquated. +1: fully shared feeling. :) -- Best regards, Meilleures salutations, Met vriendelijke

Re: [sqlite] column types and constraints

only when the type contains the words CHAR, TEXT or CLOB. STRING, which you use for your example, is even specifically warned about (being of NUMERIC affinity). https://www.sqlite.org/datatype3.html#determination_of_column_affinity -- Best Regards, Meilleures salutations, Met vrien

Re: [sqlite] column types and constraints

olumn. > d) No, as DECIMAL ist compatible to NUMERIC. Fine. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] LIMIT

27;begin-concurrent-pnu' branch and this 'exp-window-functions' branch. :) -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mailing list shutting down...

-- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Insert with an '

re the email address comes from. I'm sure there is plenty of documentation with your language binding for SQLite on how to prepare, bind, execute. Instead of building a final statement as a complete string and then execute it. -- Best Regards, Meilleures salutations, Met vriendelijke groete

Re: [sqlite] [EXTERNAL] Selecting multiple similar columnname.

al tables? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reset the cursor

ix. // -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reset the cursor

ou will then be able to bind the table name after prepare without using printf, which is good protection against code injection depending from where your tableName value comes from and will allow you to bind new table names and re-run without preparing the statement agai

Re: [sqlite] Sqlite delete too slow in 4 GB database

Hello, > Sqlite delete too slow in 4 GB database What does: 'pragma secure_delete;' and 'pragma auto_vacuum;' say, on that db? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sq

Re: [sqlite] This is driving me nuts

put the one minute sleep right after the very first step of the second loop has run. for (int i=0; sqlite3_step(desc)==SQLITE_ROW; i++) { if (i == 0) Sleep(6); if (i%Gap==0) std::cout << FreeMBs() << std::endl; } You get the idea. -- B

Re: [sqlite] This is driving me nuts

d and 2) getting to the bottom-line of this would be much easier with source code of Windows. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org ht

Re: [sqlite] 3.24 draft - upsert

t;, 10, 20.0, ..., "TEXT");// bind + exec st.run("DEF", "GHI", 11, 18.0, ..., "OTHER"); // new bind + new exec /* Pre 3.24 implementation used two hidden prepared statement behind (one update and one insert, running

[sqlite] 3.24 draft - upsert

me." Why using 'excluded' wording for this? Couldn't 'new' be used as qualifier instead, akin to trigger syntax? Might be more coherent, and shorter for the parser. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___

Re: [sqlite] This list is getting spammed again

iltering on my email services, which you can't really live without today, there is not much annoyance and it makes for an easier workflow than to subscribe and visit tens of forums. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia __

Re: [sqlite] This list is getting spammed again

e. Filtering out these IPs is probably done at the list level too, but won't help. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://

Re: [sqlite] Configuring csv extension to use '; ' as column delimiter instead of ',' ?

anguages knowledge to do it easily or more importantly to do it right. Nothing really important. Just wanted to trigger some thinking. Again, thank you. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Configuring csv extension to use '; ' as column delimiter instead of ',' ?

ions, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Window functions

sql-server-2017 https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions004.htm#SQLRF06174 -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

ions, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Header corruption

order there is no file descriptor re-use syndrome to fear, because the closesocket() rightfully comes as the very last step. -- Best regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia (from mobile device) ___ sqlite-users mai

Re: [sqlite] without rowid and secondary indexes

> Le 10 avr. 2018 à 18:25, Clemens Ladisch a écrit : > > Olivier Mascia wrote: >> Would you mean: >> >> select NAME,count(NAME) from SHEETS where SHEET>? group by NAME having NAME >> is not NULL; >> >> is more logically appropriate? >

Re: [sqlite] without rowid and secondary indexes

NG COVERING INDEX SHEETS_NAME (NAME>?) -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] without rowid and secondary indexes

by NAME having SHEET>? and NAME is not NULL; -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia > Le 10 avr. 2018 à 12:36, Richard Hipp a écrit : > > Every index is composed of the columns being indexed followed by the > primary key of the table.

[sqlite] without rowid and secondary indexes

? create index if not exists SHEETS_NAME on SHEETS(NAME); -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

Re: [sqlite] UPPER function depends on Locale?

> Le 9 avr. 2018 à 11:39, Dr. Mucibirahman İLBUĞA a > écrit : > > 09.04.2018 11:08 tarihinde Olivier Mascia yazdı: >> Is it better / simpler to write your own UPPER/LOWER specialised or to >> simply rebuild SQLite with ICU, I have too few details on your needs / go

Re: [sqlite] UPPER function depends on Locale?

is one would end up being added through a call like this (hope I did not get it wrong by synthesising it from head based on what the framework behind would have called): sqlite3_create_function_v2(db, "now", -1, 0, nullptr, sql_now, nullptr, nul

Re: [sqlite] 3.23 Windows x64 dll

> Le 2 avr. 2018 à 16:48, David Raymond a écrit : > > Is there no 64 bit precompiled dll available for Windows with this release? It looks like it is available: https://www.sqlite.org/download.html -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivi

Re: [sqlite] SQLITE_CONFIG_MULTITHREAD needed for connection pool?

t behaviour of your SQLite instance you link with (if not compiled by you), you may want to pass SQLITE_OPEN_FULLMUTEX on each sqlite3_open_v2 calls to ensure serialized mode is in effect. https://www.sqlite.org/threadsafe.html -- Best Regards, Meille

[sqlite] ext/icu/README.txt - typo?

> lower('abc') -> 'ABC' Isn't this sample beautifully reversed? :) -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] what is server-process-edition?

> page-level-locking provided that: > > • All clients are in the same process, and > • The application uses "PRAGMA synchronous=off. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia _

Re: [sqlite] Beta-testing success story! Was: The upcoming 3.23.0 release

t int. Both previous warnings about chmod/_chmod and unlink/_unlink have been taken care of: thanks! -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org ht

Re: [sqlite] The upcoming 3.23.0 release

any > headers in code that uses the original POSIX names. See: https://docs.microsoft.com/en-us/cpp/c-runtime-library/compatibility Adding a #define _CRT_NONSTDC_NO_WARNINGS to shell.c might indeed be a nice way to go. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Oliv

Re: [sqlite] UPSERT

tend to weight on the 'Lite' part of the name 'SQLite'. I would have like to have it in SQLite at some point in past time (would have made the transition easier), though learned easily to live without it. :) -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Oli

Re: [sqlite] sqlite3_serialize / sqlite3_deserialize (3.23.0 draft)

quite compact, or full of void unused space on 'pages'? (that obviously a good external compression would get rid of). Or said differently, how far or close is the serialized format to the on-disk SQLite file format? Thanks, -- Best Regards, Meilleures salutations, Met

[sqlite] sqlite3_serialize / sqlite3_deserialize (3.23.0 draft)

lijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] UPSERT

are the UPDATE in a syntactic way close to the INSERT INTO table(X,Y,Z) values(V1,V2,V3). Only have to account for the WHERE clause of the UPDATE. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

ence, but want to be sure I got the model right. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

entation being drafted to answer these, but attempting to find it using the search button on www.sqlite.org/draft, the request https://www.sqlite.org/draft/search?s=d&q=TRUE returns an "App Application Error" page. Thanks, -- Best Regards, Meilleures salutat

Re: [sqlite] Vetting SQLite

x27;s database in Mac Office 365 is a SQLite database[1]. Visual Studio 2017 (it started with Visual Studio 2015 and was an opt-in with the next before release) uses it too. Have a look in the (hidden-attributed) folder .vs where you have .sln files... -- Best Regards, Meilleures salutations, M

[sqlite] Typo on https://www.sqlite.org/draft/c3ref/c_trace.html

ps://www.sqlite.org/draft/c3ref/trace_v2.html <https://www.sqlite.org/draft/c3ref/trace_v2.html>. :) -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.o

Re: [sqlite] Off-topic: is fossil 2.4 (windows binary) broken in some way?

> Le 27 déc. 2017 à 00:39, Warren Young a écrit : > > Until drh ships Fossil 2.5, you’ll have to either stick with that workaround > or build your own fossil.exe against the trunk code. Makes it clear. Thanks. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Ol

Re: [sqlite] Off-topic: is fossil 2.4 (windows binary) broken in some way?

> Le 27 déc. 2017 à 00:13, Warren Young a écrit : > > On Dec 26, 2017, at 3:35 PM, Olivier Mascia wrote: >> >> Could it be that something is broken with fossil 2.4 windows binary (as >> available from fossil-scm.org)? > > It works for me. > > Her

Re: [sqlite] Off-topic: is fossil 2.4 (windows binary) broken in some way?

> Le 26 déc. 2017 à 23:46, Olivier Mascia a écrit : > >> >> Le 26 déc. 2017 à 23:35, Olivier Mascia a écrit : >> >> Dear all, >> >> Could it be that something is broken with fossil 2.4 windows binary (as >> available from fossil-scm.org)? &g

Re: [sqlite] Off-topic: is fossil 2.4 (windows binary) broken in some way?

> Le 26 déc. 2017 à 23:35, Olivier Mascia a écrit : > > Dear all, > > Could it be that something is broken with fossil 2.4 windows binary (as > available from fossil-scm.org)? > When attempting fossil ui the pages served seem to be missing things right > after opening

[sqlite] Off-topic: is fossil 2.4 (windows binary) broken in some way?

— Logout ... I suppose I have something setup wrong, but it all looked so simple... -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] Automatic index, despite existing index?

> Le 1 déc. 2017 à 15:00, Clemens Ladisch a écrit : > > Olivier Mascia wrote: >> 20171201 120319.404 284: automatic index on REMINDER(USER_LOGON) >> >> Here is that part of the schema: >> >> CREATE INDEX IX_REMINDER_USER on REMINDER(USER_LOGON); >&

Re: [sqlite] Automatic index on mi(ID) or tal(ID)

> Le 1 déc. 2017 à 14:58, Clemens Ladisch a écrit : > > Olivier Mascia wrote: >> I'm seeing such things in my error.log out of SQLite 3.21.0 (but I am sure >> it was already the case with 3.20): >> >> automatic index on tal(ID) >> automatic index on

[sqlite] Automatic index, despite existing index?

n the API to get a pointer to the statement which is executing while any or all of the messages are emitted? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing

[sqlite] Automatic index on mi(ID) or tal(ID)

om any abnormal behaviour, it just caught my eye). -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite and docker performance question

ur/performance of SQLite itself? The test (creation of this small db) is so small that timing it has a large potential for variance due to the system itself. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia ___ sqlite-

[sqlite] Checkpointing (PASSIVE) at every close() - Was: Get wal page count out of context of wal_hook?

e count of wal pages; to use it before each attachment close() and decide wether or not I take this opportunity to first run a passive checkpoint. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia > Le 25 nov. 2017 à 09:21, Olivier Mascia a écrit : > >

[sqlite] Get wal page count out of context of wal_hook?

Dear all, I'm looking for a mean to query the current WAL page count (at other times than at commit through the wal_hook() callback). Did I overlooked something in the C API which would allow me to query this? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier M

  1   2   3   >