[sqlite] last_insert_rowid() and changes() per statement instead of per connection?

ir private handles is a better world, without major performance impact. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] last_insert_rowid() and changes() per statement instead of per connection?

at statement ? for partial update of a row. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] last_insert_rowid() and changes() per statement instead of per connection?

nhancement for SQLite. We will anyway surely buy some yearly technical support, or at the very least maintenance subscription, which I guess will streamline the introduction of enhancement requests. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/o

[sqlite] Maybe a typo in documentation...

cific purpose. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] The Lock-Byte Page

Hello, I'm referring to paragraph 1.3 of https://www.sqlite.org/fileformat2.html about the Lock-Byte page.

[sqlite] The Lock-Byte Page

tations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] The Lock-Byte Page

n > size. All the (main?) platforms support locking regions of a file that have > not yet been populated. I suspected this, but I didn't have to use file locking APIs for so many years (lucky me!), so I really wasn't sure at all about this. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] JSON1 Extension should appear on top level doc page

N SQL Functions SQL functions for creating, parsing, and querying JSON content. :) -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] SQLITE_DEFAULT_WORKER_THREADS & SQLITE_MAX_WORKER_THREADS

ADS>SQLITE_MAX_WORKER_THREADS # undef SQLITE_DEFAULT_WORKER_THREADS # define SQLITE_DEFAULT_WORKER_THREADS SQLITE_MAX_WORKER_THREADS #endif Thank you very much, -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] SQLITE_IOERR_ACCESS with 3rd party DLL

ts of 'their' DLL (using depends.exe for instance)? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] SQLITE_IOERR_ACCESS with 3rd party DLL

clearly see how, for now. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] sqlite error 25 during bind

paths, just to be clear the prepared statement is really the one you expect. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Is it possible that dropping a big table takes very long

eign_keys = 0; > > Dan. > Not sure if this was already discussed here this last days (I don't think so for having quickly browsed this discussion), I would suggest to check these on the filled-in DB before delete: PRAGMA compile_options; (has SQLITE_SECURE_DELETE been set for compiling the library?) PRAGMA auto_vacuum; (is it set to 0 or else?) -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] UPDATE/open/close blocked while executing SELECT

journal mode, I see no issue similar to what you report in our own programming. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] UPDATE/open/close blocked while executing SELECT

short experience shows. You can even have one writer do a short-lived transaction while you have a number of readers right in the middle of select(s), that won't be a problem, wal is your friend for this. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Is it possible that dropping a big table takes very long

and see how it impacts your timings. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Bug: Successfully committed transaction rolled back after power failure

of (generally bad) sample code seen on the internet (outside of sqlite.org) where people seem to think it is ordinary business to do PRAGMA synchronous=OFF or even PRAGMA journal_mode=OFF, I live happily with this journal_mode=DELETE (which I happen to not use). :) -- Meilleures s

