Questions tagged [sqlite]
SQLite is an open-source software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.
sqlite
95,047
questions
0
votes
0
answers
13
views
Multiple JOINs is extremely slow on SQLite
I'm using EF Core with SQLite. For the MCVE, let's say, I only have these tables [DomesticContainers, DomesticRecords, InternationalContainers, InternationalRecords, Clients], where there's a one-to-...
- 613
0
votes
1
answer
32
views
Does database compound index order matter if the first column is only queried with an equal operation?
Question: assuming I have an Orders table with an index (UserId, CreatedTime), does it matter if I add DESC to CreatedTime if I want to list orders by a single user only?
For example:
SELECT *
FROM ...
- 19.8k
0
votes
0
answers
17
views
sqlite: CAST("not a number", NUMERIC) = TEXT?
Recently I wanted to find out for myself whether pydantic is that useful with combination with sqlalchemy or not, so I made a dull & dumb example:
from dataclasses import dataclass
from pydantic ...
- 63
0
votes
0
answers
8
views
How to manage offline vector tiles in an ionic app?
I have an ionic - angular - capacitor app with a map, drawn by openlayers using vector tiles from different online sources (mapbox, tomtom or openstreetmap). I try to add the possibility to use a set ...
0
votes
0
answers
8
views
How to create an archive database in sqlite using triggers
I am using SQLite Database.
I have table that holds the current material details, lets call it Material.db.
Once the current material is processed, this material details will be deleted and new ...
-2
votes
0
answers
14
views
SQLiteDialect_pysqlite cannot be used as a data source for security reasons After Changing Config File
error image is here
In the current version of Apache Superset, I'm encountering an issue with connecting to SQLite, even after setting PREVENT_UNSAFE_DB_CONNECTIONS = False in the config file. Can ...
0
votes
1
answer
11
views
Python lru_cache decorator with Sqlite database
I have a relatively simple py script that executes every minute as a Cronjob in Linux and performs a SELECT query on a Sqlite database using Sqlite3 library. Now, this ScriptE executes every minute to ...
- 33
0
votes
0
answers
29
views
Entity Framework save changes from different Task<T>
My application has two concurrent tasks:
await _fileWatcherService.StartWatchingAsync();
var backgroundTask = Task.Run(() => ProcessQueueAsync(cancellationTokenSource.Token), ...
- 73
-7
votes
0
answers
18
views
Your system has an unsupported version of sqlite3. Chroma requires sqlite3 >= 3.35.0
Here is the error i get:
Traceback (most recent call last):
from langchain_chroma import Chroma
File "D:\Internship_Developers_den\chtabot using rag\env\lib\site-packages\langchain_chroma_init_....
-6
votes
0
answers
33
views
What backend to use for an offline web app [closed]
I want to develop a web app basically for the purpose of making my boss's routine work automatique, it MUST meet the following conditions:
-use the following languages: js,html,css
-works without ...
0
votes
0
answers
22
views
How do I run sqlite INSERT INTO queries from a txt file in Flutter?
I have a txt file with sql INSERT INTO queries and values. I'd like to run them all at once in Dart/Flutter with the sqlite plugin. Is this possible?
INSERT INTO article (id, name) VALUES (1, 'Banana')...
0
votes
1
answer
28
views
How to add a new cafe (element) to database(SQLite) using Python Flask?
This is my code:
@app.route("/add", methods=["POST"])
def post_new_cafe():
new_cafe = Cafe(
name=request.form.get("name"),
map_url=request.form.get(&...
0
votes
0
answers
10
views
React Native programatically upload sqlite database from Android or iOS app to Google drive
I am developing an application with a SQLite database. I do have any server, so I am developing the app with a local database, but I want to backup the .db file to Google drive and then restore that ...
- 740
0
votes
0
answers
13
views
Why does my query from a pre-populated database return undefined?
Trying to get a list from table Nouns from a pre-populated database React Native is returning undefined. I added the pre-populated database in Android:
For IOS I just created a new assets folder and ...
- 727
-3
votes
1
answer
46
views
ExpressJS & Sqlite: How to match req.body with update query [closed]
The contents of a POST req.body are dynamic, eg unchecked checkboxes are not sent. SQL update and insert queries are conventionally hard coded, albeit with placeholders etc. This presents problems.
...
