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

Dear, 3.23.0 (pending) cites: > • Recognize TRUE and FALSE as constants. (For compatibility, if there > are columns named "true" or "false", then the identifiers refer to the > columns rather than Boolean constants.) > • Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT

[sqlite] Missing "pushDownWhereTerms" optimisation on recursive CTE

Dear SQLite, The following SQL script shows a query selecting data from a recursive CTE and filtering it. I expected the optimizer to apply the filter to the recursive CTE directly, and indeed the documentation of pushDownWhereTerms (src/select.c:3833) indicates this possibility when various

Re: [sqlite] String Too Long

> My guess is that it's a limitation of SQLiteCommand a.k.a > Microsoft.Data.Sqlite . You might want to ask about the problem in a forum > on C#, .NET or Microsoft.Data.* . Or try System.Data.SQLite instead of the Microsoft version. You can download it directly or use NuGet. -- Bill Drago

Re: [sqlite] String Too Long

On 1 Mar 2018, at 7:42pm, Matías Badin wrote: > The string is over 55000 characters and i'm using SQLiteCommand in C# Since that's less than a million, whatever limit you're hitting isn't part of SQLite, it's part of one of 1) Operating System 2) SQLite shim

Re: [sqlite] String Too Long

On 3/1/18, Matías Badin wrote: > The string is over 55000 characters and i'm using SQLiteCommand in C# That might be something in C#. SQLite can easily handle a 55K character string. It commonly does much more than that in applications such as Fossil. -- D. Richard

Re: [sqlite] High performance and concurrency

On 03/01/2018 01:24 AM, Hick Gunter wrote: Use 1 connection for each thread. Sharing a connections between threads may cause transactions to be larger than each thread thinks. Why would I have a transaction of non-zero size on a read-only connection? It looks from the source as if having

Re: [sqlite] String Too Long

The string is over 55000 characters and i'm using SQLiteCommand in C# 2018-03-01 16:40 GMT-03:00 David Raymond : > How large the string, and what program/language are you using? > > > -Original Message- > From: sqlite-users

Re: [sqlite] String Too Long

How large the string, and what program/language are you using? -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Matías Badin Sent: Thursday, March 01, 2018 2:38 PM To: SQLite mailing list Subject: Re: [sqlite] String Too Long

Re: [sqlite] String Too Long

Yes, i am binding the string. 2018-03-01 16:35 GMT-03:00 Matías Badin : > The same issue using blob. > Thanks > > 2018-03-01 16:23 GMT-03:00 Igor Korot : > >> Hi, >> >> On Thu, Mar 1, 2018 at 1:20 PM, Matías Badin >> wrote:

Re: [sqlite] String Too Long

The same issue using blob. Thanks 2018-03-01 16:23 GMT-03:00 Igor Korot : > Hi, > > On Thu, Mar 1, 2018 at 1:20 PM, Matías Badin > wrote: > > Hi all; > > I am trying to insert a big string and i have the message: Request too > long. > > > > I set my

Re: [sqlite] String Too Long

Default limits for SQLite http://www.sqlite.org/limits.html Maximum length of a string or BLOB: 1,000,000,000 (1 billion bytes) Statement length: 1,000,000 bytes How are you doing your insert? Are you binding the string (good), or substituting it into the insert statement as part of the

Re: [sqlite] String Too Long

Hi, On Thu, Mar 1, 2018 at 1:20 PM, Matías Badin wrote: > Hi all; > I am trying to insert a big string and i have the message: Request too long. > > I set my parameter as "text" but i still have this problem. > > Do you know if i can use another type? BLOB? Thank you.

[sqlite] String Too Long

Hi all; I am trying to insert a big string and i have the message: Request too long. I set my parameter as "text" but i still have this problem. Do you know if i can use another type? Thanks ___ sqlite-users mailing list

Re: [sqlite] [EXTERNAL] what internal table contains column names in a table?

The only raw storage of the schema is in the sqlite_master table, where it stores the original text of the create query. But to save yourself from the hell of parsing it all out, pragma table_info(tbl) is the way to go yes. Or the newer version of select from pragma_table_info(tbl)

Re: [sqlite] [EXTERNAL] what internal table contains column names in a table?

Pragma table_info -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von mike otwell Gesendet: Donnerstag, 01. März 2018 15:50 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] what internal table contains

[sqlite] what internal table contains column names in a table?

I want to write a program that generates insert & update statements for a table. what internal table would I query to get the column names in a table? -- ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] BF Interpreter

On 2018/03/01 8:55 AM, Gary Briggs wrote: Hopefully no-one finds this useful, Your hopes have been shattered. Now do the encoder...  :) Gary WITH RECURSIVE program AS (SELECT

Re: [sqlite] BF Interpreter

Wow. That’s impressive On Thu, 1 Mar 2018 at 09:49, Chris Locke wrote: > "Thats the beauty of it. It doesn't *do* anything." ;) > > > > On Thu, Mar 1, 2018 at 6:55 AM, Gary Briggs wrote: > > > Thanks to the help the other day with the strange

Re: [sqlite] BF Interpreter

"Thats the beauty of it. It doesn't *do* anything." ;) On Thu, Mar 1, 2018 at 6:55 AM, Gary Briggs wrote: > Thanks to the help the other day with the strange concatentation result. > > I was referring to a BF interpreter I was working on, in pure SQLite SQL. > Well,

Re: [sqlite] [EXTERNAL] Re: High performance and concurrency

Use 1 connection for each thread. Sharing a connections between threads may cause transactions to be larger than each thread thinks. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Shevek Gesendet: Donnerstag, 01. März

Re: [sqlite] High performance and concurrency

On 02/28/2018 11:45 PM, Simon Slavin wrote: On 1 Mar 2018, at 7:24am, Shevek wrote: What I think is happening is that either a pthread mutex or a database lock is serializing the accesses, so each thread blocks the others. To be specific, I'm concerned about is the