8 questions from the last 7 days
2
votes
1
answer
63
views
How do I make a custom field output different datatypes depending on file asking for data?
I'm building a molecule properties displaying website using django and sqlite. The database takes a numpy array and stores it as a BLOB. Currently, it just outputs the numpy array back out when asked ...
- 31
1
vote
1
answer
99
views
'SQLite Error 19: 'FOREIGN KEY constraint failed'.' while try to insert data
I am trying to run my database code, but I keep getting this error and I've done whatever I can think of to fix it, whether it is random posts, or chatgpt, but I can't seem to figure it out. The ...
- 11
Advice
0
votes
5
replies
98
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
69
views
Linking custom sqlite when building python
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 ...
- 151
Best practices
1
vote
4
replies
59
views
Does SQLite support calling from a TRIGGER a user-defined function that uses the WITH clause?
I have a database that implements a very simple tree structure with a table, hierarchy, which has two columns, parent and child.
CREATE TABLE hierarchy (
parent INTEGER,
child INTEGER,
...
- 61
1
vote
0
answers
78
views
Heavy duplication when upserting with GORM generics in SQLite
I have several models in my application, which have associations between each other. I'm trying to recursively upsert them, but haven't been able to find a good solution that doesn't extensively rely ...
- 49
-2
votes
0
answers
27
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&...
- 7
Best practices
0
votes
0
replies
30
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