Stack Overflow
Stack Overflow

Questions tagged [pysqlite]

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

140 questions
1
vote
1 answer

Why are not ROWIDs updated after VACUUM when using python sqlite3 module?

I'm working on an app that employs the python sqlite3 module. My database makes use of the implicit ROWID column provided by sqlite3. I expected that the ROWIDs be reordered after I delete some rows and vacuum the database. Because in the sqlite3…
user2346069
  • 35
  • 3
1
vote
0 answers

Fixed Amount of Column from CSV to pysqlite

I'm using Python 2.6 (32bits) on Windows 8. The purpose is building a pysqlite database from a comma separated CSV file where the first row is column name. My code as following (some code skipped): def BuildDatabaseFromCSV(self, file_name): with…
user2391636
  • 11
  • 1
1
vote
1 answer

How can I make Python see sqlite?

I cannot use sqlite3 (build python package), for the reason that _sqlite3.so file is missing. I found that people had the same problem and they resolved it here. To solve my problem I have to "install sqlite3 and recompile Python". I also found out…
Verrtex
  • 4,317
  • 9
  • 34
  • 33
1
vote
3 answers

How should I handle software packages?

I am trying to install pysqlite and have troubles with that. I found out that the most probable reason of that is missing sqlite headers and I have to install them. My platform: CentOS release 5.3 (Final). I have Python-2.6.2. I also found out that…
Verrtex
  • 4,317
  • 9
  • 34
  • 33
1
vote
3 answers

Why pysqlite does not work properly?

I tried to install pysqlite. Some suspicious things start to appear during the installation. Why I typed: python setup.py build I got the following message in the end: src/module.c:286: error: ‘SQLITE_PRAGMA’ undeclared here (not in a…
Verrtex
  • 4,317
  • 9
  • 34
  • 33
1
vote
1 answer

Installing pysqlite via tox

I have several test folders set up to use tox. They all have pysqlite as a requirement, either for the package itself, or for the tests to run. I've been running these packages using tox, and recently, I've noticed tox fails when it tries to install…
Susan Wright
  • 406
  • 1
  • 4
  • 13
1
vote
2 answers

pysqlite segmentation fault?

I am on OSX 10.6 and have recently upgraded my Python from 2.6 to 2.7, so I had to upgrade python packages. This time I decided to go with brew and installed sqlite, libspatialite and spatialite-tools with brew and brew doctor says everything is…
onurmatik
  • 5,105
  • 7
  • 42
  • 67
0
votes
1 answer

Error in the Django development server ("runserver")

I'm new to python and django and following the footsteps of "Django Book" I've django installed, including obtaining the following verification to import django in python: >>>Import django >>> django.VERSION (1, 3, 0, 'final', 0) I also use…
craftApprentice
  • 2,697
  • 17
  • 58
  • 86
0
votes
1 answer

Big SELECT optimization

I am using SQLite in Python for a big file management system. I have a big flat file (100 millions lines) that I want to sort using the values of 3 columns (which are integers), so that I could iterate and do some computation. I used SQLite with a…
unamourdeswann
  • 445
  • 3
  • 14
0
votes
1 answer

Transform SQLite database to SQLCipher database

My Python program uses the standard Python SQLite database (import sqlite3). All works, I want to cypher the database. I opened it with DB Browser (sqlitebrowser.org) that uses SQLCipher 3/4 and I ciphered it using a key (SQLCipher version 3). Which…
nastiliano
  • 53
  • 6
0
votes
1 answer

Inserting/Updating sqlite table from python program

I have a sqlite3 table as shown below Record(WordID INTEGER PRIMARY KEY, Word TEXT, Wordcount INTEGER, Docfrequency REAL). I want to create and insert data into this table if the table not exists else I want to update the table in such a way that…
ARUN P.S
  • 1,713
  • 2
  • 16
  • 19
0
votes
2 answers

pysqlite, save database, and open it later

Newbie to sql and sqlite. I'm trying to save a database, then copy the file.db to another folder and open it. So far I created the database, copy and pasted the file.db to another folder but when I try to access the database the output says that it…
csta
  • 2,423
  • 5
  • 26
  • 34
0
votes
1 answer

Duplicate the built-in sqlite3 module into another one, to use a newer version of the sqlite3 shared library

I'd like to use a very recent version of the sqlite3 shared library, directly compiled from the sources from https://www.sqlite.org. Overwriting /usr/lib/x86_64-linux-gnu/libsqlite3.so or libsqlite3.so.0.8.6 with the new compiled library seems like…
Basj
  • 41,386
  • 99
  • 383
  • 673
0
votes
0 answers

Python globals not generating into code in read_sql execution

I have to import data into a query where I want to fetch global variables that I declare. It works when I pass through one variable but not when I assign the multiple variables into the query. It is running but the result is not giving me back any…
adura826
  • 103
  • 1
  • 1
  • 10
0
votes
1 answer

sqlite3.OperationalError: no such column: key

I have a error, it's sqlite3.OperationalError: no such column: key, but i don't know whats the problem. I tried changing the .db file name from apiKeys.db to key.db but still raises the error sqlite3.OperationalError: no such column: key. The code…
RaphielHS
  • 31
  • 7
1 2 3
…
9 10