Stack Overflow
Stack Overflow

Questions tagged [db-browser-sqlite]

104 questions
1
vote
0 answers

Problem with dump command using DB Browser for SQLite

I am relatively new to SQlite3. I am currently using DB Browser. I have two very large .db files that I want to combine such that a all the tables (all different) all reside together in one .db (ie- I don't want to just attach them). I am trying to…
Joshua Scott
  • 11
  • 2
1
vote
1 answer

SQL Query to convert unixepoch time in nanoseconds to human readable time

I have a timestamp in epoch time with nanoseconds, like this: 1634713905326784000 I am using DB Browser for SQLite to convert this into a timestamp, like this: STRFTIME('%Y-%m-%d %H:%M:%f', timestamp/1000000000,'unixepoch') as timestamp Since I am…
petterssonm
  • 13
  • 3
1
vote
1 answer

Need help for Python and SQLite --> TypeError: 'NoneType' object is not subscriptable

I need your help in order to solve this problem. I am trying to enter a line in a database where the program has to find a material X in the database and then get the quantity value. After that, the program creates a new line where it adds the stock…
Xavi Lopez Ponte
  • 69
  • 6
1
vote
1 answer

What causes a foreign key mismatch error in sqlite database

this is my student_table create query CREATE TABLE "student_table" ( "student_id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT NOT NULL, "gender" TEXT NOT NULL, "year_admited" INTEGER ); this is for my…
eliHeist
  • 91
  • 2
  • 11
1
vote
1 answer

How do I open a sqflite database file in DB Browser for SQLite?

I have a Flutter/Dart application that I am coding using Android Studio. I use a database called envirodatabase.db with the sqflite package. I want to open the database in DB Browser for SQLite on my computer, but the only way it lets me do that is…
Marvin
  • 853
  • 2
  • 14
  • 38
1
vote
1 answer

how to insert multiple foreign key in DB Browser for SQLite (GUI)

I am using SQLite and DB Browser for SQLite. I know that if you want to insert a foreign key using the GUI, you just have to scroll to the right and double click to insert the foreign key to the corresponding field. The problem is when you want to…
Osolemio44
  • 63
  • 1
  • 10
1
vote
1 answer

SUM ( CASE WHEN A=B THEN COUNT*X) statment

I am trying to run a query in SQLite3 where I want the grand total of Savings column from Case statement. My SQL query looks like this now: SELECT COUNT(PhoneNumber), Dept, Device CASE WHEN Device='Apple' THEN 500*COUNT(PhoneNumber) WHEN…
Malhar
  • 11
  • 2
1
vote
1 answer

How can I run a migration with Entity Framework Core on an encrypted SQLite database?

I have an ASP.NET Core console application (targeting version 2.2), using Entity Framework Core. I'm trying to connect to an empty, encrypted SQLite database created with DB Browser for SQLCipher. After creating the connection, I'm attempting to…
Caleb Powell
  • 33
  • 4
1
vote
1 answer

Foreign Key Constraint Failed - Even when I try to manually add data

I am studying SQL in my data science degree program, and the assignment is to perform SQL queries for the first time. In order to do that, I have to paste the SQL starter code in and run it. However, when I do, I hit an error that I can't solve. …
Michael Martin
  • 47
  • 9
1
vote
2 answers

SQlite DB BRowser - Create users in auth_user table by SQL - how to hash password?

Maybe I am doing something wrong but I would like to create data for my Django app tests and first, I would like to create users using sql script in DB Browser SQLite INSERT INTO auth_user (date_joined, username, first_name, last_name, email,…
SLATER
  • 613
  • 9
  • 31
1
vote
2 answers

How to insert string value into table in SQLite3?

New to coding - I've made a colour game so the user can get as many points as possible under a set time. I am trying to insert the scores into a table. global score global timeleft if timeleft > 0: e.focus_set() if e.get().lower() ==…
user11976133
1
vote
1 answer

database data not fully shown in mobile when run

This will be a long post but please do read until the end and help out. Thank you! In continuation of my previous post, [Android Studio - Database file loaded in the wrong encoding: 'UTF-8' my app was working fine when I run it both on my phone & an…
user10504780
1
vote
1 answer

How to add bulk values in column using DB Browser SQLite

I have a table that contain two columns. One column "rewords" contain 12186 words. and the other column named "ID" is the column that I newly created so it is empty. I want to add numbers against the rewords column. numbers from 1, 2, 3, to 12186. i…
Surraya Marvi
  • 131
  • 1
  • 11
1
vote
0 answers

dump file to db using "DB browser for SQLite"

I have a .dump file that contains about 159k of queries to create a database. I'm new to sqlite3 and using "DB browser for SQLite". How can I make my database using the dump file? I didn't find any options in the application... I did a dummy thing…
Mohammad Shahriari
  • 61
  • 1
  • 6
1
vote
1 answer

Disk I/O Error when importing from SQL into python

import sqlite3 import pandas as pd slice3_path=r"F:\GM RWA\Database\Wild.sql" conn = sqlite3.connect(slice3_path) sql='''SELECT DOG, CAT, TIGER FROM (SELECT * FROM "Mammals") GROUP BY DOG, CAT, TIGER ORDER BY TIGER asc''' df = pd.read_sql(sql=sql,…
throway172
  • 123
  • 2
  • 4
  • 12
1
2
3 4 5 6 7