Re: [sqlite] The upcoming alter table rename column

Still doesn't work when saving directly to file. Nice though. Modified version follows. Thanks. danap. Fixes/Adds: 1. Header comment added --. 2. Added drop IF EXISTS. 3. Each CREATE VIEW added space after AS. 4. Placed end of statement semicolon directly after parenthesis. 5. Has only \n for

Re: [sqlite] PRAGMA case_sensitive_like

Chris Locke wrote: > Is there a reason for it being write only? This pragma just installs a different LIKE() function, and there is no easy mechanism to read the function pointer back. Regards, Clemens ___ sqlite-users mailing list

Re: [sqlite] PRAGMA case_sensitive_like

Thanks J - not entirely sure how that's helpful - I know how to call the pragma, but I was enquiring as to whether there was a way of reading a write-only pragma (which sounds nonsense now that I've written that down!!) Thanks, Chris On Thu, Aug 16, 2018 at 3:16 PM J Decker wrote: >

Re: [sqlite] PRAGMA case_sensitive_like

https://www.sqlite.org/pragma.html#pragma_case_sensitive_like Basically nope, there isn't a better way. There is no 0 argument version of the pragma, and there is no table-valued function as it's a pragma with a side effect. So running a small query where you know what the answer is is

Re: [sqlite] PRAGMA case_sensitive_like

https://www.sqlite.org/pragma.html#pragma_pragma_list A pragma can take either zero or one argument. The argument is may be either in parentheses or it may be separated from the pragma name by an equal sign. The two syntaxes yield identical results. In many pragmas, the argument is a boolean. The

[sqlite] Lite plus

Hi all, I'd like to announce a small project called liteplus https://gitlab.com/daitangio/sqlite_ora_functions Liteplus provide a bunch of extra function to sqlite, written in python. You got some common Oracle functions (like nvl,decode, etc) Feel free to comment, open issue/suggestions an give

[sqlite] PRAGMA case_sensitive_like

While the pragma *case_sensitive_like *can be set, there doesn't seem to be a way to read it. Is there a reason for it being write only? A hacky workaround is to use the SQL, "select 'x' like 'X' ", but is there a better way? ___ sqlite-users mailing

Re: [sqlite] Safe sqlite over remote filesystem?

On 15 August 2018 at 14:12, Wout Mertens wrote: > On Tue, Aug 14, 2018 at 6:28 PM Rowan Worth wrote: > > > FWIW in the building I work in we have 20-30 users hitting around a dozen > > SQLite DBs 8 hours a day 5 days a week, with all DBs served over nfs. > > > Multiple writers? I presume you