Stack Overflow
Stack Overflow

Questions tagged [sqlitestudio]

SQLiteStudio is a DB manager for SQLite databases

SQLiteStudio is a Windows-base DB manager for SQLite databases

90 questions
0
votes
1 answer

Why can't I create this SQLite view using the command line?

When I run the query below in SQLiteStudio, the view is successfully created. CREATE VIEW BeatsEventsView AS SELECT BeatId, EventId, Hero, Beat, AdaptationPhase, Essence, Act, …
Glory to Russia
  • 17,289
  • 56
  • 182
  • 325
0
votes
0 answers

Slow query performance in sqlite but sqlite studio reports fast execution

I have two large (~100 million rows) tables I'm trying to join. I have indices on both columns used in the join. Selecting the first 1000 rows takes several hours, but when it's done, SQLite Studio reports that it only took a minute. Then, it…
Kalev Maricq
  • 617
  • 1
  • 7
  • 24
0
votes
1 answer

SQLiteStudio using upsert

I am using Sqlite 3.32.3. I imported data into a table (rover) with SQLiteStudio 3.2.1. I want to use UPSERT to update existing rows and insert new rows. As a test, I'm using the statement below to update a single existing row. It does not work…
Michael
  • 3
  • 3
0
votes
1 answer

SQLite Database not showing updates in Manager

I am running a Setup where I have a SQLite DB on my Raspberry Pi and I would like to open it remotely via a Database Manager like SQLiteStudio. I have setup a samba server on my raspberry and shared the .db file. Now I want to open the file on my…
Moritz Pfennig
  • 172
  • 12
0
votes
1 answer

SQLiteStudio automatically insert value

I have a database created with SQLiteStudio that has a products table with two columns, item and price. It also has a sales table with an item column that is linked to the item column in products. I'd like the sales table to also have a price…
DKJ
  • 53
  • 1
  • 5
0
votes
0 answers

How to Populate SQLite Database from Text File in Android Studio

So I followed a tutorial to create a simple SQLite database for my app using Android Studio. I created the necessary columns and variable names and then I downloaded SQLite Studio so I could view my database. The next step for me is to populate my…
mzm0227
  • 43
  • 5
0
votes
1 answer

Cannot get onto sqlitestudio.pl to install sqlite studio, got error: err: database or disk is full

I am trying to install sqlite studio and from what I have researched I have seen that I need to go to sqlitestudio.pl. However, once I navigate to the website I get an error saying: err: database or disk is full I have downloaded the sqlite3tools…
jr218
  • 1
  • 1
0
votes
1 answer

Update a CSV table in SQLite Studio

I have a bunch of CSVs that get updated locally on my computer every few days. I want to refresh them in SQLite Studio but I can't find out where to actually refresh. Is there an option to do this? The only way i've been able to refresh is to fully…
eluth
  • 69
  • 2
  • 13
0
votes
2 answers

How do I fix an import error for the SQLite Studio Android-Plugin that does exist?

My Problem: I'm receiving the flowing error when trying to launch my Android application with the SQLiteStudioRemote plugin (jar file). Below is a copy of the error and an image the shows the jar is properly included as an external jar and that the…
svstackoverflow
  • 665
  • 6
  • 19
0
votes
2 answers

SQLite Studio cannot load database - red exclamation marks

SQLite Studio on my Mac suddenly stopped being able to load databases. Launched app and clicked Database | Add a database Red exclamation mark appears on File and Name prompts Browsed to a known good .db3 file, clicked Test Connection and got a…
BillF
  • 1,034
  • 3
  • 13
  • 28
0
votes
0 answers

Table Updates Made in SQLiteStudio Not Recognized by iOS Mobile Application

I am working on a iOS mobile application using Xcode as the IDE and Swift as the language of choice. I added a column to the SQLite database that interacts with my application but unfortunately when I attempt to perform any database operations…
Deus Ex Machina
  • 383
  • 2
  • 5
  • 18
0
votes
1 answer

SQLiteStudio can I see the SQLite query generated by clicking options?

I use the wizard in "Tools" (SQLiteStudio 3.2.1, circa June 2019) to import a csv file into a table. I need to repeat the task a few (5) dozen times and I want to submit a query instead of pointing and clicking each time.
VictorZurkowski
  • 180
  • 1
  • 10
0
votes
1 answer

Many to many relationship SQLite (studio or sql)

Hellow. It seems to me that I just don't understand something quite obvios in databases. So, we have an author that write books and have books themselves. One author can write many books as well as one book could be written by many authors. Thus,…
V.Nosov
  • 93
  • 3
  • 10
0
votes
0 answers

Java application with SQLite not saving operations on a specific computer after closing, .sqlite-journal not flushing

I made a simple application for registering, deleting and searching for users using java + sqlite (netbeans and sqlite studio). I tested on 3 computers and everything worked correctly, however on a specific computer the behavior is: I open the…
user3533567
  • 1
  • 2
0
votes
1 answer

How to include a Qt Core c++ class for use in QtScript user function in SQLiteStudio 3.1.1?

I'm trying to write a user-defined function within SQLiteStudio (v3.1.1). This function needs to decode a field stored in base64. I think I can achieve what I want to using the QByteArray class from Qt Core like so: QByteArray text =…
ConnectSaucer
  • 5
  • 4
1 2 3
4
5 6