Questions tagged [db-browser-sqlite]
104 questions
1
vote
1 answer
18.04 ubuntu sqlitebrowser doesn't start
I'm new to ubuntu and I cannot make db browser to launch, it seems to me that i am missing libraries, but i don't know how to add them because I am a noob.
when i type sqlitebrowser in terminal I get:
sqlitebrowser: error while loading shared…
pezet
- 9
- 5
1
vote
1 answer
How do I set a PK:FK relationship in DB Browser for SQLite?
I'm in DB Browser for SQLite and I don't see any way to set a PK:FK relationship. Can it do that?
thanks - dave
David Thielen
- 28,723
- 34
- 119
- 193
0
votes
0 answers
Setting DB Browser (SQLite) application as a default app for opening .sqlite files for all users
I need to set DB Browser application as a default app for .sqlite files for all users.
I tried to set applicationn in windows settings for .sqlite files but it was set only for me.
Also I tried to search for some domain policy but also with no…
0
votes
0 answers
python saying table does no exist but the table is in DB browser
I am trying to make a search application connecting 4 databases but when I enter something in the input field. The application breaks
When I debug the application, it says 'MemberDetails' table does not exist. But the table does exist as it has been…
lilmae23
- 1
- 1
0
votes
1 answer
Update year only in column timestamp date field SQLITE
I want to update the year only to 2025 without changing the month day and time
what I have
2027-01-01 09:30:00
2012-03-06 12:00:00
2014-01-01 17:24:00
2020-07-03 04:30:00
2020-01-01 05:50:00
2021-09-03 06:30:00
2013-01-01 23:30:00
2026-01-01…
0
votes
1 answer
Choose encoding when converting to Sqlite database
I am converting Mbox files to Sqlite db. I do not arrive to encode the db file into utf-8.
The Python console displays the following message when converting to db:
Error binding parameter 1 - probably unsupported type.
When I visualize my data on DB…
FrançoisR
- 1
- 3
0
votes
1 answer
SQL LIKE + wildcard operator only returns results with first value
What's happening StackOverflow.
I'm using DB Browser for SQLLite to query a database with two tables - people and states. people has the field state_code and states has the fields state_abbrev and state_name. people.state_code and…
InvalidObjects
- 27
- 1
- 5
0
votes
0 answers
How to add images to DB Browser for sqlite that are stored in drawable folder?
I am trying to pre-populate a room database with some data using DB Browser for sqlite.
I have a table defined with (name: String, score:Int, image:Int). That image field stores an image from drawable folder so the example for an insert would be…
Grim Reaper
- 31
- 2
0
votes
1 answer
SQLITE_BUSY The database file is locked
I'm getting the error [SQLITE_BUSY] The database file is locked (database is locked), even though I close my connection and the statements. Not sure what else to try.
public void getTeams() throws SQLException {
Connection c =…
huardy
- 33
- 5
0
votes
1 answer
How to split these records into individual new ones?
I want to search if a string exists in column2 (site_id) then put that string in a new table with the value of its before column in that row. The table has only 2 columns and the site_id column may have many 5-word strings that I want.
I want to get…
Just Forwork
- 23
- 3
0
votes
1 answer
Opening a c# sqlite-net-sqlcypher database in a SQLite manager and vice versa
Situation : Windows 11 - Latest updates; .NET 6 console app - latest updates; sqlite-net-sqlcypher nuget package (1.8.116) - also latest version; Both Visual Studio (2019 and 2022) and Rider - All latest versions)
I have created a little test…
Geertie
- 237
- 4
- 15
0
votes
0 answers
How can I calculate the Gini coefficient per state (external source as example)?
I am busy messing around in SQLite and want to calculate the Gini coefficient per US states based on median income per capita and the populations per county.
The process is explained here:…
user12973342
0
votes
0 answers
How do I output a list of columns from a row value?
I want to query and output a count of countries where residents of each country last travelled to. I have the following query:
SELECT
COUNTRY, SUM(COUNTRY_OF_LAST_TRAVEL = 'USA') AS USA
FROM BASE_TABLE
GROUP BY
COUNTRY
and the output is something…
bixby
- 23
- 3
0
votes
1 answer
Different output between DISTINCT SQL statement and DISTINCT method from pyspark
I'm making some cleanings in a +11M rows dataset that contains entreprises names with so much noise. I want to make some regex cleanings (deleting punctuation, whitespaces, digits, accents and some othe issues) and then apply some approximate string…
Nachengue
- 376
- 1
- 2
- 11
0
votes
0 answers
No such column error when replacing comma in integer field for percentage calculation
I'm having trouble calculating a percentage from integer columns in two tables in SQLite. My employeetrained and employeetotal data are both integers, but one has commas. I'm using REPLACE to take care of that and create a new column with an alias,…
Marcatectura
- 1,721
- 5
- 30
- 49