https://www.sqlite.org/privatebranch.html
This command both creates the new repository and populates it with all the
latest SQLite could
->
This command both creates the new repository and populates it with all the
latest SQLite code
On Wed, Jan 24, 2018 at 10:44 PM Richard Hipp wrote:
> On 1/2
On 1/24/18, petern wrote:
> Have you worked out an automated way for your changes to shadow and
> auto-merge from the official trunk?
https://www.sqlite.org/privatebranch.html
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-use
On Wed, Jan 24, 2018 at 1:30 PM, petern wrote:
> Have you worked out an automated way for your changes to shadow and
> auto-merge from the official trunk? That is, aside from collision edits,
> is it automated? Longer term, your shadow distribution also needs
> new/merged test cases and a regre
Have you worked out an automated way for your changes to shadow and
auto-merge from the official trunk? That is, aside from collision edits,
is it automated? Longer term, your shadow distribution also needs
new/merged test cases and a regression test run to re-qualify the merged
changes at each c
Thank you, Richard.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Richard Hipp [d...@sqlite.org]
Sent: Thursday, August 03, 2017 3:38 PM
To: SQLite mailing list
Subject: Re: [sqlite] command shell .timeout
On 8/3
On 8/3/17, Roman Fleysher wrote:
> Dear SQLiters,
>
> I am using sqlit3 command shell. It has ".timeout" command. What is the
> difference between:
>
> .timeout MS
> PRAGMA busy_timeout = milliseconds;
They accomplish the same thing. The ".timeout" command (which I had
forgotten about) existed l
Thanks, that worked.
John Gillespie
On 8 November 2016 at 14:30, Richard Hipp wrote:
> On 11/8/16, John G wrote:
> > I normally use the 3.8.8.3 supplied with MacOS El Capitan.
> > I downloaded version 3.15.1 from the Download page - precompiled
> > command-line tools : (sqlite-tools-osx-x86-31
On Tue, Nov 8, 2016 at 3:30 PM, Richard Hipp wrote:
> On 11/8/16, John G wrote:
> > I normally use the 3.8.8.3 supplied with MacOS El Capitan.
> > I downloaded version 3.15.1 from the Download page - precompiled
> > command-line tools : (sqlite-tools-osx-x86-3150100.zip).
> >
> > When I tried co
On 11/8/16, John G wrote:
> I normally use the 3.8.8.3 supplied with MacOS El Capitan.
> I downloaded version 3.15.1 from the Download page - precompiled
> command-line tools : (sqlite-tools-osx-x86-3150100.zip).
>
> When I tried copying and pasting multiple or multi-line statements from my
> edit
Microsoft seems to only make the stderr stream unbuffered when writing to a
character device: "The stdout and stderr functions are flushed whenever they
are full or, if you are writing to a character device, after each library
call." It doesn't seem to consider pipe that emacs is reading from a
On 19 Jan 2014, at 7:32pm, Luuk wrote:
> It is acceptable—and normal—for standard output and standard error to be
> directed to the same destination, such as the text terminal. Messages appear
> in the same order as the program writes them, unless buffering is involved.
> (For example, a comm
On 19-01-2014 19:59, Christopher Wellons wrote:
When the shell is set to interactive (i.e. "-interactive"), the output
(stdout) is flushed with every prompt (shell.c:422) but stderr is not.
Stderr is suppose to be unbuffered so that flushing is not required. Or is
that different for windows
>> When the shell is set to interactive (i.e. "-interactive"), the output
>> (stdout) is flushed with every prompt (shell.c:422) but stderr is not.
> Stderr is suppose to be unbuffered so that flushing is not required. Or is
> that different for windows?
According to the stderr Linux man page s
On Sun, Jan 19, 2014 at 11:10 AM, Christopher Wellons <
well...@nullprogram.com> wrote:
>
> When the shell is set to interactive (i.e. "-interactive"), the output
> (stdout) is flushed with every prompt (shell.c:422) but stderr is not.
>
Stderr is suppose to be unbuffered so that flushing is not
http://www.sqlite.org/download.html
scroll to "Precompiled Binaries for Windows"
It runs just fine on 32 bit windows.
Adam
Hi, thanks, and yes I have these, but am specifically interested in the latest development trunk, which I don't think is included on
this page in compiled form (unless I'
http://www.sqlite.org/download.html
scroll to "Precompiled Binaries for Windows"
It runs just fine on 32 bit windows.
Adam
On Thu, Jul 11, 2013 at 12:20 PM, RSmith wrote:
> Could someone send me a build with the current trunk of the command-line
> utility for Windows 32Bit with the standard opt
Yes, I installed the latest version myself.
> Date: Fri, 11 May 2012 07:46:16 +0100
> From: amit.k.chaudh...@gmail.com
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Command history not working in sqlite3 tool for MAC OS
>
> My Mac is running system provided sqlite3 (3.
My Mac is running system provided sqlite3 (3.6.12) and up arrow returns
last command as expected. Did you install 3.7.11 your self, if so I wonder
if you missed a component (e.g. one which provides the cmd line
functionality).
On Fri, May 11, 2012 at 6:33 AM, Neo Anderson wrote:
>
> The UP/DOWN
On 22/12/2011 7:25 AM, Matt Young wrote:
select count() from sqlite_master;
No??
...where type='table';
Cheers,
Mohit.
22/12/2011 | 12:51 PM.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sq
select count() from sqlite_master;
No??
On Wed, Dec 21, 2011 at 10:32 AM, smallboat wrote:
> Hello,
>
> I have a sqlite file. I would like to open it and know how many tables in
> it.
>
> What is the command line to open a sqlite file and get to know how many
> tables in it? Thanks.
>
> Regards
Somthing like
sqlite3 sqlite.file
sqlite> select count(*) from sqlite_master where type = 'table';
/Roger
On 12/21/11 19:32, smallboat wrote:
Hello,
I have a sqlite file. I would like to open it and know how many tables in it.
What is the command line to open a sqlite file and get to know how
On 21 Dec 2011 at 18:32, smallboat wrote:
> I have a sqlite file. I would like to open it and know how many tables in it.
>
> What is the command line to open a sqlite file and get to know how many tables
> in it? Thanks.
See:
http://www.sqlite.org/sqlite.html
and:
http://www.sqlite.org/faq.
good thing
David M Walker
Data Management & Warehousing
0118 321 5930
dav...@datamgmt.com
http://www.datamgmt.com
> Date: Thu, 8 Dec 2011 17:26:55 +
> From: Simon Davies
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Command line option equivalent for .read
&
On 8 December 2011 17:05, David Walker wrote:
> Hi,
>
> Having played around with a shell script that calls SQLite I have noticed
> that I can something like
>
> .separator STRING at the SQLite prompt
> .mode line
>
> or I can do
>
> sqlite3 -separator STRING at the comm
Hi,
Sorry, never mind this post. I haven't found the problem actually yet,
but a "bare minimum" example fed directly to the interpreter through
the command line works correctly:
% package require sqlite3
3.7.2
% set inf [open 1_schema.sql r]
file6
% set sql [read $inf]
[... the contents of the re
On Sat, Nov 20, 2010 at 2:43 PM, Richard Hipp wrote:
> On Sat, Nov 20, 2010 at 8:25 AM, Fredrik Karlsson wrote:
>
>> Dear list,
>>
>> I am having a silly problem, and need your expertise. I just want to
>> initiate a SQLite database using a schema file in Tcl, but I just get
>> an empty database w
On Sat, Nov 20, 2010 at 8:25 AM, Fredrik Karlsson wrote:
> Dear list,
>
> I am having a silly problem, and need your expertise. I just want to
> initiate a SQLite database using a schema file in Tcl, but I just get
> an empty database whatever I do. I asked this question on the Tcl
> list, and got
I upgraded to 3.7.0 and it fixes the problem.
Thanks!
Ben
On Wed, Aug 4, 2010 at 8:07 AM, Black, Michael (IS)
wrote:
> I just ran your code on 3.6.23.1 and it works just fine.
>
> Can you try a newer version?
>
> x.sql:
> create table mytable (id VARCHAR(255), name VARCHAR(255), address
> VARCH
I just ran your code on 3.6.23.1 and it works just fine.
Can you try a newer version?
x.sql:
create table mytable (id VARCHAR(255), name VARCHAR(255), address VARCHAR(255),
PRIMARY KEY(id));
insert into mytable (id, name, address) VALUES ('123abc','charlie', '123 st');
insert into mytable (id,
hi Jay
Jay A. Kreibich wrote:
> Yes. Readline support is not on by default.
>
> You need to compile it with -DHAVE_READLINE and add -lreadline
> to the linker:
>
> $ cc -DHAVE_READLINE -o sqlite3 sqlite3.c shell.c -lreadline
recompiling sqlite3 from source code with your command
solved the
On Fri, Nov 20, 2009 at 10:29:20PM -0500, Qianqian Fang scratched on the wall:
> Is this possibly caused by how sqlite binary was compiled?
Yes. Readline support is not on by default.
You need to compile it with -DHAVE_READLINE and add -lreadline
to the linker:
$ cc -DHAVE_READLINE -o sq
I don't know, is there a way I can tell?
the binary was downloaded from sqlite website, version
is 3.6.2. The binary stores in a remote server, running
Debian 3, I used ssh in a Terminator/gnome-terminal
bash shell.
I also installed sqlite on my local machine, running
Ubuntu Karmic, interestingly
On Fri, Nov 20, 2009 at 6:02 PM, Qianqian Fang
wrote:
> hi
>
> I can not type arrow keys in the sqlite3 command line, all the arrow
> keys (as well as other keys in the small keyboard) will be shown as
> escape sequence "^]]A".
Could it be a problem with readline? See
http://www.sqlite.org/cvstr
sqlite3_open.
Mozaharul Haque wrote:
> Hi,
>
> A silly asking. I found the command to create a table but what about to
> create a database?
>
> The table would be stored in the sqlite_master table.
>
> And how do I refer (full path) to the database using application like
> Basic4ppc 6.05.
>
>
"Mozaharul Haque" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> A silly asking. I found the command to create a table but what about
> to create a database?
Just give a file name to sqlite3_open, then create a table. If the file
didn't exist, it will be created at this point.
Igo
using UODATE command its working.
thanks for the help
regards
Nishit
On 8/30/07, Jim Dodgen <[EMAIL PROTECTED]> wrote:
>
> Also I recommend you get a very basic SQL database book.
>
>
> Quoting John Stanton <[EMAIL PROTECTED]>:
>
> > nishit sharma wrote:
> > > i have given some text in a databas
Also I recommend you get a very basic SQL database book.
Quoting John Stanton <[EMAIL PROTECTED]>:
> nishit sharma wrote:
> > i have given some text in a database file as
> > America|england| and many more.
> > now i want to replace some text with new text how
> > this is possible. Also my dat
nishit sharma wrote:
i have given some text in a database file as
America|england| and many more.
now i want to replace some text with new text how
this is possible. Also my database has around 15 rows now
which will be incremented.
so, plz anyone tell me how to replace a text in a row and
how
Update can be used to replace a text with some new text.
To delete a particular row use 'where' command along with
'delete'.
-Original Message-
From: nishit sharma [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 30, 2007 4:04 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] command
i h
"Yes and yes."
:)
Alejo
On 10/26/06, Kees Nuyt <[EMAIL PROTECTED]> wrote:
Hi Richard,
On Thu, 26 Oct 2006 17:23:17 +, you wrote:
> So the question:
> Who will be adversely effected by the new error behavior
> in the sqlite command-line shell?
Not really. I prefer the new behaviour. At t
Hi Richard,
On Thu, 26 Oct 2006 17:23:17 +, you wrote:
> So the question:
> Who will be adversely effected by the new error behavior
> in the sqlite command-line shell?
Not really. I prefer the new behaviour. At the moment
I have to jump through hoops and scan my make logs to
detect errors
[EMAIL PROTECTED] writes:
> So the question: Who will be adversely effected by the new
> error behavior in the sqlite command-line shell? Who is
> using the sqlite command-line shell in scripts in such a
> way that the script will no longer work with the new
> behaviors? Do I need to change the
I don't use the command-line shell, but I'd definitely prefer not to see
a fundamental change in the behavior of any tool I use. The debugging
could get nasty and it's possible that someone using the tool in an
unsupervised script might not notice the problem until after it had done
some damage
On 9/14/05, Sijm, Norbert <[EMAIL PROTECTED]> wrote:
>
>
>
> Hi, I'm trying to execute a command in a DOS batchfile , but I get a syntax
> error. Is this supported in 2.8.16 ?
> ( sqlite mydbase.db select * from table1; )
Try enclosing your SQL statements in double quotes, like this:
sqlite my
Puneet,
Puneet Kishor <[EMAIL PROTECTED]>
03/05/2004 05:01 AM
To: SQLite <[EMAIL PROTECTED]>
cc:
Subject:[sqlite] command history
> Is there a way to enable some kind of command history in the SQLite
> shell? You know, press the up arrow to get the pr
On May 3, 2004, at 3:48 AM, eno wrote:
Puneet Kishor wrote:
Actually I am on Mac OS X 10.3. I have no idea what I need to do to
enable READLINE. I just downloaded the source and did the
./configure, make, make install dance and got no READLINE. It must be
somewhere on my system because the beh
Puneet Kishor wrote:
Actually I am on Mac OS X 10.3. I have no idea what I need to do to
enable READLINE. I just downloaded the source and did the ./configure,
make, make install dance and got no READLINE. It must be somewhere on my
system because the behavior I want is very much a part of tcsh
On May 2, 2004, at 4:22 PM, Kurt Welgehausen wrote:
I think it is called READLINE support, no? ...
Yes, the SQLite shell uses readline by default under Linux,
so you must be using something else. Readline has been
ported to MS Windows, but I don't know what would be involved
in rebuilding the she
>> I think it is called READLINE support, no? ...
Yes, the SQLite shell uses readline by default under Linux,
so you must be using something else. Readline has been
ported to MS Windows, but I don't know what would be involved
in rebuilding the shell to link and use the readline library
under MSW
Paul,
Thanks very much for a clear explanation, and one which I could understand!
Pity about the no-timing returns, but I suppose it's obvious that you should
employ indexes wherever possible
Now to test all my "selects"
Thanks again,
Brian
At 15:20 28/11/2003, [EMAIL PROTECTED] wrote:
I'm attempting to use the command-line SQLite to test the speed of certain
"selects" and how writing them in different fashions affects speed
OK, can anyone explain (no pun intended!) what I should be looking for in
what information "explain" returns
51 matches
Mail list logo
