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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month ago