Top "Pysqlite" questions

A DB-API2 compliant module in Python for interacting with a SQLite relational database.

Python SQLite: database is locked

I'm trying this code: import sqlite connection = sqlite.connect('cache.db') cur = connection.cursor() cur.execute('''create table item (id …

python sqlite pysqlite
How to install pysqlite?

I am trying to install pysqlite (Python interface to the SQLite). I downloaded the file with the package (pysqlite-2.5.5.tar.…

python linux sqlite gcc pysqlite
I can't get Python's executemany for sqlite3 to work properly

I was trying to use executemany to insert values into a database, but it just won't work for me. Here …

python sqlite pysqlite
Why can't pip uninstall pysqlite?

I'm trying to remove pysqlite from my system using pip. What I get doing so makes no sense: $ pip uninstall …

python pip pysqlite
WARNING: IPython History requires SQLite, your history will not be saved

Hi I'm using Ubuntu release 12.10 (quantal) 32-bit with Linux Kernel 3.5.0-21-generic. I'm trying to get IPython's History to work. …

python sqlite ipython pysqlite
"%s" % format vs "{0}".format() vs "?" format

In this post about SQLite, aaronasterling told me that cmd = "attach \"%s\" as toMerge" % "b.db" : is wrong cmd = 'attach "{0}" …

python string-formatting pysqlite
What are sqlite development headers and how to install them?

I am trying to install pysqlite and have troubles with that. I found out that the most probable reason of …

python header pysqlite
pysqlite2: ProgrammingError - You must not use 8-bit bytestrings

I'm currently persisting filenames in a sqlite database for my own purposes. Whenever I try to insert a file that …

python sqlite pysqlite
pysqlite - how to save images

I need to save an image file into sqlite database in python. I could not find a solution. How can …

python image sqlite blob pysqlite
ImportError: No module named pysqlite2

Why does from pysqlite2 import dbapi2 as sqlite cause ImportError: No module named pysqlite2 Isn't pysqlite2 already installed in Python 2.6.5?

python sqlite pysqlite