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
2
votes
0 answers

sqlite database schema version incrementing on disconnect/connect from sqlitestudio

I use the sqlite database schema version. PRAGMA schema_version; It helps me control upgrades and prevents user from modifying the schema and then reporting a flood of irreproducible bugs. However, I find the version increments far more often that…
ravenspoint
  • 19,093
  • 6
  • 57
  • 103
1
vote
1 answer

How to view a temporary table?

I am using SQLite Studio. When I create a table I can see and add data to it. I cannot see a temporary table. My code: create temporary table Books2 ( Title varchar(32) primary key, year integer not null, des …
Sepehr Omidvar
  • 127
  • 1
  • 8
1
vote
1 answer

How can I create a Running Total Sumifs-like function in SQL?

I'm pretty new to SQL, but Excel has become far too slow to continue working with, so I'm trying SQLiteStudio. I'm looking to create a column in a query showing running total over time (characterized as Schedule Points, marking each percent through…
Alex M
  • 21
  • 3
1
vote
2 answers

ORDER BY not giving max digital

I'm using SQLite Studio and need to show 20 largsest numbers in SUM_D, but it get me "999,987" as biggest. At least i have "1 925,886", but it isn't show. SELECT NAME, SUM_D FROM borg_1 ORDER BY SUM_D DESC LIMIT 20; so here u could see my data…
Jeki4an
  • 19
  • 7
1
vote
1 answer

Lag() Function in SQLiteStudio

I am wanting to return the last transaction date grouped by CustomerID, and I am using SQLiteStudio 3.2.1. My table looks like this: CustomerID Date TransactionID Amount 1 2000-07-01 1 20.00 2 …
Jen
  • 15
  • 4
1
vote
0 answers

Read the SQLite format 3 DB file saved as blob in a oracle DB

I am using SQLite as a storage extension for offline functionality in my app. I have a feature where I save the entire db file in users device to my main oracle database (mainly for troubleshooting).This is of type BLOB. How can I download this file…
RBz
  • 896
  • 3
  • 17
  • 34
1
vote
0 answers

How to store functions using SQLite

For example, I am creating one table to store a complex function such as y= α·β·(2|ΔP|/ρ)^0.5.by the way, I will call the function from this table through R Program. Thanks for your attention!
Jason S
  • 11
  • 1
1
vote
2 answers

Cannot run SQLiteStudio 3.2.1 on Mac OS Catalina? Stuck at choose language

I am a beginner. I've searched online for others with a similar issue but didn't get results. I am trying to learn SQL and the course I'm following is using SQLiteStudio. I have downloaded the *.dmg file and installed but upon running the app, it…
Jenn Fern Carneiro
  • 11
  • 3
1
vote
0 answers

How to bypass gatekeeper on macOS Catalina for only one particular program?

I don't want to find some disabling of gatekeeper where I just turn it off completely. However, I use SQLiteStudio probably more often than majority of the applications on my computer, but every single time I open it (which I try to avoid and just…
dblover
  • 11
  • 1
1
vote
0 answers

Adding image to sqlite studio Ionic

I searched, but found nothing. Is it possible to add an image to sqlite studio? I have a database in my project, and in it I have some tables and columns with products. They all have information, but now I need to add an image to each of them. Is it…
Felipe XST
  • 141
  • 1
  • 14
1
vote
1 answer

SQLiteStudio import extremely slow

SQLiteStudio is lightning fast with queries, but whenever I import a .csv of even modestly large size (say, 60,000 rows, smaller than 2MB), it takes 5 minutes or more to import. And somewhat larger files can run 15 minutes before I give up. The…
MKauffman
  • 11
  • 1
1
vote
2 answers

Why is SqliteStudio showing DATETIME column in its Create Table statement

I have read that date time is stored in either Text, Real, or Integer in sqlite, but sqlitestudio shows the datetime column as Datetime, like in the following DDL it shows the DATETIME column: CREATE TABLE tblWeights ( uid STRING, …
user734028
  • 1,021
  • 1
  • 9
  • 21
1
vote
0 answers

How to transfer changes made in SQliteStudio to Flask models (SQlAlchemy)

Sorry for possibly incorrect Title, but I tried so hard to specify the problem. So, here is the situation: I'm trying to implicate Miguel Grinberg's Flask Tutorial... I've created the database as it was explained in tutorial (imported DB into…
Василий Масов
  • 141
  • 1
  • 1
  • 6
1
vote
1 answer

way to mass-add columns in sqlite studio?

I'm new to creating databases, and right now all I want to do is import a csv file into an empty sqlite3 database using sqlite studio. I created an extremely basic table with only a single unnamed empty column, and then attempted to import my file…
lmotl3
  • 537
  • 1
  • 8
  • 20
1
vote
4 answers

SQLiteStudio: How to create unique row (not column)?

I want to create a table that only allows unique rows with SqliteStudio: This should work: |--ID--|--Column01--|--Column01--| | 1 "brun/brune" "brown" | | 2 "yellow" "brown" | This shouldn´t…
MeineHTMLCodes
  • 509
  • 5
  • 19
1
2
3 4 5 6