Questions tagged [sqlite]

-1 votes
0 replies
Locking entire SQLite3 database during update
I have to update a SQLite3 database, which will drop a table, recreate it, and then repopulate the table. I want to ensure all my other processe...
asked 4 months ago
0 votes
0 replies
SQLite Database is getting locked when Alter or Drop command is used in my c# application
I have created a C# application which uses sqlite database for data storage. The application is installed on the client machine and working fine...
asked 4 months ago
0 votes
0 replies
How to edit and update a qtableWidget connected to the database?
I'm new to python GUI and I am using pyqt4. For now my code has a GUI that has a qtableWidget and it shows the data of a table from an sqlite3 da...
asked 4 months ago
0 votes
4 replies
How to add a new key:value pair to an already existing array state variable react native
I have a database function that returns some rows from a sqlite database then stores that in state rows = await ReturnSelectedSymbolsDB() this.s...
asked 4 months ago
0 votes
0 replies
Optimisiing SQLite DB file for android
I am converting xlxs to CSV table and then finally convert them to Sqlite DB file using DB Browser for SQLite. My Sqlite DB file size is around...
asked 4 months ago
0 votes
1 replies
If there is a way to pre-calculate SQL View in order to speed-up queries from it?
I perform numerous different SELECTs from an SQLite VIEW (dynamic table) using a cycle in Python. The underlying SQL query for the VIEW takes abo...
asked 4 months ago
0 votes
1 replies
Is there an SQLite equivelant to SHOW CREATE TABLE from MYSQL?
I am working with sqlite3 and trying to get the create table statement of a table that I have modified since I have created it. However, the sql...
asked 4 months ago
0 votes
0 replies
Use sqlite3 in Electron with Ionic 4
I would like to use Electron for Desktop in my Ionic 4 application. But I can't get it work with cordova-sqlite-storage plugin. It seems like Ion...
0 votes
0 replies
SQLITE/JAVA : The database file is locked (database is locked)
I've got this error while entering my second function. I know I shouldn't open a connection while there is another one not closed but I'm sure th...
asked 4 months ago
0 votes
1 replies
Jar file cannot read the sqlite database file
I am creating a JavaFX application with some read and writes to sqlite database. I created the connection to the database file using, connectio...
asked 4 months ago
-4 votes
1 replies
How should I access database instance on iOS using Swift [closed]
let fileURL = try! FileManager.default.url(for: .documentDirectory, in: .userDomainMask, appropriateFor: nil, create: false) .appendingPa...
asked 4 months ago
1 votes
1 replies
How can I use JOIN and CASE WHEN statement in this case (sqlite android)
I have two table) CREATE TABLE `Company` ( `companyName` TEXT, `status` TEXT, `extra` TEXT, `companyId` TEXT, `companyS...
asked 4 months ago
1 votes
0 replies
Relation on entities - android
I am using from architect component and I need to set a lot of query on bellow values. How to create relation between bellow entities for query?...
0 votes
0 replies
How can i tell the PATCH Method which field i want to update
I'm working on a simple REST API and I'm having troubles with the PATCH method. I don't know how can i tell the method and the query which fields...
asked 4 months ago
0 votes
0 replies
Project ERROR: WebKit requires SQLite. Either make it available via pkg-config.?
Project ERROR: WebKit requires SQLite. Either make it available via pkg-config, set $SQLITE3SRCDIR or build WebKit under qt5.git. What sho...
asked 4 months ago
2 votes
1 replies
How to redirect class data into xaml page?
I'm getting issue while transferring data from class to xaml page, In my console data showing in the class but it doesn't pass to xaml page in UW...
asked 4 months ago
0 votes
2 replies
How can I use exception handling while sending duplicate values in an insert statement, if I'm sending many values in batches?
I've written a class method that will take "batches" of data (each row that makes a "value" to be inserted, via SQL, to the database comes from a...
-4 votes
1 replies
How do you assign a variable to a specific cell?
In this case I have a simple user database to log usernames and passwords. def load(*args): options = {"level":0, "age":1, "cname":2, "reputatio...
asked 4 months ago
1 votes
1 replies
Setting value of boolean columns based on existence of value in set
I have a SQL table of the format (INTEGER, json_array(INTEGER)). I need to return results from the table that have two boolean columns. One is s...
asked 4 months ago
0 votes
0 replies
sqlalchemy - DetachedInstanceError when using a session as a contextmanager with sqlite
I'm sure there is a duplicate somewhere but just couldn't find it. If you do, please mark this question as duplicate. Consider a very basic mode...
asked 4 months ago
1 votes
5 replies
How can I find my app and the SQLite .db file in Android
I created my first Android App with SQLite and tested it on my phone. Now I installed an SQLiteManager on the phone and I would like to open the...
asked 4 months ago
0 votes
0 replies
Difference between SQLiteConnection and SQLiteConnectionWithLock
I am using SQLite-net in my project. Currently i am using SQLiteConnection and handling all DB locks/unlocks in my code. Just saw a class "SQLite...
asked 4 months ago
0 votes
2 replies
SQLite - Return Rows Even If They Are Duplicates
I have a simple SQLite table which has just one ID column. I have some variable IDs that may be duplicates of each other like: 1,2,3,4,3,1 (Thes...
asked 4 months ago
1 votes
3 replies
sql query exact search than others
I have table that has many columns. But we consider here 2 columns. Name is Column1 and Column2. And table name is WordTable. I just want to sear...
asked 4 months ago
2 votes
2 replies
How can be unique each row in sqlite table. Not just a column of row
I have a sqlite table with two column like name and surname .I want name and surname must be different not just name. My table code is private...
asked 4 months ago