94,982 questions
-1
votes
0
answers
52
views
Can't connect to different SQLite database files from same MikroORM instance [closed]
I'm building a web app that uses a SQLite database for persistence, accessed via MikroORM. The database tracks the content of a particular game session, and I want different users to be able to access ...
- 425
Advice
0
votes
3
replies
62
views
How to use a database with Svelte?
I want to track user input in a small Svelte app using a database, with SQLite preferred.
The user input is a questionnaire, along with timestamps for mouse actions (movement, pressed, and hovered ...
- 300
1
vote
1
answer
100
views
DatabaseException "out of memory" when opening SQLCipher 3 encrypted DB on versions > 2.2.1
I’m encountering a crash when opening an encrypted database using sqflite_sqlcipher on versions above 2.2.1. The same code works fine on 2.2.1, but fails consistently on newer versions.
Code Snippet:
...
- 11
0
votes
1
answer
85
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 ...
- 29
Advice
0
votes
2
replies
109
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
-1
votes
0
answers
110
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 ...
- 93
0
votes
0
answers
44
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 ...
0
votes
1
answer
132
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 ...
- 1
0
votes
0
answers
98
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
56
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
97
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
165
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
78
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
82
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
-1
votes
1
answer
81
views
How can I specify a variable amount of whitespace as CSV import column separator?
In SQLite:
.separator " " # is one space
.separator , # is a comma
.separator "\t" # is a tab
But how can I specify a variable number of spaces for CSV import? E.g.:
<<...
- 600
