Re: [sqlite] a suggestion to write tutorial for sqlite

[Alex Katebi]

http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730

Excellent book!



On Sat, Apr 19, 2008 at 12:37 PM, mikeobe <[EMAIL PROTECTED]> wrote:

> i found it boring to learn how to use sqlite, maybe we can write a
> tutorial for it, with examples,
> it will be much easier for the beginner to start with sqlite.
>
> 2008-04-19
> mikeobe
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Gerry Snyder]

P Kishor wrote:
> 
>
>
> For starters, a database of every single email from Igor and Dennis
> Cote should be mandatory reading for anyone wanting to do anything
> with SQLite.
And drh and Dan Kennedy and Scott Hess.

You probably assumed that the first of these went without saying.


Gerry
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Mike McGonagle]

For what it is worth, while I had done a few simple things in MySQL prior to
using SQLite, I think it would be nice if there were a couple of different
"tracks" of tutorials. Maybe they could be one for the "Novice", one for an
"Experienced" user, and then one for those that are doing actual C
development using SQLite.
The first two catagories would be limited to using only SQL, where the
Novice track might provide some simple tutorials on database design (yes, I
know there are so many other out there, and they could be referenced, too,
but I think it would be a good thing to have a completely self-contained way
to learn SQLite). The Experienced track might get into topics that are a bit
more higher level SQL stuff, like triggers, indexing, transactions, etc.
Also, both of these "track" might stick to using the Commandline version of
SQLite.

This way, different users can start one whatever tutorials that their level
of experience demands.

Just another 2cent opinion.

Mike


On Sat, Apr 19, 2008 at 11:37 AM, mikeobe <[EMAIL PROTECTED]> wrote:

> i found it boring to learn how to use sqlite, maybe we can write a
> tutorial for it, with examples,
> it will be much easier for the beginner to start with sqlite.
>
> 2008-04-19
> mikeobe
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Peace may sound simple—one beautiful word— but it requires everything we
have, every quality, every strength, every dream, every high ideal.
—Yehudi Menuhin (1916–1999), musician
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[P Kishor]

On 4/21/08, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> FWIW, I'll be happy to give write access to the documentation
>  repository (http://www.sqlite.org/docsrc/) and even a
>  prestigious "sqlite.org" email alias to anybody who is
>  willing to step up and make some improvements and
>  updates to the current documentation.
>

 my kingdom for a sqlite.org email alias.


For starters, a database of every single email from Igor and Dennis
Cote should be mandatory reading for anyone wanting to do anything
with SQLite.




>
>  D. Richard Hipp
>  [EMAIL PROTECTED]
>
>
>



-- 
Puneet Kishor http://punkish.eidesis.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Robert L Cochran]

I think later this year, I may be happy to take up this challenge. I've
always wanted to contribute to something like this. I cannot do it for
at least a few months. I'll need a lot of feedback from the true
database experts out there (as opposed to beginners like me.) Plus I
have 15,338 sqlite-users emails I can mine for tutorial perls right here.

I love writing projects.

Bob Cochran
Greenbelt, Maryland, USA


D. Richard Hipp wrote:
> FWIW, I'll be happy to give write access to the documentation
> repository (http://www.sqlite.org/docsrc/) and even a
> prestigious "sqlite.org" email alias to anybody who is
> willing to step up and make some improvements and
> updates to the current documentation.
>
> D. Richard Hipp
> [EMAIL PROTECTED]
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Toby Roworth]

D. Richard Hipp wrote:
> FWIW, I'll be happy to give write access to the documentation
> repository (http://www.sqlite.org/docsrc/) and even a
> prestigious "sqlite.org" email alias to anybody who is
> willing to step up and make some improvements and
> updates to the current documentation.
>
> D. Richard Hipp
> [EMAIL PROTECTED]
>
>
>   
As I haven't been using SQLite for very long, although I can't write the 
documentation, I'm happy to read through drafts and give pointers to 
what might need to be changed - I'm probably still at the stage where I 
need to read something like this, so I could quite happily be a "test 
candidate" if it helps.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   

-- 

Sent by Toby Roworth ([EMAIL PROTECTED])
This message is intended for the named reciepients only, and should not 
be forwarded without permission
The conents of this message may be ©Toby Roworth


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[D. Richard Hipp]

FWIW, I'll be happy to give write access to the documentation
repository (http://www.sqlite.org/docsrc/) and even a
prestigious "sqlite.org" email alias to anybody who is
willing to step up and make some improvements and
updates to the current documentation.

D. Richard Hipp
[EMAIL PROTECTED]



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Wilson, Ron P]

Along these lines, also note that the "quickstart" (url below) still
shows the callback method instead of the v2 methods.  The last time
another programmer asked me for help, I referred him there and I was
shocked later at the code he produced.  "Nice code, but you could have
done the same thing a lot easier with the v2 methods."  "The v2
methods?"  "Yeah."  "But this is SQlite3.  Why would I use v2 methods?"

http://www.sqlite.org/quickstart.html 

Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Toby Roworth]

I'm sorry if this reply seems jumbled - I wrote the middle bit (about 
the sugested content) after the bits above and below it.

