Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #51875 > unrolled thread

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

Back to article view | Back to comp.lang.python

Contents

  Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. Aseem Bansal <asmbansal2@gmail.com> - 2013-08-03 10:57 -0700
    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 <vito.detullio@gmail.com> - 2013-08-03 20:47 +0200
    Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. Joel Goldstick <joel.goldstick@gmail.com> - 2013-08-03 14:53 -0400
    Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. Cousin Stanley <cousinstanley@gmail.com> - 2013-08-03 19:06 +0000
    Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. CM <cmpython@gmail.com> - 2013-08-03 17:53 -0700
    Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. inq1ltd <inq1ltd@inqvista.com> - 2013-08-04 11:01 -0400
    Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. Gilles <nospam@nospam.com> - 2013-08-06 12:51 +0200
      Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. Jordi Riera <kender.jr@gmail.com> - 2013-08-06 13:05 +0200
    Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. memilanuk <memilanuk@gmail.com> - 2013-08-06 20:22 -0700
    Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. Skip Montanaro <skip@pobox.com> - 2013-08-07 05:59 -0500
    Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. Skip Montanaro <skip@pobox.com> - 2013-08-07 12:43 -0500
    Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-08-07 18:34 -0400

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

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? 

[toc] | [next] | [standalone]

#51877

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

[toc] | [prev] | [next] | [standalone]

#51878

On Sat, Aug 3, 2013 at 1:57 PM, Aseem Bansal <asmbansal2@gmail.com> 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

[toc] | [prev] | [next] | [standalone]

#51881

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

[toc] | [prev] | [next] | [standalone]

#51910

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.

[toc] | [prev] | [next] | [standalone]

#51925

[Multipart message — attachments visible in raw view] — view raw

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-users@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

[toc] | [prev] | [next] | [standalone]

#52029

On Sat, 3 Aug 2013 10:57:32 -0700 (PDT), Aseem Bansal
<asmbansal2@gmail.com> 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

[toc] | [prev] | [next] | [standalone]

#52036

[Multipart message — attachments visible in raw view] — view raw

Hey,

can't you use django to deal with your sqlite?
If so, django models<https://docs.djangoproject.com/en/dev/topics/db/models/>are
a smart way to do.

Regards,
Jordi


On Tue, Aug 6, 2013 at 12:51 PM, Gilles <nospam@nospam.com> wrote:

> On Sat, 3 Aug 2013 10:57:32 -0700 (PDT), Aseem Bansal
> <asmbansal2@gmail.com> 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

[toc] | [prev] | [next] | [standalone]

#52099

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.

[toc] | [prev] | [next] | [standalone]

#52130

> 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

[toc] | [prev] | [next] | [standalone]

#52142

> 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

[toc] | [prev] | [next] | [standalone]

#52153

On Wed, 7 Aug 2013 12:43:55 -0500, Skip Montanaro <skip@pobox.com>
declaimed the following:


>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.

	Well -- it might be useful for transitioning to M$ SQL Server/MSDE...
As I recall, SQL Server started life as a port of Sybase. <G>

	Thought Codd did NOT define SQL (which sort of combines relational
calculus with some relational algebra); early relational theory was more a
"view" and "analysis" of database data -- which could possibly be overlaid
on hierarchical and network implementations. SQL was about a decade later,
branched off of the Sequel language. Most modern RDBMs seem to have
reverted to using the logical view as the physical storage <G>

	I'm afraid the books on my shelf wouldn't help for SQL...

	Yang "Relational Databases", Date "Database Design and Relational
Theory", Maier "The Theory of Relational Databases", and von Halle
"Handbook of Relational Database Design" (and Gio Wiederhold is in storage)

	Most of them probably predate the first SQL standard <G>

-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
    wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web