95,064 questions
-1
votes
1
answer
33
views
better-sqlite3 Update the row value (SqliteError: unrecognized token: ":") [closed]
Error - SqliteError: unrecognized token ...
const appSchemaTableQuery = `
CREATE TABLE IF NOT EXISTS app_schema (
id INTEGER PRIMARY KEY AUTOINCREMENT,
_c_url TEXT,
created_at ...
1
vote
1
answer
105
views
Getting SQLAlchemy's datetime function to work with an SQLite database
I'm rebuilding my site's backend from scratch using Python (no frameworks, and I'm also new to Python), and I'm working on the scripts and models to build a database for my posts and articles using ...
- 117
0
votes
1
answer
89
views
SQLite fails to find newly inserted row [closed]
I'm using SQLite to track Fabrics and create projects that use those Fabrics. Two tables point to each other so Fabrics knows what projects they belong to and projects know what Fabrics are a part of ...
1
vote
1
answer
110
views
Recursive common table expression initial select search with primary key
I have a question about initial select in a recursive common table expression
(CTE) on SQLite and how to interpret the output of EXPLAIN QUERY PLAN.
I have constructed a linked list out of node and ...
- 1,189
1
vote
0
answers
118
views
Why am I getting a foreign key mismatch when trying to join 2 tables using foreign keys?
I am doing Chapter 16 - SQLite Databases of Automate the Boring Stuff with Python By Al. Sweigart and I ran into a problem in the "Joining Multiple Tables with Foreign Keys" part, let it be ...
- 33
Advice
0
votes
0
replies
61
views
How to add a new collation for NOCASE in SQLitestudio
I' have just installed a new computer and added SQLiteStudio3. Tried to open a database created by a mORMot application and got the error: "no such collation sequence: SYSTEMNOCASE".
I have ...
- 841
1
vote
1
answer
119
views
I can't query by UUID
I'm having trouble querying UUID values stored as BLOB(16) in SQLite3 using Go (with goqu). I insert a UUID using uuid.New().MarshalBinary() and this works correctly. However, when I try to select the ...
-3
votes
0
answers
47
views
ENOENT for node:sqlite without it being a dependency
I am currently making a npm package for a TypeScript Console Application Framework. I want this framework to offer the using developers a simple npm script "tscaf build" which takes all the ...
- 15
-3
votes
0
answers
182
views
SQLite not working after migrating form VS 2022 to VS 2026
I am migrating a large Windows Forms application from Visual Studio 2022 to Visual Studio 2026 (both Community Edition). The current version of the application, consisting of 13 C# projects, is based ...
- 45
2
votes
1
answer
80
views
How do I fix this error when using SELECT in my ON CONFLICT ... DO statement in SQLite3?
I'm new to SQLite and trying to make an UPSERT statement that just updates everything in one table with everything from a different table. If there are conflicts, it should update with the new values. ...
2
votes
1
answer
202
views
Displayed data disappears after successfully adding data to sqlite database
Please help me! I'm building a simple stock search app using Flask (backend) and plain HTML/JS (frontend).
When the user enters a ticker, the app:
Send a GET request to my Flask backend (/search)
...
- 55
-3
votes
0
answers
48
views
sqlite3.OperationalError because Python thinks my table name is a column [duplicate]
I am trying to access the table in my game which is called tbl[savename]. But it thinks my table name is a column.
My code is:
def save_data(self, data):
conn = sqlite3.connect("dbInfo.db&...
- 5
Best practices
0
votes
0
replies
43
views
How can I set up an ETL process for DataFrames (dbt or alternative tools)?
Question: I'm currently working on a dashboard prototype and storing data from a 22-page PDF document as 22 separate DataFrames. These DataFrames should undergo an ETL process (especially data type ...
- 83
Advice
0
votes
6
replies
188
views
Understanding Dataset Controls in Delphi While Using SQLite
My Delphi application uses SQLite for its database. My understanding is that the database connection control TFDConnection has a default row count of 50 records. If true, there should only be 50 ...
- 216
2
votes
0
answers
105
views
How do I link a custom SQLite and not the system version when building Python? [closed]
I am trying to link a custom version of sqlite3 when building Python, but there is an error when compiling Python:
/usr/bin/install: cannot stat 'Modules/_sqlite3.cpython-313-x86_64-linux-gnu.so': No ...
- 159