Jay A. Kreibich wrote:
> On Sat, Apr 19, 2008 at 05:40:45PM +0100, Toby Roworth scratched on the wall:
>   
>> mikeobe wrote:
>> 
>>> i found it boring to learn how to use sqlite, maybe we can write a
>>> tutorial for it, with examples, it will be much easier for the
>>> beginner to start with sqlite.
>>>   
>> Agreed - I had to learn from the 5 minute introduction (which I was 
>> later told was a poor way of doing it), and then by using the reference, 
>> which leaves a lot to be desired when it comes to having little 
>> knowledge of SQLite - and it's still giving me trouble now!
>> 
>
>   What are we looking for?  A 60 minute introduction?
>
>   Any thoughts on specific topics, or is the main thing just
>   covering the basics of the API in vanilla situations?
>   
I think that's exactly what we need - how to run a SQL statement and 
return/print the results.

A brief explanation of:
sqlite3_open_v2()
sqlite3_prepare_v2()
sqlite3_step()
sqlite3_finalize()
sqlite3_close()
and any other important ones
might be nice, in slightly more friendlier terms then the API reference, 
then an example thet puts them toggether.
>   I have a great deal of interest in this area, and would love to hear
>   from anyone that has thoughts, ideas, or comments.  I would
>   especially like to hear if there is a specific area or concept that
>   confused folks when they were learning SQLite.
>   
Ideally, the tutorial would allow someone who has very limited/no 
database knowledge to be able to use SQLite in a simple application, EG 
an address book:
1: Database design (in sqlite3 program?) (creating the table containing 
name, address, telehone)
2: queries to run (finding all people living at an address, finding 
someone's phone number, possible annother)
3: The above bit - run down of frequently used functions
4: putting it all toggether into a C program
5: code listing (could be in 4)

I think something along these lines could work weel, as long as it is 
well written
>   SQLite tends to get used by a lot of people that have a stronger
>   background in software development than in databases, so I would
>   expect there to be some confusion about "database things" like table
>   design and complex query commands.  Solid introductory materials need
>   to take that into account, but we need to gather some more
>   information on precisely what that difference means.
>   
Should a separate SQL/databases introduction be available - this could 
be quite useful, but would it be duplicating what's already available 
elsewhere (see above point)
>
>   This is a bit off-topic for the mailing list, so please feel free
>   to send stuff directly to the address below.
>
>-j
>
>
>   

-- 

Sent by Toby Roworth ([EMAIL PROTECTED])
This message is intended for the named reciepients only, and should not 
be forwarded without permission
The conents of this message may be ©Toby Roworth


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Fred J. Stephens]

I think one of the most lacking aspects of the documentation are 
examples. Perhaps this is better addressed in the proposed tutorial, but 
not all the "SQL Syntax" pages make it clear how to use the statement, 
especially the more complex ones like SELECT, and expressions.
The datetime use is also not always easy to grasp (as witnessed by 
questions on this list).
So, I think a tutorial is a great idea!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Robert L Cochran]

