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,035
questions
-3
votes
0
answers
13
views
SQLite file location
I have a problem running my Android app:-
Running through the Emulator there are no problems
However when I run in USB Debugging mode on a real Android device this is the error message I get:-
no such ...
0
votes
0
answers
11
views
Electronjs + Sequelize + SQLITE3 + VITE
I can't load extra file in main process.
I'm trying to use sequlieze and sqlite3 with electronjs but this error blocking me.
How can i fix this?
Thank you.
Error: Cannot find module './database/models/...
0
votes
0
answers
13
views
Python with guizero: how can buttons in a waffle grid be used to update values in an sqlite3 database?
I am using Python with guizero to build a grid of buttons, like so:
from guizero import App, PushButton, Waffle, Text
def button_click(x, y):
print(f"Button {x+1}-{y+1} wurde geklickt!“)
...
0
votes
0
answers
28
views
SQlite3 slow writes in WAL mode and the need for 'EXCLUSIVE'
I am trying to see the insert performance of SQLite3 for a large number of inserts, I read about WAL mode, and how it is better at concurrency but I cannot follow up on the concurrency part or see a ...
0
votes
0
answers
11
views
How can I create a extension from the interface inside of a external npm package in typescript?
in react-native typescript, I use a npm called react-native-sqlite-storage, that npm has a interface like this inside its node_modules
export interface SQLiteDatabase {
dbname: string;
...
0
votes
0
answers
19
views
Why I receive Expo SQLite: Persistent 'Unhandled promise rejection' with NullPointerException in NativeDatabase.execAsync?
I'm developing a React Native application using Expo (SDK 51) and SQLite. I've implemented local database operations for managing orders, but I'm encountering a persistent warning about an unhandled ...
0
votes
0
answers
33
views
How to add range of floating numbers with select slider in streamlit
I have a sqlite database with longitude values in which range between 24.90000 to 24.99999. The code I'm trying is this:
longi_range = np.arange(24.90000, 25.00000)
long_range = st.select_slider("...
1
vote
0
answers
40
views
Why is there no jsonb_each in SQLite?
I have been working with SQLite’s JSON1 extension and have noticed that while there are jsonb_ variants for nearly all json_ functions, the jsonb_each function seems to be missing.
Here is the ...
-6
votes
1
answer
71
views
SQLite database Table not found
I'm doing laravel project, and trying to create a database factories and migration, where i want to put random data.
I'm using PHP artisan tinker to generate random data for the database.
But I get ...
-4
votes
1
answer
40
views
Deleting item from sqlite database have error [closed]
Deleting item from sqlite database error.
CustomAdapter
public class PassAdapter extends RecyclerView.Adapter<PassViewHolder> {
Context context;
MainActivity mainActivity;
private ...
0
votes
0
answers
39
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-...
-1
votes
1
answer
65
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 ...
0
votes
0
answers
31
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 ...
0
votes
0
answers
27
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
1
answer
45
views
How do I insert data on DELETE into a different database?
My table holds material details in Material.db. Once the material is processed its details are deleted and new material details inserted. Before deleting I want this data stored in archive database ...