Re: [sqlite] log() in sqlite3

The log function does seem to be supported by extension-functions.c which is available from here: https://www.sqlite.org/contrib On Fri, Jan 31, 2020 at 1:30 PM David Raymond wrote: > The core functions of the library are fairly unlikely to get expanded upon > at this point, so it's up to the

Re: [sqlite] "Standard SQL" ?

A few resources I found from https://www.google.com/search?q=sql+standard : - https://en.wikipedia.org/wiki/SQL - https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/#gref - https://dev.to/0xcrypto/who-owns-the-sql-standard-76m -

Re: [sqlite] A crash bug in sqlite

> Yes. I discovered the same thing independently. The previous fix was > subtly wrong. Please try the latest trunk version. Will there be a patch release, or should we just wait for the next minor? ___ sqlite-users mailing list

Re: [sqlite] Proposal: SQLite on DNA

> > May I humbly suggest that the development team look into porting to a new > > platform: > > > +1 (+100) > As in Viral File System? Yes (haha) ___

Re: [sqlite] Apparent power fail data loss in embedded use - SQLite newbie

> SQLite is built from (the combined) source as part of the project build. > [...] If you want extra safety, I would recommend you consider using SQLITE_DEFAULT_SYNCHRONOUS=3 which is the equivalent to using PRAGMA synchronous=EXTRA. Quick references: *

Re: [sqlite] SQLITE_DBCONFIG_DEFENSIVE documentation looks confusing

this right, really wish it were better documented. On Tue, Jan 29, 2019 at 10:17 AM Chris Brody wrote: > > I am very sorry to say that I have found the usage of the > SQLITE_DBCONFIG_DEFENSIVE option to be somewhat confusing. > > From my first reading of https://www.sqlite.org/r

[sqlite] SQLITE_DBCONFIG_DEFENSIVE documentation looks confusing

I am very sorry to say that I have found the usage of the SQLITE_DBCONFIG_DEFENSIVE option to be somewhat confusing. From my first reading of https://www.sqlite.org/releaselog/3_26_0.html I thought SQLITE_DBCONFIG_DEFENSIVE was a compile-time option. (I was proven wrong pretty quickly.) Then I

Re: [sqlite] about upsert feature.

I wonder if this should be considered a bug, or if should be better documented? On Thu, Nov 8, 2018 at 9:57 AM 畑宏和 wrote: > Thanks for your reply! > My script's select-stmt do not include where. > When I add 'where true', syntax error does not occur. > > Thanks! > > 2018年11月7日(水) 19:44、Richard

Re: [sqlite] Regarding CoC

I would vote for a major simplification, down to something like "love thy neighbor", "do unto others as ...", or "don't do unto others as ..." For reference: * https://www.simpletoremember.com/jewish/blog/loving-thy-neighbor-judaism/ *

Re: [sqlite] Regarding CoC

> Looks like that happened this morning. > https://news.ycombinator.com/item?id=18273530 I saw it coming, tried to warn you guys in private. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Persistent snapshots and rollbacks

> Yes, but there are some things I don't like about it -- see my earlier > reply in this thread (to Simon's first message). Gotta say I could not follow what you said in the earlier reply. It would be nice if you could explain in some finer detail. That said, I would personally favor using

Re: [sqlite] Persistent snapshots and rollbacks

> I did now a quick experiment with the sqlite3 command-line, and it seems > that savepoints indeed work exactly what I need *except* for being > non-persistent. Is there some way or trick I could use to make them (or > the "current session") persist? Couldn't

Re: [sqlite] Persistent snapshots and rollbacks

Savepoints ()? On Fri, Oct 5, 2018 at 11:40 AM Daniel Kraft wrote: > > Hi! > > I need the ability to make multiple changes / commits to my SQLite > database but keep snapshots of previous states and potentially roll back > to those states later on. All

Re: [sqlite] A SQL statement reformatter

I found https://github.com/mjibson/sqlfmt through their about page. No license though, just raised https://github.com/mjibson/sqlfmt/issues/33. GitHub fork-me ribbon would also be nice I think. Someone should have make this tool 20-30 years ago! On Fri, Sep 28, 2018 at 10:44 AM Peter da Silva

Re: [sqlite] downloading older versions

From https://www.sqlite.org/chronology.html you should be able to click on the date, then click on the check-in hash number, then click the link after "Downloads:" to download a ZIP, TAR, or SQLAR of the older version. Keep in mind that this gives you a snapshot of the source tree, you would have

Re: [sqlite] Error when reading from pre-populated SQLite database in Ionic project

