I'm trying to learn SQLite for Python...Best method? [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. 开发者_运维知识库 Closed 11 years ago.

I've read a few books that touch on SQLite but nothing concrete enough to help me learn it within Python, Question is, is there any book or source you could recommend to help me with this...

Secondly is learning MySQL the same as learning SQLite because I see those resources everywhere...

---

You probably want to learn about SQL, variants of which are used by a number of different relational databases, including MySQL and SQLite (which as several comments have pointed out you are mixing together) using the python standard library's sqlite3 module. You can't go wrong with Doug Hellmann's PyMOTW introduction to the sqlite3 module: http://www.doughellmann.com/PyMOTW/sqlite3/.

---

Just as zeekay said, MySQL and SQLite are two different relational databases. They can work independently without support of Python. For example, you can use command console or firefox sqlite plugin to manipulate sqlite database. I guess what you want to learn is the python API how to manipulate sqlite. I would recommend sqlite3 as the first choice. It follows the DB-API2 interface and easy to learn. And as soon as you understand how to use connection and cursor class, you can do a lot of things with sqlite.