D. Richard Hipp wrote:
> On Apr 19, 2008, at 5:44 PM, Jay A. Kreibich wrote:
>   
>>  This is a bit off-topic for the mailing list, so please feel free
>>  to send stuff directly to the address below.
>>
>> 
>
> It would be good, I think, to have a public record of this
> conversation.  We can create an [EMAIL PROTECTED]
> mailing list if you think it would help.
>
> D. Richard Hipp
> [EMAIL PROTECTED]
>
>   
I agree with DRH. I too would like to see a public record so that
everyone can contribute and discuss. I see great value in a tutorial not
just for myself (I'm no great database expert...yet!), but also for
other members of my project team at my place of employment, and the
students I try to introduce databases to.

Also...I just recieved an Amazon Kindle reader. I am still learning how
to use it but I'd like the page design of any tutorial to take in mind
someone like me might pop it on an e-book reader like the Kindle. So
far, Amazon seems to be having trouble converting pdf documents to
Kindle format. The conversion process "mixes up" text on a short sample
PDF document I'm testing with. It could be due to the way the PDF is
designed (the author may have made mistakes during the conversion to PDF
which got amplified by my subsequent conversion to Amazon Kindle
format). Any errors that can be traced to Amazon's conversion software
will probably get fixed fast, especially if the company open sources it.
But anyhow folks, let's keep in mind that a tutorial should have a page
design that is e-book friendly.

Thanks

Bob Cochran
Greenbelt, Maryland, USA


>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[ajm]

Why not include a section "User Contributed Notes" (in the style of the php 
doc) besides each page of the SQLite man pages?
specially those devoted to:

 1. List Of Objects
 2. List Of Constants
 3. List Of Functions

HTH 

Adolfo.

-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 19, 2008 05:47 PM
To: [EMAIL PROTECTED], 'General Discussion of SQLite Database'
Subject: Re: [sqlite] a suggestion to write tutorial for sqlite

On Apr 19, 2008, at 5:44 PM,
Jay A. Kreibich wrote:
 >> This is a bit off-topic for the mailing list, so please feel free
> to send stuff directly to the address below.
>It would be good, I think, to have a public record of thisconversation.
 We can create an [EMAIL PROTECTED] list if you think it would help.
D. Richard [EMAIL PROTECTED]


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Ken]

A few things that confused me in my (still ongoing) learning.
   
  1. Bindings, in that the bind needed to be perfomed each and every time.
  2. Transactions, the begin vs begin immediate. Coming from a database 
background I assumed the begin started the transaction but did not...
  3. Locking, SQLITE_BUSY waiting.
  4. Page size pragma having  to use this prior to creating a table for it to 
be effective.
  5. Prepare/bind/step/finalize/reset and when to use in success/error 
conditions.
  6. Thread safety and threaded access. But this has been vastly improved in 
3.5.x series!
  7. Shared cache, appropriate uses?
   
  Just a start and my .02
   
  Thanks,
  Ken
  
"Jay A. Kreibich" <[EMAIL PROTECTED]> wrote:
  
On Sat, Apr 19, 2008 at 05:40:45PM +0100, Toby Roworth scratched on the wall:
> mikeobe wrote:
> > i found it boring to learn how to use sqlite, maybe we can write a
> > tutorial for it, with examples, it will be much easier for the
> > beginner to start with sqlite.
>
> Agreed - I had to learn from the 5 minute introduction (which I was 
> later told was a poor way of doing it), and then by using the reference, 
> which leaves a lot to be desired when it comes to having little 
> knowledge of SQLite - and it's still giving me trouble now!

What are we looking for? A 60 minute introduction?

Any thoughts on specific topics, or is the main thing just
covering the basics of the API in vanilla situations?

I have a great deal of interest in this area, and would love to hear
from anyone that has thoughts, ideas, or comments. I would
especially like to hear if there is a specific area or concept that
confused folks when they were learning SQLite.

SQLite tends to get used by a lot of people that have a stronger
background in software development than in databases, so I would
expect there to be some confusion about "database things" like table
design and complex query commands. Solid introductory materials need
to take that into account, but we need to gather some more
information on precisely what that difference means.


This is a bit off-topic for the mailing list, so please feel free
to send stuff directly to the address below.

-j


-- 
Jay A. Kreibich < J A Y @ K R E I B I.C H >

"'People who live in bamboo houses should not throw pandas.' Jesus said that."
- "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006"
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[D. Richard Hipp]

On Apr 19, 2008, at 5:44 PM, Jay A. Kreibich wrote:
>
>  This is a bit off-topic for the mailing list, so please feel free
>  to send stuff directly to the address below.
>

It would be good, I think, to have a public record of this
conversation.  We can create an [EMAIL PROTECTED]
mailing list if you think it would help.

D. Richard Hipp
[EMAIL PROTECTED]



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Jay A. Kreibich]

On Sat, Apr 19, 2008 at 05:40:45PM +0100, Toby Roworth scratched on the wall:
> mikeobe wrote:
> > i found it boring to learn how to use sqlite, maybe we can write a
> > tutorial for it, with examples, it will be much easier for the
> > beginner to start with sqlite.
>
> Agreed - I had to learn from the 5 minute introduction (which I was 
> later told was a poor way of doing it), and then by using the reference, 
> which leaves a lot to be desired when it comes to having little 
> knowledge of SQLite - and it's still giving me trouble now!

  What are we looking for?  A 60 minute introduction?

  Any thoughts on specific topics, or is the main thing just
  covering the basics of the API in vanilla situations?

  I have a great deal of interest in this area, and would love to hear
  from anyone that has thoughts, ideas, or comments.  I would
  especially like to hear if there is a specific area or concept that
  confused folks when they were learning SQLite.

  SQLite tends to get used by a lot of people that have a stronger
  background in software development than in databases, so I would
  expect there to be some confusion about "database things" like table
  design and complex query commands.  Solid introductory materials need
  to take that into account, but we need to gather some more
  information on precisely what that difference means.


  This is a bit off-topic for the mailing list, so please feel free
  to send stuff directly to the address below.

   -j


