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…
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…
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…
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…
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…
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