Stack Overflow
Stack Overflow

Questions tagged [db-browser-sqlite]

104 questions
4
votes
2 answers

How to fix empty string while fetching it from Database?

I am fetching a string from Database using the column id. When I enter a query in SQLite DB Browser it returns what is need but the same query returns nothing when coded through Java. My Data Base contains a table named drugs which has 3 columns…
Huzaifa Asif
  • 658
  • 1
  • 8
  • 24
4
votes
0 answers

How do I refresh sqlite database in SQLite Database Browser?

I am using python to connect and make changes with a sqlite database. On the side, I am viewing the tables and database structure of the sqlite db using DB Browser for SQLite. After I run my python code and make changes, I normally have to close…
KubiK888
  • 4,377
  • 14
  • 61
  • 115
3
votes
4 answers

Why are no rows returned in my app, whereas the same query returns rows in DBBrowser?

With this simple query against my SQLite database: SELECT MovieTitle, MPAARating, IMDBRating, DurationInMinutes, YearReleased, genres, actors, directors, screenwriters FROM MOVIES_SINGLETABLE WHERE IMDBRating >= @IMDBMinRating ORDER BY…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
3
votes
2 answers

IF ELSE Condition in SQLite

I am new to SQLite. I am looking for IF ELSE in SQLite to perform UPDATE OR INSERT operation based on the condition check. What I tried is: IF EXISTS(SELECT 1 FROM TblTest WHERE ID = 1 AND Name = 'XYZ') BEGIN END UPDATE TblTest SET Address =…
MAK
  • 6,824
  • 25
  • 74
  • 131
3
votes
0 answers

Create a encrypted SQLite database with C# EntityFramework and open with Database Browser for SQLite

I have created an encrypted SQLite database using C# EntityFramework but I'm not able to open it using DB Browser for SQLite DB Browser for SQLite is updated at the latest version 3.11 and I'm using DB Browser (SQLCipher) using…
Cyr
  • 431
  • 1
  • 6
  • 18
2
votes
1 answer

How to push data to DBHub.io in Python

I was wondering if there was a way to connect to my sqlite DB in Python and push that data to the cloud in DBHub.io. The reason for this is that I already have my DB in DBBrowser locally and now I want to push it into the cloud.
Alberto Martinez Lasheras
  • 37
  • 6
2
votes
2 answers

How to open a database encrypted with SQLCipher?

I created and encrypted a database with the package.(react-native-sqlcipher) I want to open this database with "DB Browser for SQLite" or "SQLite Studio". However, it doesn't open even though I enter the correct key. Is salt being added while…
ertandrn
  • 71
  • 1
  • 4
2
votes
3 answers

Nesting queries

My query from the attached schema is asking me to look for the same location of where the people who tested positive went and were in the same people as the untested people. (Untested means the people not there in the testing table. --find the same…
Vij
  • 59
  • 5
2
votes
1 answer

DB Browser for Sqlite New Record GUI

Sometimes when I click the "new record" button in DB Browser for Sqlite, a new row is added with cells which I can click into and fill. Other times it creates a pop up window where I can enter my data, as in the picture below. There seems to be no…
Robin Andrews
  • 3,514
  • 11
  • 43
  • 111
2
votes
2 answers

if I update the database by DB Browser, it does not change in my app

I have an SQLite database which I created by using DB Browser, I putted it in assets file and I use SQLiteAssetHelper to access it. Why if I update any record using DB Browser It dose not change in my app ?! Also If I execute insert query in my app,…
Noor
  • 57
  • 1
  • 7
2
votes
1 answer

Database file loaded in the wrong encoding: 'UTF-8'

I know there are two similar questions asked about this issue, but both questions did not receive any explicit solutions. I have also tried the solutions mentioned but none solved mine. My issue is that I have a database created (using DB Browser…
user10504780
2
votes
2 answers

How to connect to a protected Sqlite3 database with Python

I created a SQLite3 database and protected it with a password ("test") thanks to the application DB browser for SQLite. In order to connect to my database via Python, I need to provide the password but I can't figure out how to do that. I tried the…
H. Dave
  • 549
  • 3
  • 9
  • 26
1
vote
0 answers

Adding a foreign key is not working in db browser for sqlite

ALTER TABLE employee ADD FOREIGN KEY(branch_id) REFERENCES branch(branch_id) ON DELETE SET NULL; gives me following error message: near "FOREIGN": syntax error in line 12: ALTER TABLE employee ADD FOREIGN The branch table exists with the branch_id…
Seppi
  • 11
  • 3
1
vote
1 answer

How to insert a row into a table with a composite foreign key referencing a composite primary key

I have a table called BB: CREATE TABLE BB ( SID INTEGER PRIMARY KEY, FName TEXT, LName TEXT ); And a table called QR that contains a composite foreign key referencing the FName and LName rows on the BB table. CREATE TABLE QR ( QID…
Kade Allen
  • 13
  • 3
1
vote
1 answer

How to write the exact text next to the text and replace certain letters in it? SQLite

I am creating a phonetic dictionary for American English. Here are some examples: vocabulary phonetic_transcription dream dɹim drain dɹeɪn drink dɹɪŋk adrenaline əˈdɹɛnəlɪn If dɹ is in the…
Aschente
  • 105
  • 7
1
2 3 4 5 6 7