95,017 questions
0
votes
0
answers
70
views
How can I compile an SQLite amalgamation version in C++ Builder CE?
I want 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 ...
- 11
Best practices
0
votes
1
replies
46
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
Best practices
11
votes
11
replies
2k
views
I built a database. What should I do next?
I built a small relational database as a personal learning project. It is around 10,000 lines of code and already includes many of the core parts of a basic relational database, such as page-based ...
- 1
0
votes
0
answers
70
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
63
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
2
votes
2
answers
156
views
Recursive CTE to return item where a descending table and an ascending formula meet
I want the recursive bit that goes down in values be the values of c in the pc table and up in values be the plus_one recursive formula until the value from plus_one is greater than the one coming ...
- 315
Advice
0
votes
0
replies
36
views
Debugging Node.js App Via Plesk Recommendations
I have developed a node.js website with both front and backend elements. The app runs alright locally (with npm start). I've been trying to get it hosted with Heliohost. The frontend pages load ...
- 11
0
votes
1
answer
63
views
On Update Cascade not cascading in child table [closed]
I have a parent table created by the following statement:
Create Table "GL_Cash_Book"
(
"y_trans_code" Integer Not Null,
"trans_date" Integer Default ...
- 49
0
votes
1
answer
105
views
Unable to read sqlite table from "Python in Excel" [closed]
I'm trying to display the contents of a (local) sqlite table in Excel. I want to use "Python in Excel" for various reasons. This is the code I have written in cell A1 using the PY() formula:
...
- 27
-1
votes
0
answers
60
views
What causes `sqlite3_rsync` to produce "database disk image is malformed" on a target database [closed]
I have two small devices, A and B. Device A continuously reads and writes to a SQLite database in WAL mode called mydata.sqlite.
At regular intervals, a different process synchronizes this file from ...
- 682
-1
votes
1
answer
101
views
Avoid quoted JSON output in SQLite
I have a query on my SQLite3 database where one of the columns results in JSON, produced via the built-in JSON functions. When I set the output format to JSON as well, I would have expected that this ...
- 249
3
votes
3
answers
139
views
Can this parent-child table with linked list under parent CTE be reduced?
I use a parent-child table with a linked list to denote the order of children. This provides correct results but takes two recursive CTE steps: one to assign a position idx to each child, then again ...
- 3,296
0
votes
0
answers
36
views
SQLAlchemy create_all() does not add new columns to existing SQLite tables [duplicate]
I added a new column to an existing SQLAlchemy ORM model in an SQLite-backed application.
My model:
class User(Base):
__tablename__ = "users"
id = Column(String(36), primary_key=True)...
- 37
Advice
0
votes
3
replies
72
views
How can an embedded database support PostgreSQL syntax without running a PostgreSQL server?
I'm experimenting with building an embedded SQL engine for Node.js and Bun.
The idea is similar to SQLite, but the engine aims to support a large subset of PostgreSQL syntax such as:
- joins
- CTEs
- ...
1
vote
0
answers
140
views
Why am I ending up with the wrong number of rows for chained SQLite triggers?
Why am I getting wrong inserts in some chained insert triggers in SQLite (Cloudflare D1)?
Table arrivals has an insert trigger that inserts rows via INSERT OR IGNORE into table places.
Table places ...
- 34.8k