-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"'People who live in bamboo houses should not throw pandas.' Jesus said that."
   - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006"
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

[Toby Roworth]

Agreed - I had to learn from the 5 minute introduction (which I was 
later told was a poor way of doing it), and then by using the reference, 
which leaves a lot to be desired when it comes to having little 
knowledge of SQLite - and it's still giving me trouble now!

Toby

mikeobe wrote:
> i found it boring to learn how to use sqlite, maybe we can write a tutorial 
> for it, with examples, 
> it will be much easier for the beginner to start with sqlite.
>
> 2008-04-19 
> mikeobe 
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   

-- 

Sent by Toby Roworth ([EMAIL PROTECTED])
This message is intended for the named reciepients only, and should not 
be forwarded without permission
The conents of this message may be ©Toby Roworth


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] a suggestion to write tutorial for sqlite

[mikeobe]

i found it boring to learn how to use sqlite, maybe we can write a tutorial for 
it, with examples, 
it will be much easier for the beginner to start with sqlite.

2008-04-19 
mikeobe 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A suggestion

[jphillip]

Doskey was the history TSR.

On Wed, 9 May 2007, Rich Shepard wrote:

> On Wed, 9 May 2007, John Stanton wrote:
> 
> > That program does have the capability, but may not be implemented that way
> > on Windows.  Why not make the change yourself?
> >
> > A.J.Millan wrote:
> > > As a suggestion, and even in the risk to abuse of Mr Hipp's patience.
> > > Would
> > > it be possible to include in the command-line program (sqlite3.exe) the
> > > ability to edit, an repeat at least the five or six last commands, as in
> > > Linux?. Is to say with up-arrow and down-arrow.  I believe it would be too
> > > helpful.
> 
>   That, I believe, is a function of the shell, not the application using it.
> For example, the command history available in bash is not present -- at
> least, was not present -- in sh. Command history, IIRC, was a feature of the
> csh, and bash (the Bourne Again Shell) took the best features of sh, csh,
> and the Textronics version tcsh.
> 
>   Years ago, about a decade, when I had PC DOS 7.0 installed along with
> linux, I discovered that the DOS shell allowed tab completions. I don't
> recall if it had the history recall, too.
> 
> Rich
> 
> -- 
> Richard B. Shepard, Ph.D.   |The Environmental Permitting
> Applied Ecosystem Services, Inc.|  Accelerator(TM)
>  Voice: 503-667-4517  Fax: 503-667-8863
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 
> 

You have to be BRAVE to grow OLD.
There are no old CARELESS pilots or electricians.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] A suggestion

[Trey Mack]

Works for me straight out of the box on Windows XP.


That program does have the capability, but may not be implemented that way 
on Windows.  Why not make the change yourself?


A.J.Millan wrote:
As a suggestion, and even in the risk to abuse of Mr Hipp's patience. 
Would

it be possible to include in the command-line program (sqlite3.exe) the
ability to edit, an repeat at least the five or six last commands, as in
Linux?. Is to say with up-arrow and down-arrow.  I believe it would be 
too

helpful.




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] A suggestion

[John Stanton]

Rich Shepard wrote:

On Wed, 9 May 2007, John Stanton wrote:

That program does have the capability, but may not be implemented that 
way on Windows.  Why not make the change yourself?


A.J.Millan wrote:

As a suggestion, and even in the risk to abuse of Mr Hipp's patience. 
Would

it be possible to include in the command-line program (sqlite3.exe) the
ability to edit, an repeat at least the five or six last commands, as in
Linux?. Is to say with up-arrow and down-arrow.  I believe it would 
be too

helpful.



  That, I believe, is a function of the shell, not the application using 
it.

For example, the command history available in bash is not present -- at
least, was not present -- in sh. Command history, IIRC, was a feature of 
the

csh, and bash (the Bourne Again Shell) took the best features of sh, csh,
and the Textronics version tcsh.

  Years ago, about a decade, when I had PC DOS 7.0 installed along with
linux, I discovered that the DOS shell allowed tab completions. I don't
recall if it had the history recall, too.

Rich


It would be a function of "readline".  I have not looked closely but I
would imagine that to implement or emulate readline on Windows would
achieve the function.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] A suggestion

