Re: [sqlite] Does VACUUM imply REINDEX?

2020-02-19 Thread Olivier Mascia
> 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

[sqlite] Does VACUUM imply REINDEX?

2020-02-19 Thread Olivier Mascia
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

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

2020-01-30 Thread Olivier Mascia
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.

2019-09-26 Thread Olivier Mascia
g/draft/rbu.html 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

2019-09-08 Thread Olivier Mascia
s 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

2019-09-02 Thread Olivier Mascia
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

2019-08-12 Thread Olivier Mascia
, 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

2019-08-12 Thread Olivier Mascia
ubject, 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@mailinglists.sqlite.org

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

2019-08-09 Thread Olivier Mascia
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?

2019-08-09 Thread Olivier Mascia
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

2019-08-07 Thread Olivier Mascia
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)

2019-08-06 Thread Olivier Mascia
g, 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

2019-08-06 Thread Olivier Mascia
.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.sqlite.org http://mailin

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

2019-08-06 Thread Olivier Mascia
s 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 vriendelijke g

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

2019-08-06 Thread Olivier Mascia
> 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

2019-08-06 Thread Olivier Mascia
ture 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.sqlite.org http://mailinglists.sqlite.or

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

2019-08-06 Thread Olivier Mascia
> 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?

2019-08-06 Thread Olivier Mascia
nd 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 salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia https://www.integral.b

Re: [sqlite] mode insert dumps

2019-08-02 Thread Olivier Mascia
, 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, Olivier

Re: [sqlite] Large database backup

2019-08-01 Thread Olivier Mascia
ing 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.

2019-07-31 Thread Olivier Mascia
ndelijke 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

2019-07-31 Thread Olivier Mascia
d 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.

2019-07-30 Thread Olivier Mascia
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.

2019-07-30 Thread Olivier Mascia
; 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.

2019-07-30 Thread Olivier Mascia
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 ...

2019-07-18 Thread Olivier Mascia
;) > ) 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_sometimes_conta

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

2019-06-14 Thread Olivier Mascia
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?

2019-06-13 Thread Olivier Mascia
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

2019-05-04 Thread Olivier Mascia
, "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@mailinglists.sqlite.org http://mail

Re: [sqlite] Feature request, sqlite3_stmt_action

2019-03-28 Thread Olivier Mascia
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

2019-03-14 Thread Olivier Mascia
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

2019-02-17 Thread Olivier Mascia
cedure. -- 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 ..

2019-01-28 Thread Olivier Mascia
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

2018-12-12 Thread Olivier Mascia
fault 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 ___ sqlite-

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

2018-12-08 Thread Olivier Mascia
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.

2018-11-29 Thread Olivier Mascia
hile 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, Olivier Mascia ___

Re: [sqlite] sqlite3 Asynchronous I/O

2018-11-28 Thread Olivier Mascia
o 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

2018-11-08 Thread Olivier Mascia
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 groeten, Olivi

Re: [sqlite] Optmize queries on ranges

2018-10-26 Thread Olivier Mascia
m 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