Check the results of cordova plugin ls A common pitfall is that you have to use cordova-sqlite-ext plugin to get pre-populated database functionality. Commonly used cordova-sqlite-storage plugin does not support this feature. Second pitfall is if you have multiple Cordova sqlite plugins

Re: [sqlite] sqlite on IBM z/OS Unix

It is not clear to me why your program closes the sqlite3 database at the end of each C function invocation. AFAIK sqlite3 should not close any database connection unless your program invokes sqlite3_close. If something in the "Language Environment" closes and releases internal resources at the

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

On Wed, Jun 13, 2018 at 3:00 PM Richard Hipp wrote: > > Cross-posted to the fossil-users mailing list since www.fossil-scm.org +1 > Even so, Discourse does seem like considering. Does anybody else have > any experience with Discourse, good or bad? SQLCipher switched over to Discourse for the

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

On Wed, Jun 13, 2018 at 10:44 AM jungle Boogie wrote: > [...] > http://spamassassin.apache.org/ Maybe just add SpamAssassin to the existing GNU MailMan setup? http://www.jamesh.id.au/articles/mailman-spamassassin/ ___ sqlite-users mailing list

Re: [sqlite] Possible Input Parser Issue Inf How to convert SQL file into database when a column value is Inf?

On Tue, Jun 12, 2018 at 6:40 PM Richard Hipp wrote: > [...] > Maybe use 1e999 and -1e999 instead? I can confirm on SQLite versions 3.19.2 & 3.24.0: sqlite> select 1e999; Inf sqlite> select -1e999; -Inf I wouldn't mind it if SQLite would be a little more symmetrical, i.e. output of .dump with

Re: [sqlite] Database is malformed but no further information

My understanding is that mobile apps are not 100% predictable since they may be randomly suspended or terminated, at any point of time. The operating system should give a signal before suspending or terminating but I would not trust it. Goes for Android, iOS, Windows Mobile, and others. To be

Re: [sqlite] sqlite.org website is now HTTPS-only

http://sqlite.org and https://sqlite.org seem to redirect OK to https://sqlite.org/index.html http://www.sqlite.org and https://www.sqlite.org seem to redirect OK to https://www.sqlite.org/index.html fossil clone https://www.sqlite.org/src sqlite.fossil works for me on my mac (recent version

Re: [sqlite] Filename encoding on Unix platforms

On Tue, Jun 5, 2018 at 2:27 PM, Warren Young wrote: > > On Jun 5, 2018, at 11:39 AM, R Smith wrote: > > > > Any idea what might be the sudden spam activator? I'm using Thunderbird > > client and gmail service. Weird. > > Gmail seems to now consider an origin of mailinglists.sqlite.org to be a

Re: [sqlite] Size of the SQLite library

On Thu, May 31, 2018 at 11:38 AM, Richard Hipp wrote: > [...] > By using multiple SQLITE_OMIT compile-time options to leave out > features, I can get the size down to 308,189 bytes using gcc-7 -Os > -m32. @Richard can you elaborate some more on how you make this kind of a build? I wouldn't mind

Re: [sqlite] More sqlite header questions

On Tue, Feb 13, 2018 at 2:03 PM, Simon Slavin wrote: > [...] > There are two possibilities: > > A) The SQLite API was used correctly, including being allowed to close all > files it opened. > B) Any other situation. > > If (A) happened, you can predict things about the

[sqlite] More sqlite header questions

)? On Tue, Feb 13, 2018 at 9:10 AM, Richard Hipp <d...@sqlite.org> wrote: > > On 2/13/18, Chris Brody <chris.br...@gmail.com> wrote: > > I was wondering what would happen if there would be an application crash, > > system crash, or power failure while SQLite is upda

[sqlite] Crash when writing header

I was wondering what would happen if there would be an application crash, system crash, or power failure while SQLite is updating the file header? Did I miss an explanation somewhere? -- From: David Raymond Date: Tue, Feb 6, 2018 at 12:04 PM Subject: Re:

Re: [sqlite] Is WAL mode more robust against corruption?

On Thu, Dec 28, 2017 at 3:59 PM, Simon Slavin <slav...@bigfraud.org> wrote: > On 28 Dec 2017, at 8:10pm, Chris Brody <chris.br...@gmail.com> wrote: > >> [...] >> But I wondered if WAL may be more robust against possible sqlite >> corruption, in theory or

[sqlite] Is WAL mode more robust against corruption?

Hello, I am considering whether or not to recommend the WAL mode for users in the PhoneGap sqlite plugin that I maintain. The negative I see is the delays that may result at certain points from the need for database checkpoints. But I wondered if WAL may be more robust against possible sqlite

