95,004 questions
0
votes
1
answer
73
views
I want to add a button that lets me view notes on the same line
I want to create a small desktop app where I can see the books I've read and also view the notes I've written about them.
I'm using SQLite3 with a database that contains the ID, title, author, and ...
- 13
Advice
0
votes
2
replies
96
views
Flutter: Auto-populate Excel (DTR template) from SQLite data and preview before export
The app can now save the records. My only problem is I'm stock on how the app can use my existing template and automatically insert the data in each cell, while also adjusting the cell format if it's ...
user20814004
-6
votes
0
answers
75
views
Trying to design a flask sql cart and products page [closed]
Could someone help me design code for a shopping page and working cart.
# Import Flask tools for routes, templates, JSON, redirects, and URL building
from flask import Flask, render_template, jsonify,...
-8
votes
2
answers
132
views
How can I break out of a loop within a function and return to my main program? [closed]
I'm working on creating a kind of online library. I'm using SQLite3 with Python, and basically I can add, delete, view my library, and search for books.
But if I select the search option, I can search ...
- 13
-1
votes
0
answers
103
views
Database error trying to enforce constraint
I am writing a small script to collect some URL info, and store it in a database.
I'm getting the following error:
Dropping index: sqlite_autoindex_keywords_1
Traceback (most recent call last):
FilX ...
- 113
-1
votes
0
answers
57
views
Opencode Sqlite error on creating session ('PRAGMA journal_mode = WAL') [closed]
Opencode 1.4.6 - Windows10-Wsl-Ubutu24.04
log files -> here
On creating a new session on newly installed Opencode 1.4.6, an sqlite error is given ->
Sqlite error on Invoking session ('PRAGMA ...
- 1,659
0
votes
0
answers
36
views
Hanami db migrate
I'm following the Hanami tutorial documentation for building a web app.
I run bin/hanami db migrate and I get the following error:
=> database db/bookshelf.sqlite migrated in 0.2763s
Error: in ...
-1
votes
0
answers
70
views
C++ SQLITE sqlite3_bind_blob cuts off at first NULL [closed]
std::vector<unsigned char> response = { /* HTTP RESPONSE */ }
sqlite3_bind_blob(stmt, 2, response.data(), response.size(), SQLITE_TRANSIENT);
Expected result from SELECT
HTTP HEADERS
\n\n
full ...
0
votes
1
answer
106
views
When using Tcl/SQLite for application data, how to safely to perform database updates outside of application triggered transactions?
When using Tcl with SQLite, with database requests arriving at Tcl over a socket, what happens if you try to perform additional database work outside of the request's transaction and after the result ...
- 3,330
0
votes
0
answers
83
views
Enumerate last query result when I pass several to sqlite3_prepare_v2() in one string
I prepare an SQLite query:
std::string sql = "CREATE TEMPORARY TABLE T1 AS SELECT * FROM TABLE1 ; SELECT * FROM T1";
TABLE1 isn't empty. I enumerate rows of the 2nd query (SELECT FROM T1) ...
- 359
1
vote
1
answer
55
views
Cannot use ".mode --insert table1" to import from ".read query.sql" [closed]
In the SQLite command shell I can use .read to run Query.sql and produce the result set. I can export the result set to a .csv file using .output csv and import that into TargetTable.
I'd like to ...
- 11
0
votes
0
answers
93
views
werkzeug.security log_in(user) returns error 404
When I try to log in my user and use check_password_hash() of Werkzeug security, I get 404 redirection link invalid. After adding the try and except clause it gets redirected to my except:
'tuple' ...
- 1
0
votes
0
answers
127
views
How can I compile an SQLite amalgamation version in C++ Builder CE?
To make a static library with an amalgamation version of SQLite to use in my C++ Builder program I created a static lib project and added 4 files from sqlite.org (C source code as an amalgamation ...
- 21
Best practices
0
votes
1
replies
66
views
Langchain agent state preservation to ensure LLM responds appropriately
I've been trying to create my first agent using Langchain. I would like some way to store user details, what questions they may be asking etc to be able to effectively govern how the LLM responds. It'...
- 51
0
votes
0
answers
78
views
Losing SQLite connection after app reloads
I am refactoring code and implementing repositories. Database access is handled via this singleton:
class SQLiteConnectorV2 {
private static instance: SQLiteConnectorV2 | null = null;
public db: ...
- 1