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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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
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...
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
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...
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.