Re: [sqlite] Patch for consideration: auto_vacuum slack.

On Mon, Feb 13, 2017 at 9:13 PM, Richard Hipp wrote: > [...] > This makes me want to ask: Is anybody still using auto_vacuum? And > if they are, should they be? I am thinking to change the commonly-used Cordova/PhoneGap sqlite plugin [1] to enable auto-vacuum by default for

Re: [sqlite] UNIQUE Constraint failure better diagnostics

+1 on my part On Sun, Aug 14, 2016 at 9:59 AM, Василий Кудрявцев wrote: > Hi! > > > > I would like to propose an enhancement to SQLite diagnostics in case of > unique constraint failure. > > Currently the message does not contain the name of constraint in question, > only

Re: [sqlite] ENABLE_UPDATE_DELETE_LIMIT

Thanks, definitely looks straightforward to me. On Tue, Jul 12, 2016 at 11:14 AM, Jan Nijtmans <jan.nijtm...@gmail.com> wrote: > 2016-07-12 11:03 GMT+02:00 Chris Brody: >> Personally I would really like to see this. Can you show the patch somewhere? > > Here is th

Re: [sqlite] ENABLE_UPDATE_DELETE_LIMIT

> Actually, it is very well possible to build an amalgamation which can > be built with or without ENABLE_UPDATE_DELETE_LIMIT, and > functions fine as expected both ways without rerunning Lemon. If you > are interested in a patch which demonstrates this, I'm happy to provide that. Personally I

Re: [sqlite] Updating two virtual table in WinRT under one transaction with debug mode

t occured, only on Windows with this settings in > Debug mode, and maybe there can be some consequence on release mode too, I > don't know yet. > > Thanks, > Bence > > 2016. 07. 11. 16:28 keltezéssel, Chris Brody írta: >> >> Did you see the Cordova-sqlite-storage plugi

Re: [sqlite] Updating two virtual table in WinRT under one transaction with debug mode

Did you see the Cordova-sqlite-storage plugin that I maintain? It supports Windows 8.1, Windows Phone 8.1, and Windows 10 UWP in addition to Android and iOS. It uses the SQLite3-WinRT C++ library which I think is better than using .NET/C#. The following test case works fine for me when I try it

Re: [sqlite] Problem with savepoints

> > Just for my information, what is the purpose of this temporary file? I see >> that -journal file is always stored to disk. >> > > It's a statement journal: > > https://www.sqlite.org/tempfiles.html#stmtjrnl > > Recent changes mean that the first 64KiB of a statement journal are always >

Re: [sqlite] Update DataGrid and Save to database

I wonder if the answers following link could help you: http://stackoverflow.com/questions/19617368/sqlite-database-and-datagrid I found this by a quick Google search. For the future please explain the context, show that you have done some basic research, show what you have found, and show

Re: [sqlite] Latin-1 characters cannot be supported for Unicode

Hi Wei Wang, Did you populate the database from the sqlite3 CLI tool, your own C program, or from another language? Do you see this when you create a database from scratch, if you use a database created by another program, or in both cases? If you populated the database from the sqlite3 CLI

Re: [sqlite] SQLite in Android N

On Jun 6, 2016 7:47 PM, "Eric Sink" wrote: > > Official, but slightly vague: > > https://developer.android.com/preview/behavior-changes.html#ndk SQLCipher (based on SQLite) has already dealt with this in: https://github.com/sqlcipher/android-database-sqlcipher/issues/216 I

Re: [sqlite] SQL / SQLite for Beginners

Another piece of feedback: I think it would be people to have access to the presentation slides and samples. Having JOIN for beginners is great. I think it would be cool to have VIEWs for beginners as well. These are major benefits over NoSQL. On May 22, 2016 1:29 PM, "R.A. Nagy"

[sqlite] SQLite custom function for regular expression using c/c++

On Mon, May 9, 2016 at 2:20 PM, Richard Hipp wrote: > On 5/9/16, Chris Brody wrote: >> On Wed, May 4, 2016 at 2:52 PM, Richard Hipp wrote: >>> On 5/4/16, Bhagwat Balshetwar wrote: >>>> I want to write the custom function for regular expression using C/C++.

[sqlite] SQLite custom function for regular expression using c/c++

On Wed, May 4, 2016 at 2:52 PM, Richard Hipp wrote: > On 5/4/16, Bhagwat Balshetwar wrote: >> I want to write the custom function for regular expression using C/C++. > > You mean like this one: https://www.sqlite.org/src/artifact/a68d25c659bd2d89 Is there any reason this cannot be included as