pysqlite Questions

4

Symptom: In my Django app, when I call from pysqlite2._sqlite import * I get the traceback Symbol not found: _sqlite3_enable_load_extension when Background: I've installed python using homebrew...
Eades asked 2/2, 2017 at 4:56

4

I need to use sqlite version 3.8 or higher with python in Amazon Linux. I updated my sqlite installation to the latest version: $ sqlite3 -version 3.22.0 2018-01-22 18:45:57 0c55d179733b46d8d0ba...
Cheeks asked 19/2, 2018 at 11:40

23

Solved

I'm trying this code: import sqlite connection = sqlite.connect('cache.db') cur = connection.cursor() cur.execute('''create table item (id integer primary key, itemno text unique, scancode text...
Mcconaghy asked 29/4, 2010 at 21:12

4

Solved

trying to get jupyter (ipython3) running on Python3.5, I installed it using sudo pip3 install jupyter However, when trying to launch jupyter notebook I receive the error that the modules _sqlit...
Exhume asked 8/8, 2017 at 10:0

6

Solved

I have a django project that uses a sqlite database that can be written to by an external tool. The text is supposed to be UTF-8, but in some cases there will be errors in the encoding. The text is...
Shopping asked 30/4, 2010 at 13:0

5

Solved

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. I've set it up using pythonbrew and a virtual environment. In the...
Hayse asked 5/1, 2013 at 15:33

5

Solved

I'm currently persisting filenames in a sqlite database for my own purposes. Whenever I try to insert a file that has a special character (like é etc.), it throws the following error: pysqlite2.d...
Wast asked 14/5, 2010 at 22:44

3

Solved

I'm trying to remove pysqlite from my system using pip. What I get doing so makes no sense: $ pip uninstall pysqlite The command worked, but watch this: $ pip freeze [...] pysqlite==1.0.1 Le...
Priorate asked 30/10, 2012 at 9:29

2

pip install pysqlite fails, and outputs the following with the following error log: ➜ ~ pip install pysqlite Collecting pysqlite Using cached pysqlite-2.6.3.tar.gz Installing collected packages: p...
Child asked 17/6, 2015 at 19:33

3

Solved

In pysqlite, violating a NOT NULL or a UNIQUE constraint likewise raise an IntegrityError. Unfortunately, this Exception type does not provide an error code, but only a message. So, let's say I wa...
Cassilda asked 16/6, 2014 at 14:33

3

Solved

I am tearing my hair out trying to install Spatialite for GeoDjango! I am already using Homebrew, it's generally easy and convenient so I initially tried to follow the Homebrew instructions for Ge...
Caprification asked 10/12, 2013 at 21:28

2

Solved

I was trying to use executemany to insert values into a database, but it just won't work for me. Here is a sample: clist = [] clist.append("abc") clist.append("def") clist.append("ghi") cursor.exe...
Chercherbourg asked 16/3, 2011 at 21:18

0

I'm following the GeoDjango Tutorial to set up a dev spatial DB for my project on my home machine, a Mac Mini running OSX 10.8.2. I installed the KyngChaos packages (UnixImageIO, PROJ, GEOS, SQLite...
Replenish asked 15/1, 2013 at 2:8

2

Solved

Using pysqlite I am making a procedure to do something with some data. The same kind of operation is done on similar fields in multiple tables and columns, so I thought I could parameterize the sql...
Lossa asked 12/1, 2012 at 20:1

3

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. However, I have no ideas what t...
Chancery asked 22/9, 2009 at 20:57

1

Solved

Gang, I am beginning to play around with pySQLite and I'm trying to find an example that illustrates how to query the db for existing records before inserting a new record if it doesn't already exi...
Pitsaw asked 10/4, 2011 at 15:26

4

Solved

SQLite docs specifies that the preferred format for storing datetime values in the DB is to use Julian Day (using built-in functions). However, all frameworks I saw in python (pysqlite, SQLAlchemy...
Tingaling asked 6/9, 2009 at 16:43

1

Solved

When using Python with SQLite DB, how to escape the data going in and pulling the data coming out? Using pysqlite2
Kiger asked 17/10, 2010 at 8:27

2

Solved

When I see the examples for pysqlite, there are two use cases for the SQLite library. from sqlite3 import dbapi2 as sqlite3 and import sqlite3 Why there are two ways to support the sqlite3 ap...
Burd asked 20/9, 2010 at 17:57

3

Solved

In this post about SQLite, aaronasterling told me that cmd = "attach \"%s\" as toMerge" % "b.db" : is wrong cmd = 'attach "{0}" as toMerge'.format("b.db") : is correct cmd = "attach ? as toMerge...
Lorenelorens asked 11/9, 2010 at 17:45

4

Solved

I need to save an image file into sqlite database in python. I could not find a solution. How can I do it? Thanks in advance.
Gemstone asked 22/7, 2010 at 14:29

3

Solved

I am trying to insert a data into SQLite database using Python. INSERT INTO DATA_TABLE(UID,LABEL) VALUES (NULL, "UK") WHERE "UK" NOT EXISTS IN (SELECT LABEL FROM DATA_TABLE); This query is dyn...
Kingdom asked 19/7, 2010 at 14:9

2

Solved

I have an object with an internal database connection that's active throughout its lifetime. At the end of the program's run, the connection has to be committed and closed. So far I've used an expl...
Esplanade asked 10/6, 2009 at 10:39
1

© 2022 - 2024 — McMap. All rights reserved.