[Rich Shepard]

On Wed, 9 May 2007, John Stanton wrote:

That program does have the capability, but may not be implemented that way on 
Windows.  Why not make the change yourself?


A.J.Millan wrote:

As a suggestion, and even in the risk to abuse of Mr Hipp's patience. Would
it be possible to include in the command-line program (sqlite3.exe) the
ability to edit, an repeat at least the five or six last commands, as in
Linux?. Is to say with up-arrow and down-arrow.  I believe it would be too
helpful.


  That, I believe, is a function of the shell, not the application using it.
For example, the command history available in bash is not present -- at
least, was not present -- in sh. Command history, IIRC, was a feature of the
csh, and bash (the Bourne Again Shell) took the best features of sh, csh,
and the Textronics version tcsh.

  Years ago, about a decade, when I had PC DOS 7.0 installed along with
linux, I discovered that the DOS shell allowed tab completions. I don't
recall if it had the history recall, too.

Rich

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.|  Accelerator(TM)
 Voice: 503-667-4517  Fax: 503-667-8863

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] A suggestion

[John Stanton]

That program does have the capability, but may not be implemented that 
way on Windows.  Why not make the change yourself?


A.J.Millan wrote:

As a suggestion, and even in the risk to abuse of Mr Hipp's patience. Would
it be possible to include in the command-line program (sqlite3.exe) the
ability to edit, an repeat at least the five or six last commands, as in
Linux?. Is to say with up-arrow and down-arrow.  I believe it would be too
helpful.

A.J.Millan
ZATOR Systems


-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] A suggestion

[A.J.Millan]

Sorry!!

Although there are two other boxes around; one with XP and the other with
Vista, for test purposes, actually I still use  a third, with my old Windows
98SE and a utility, DOSKEY.COM, who emulates the Linux behavior in the
Windows shell (who natively does not do that), but when I use it with
sqlite3.exe that ability is lost.

By the way, after this response, I have been looking in the XP box and there
are a doskey.exe, but does not work in that way, but when try with sqlite3
in it, that works fine!!

Perhaps that would make me jump to that system despite my reluctance :-)

A.J.Millan
ZATOR Systems



- Original Message - 
From: "Peter van Dijk" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, May 09, 2007 12:11 PM
Subject: Re: [sqlite] A suggestion


>
> On 9-mei-2007, at 11:06, A.J.Millan wrote:
>
> > As a suggestion, and even in the risk to abuse of Mr Hipp's
> > patience. Would
> > it be possible to include in the command-line program (sqlite3.exe)
> > the
> > ability to edit, an repeat at least the five or six last commands,
> > as in
> > Linux?. Is to say with up-arrow and down-arrow.  I believe it would
> > be too
> > helpful.
>
> Arrow up and down work fine for me, I'm not sure what your actual
> request is then?
>
> Cheers, Peter.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] A suggestion

[Lloyd]

In old versions it work... But in new versions (3.* I think) its not
working!

On Wed, 2007-05-09 at 12:11 +0200, Peter van Dijk wrote:
> On 9-mei-2007, at 11:06, A.J.Millan wrote:
> 
> > As a suggestion, and even in the risk to abuse of Mr Hipp's  
> > patience. Would
> > it be possible to include in the command-line program (sqlite3.exe)  
> > the
> > ability to edit, an repeat at least the five or six last commands,  
> > as in
> > Linux?. Is to say with up-arrow and down-arrow.  I believe it would  
> > be too
> > helpful.
> 
> Arrow up and down work fine for me, I'm not sure what your actual  
> request is then?
> 
> Cheers, Peter.
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] A suggestion

[Peter van Dijk]

On 9-mei-2007, at 11:06, A.J.Millan wrote:

As a suggestion, and even in the risk to abuse of Mr Hipp's  
patience. Would
it be possible to include in the command-line program (sqlite3.exe)  
the
ability to edit, an repeat at least the five or six last commands,  
as in
Linux?. Is to say with up-arrow and down-arrow.  I believe it would  
be too

helpful.


Arrow up and down work fine for me, I'm not sure what your actual  
request is then?


Cheers, Peter.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] A suggestion

[A.J.Millan]

As a suggestion, and even in the risk to abuse of Mr Hipp's patience. Would
it be possible to include in the command-line program (sqlite3.exe) the
ability to edit, an repeat at least the five or six last commands, as in
Linux?. Is to say with up-arrow and down-arrow.  I believe it would be too
helpful.

A.J.Millan
ZATOR Systems


-
To unsubscribe, send email to [EMAIL PROTECTED]
-