Stack Overflow
Stack Overflow

Questions tagged [sqlite-browser]

DB Browser for SQLite is a visual, open source tool to create, design, and edit database files compatible with SQLite.

DB Browser for SQLite is a visual, open source tool to create, design, and edit database files compatible with SQLite.

It is a synonym for

15 questions
21
votes
4 answers

Android: SQLite database created with room shows no tables when opening with sqlte-browser

I am using Room Persistence Library 1.1.0. I could find the database file at /data/data//databases/ using Android Studio's Device File Explorer. It contains multiple tables and I can access contents of that tables without any problem…
Bertram Gilfoyle
  • 9,899
  • 6
  • 42
  • 67
6
votes
1 answer

SQLite Browser without SQLCipher support in Ubuntu

SQLite Browser package for ubuntu does not come with SQLCipher by default. sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser sudo apt-get update sudo apt-get install sqlitebrowser The Question How could it be enabled in order to be able to…
Camilo Silva
  • 8,283
  • 4
  • 41
  • 61
6
votes
3 answers

Error: no such function: json_each in SQLite with JSON1 installed

I've installed SQLite3 with JSON1 through brew: brew install sqlite3 --with-json1 --with-fts5 Version: 3.15.2 2016-11-28 19:13:37 bbd85d235f7037c6a033a9690534391ffeacecc8 When running a query, some functions work fine, such as…
sgtdck
  • 1,008
  • 7
  • 15
2
votes
4 answers

Does SQLite actually support DATE type?

After reading https://sqlite.org/datatype3.html which states "SQLite does not have a storage class set aside for storing dates and/or times." but able to run this CREATE TABLE User (ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, BORN_ON DATE…
Alex
  • 5,510
  • 8
  • 35
  • 54
2
votes
1 answer

Can't retrieve data from sqlite3 file with unexpected characters

I have sqlite3 database file that I'm trying to get data from. When I try to open it in sqliteBrowser it will generate the tables but it ignores the data within the file so I get empty tables. This is the file: localData.sqlite I don't know if the…
paty.r15
  • 361
  • 4
  • 16
1
vote
1 answer

in sqlite database or sqlitebrowser, in linux, how make a column write protected?

in sqlite database or sqlitebrowser, in linux, how make a column write protected? I am opening sqlite browser. I create a table. then, some columns. eg. the column A must be write protected. But not such "option" exists as "unique key" options…
Estatistics
  • 874
  • 9
  • 24
1
vote
1 answer

Sqlite Browser does not launch on Windows 7

I have downloaded the Sqlite browser from the official website. I installed it without any error but after I installed if I try to launch the SQLite browser it shows the following error. The application was unable to start correctly(0x000007b).…
BALAKRISHNAN
  • 11
  • 2
1
vote
0 answers

Data content of sqlite on iOS simulator not appears on DB Browser for SQLite

I used CoreData to create a database and I did save some content. If I navigate to local at database on iOS simulator, I can see the data using select * from ZPRODUCT; but, if I open with DB Browser SQLite, or other software for this, I can't see…
Augusto
  • 3,825
  • 9
  • 45
  • 93
0
votes
0 answers

SQLite db browser does not show tables

I am creating add contact android application. I am using SQLite database. The app is running perfectly without any error. But DB browser for SQLite does not show the tables created in my database. I have deleted the database and increased version…
komal
  • 17
  • 2
0
votes
1 answer

Android realtime database inspection

I am working on an app and using GreenDao for database. So now to debug and inspect and validate database changes I have to do fetch out the database file after making any changes to database. To get the database file I am following this way. But…
A.s.ALI
  • 1,992
  • 3
  • 22
  • 54
0
votes
3 answers

Exporting a SQLite3 Table from a DB with "Error: no such collation sequence: IUNICODE"

Using DB Browser for SQLite, you can now successfully export a table from databases with IUNICODE collation sequence errors, but it is a manual process using DB Browser's GUI. I used DB Browser because if you try to export the table using sqlite3…
user3447273
  • 351
  • 1
  • 4
  • 12
0
votes
1 answer

Using Pandas and sqlite3

Try to implement the privote_table of pandas to produce a table for each of party and each state shows how much the party receievd in total contributions from the state. Is this the right way to do or i has to get into the data base and get fectched…
user7148237
0
votes
0 answers

Error while installing DB Browser for SQLite for my windows 7(64 bit) pc

i am new here... recently i face a problem while installing DB Browser for SQLite for my windows 7 pc.. after completing installation i can not run it anyway.. i dont know why... please help me.. i use the following link for…
poushali
  • 1
  • 1
0
votes
1 answer

ios-add column to sqlite after apply lightweight migration?

I am developing an app that use Core Data and SQLite. The SQLite database is for retrieve data. I filled the SQLite database with data, and thereafter I used lightweight migration to add some new attribute to my entities. Now I have changed the…
Mehdi Negahban
  • 85
  • 2
  • 9
-3
votes
3 answers

Opening a program and loading a file into the program

I am looking for a way to create a Powershell script that will allow me to open DB Browser for SQLite ("C:\Program Files\DB Browser for SQLite\DB Browser for SQLite.exe") and upon opening, load a file…
Brandon O'Brien
  • 1