From: Panagiotis Atmatzidis <ml@...>
Date: 2012-08-04T14:56:46+09:00
Subject: Re: Help with sqlite3 please

Hello,

On 4 Αυγ 2012, at 07:25 , Kaye Ng <lists@ruby-forum.com> wrote:

> Chris Hulan wrote in post #1071197:
>> 'SQL' is not part of the command
>> See the example here: http://www.sqlite.org/sqlite.html
>> 
> Got it.  But I was only following a book, can you tell me why it says 
> 'type SQL and press enter'?
> 
> "If you want to play along at home, you can use the command-line sqlite3 
> client to create a
> database and perform SQL queries upon it without getting involved with 
> Ruby at all. Just run
> sqlite3 test.db, where test.db is your chosen database file name. You 
> can then type SQL and
> press Enter to execute it. To leave the client, you can type .quit on a 
> separate line and press
> Enter."
> 
> Thank you.
> 
> -- 
> Posted via http://www.ruby-forum.com/.
> 



I don't know exactly what book are you reading. The references that other users showed and the comments they made are all valid. If you want to see a small readable example of SQLite3 usage in ruby, take a look at my script, which saves tweets into an SQLite3 database.

It's not advanced in any way but it clearly shows how to handle SQLite3 queries and issue commands using ruby.

https://github.com/atmosx/morula/blob/master/morula

Best Regards,


Panagiotis Atmatzidis
-----------------------------
Pharmacy Student at VFU

email4lists: 	ml@convalesco.org
More info: 	http://about.me/atmosx

The wise man said: "Never argue with an idiot, he brings you down to his level and beat you with experience."