[sqlite] Version 3.11.0 beta

].bOk==0 ) continue; for(pTerm=>apExprPhrase[i]->aTerm[0]; pTerm; pTerm=pTerm->pSynonym){ int nTerm = strlen(pTerm->zTerm); <<<--- strlen returns size_t (64 bits) -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Version 3.11.0 beta

> Le 11 f?vr. 2016 ? 10:48, Olivier Mascia a ?crit : > > It looks like the appropriate character set mapping behavior on Windows is > still not quite right in the command line utility. I'm currently reviewing > the code and it looks like it revolves around the > sqlite3_

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

nt. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 842 bytes Desc: Message signed with OpenPGP using GPGMail URL:

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

> Le 11 f?vr. 2016 ? 16:46, Olivier Mascia a ?crit : > > 3.12.0 is good target, imo. > The way I patched it works nicely for the interactivity, but more work needs > to be done for handling the command-line itself properly (it always is ANSI - > or Wide and not OEM-

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

> Le 11 f?vr. 2016 ? 17:33, Olivier Mascia a ?crit : > > In between if any of you want to experiment with the path I followed, up to > now, here is a quick and dirty patch made on the amalgamation code from > https://www.sqlite.org/snapshot/sqlite-snapshot-201602101910.tar.g

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

far on the Windows timeline. Using the Get... path, the user can change its codepage himself through command chcp ..., knowingly. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part -- A non-text attachment was scru

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

rong unicode support. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 842 bytes Desc: Message signed with O

[sqlite] Windows A and W APIs dual support

are not available? I know about Windows 3.0, but what else? Some CE editions? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature

[sqlite] Process duplicate field values

. You lost me between those lines. :) -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 842 bytes Desc: Message sign

[sqlite] User-defined SQL functions

()' which would return the current_timestamp as julian day, but would return exactly the same value for any call made during the same transaction? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part -- A non-text

[sqlite] User-defined SQL functions

that the query planner brings the guarantee that it will make it so there is a singleton call to the function (for a given input value) during a statement execution. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part

[sqlite] User-defined SQL functions

ng on commit/rollback hooks to discover when transactions end (time to reset value). I take it there is nothing like some kind of a transient transaction 'integer autoincrement' ID which I could have retrieved from the SQL function? -- Meilleures salutations, Met vriendelijke groeten, Best Regards,

[sqlite] Page_size

I can't bring any comment regarding other OS. But there is probably not ONE answer to your question. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part -- A non-text attachment was scrubbed... Name: signature.asc

[sqlite] Page_size

> Le 29 f?vr. 2016 ? 12:34, Simon Slavin a ?crit : > > On 29 Feb 2016, at 9:14am, Olivier Mascia wrote: > >> we have found the sweet spot (for us, and for now) to be 4K page sizes, >> which just happen to be the virtual memory page size of Windows system > >

[sqlite] Are there practical limits to a not-so simple schema?

groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Are there practical limits to a not-so simple schema?

rts working, it will do so for minutes or hours (unlike successive web requests that would live for only msec). We can open a connection for this user and let it use it for the duration of his/her work. All statements will properly close when the user is still connected but otherwise idle, leaving a connection open, but without contention against any other. Thanks too Paul, -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Are there practical limits to a not-so simple schema?

h for my needs if it really fits the description, which I'll write a dedicated test for. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pg

[sqlite] sqldiff.c : 2 benign warnings in 64 bits builds

pointers is a 64 bits value. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Best way to terminate a dead-transaction: commit or rollback?

Hello, Let a transaction (started with BEGIN TRANSACTION) which did only reads. Is it any better to end it by COMMIT TRANSACTION or ROLLBACK TRANSACTION, or is it completely insignificant? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] sqlite3_wal_checkpoint_v2() returning SQLITE_LOCKED: in what circumstances?

erstanding probably. I have no problem with that, I'm merely gathering knowledge of how to best use it. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/o=m

[sqlite] sqlite3_wal_checkpoint_v2() returning SQLITE_LOCKED: in what circumstances?

> Le 15 janv. 2016 ? 11:54, Olivier Mascia a ?crit : > > What are the circumstances leading to: > > int status = sqlite3_wal_checkpoint_v2(conn, "main", > SQLITE_CHECKPOINT_PASSIVE, 0, 0); > > returning SQLITE_LOCKED immediately? > > > It looks l

[sqlite] sqlite3_wal_checkpoint_v2() returning SQLITE_LOCKED: in what circumstances?

led successfully. Would it make sense (or even be valid) to use the sqlite3_unlock_notify() mechanism on attempts to wal_checkpoint as we do it successfully on prepare or step? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] sqlite3_wal_checkpoint_v2() returning SQLITE_LOCKED: in what circumstances?

to decide for SQLite in our next releases, we will happily contract one of the paid professional support options HWACI offers. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Best way to terminate a dead-transaction: commit or rollback?

ich is *very* important for some kind of work which can not easily expressed in a single select statement, however complex it is. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part -- A non-text attachment was scrubbed

[sqlite] sqldiff.c : 2 benign warnings in 64 bits builds