2018-10-23 Thread Olivier Mascia
UPDATE (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

2018-10-22 Thread Olivier Mascia
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

2018-10-22 Thread Olivier Mascia
lleures salutations, Met vriendelijke groeten, Olivier Mascia > sqlite3 *mod_init() { > >/* Open database */ >//rc = sqlite3_open("test.db", >db); >lastError = sqlite3_open_v2("test.db", , SQLITE_OPEN_READWRITE | > SQLITE_OPEN_CREATE | SQLITE_OPEN

Re: [sqlite] segmentation fault in sqlite api call

2018-10-21 Thread Olivier Mascia
(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 instead of fil

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT

2018-10-16 Thread Olivier Mascia
> 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 to &

[sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT

2018-10-16 Thread Olivier Mascia
ons, 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

2018-08-22 Thread Olivier Mascia
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

2018-08-13 Thread Olivier Mascia
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

2018-06-30 Thread Olivier Mascia
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 groe

Re: [sqlite] column types and constraints

2018-06-30 Thread Olivier Mascia
so 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

2018-06-30 Thread Olivier Mascia
t; 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

2018-06-26 Thread Olivier Mascia
dow-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...

2018-06-13 Thread Olivier Mascia
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 '

2018-06-11 Thread Olivier Mascia
re 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 groeten, Olivier Mascia _

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

2018-06-08 Thread Olivier Mascia
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

2018-06-05 Thread Olivier Mascia
/ -- 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

2018-06-05 Thread Olivier Mascia
e 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 again. -- Best R

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

2018-06-04 Thread Olivier Mascia
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 ___ sqlite-users mailing l

Re: [sqlite] This is driving me nuts

2018-05-31 Thread Olivier Mascia
e 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. -- Best Regard

Re: [sqlite] This is driving me nuts

2018-05-31 Thread Olivier Mascia
g 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 http://mailinglis

Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread Olivier Mascia
F", 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 the in

[sqlite] 3.24 draft - upsert

2018-05-09 Thread Olivier Mascia
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

2018-05-08 Thread Olivier Mascia
am filtering 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 groet

Re: [sqlite] This list is getting spammed again

2018-05-08 Thread Olivier Mascia
change their IPs of course. 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@m

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

2018-05-01 Thread Olivier Mascia
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-us

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

2018-05-01 Thread Olivier Mascia
, 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

2018-04-25 Thread Olivier Mascia
ct-over-clause-transact-sql?view=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-u

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

2018-04-17 Thread Olivier Mascia
rds, 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] Header corruption

2018-04-17 Thread Olivier Mascia
in the right 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) ___ sq

Re: [sqlite] without rowid and secondary indexes

2018-04-10 Thread Olivier Mascia
> Le 10 avr. 2018 à 18:25, Clemens Ladisch <clem...@ladisch.de> 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 logi

Re: [sqlite] without rowid and secondary indexes

2018-04-10 Thread Olivier Mascia
SHEETS USING 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

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

[sqlite] without rowid and secondary indexes

2018-04-10 Thread Olivier Mascia
? 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?

2018-04-09 Thread Olivier Mascia
> Le 9 avr. 2018 à 11:39, Dr. Mucibirahman İLBUĞA <mucip.ilb...@gmail.com> 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

Re: [sqlite] UPPER function depends on Locale?

2018-04-09 Thread Olivier Mascia
the end this 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, nullptr, nullptr)

Re: [sqlite] 3.23 Windows x64 dll

2018-04-02 Thread Olivier Mascia
delijke 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_CONFIG_MULTITHREAD needed for connection pool?

2018-03-27 Thread Olivier Mascia
aviour 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, Meilleures salutations, M

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

2018-03-27 Thread Olivier Mascia
-> '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?

2018-03-26 Thread Olivier Mascia
urrent read/write transactions using > 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

2018-03-24 Thread Olivier Mascia
h 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 http://mailingl

Re: [sqlite] The upcoming 3.23.0 release

2018-03-22 Thread Olivier Mascia
including 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,

Re: [sqlite] UPSERT

2018-03-19 Thread Olivier Mascia
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, Olivier Mascia ___

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

2018-03-18 Thread Olivier Mascia
the serialized format 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 vriendel

[sqlite] sqlite3_serialize / sqlite3_deserialize (3.23.0 draft)

2018-03-18 Thread Olivier Mascia
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

2018-03-16 Thread Olivier Mascia
n helper layers to prepare 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 _

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

2018-03-02 Thread Olivier Mascia
idence, 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

2018-03-01 Thread Olivier Mascia
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=TRUE returns an "App Application Error" page. Thanks, -- Best Regards, Meilleures salutations

Re: [sqlite] Vetting SQLite

2018-02-06 Thread Olivier Mascia
ards, 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] Typo on https://www.sqlite.org/draft/c3ref/c_trace.html

2018-01-18 Thread Olivier Mascia
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.org ht

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

2017-12-26 Thread Olivier Mascia
, 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] Off-topic: is fossil 2.4 (windows binary) broken in some way?

2017-12-26 Thread Olivier Mascia
> Le 27 déc. 2017 à 00:13, Warren Young <war...@etr-usa.com> a écrit : > > On Dec 26, 2017, at 3:35 PM, Olivier Mascia <o...@integral.be> wrote: >> >> Could it be that something is broken with fossil 2.4 windows binary (as >> available from fossil-scm.org

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

2017-12-26 Thread Olivier Mascia
> Le 26 déc. 2017 à 23:46, Olivier Mascia <o...@integral.be> a écrit : > >> >> Le 26 déc. 2017 à 23:35, Olivier Mascia <o...@integral.be> a écrit : >> >> Dear all, >> >> Could it be that something is broken with fossil 2.4 windows

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

2017-12-26 Thread Olivier Mascia
> Le 26 déc. 2017 à 23:35, Olivier Mascia <o...@integral.be> 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 th

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

2017-12-26 Thread Olivier Mascia
— 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?

2017-12-01 Thread Olivier Mascia
> Le 1 déc. 2017 à 15:00, Clemens Ladisch <clem...@ladisch.de> 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_REMIND

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

2017-12-01 Thread Olivier Mascia
> Le 1 déc. 2017 à 14:58, Clemens Ladisch <clem...@ladisch.de> 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) >&

[sqlite] Automatic index, despite existing index?

2017-12-01 Thread Olivier Mascia
he 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 list

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

2017-12-01 Thread Olivier Mascia
, 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

2017-11-30 Thread Olivier Mascia
ormance 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-users mailing l

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

2017-11-26 Thread Olivier Mascia
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 <o...@integral.be>

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

2017-11-25 Thread Olivier Mascia
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 Mascia

  1   2   3   >