Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[Skip Montanaro]

> I have one on my desk at work whose name I can't remember off the
> top of my head.  I still refer to it from time-to-time.  If you'd
> like a reference, let me know and I'll check on it at work.

While I think of it:

"The Practical SQL Handbook; Using Structured Query Language," by
Bowman, Emerson, and Darnovsky

Mine's the third edition.  It even has a Sybase SQL Runtime CDROM
inside the back cover.  How quaint. :-)  There is a fourth edition
available.

Skip
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[Skip Montanaro]

> Can someone suggest me better resources for learning sql/sqlite3?

The concepts behind the Structured Query Language haven't changed much
since Edgar Codd first developed them in the 1970s.  (He received the
Turing Award in 1981 for this work.)

Building and querying databases is very easy to do very badly,
especially if you are new to its concepts.  This is a case where a
textbook might be helpful. Since these ideas have been around for a
long while, there are plenty of good books on the subject. I have one
on my desk at work whose name I can't remember off the top of my head.
 I still refer to it from time-to-time.  If you'd like a reference,
let me know and I'll check on it at work.

Skip
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[memilanuk]

On 08/03/2013 10:57 AM, Aseem Bansal wrote:
> I was writing a Python script for getting the user stats of a
> website(Specifically codereview.stackexchange). I wanted to store the
> stats in a database. I found Python3's sqlite3 library. I found that
> I needed sql commands for using it.
> 
> I have tried sql.learncodethehardway but it isn't complete yet. I
> tired looking on stackoverflow's  sql tag also but nothing much
> there. Can someone suggest me better resources for learning
> sql/sqlite3?
> 

https://www.youtube.com/watch?v=__eI1sbEfLw&feature=c4-overview-vl&list=PLAA9B7C174493EC68

The same author has some other videos on working with sqlite in general,
sql, etc. that may also prove useful.

-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[Jordi Riera]

Hey,

can't you use django to deal with your sqlite?
If so, django modelsare
a smart way to do.

Regards,
Jordi


On Tue, Aug 6, 2013 at 12:51 PM, Gilles  wrote:

> On Sat, 3 Aug 2013 10:57:32 -0700 (PDT), Aseem Bansal
>  wrote:
> >I found Python3's sqlite3 library. I found that I needed sql commands for
> using it.
> >
> >I have tried sql.learncodethehardway but it isn't complete yet. I tired
> looking on stackoverflow's  sql tag also but nothing much there.
>
> It'll be easier to read tutorials specifically meant to use Sqlite
> with Python:
>
> www.google.com/search?q=python+sqlite+examples
> --
> http://mail.python.org/mailman/listinfo/python-list
>



-- 
- Jordi Riera, Connecting people.
+33 662217507
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[Gilles]

On Sat, 3 Aug 2013 10:57:32 -0700 (PDT), Aseem Bansal
 wrote:
>I found Python3's sqlite3 library. I found that I needed sql commands for 
>using it.
>
>I have tried sql.learncodethehardway but it isn't complete yet. I tired 
>looking on stackoverflow's  sql tag also but nothing much there.

It'll be easier to read tutorials specifically meant to use Sqlite
with Python:

www.google.com/search?q=python+sqlite+examples
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[inq1ltd]

On Saturday, August 03, 2013 10:57:32 AM Aseem Bansal wrote:
> I was writing a Python script for getting the user stats of a
> website(Specifically codereview.stackexchange). I wanted to store the 
stats
> in a database. I found Python3's sqlite3 library. I found that I needed sql
> commands for using it.
> 
> I have tried sql.learncodethehardway but it isn't complete yet. I tired
> looking on stackoverflow's  sql tag also but nothing much there. Can
> someone suggest me better resources for learning sql/sqlite3?


Go to:
sqlite-us...@sqlite.org
and join.

Ask any question, you will get an answer.
 
Print out the manual.  For someone that is not 
familiar with Relational DB programming it
may look like a newspaper from 
another planet, but you should have it.

You mentioned creating a database for stats. Learn 
how to create a table, and populate it. that is basic.
Ask how to on the users help site, then compare the 
method sent to you to the manual.  You need to know 
how the answer relates to the manual.

The sqlite manual is in the standard format that is the 
accepted world wide.  Once you can understand 
the manual format you can work your way through a 
lot of what you want to do. 

jimonlinux
inqvista.com







-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[CM]

ave tried sql.learncodethehardway but it isn't complete yet. I tired looking on 
stackoverflow's  sql tag also but nothing much there. Can someone suggest me 
better resources for learning sql/sqlite3?

There are a lot of nice small tutorials out there found by Googling.  One 
resource that you might not find easily, though, and that helped me a while 
back and I liked is:

http://sqlzoo.net/howto/source/u.cgi/tip241028/sqlite

The thing about that page is, if you go to the main site, sqlzoo.net, it seems 
that SQLite is no longer one of the options.  But if you go through the link I 
gave above, you can find the older site that does treat SQLite.  To find the 
other command examples, I guess use Google like so:

sqlite zoo INSERT
sqlite zoo UPDATE

and others.  I don't know why SQLite was dropped from the Zoo's roster; I 
really liked that format.
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[Cousin Stanley]

Aseem Bansal wrote:

> 
> Can someone suggest me better resources 
> for learning sql/sqlite3 ?

  http://docs.python.org/3/library/sqlite3.html

  http://wiki.python.org/moin/DbApiCheatSheet

  http://www.w3schools.com/sql/default.asp

  http://www.sqlcourse.com/index.html

  http://sqlite.org/docs.html

  http://zetcode.com/db/sqlite/  
 


-- 
Stanley C. Kitching
Human Being
Phoenix, Arizona

-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[Joel Goldstick]

On Sat, Aug 3, 2013 at 1:57 PM, Aseem Bansal  wrote:
> I was writing a Python script for getting the user stats of a 
> website(Specifically codereview.stackexchange). I wanted to store the stats 
> in a database. I found Python3's sqlite3 library. I found that I needed sql 
> commands for using it.
>
> I have tried sql.learncodethehardway but it isn't complete yet. I tired 
> looking on stackoverflow's  sql tag also but nothing much there. Can someone 
> suggest me better resources for learning sql/sqlite3?

Have you tried the sqlite home page at http://www.sqlite.org/


> --
> http://mail.python.org/mailman/listinfo/python-list



-- 
Joel Goldstick
http://joelgoldstick.com
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[Vito De Tullio]

Aseem Bansal wrote:

> I have tried sql.learncodethehardway but it isn't complete yet. I tired
> looking on stackoverflow's  sql tag also but nothing much there. Can
> someone suggest me better resources for learning sql/sqlite3?

a start is the sqlite homepage: http://www.sqlite.org/docs.html

-- 
By ZeD

-- 
http://mail.python.org/mailman/listinfo/python-list

Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

[Aseem Bansal]

I was writing a Python script for getting the user stats of a 
website(Specifically codereview.stackexchange). I wanted to store the stats in 
a database. I found Python3's sqlite3 library. I found that I needed sql 
commands for using it.

I have tried sql.learncodethehardway but it isn't complete yet. I tired looking 
on stackoverflow's  sql tag also but nothing much there. Can someone suggest me 
better resources for learning sql/sqlite3? 
-- 
http://mail.python.org/mailman/listinfo/python-list