better with the cast. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om > Le 14 janv. 2016 ? 10:55, Olivier Mascia a ?crit : > > Hello, > > May I suggest to patch sqldiff.c (3.10.0) on lines 997 and 1144 as this: > >

[sqlite] SQLite crashing

lite.dll!operator delete(void * pUserData) Line 54 + 0x10 bytesC++ > sqlite.dll!SQLiteDatabase::`vector deleting destructor'() + 0x65 > bytes C++ -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Why does the stored schema strings have their beginning upper-cased?

reate table ..." to "CREATE TABLE ...". Is there a functional reason to do this? (I'm not asking for a change, just trying to understand the motivation). :) -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part

[sqlite] Why does the stored schema strings have their beginning upper-cased?

> Le 2 mars 2016 ? 13:26, Richard Hipp a ?crit : > > On 3/2/16, Olivier Mascia wrote: >> Hello, >> >> This is really not important, nor a bug, but since I started with SQLite I >> have been puzzled about its habit to convert to upper case the beginning of >&

[sqlite] SQLite with wall enabled what's wrong C demo

very last one to close will take care of finalizing the checkpointing (if needed). The WAL additional files will disappear. Maybe WAL is not suited for your use-case as there are disadvantages too: https://sqlite.org/wal.html. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Oli

[sqlite] Calling some predefined SQL function from another custom SQL function?

salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Calling some predefined SQL function from another custom SQL function?

SQLite here. Just maybe a single C-API function to consider for addition at some point in the future. Thanks you all, -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om Context, initial post: > Le 30 mars 2016 ? 20:04, Olivier Mascia a ?crit

[sqlite] 3.13 support of Windows command-prompt extended characters

- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Updating the 'default' clause of a column?

applied when needed. But am I missing some important detail that could hurt me later? Or do you agree with this procedure? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om

[sqlite] Updating the 'default' clause of a column?

encoded integer. We also have overloads for date(), time() and datetime() to returning readable string values when some hand work has to be done on the command line. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia (from mobile device), integral.be/om > Le

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

TITHREADED mode instead of SERIALIZED, and taking care that NO database attachment is ever shared by multiple threads, alongside using the PRIVATE_CACHE mode and not the SHARED_CACHE mode. This provides for the least contention on data structures. -- Meilleures salutations, Met vriendelijke

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

the application will actually run on the server-side, no database file access over a networked file-system. So WAL is not ruled out here. The rest is a matter of clean application design. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om __

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

reasonably long enough before abandoning: it needs to wait for some other writer to commit or rollback before proceeding. That, or you handle the BUSY in the application code. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om __

Re: [sqlite] Bug Report: All database opening blocked awaiting wal index rebuild

about this problem clearly, or if you > would like me to test some things or write a simple test case. As I'm just as you a user of Sqlite, it probably is best to let its developers take on this thread from here (or from the beginning). -- Meilleures salutat

Re: [sqlite] The upcoming "pi" release of SQLite

e X'string' represented, and get a placeholder for larger ones. Kudos for the content of the 'pi' release! About documentation, is the sessions extension among the targets for the documentation effort regarding 3.14 ? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Ma

[sqlite] "pi" release: sqlite3_trace() deprecated

to compile using SQLITE_OMIT_DEPRECATED. See: loadext.c, sqlite3ext.h. Maybe tclsqlite.c should use the newer non-deprecated API too. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, integral.be/om > Début du message réexpédié : > > De: Richar

Re: [sqlite] How is pages allocation decided?

> Le 18 juil. 2016 à 14:07, Olivier Mascia <o...@integral.be> a écrit : > > is there common knowledge here about how page allocation is decided? > > Let's say we have a database with page_size set to 16 KiB. > What will happen when inserting a row whose encoded weight is

Re: [sqlite] Number of SQLITE_OMIT_ defines not working correctly

source files. From the full source tree code, you should be able to build SQLite to your liking or even build a lighter amalgamation source. Go down the download page to the Alternative Source Code Formats for links to the full source code. -- Meilleures salutations, Met vriendelijke gr

Re: [sqlite] Number of SQLITE_OMIT_ defines not working correctly

rce code of SQLite? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How is pages allocation decided?

suppose there is, but couldn't find it. So much thanks for pointers or definitive answers. :) -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Bug Report: All database opening blocked awaiting wal index rebuild

n (and dependent structures like statements) between threads. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists

Re: [sqlite] Bug Report: All database opening blocked awaiting wal index rebuild

. Chances are that if OP Brian tries the same scenario with PRIVATE_CACHE connections, the issue will not occur. I think this would probably qualify for an inherent limitation, which might be documented, but not something necessarily undesirable. -

Re: [sqlite] Missing source code in 3.14 release

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

Re: [sqlite] Bug in CREATE INDEX

> Does anybody know where the actual defaults and controlling environment > variables are documented, by operating system? https://www.sqlite.org/tempfiles.html -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia (from mobile device), integral

Re: [sqlite] update or replace ...

on related data (on delete cascade for instance). 3) The typical use case for some form of "UPSERT" (whatever the name and syntax it takes) is to generally update a row, assumed to be existing, inserting it at that occasion if needed. -- Meilleures salutations, Met vriendeli

Re: [sqlite] update or replace ...

rare case it might not already exist, to insert it. I have not yet deep enough knowledge of inner details and optimizations inside sqlite.c but I tend to think it might be more costly to attempt insert first, having it fail (ignored) most of the times, and then only do the update. -- Meilleures

Re: [sqlite] update or replace ...

tool, you're stuck trying to emulate that semantic. Or can we check by script the outcome of the UPDATE? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om ___ sqlite-users mailing list sqlite-users@m

Re: [sqlite] update or replace ...

lleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia (from mobile device), integral.be/om ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] update or replace ...

it again using the other syntax. :) And *that* is my concern when having to write a piece of script for some quick data fix. :) -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om ___ sqlite-users mailing list sqlite-u

Re: [sqlite] update or replace ...

> Le 29 juin 2016 à 18:56, Olivier Mascia <o...@integral.be> a écrit : > > Clearly it does nothing. > Does this fit the intended behavior? > Would that mean 'or replace' in the context of an update statement is a void > operation? Thanks Ryan and Simon for your a

[sqlite] update or replace ...

or replace' in the context of an update statement is a void operation? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om ___ sqlite-users mailing list sqlite-users@mailinglists.sqlit

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

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

[sqlite] sqlite3_blob_bytes64() ?

millions. And, quite rightly I think, there is no sqlite3_blob_size64(). -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing list sqlite-users@mailinglists.sqlit

Re: [sqlite] sqlite3_blob_bytes64() ?

> Le 13 févr. 2017 à 23:23, Olivier Mascia <o...@integral.be> a écrit : > > What is the purpose of sqlite3_bind_blob64() and sqlite3_bind_zeroblob64()? > > The documentation says: "The current implementation will only support a > string or BLOB length

Re: [sqlite] sqlite3_blob_bytes64() ?

> Le 14 févr. 2017 à 12:46, Clemens Ladisch <clem...@ladisch.de> a écrit : > > Olivier Mascia wrote: >> What is the purpose of sqlite3_bind_blob64() and sqlite3_bind_zeroblob64()? > > To allow 64-bit types (but not necessarily 64-bit values). IIRC some > langua

Re: [sqlite] WAL journal mode & sqlite3_backup_step()

> Le 15 févr. 2017 à 17:41, Olivier Mascia <o...@integral.be> a écrit : > >> Le 15 févr. 2017 à 16:04, Olivier Mascia <o...@integral.be> a écrit : >> >> Dear all, >> >> https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupstep makes it &g

Re: [sqlite] WAL journal mode & sqlite3_backup_step()

> Le 15 févr. 2017 à 16:04, Olivier Mascia <o...@integral.be> a écrit : > > Dear all, > > https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupstep makes it > clear that connections (other than the one used for the backup feature) which > writes in between c

Re: [sqlite] WAL journal mode & sqlite3_backup_step()

> Le 15 févr. 2017 à 18:44, Clemens Ladisch <clem...@ladisch.de> a écrit : > > Olivier Mascia wrote: >> A good approach ... is to drive the backup by a single call to >> sqlite3_backup_step() > > This is indeed what you should do with WAL. > >> The on

[sqlite] WAL journal mode & sqlite3_backup_step()

be in the WAL journal, or is the goal to get a copy of what is seen by the implicit read transaction of the connection doing the backup? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software

Re: [sqlite] VARCHAR or TEXT to save sapce

org/datatype3.html will tell you all there is to know about the datatypes in SQLite. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om ___ sqlite-users mailing list sqlite-users@mailinglis

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

t for sqlite.org content. I wouldn't say the same for the a marketing website, heavily built of highly graphical content. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om ___ sqlite-users mai

Re: [sqlite] When is data committed on one connection seen on another?

currency among threads. I win on two levels where you intend to loose on both of them (pooling connections and sharing them across threads at the cost of mutual exclusion contention to get it working). :) -- Meilleures salutations, Met vriendelijke groeten, Best Regards,

Re: [sqlite] When is data committed on one connection seen on another?

of having threads which can actually work simultaneously? Only you will tell. (Sorry for these long answers.) Best, -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om ___ sqlite-users mailing list sqlite-u

Re: [sqlite] Frequent database corruptions on Windows 10

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

Re: [sqlite] Problem with CASE in WHERE clause

d 'integer value 1' (types 8 and 9). For these, there is not even a 'value' stored, merely the type (this is true with SQLite > 3.3.0). -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqli

Re: [sqlite] BUG?: operation unexpectedly applied to both main and temp

ompared to main. :) -- Best regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia (from mobile device), http://integral.software ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] PRAGMA foreign_key_list(table-name);

? Or is the documentation missing some precision here? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

Re: [sqlite] PRAGMA foreign_key_list(table-name);

After some tests, it looks like: PRAGMA schema.foreign_key_list(table-name) is indeed perfectly functional as expected. This is only a minor documentation issue. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___

Re: [sqlite] Questions on big blobs and blob I/O

developers would clarify this better. Yet, since you're using WAL it should work. Else the implementation of the blob API would not obey the transactional/isolation rules and I suppose it would qualify as a (horrible) bug. -- Best Regards, Meilleures salutations, Met vriendelijke groet

Re: [sqlite] json() number value parsing

); // be lenient in what you read {"this":0.23} // be strict in what you write :) -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "struct Mem" conflicts with namespaces/classes having the same name

: that's best handled at the user project level. -- Best regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia (from mobile device), http://integral.software ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Get size of blob

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

Re: [sqlite] Does SQLite do any file editing when you close a database ?

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

Re: [sqlite] "struct Mem" conflicts with namespaces/classes having the same name

that Mem in the public namespace is certainly the long term better solution for everyone. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "struct Mem" conflicts with namespaces/classes having the same name

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

[sqlite] SAVEPOINT savepoint-name [DEFERRED|IMMEDIATE/EXCLUSIVE]?

ybe it slips too far away from whatever standard? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite

Re: [sqlite] SAVEPOINT savepoint-name [DEFERRED|IMMEDIATE/EXCLUSIVE]?

Clemens, Friendly said, you might have missed my point, which probably simply demonstrate I failed stating it correctly. > Le 13 avr. 2017 à 14:14, Clemens Ladisch <clem...@ladisch.de> a écrit : > > Olivier Mascia wrote: >> "When a SAVEPOINT is the outer-most save

Re: [sqlite] SAVEPOINT savepoint-name [DEFERRED|IMMEDIATE/EXCLUSIVE]?

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

Re: [sqlite] Is it possible to create the Stored Procedure (SP) in Sqlite?

ls of SQLite. Please correct me as needed. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

  1   2   3   >