Re: [sqlite] how to disable dot commands?

2020-01-12 Thread Xingwei Lin
I like this answer!! I think I think it's the easiest way. On Mon, Jan 13, 2020 at 10:22 AM Keith Medcalf wrote: > > On Sunday, 12 January, 2020 18:44, Xingwei Lin > wrote: > > >Is there any way can we disable the dot commands feature in sqlite? > > SQLite does not process dot commands, they

Re: [sqlite] how to disable dot commands?

2020-01-12 Thread Keith Medcalf
On Sunday, 12 January, 2020 18:44, Xingwei Lin wrote: >Is there any way can we disable the dot commands feature in sqlite? SQLite does not process dot commands, they are commands to the shell.c SQLite Application program. The current shell.c application currently does not have a way to omit

Re: [sqlite] how to disable dot commands?

2020-01-12 Thread Igor Korot
Hi, On Sun, Jan 12, 2020 at 7:44 PM Xingwei Lin wrote: > > Hi, > > Is there any way can we disable the dot commands feature in sqlite? Are you talking about the SQLite shell? Why do you want to disable them? What is your specific scenario? Thank you. > > -- > Best regards， > Xingwei Lin >

Re: [sqlite] how to disable dot commands?

2020-01-12 Thread Simon Slavin
On 13 Jan 2020, at 1:43am, Xingwei Lin wrote: > Is there any way can we disable the dot commands feature in sqlite? SQLite – the library you call from C and other programming languages – does not support the dot commands. It doesn't recognise them. If you try to use them you will get a

[sqlite] how to disable dot commands?

2020-01-12 Thread Xingwei Lin
Hi, Is there any way can we disable the dot commands feature in sqlite? -- Best regards， Xingwei Lin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Test failures on GPFS

2020-01-12 Thread Roman Fleysher
I use SQLite over GPFS , but in DELETE (which I think is the default) mode. Not WAL mode. No issues with locking, except performance when accessing concurrently from multiple nodes. As others pointed out, this has to do with the overhead due to lock requests. GPFS must coordinate with many

Re: [sqlite] Unexplained table bloat

2020-01-12 Thread R Smith
On 2020/01/13 12:25 AM, Tom Browder wrote: On Sun, Jan 12, 2020 at 14:05 Keith Medcalf wrote: Close, but no banana. Every value has a type. A column may contain multiple values (as in one per row) Thanks, Keith. I assume that is just for SQLite, or am I wrong again? You are not

Re: [sqlite] Best way to store key,value pairs

2020-01-12 Thread James K. Lowden
On Tue, 7 Jan 2020 17:11:45 -1000 Jens Alfke wrote: > Consider encoding the headers as JSON and storing them in a single > column. SQLite has a JSON extension that makes it easy to access > values from JSON data in a query. What is the motivation behind this advice? It's completely

Re: [sqlite] Unexplained table bloat

2020-01-12 Thread Keith Medcalf
On Sunday, 12 January, 2020 15:31, Simon Slavin wrote: >You're generally right. SQLite always uses affinities (more or less >'weak typing') rather than strong typing. I don't know of any other SQL >implementations which allow this without explicit declaration, and most >don't allow it at all.

[sqlite] [lemon] lempar function visibility

2020-01-12 Thread Luke Drummond
Hi all I have been using lemon successfully to generate a parser used in a library, and I'd like some source-level way of limiting the visibility of some lempar symbols. I threw together a proof of concept for a macro that can be user defined to allow setting `static` or e.g.

Re: [sqlite] Unexplained table bloat

2020-01-12 Thread Keith Medcalf
On Sunday, 12 January, 2020 15:29, Richard Damon wrote: >On 1/12/20 5:25 PM, Tom Browder wrote: >> On Sun, Jan 12, 2020 at 14:05 Keith Medcalf wrote: >>> On Sunday, 12 January, 2020 09:03, Tom Browder >>> wrote: Am I missing something? I thought every column has to have a type? >>>

Re: [sqlite] Unexplained table bloat

2020-01-12 Thread Tim Streater
On 12 Jan 2020, at 22:25, Tom Browder wrote: > On Sun, Jan 12, 2020 at 14:05 Keith Medcalf wrote: > >> On Sunday, 12 January, 2020 09:03, Tom Browder >> wrote: >> >Am I missing something? I thought every column has to have a type? >> >> Close, but no banana. Every value has a type. A column

Re: [sqlite] Unexplained table bloat

2020-01-12 Thread Simon Slavin
On 12 Jan 2020, at 10:25pm, Tom Browder wrote: > I assume that is just for SQLite, or am I wrong again? You're generally right. SQLite always uses affinities (more or less 'weak typing') rather than strong typing. I don't know of any other SQL implementations which allow this without

Re: [sqlite] Unexplained table bloat

2020-01-12 Thread Richard Damon
On 1/12/20 5:25 PM, Tom Browder wrote: On Sun, Jan 12, 2020 at 14:05 Keith Medcalf wrote: On Sunday, 12 January, 2020 09:03, Tom Browder wrote: Am I missing something? I thought every column has to have a type? Close, but no banana. Every value has a type. A column may contain multiple

Re: [sqlite] Unexplained table bloat

2020-01-12 Thread Tom Browder
On Sun, Jan 12, 2020 at 14:05 Keith Medcalf wrote: > On Sunday, 12 January, 2020 09:03, Tom Browder > wrote: > >Am I missing something? I thought every column has to have a type? > > Close, but no banana. Every value has a type. A column may contain > multiple values (as in one per row)

Re: [sqlite] Unexplained table bloat

2020-01-12 Thread Keith Medcalf
On Sunday, 12 January, 2020 09:03, Tom Browder wrote: >Am I missing something? I thought every column has to have a type? Close, but no banana. Every value has a type. A column may contain multiple values (as in one per row). Therefore each of those values has a type, which may be

Re: [sqlite] Unexplained table bloat

2020-01-12 Thread Tom Browder
Am I missing something? I thought every column has to have a type? -Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users