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

Groups > comp.lang.python > #51925

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

Show all headers | View raw

[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

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

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

csiph-web