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
6
votes
1 answer

Open encrypted SQLite database with SQLiteStudio

I'm using System.Data.SQLite to create an encrypted SQLite database in a WPF project. The encryption is done by providing a password in the connection string just like this one: new SQLiteConnection("Data…
stefan
  • 658
  • 2
  • 9
  • 31
3
votes
1 answer

SQLite before insert trigger

I'm trying to insert duplicates data to table B when PKA violated using a BEFORE INSERT TRIGGER as the following example: CREATE TABLE A( Col INTEGER, Coll TEXT(25), CONSTRAINT PKA PRIMARY KEY(Col, Coll) ON CONFLICT IGNORE); CREATE UNIQUE INDEX IX_A…
Ilyes
  • 14,640
  • 4
  • 29
  • 55
3
votes
1 answer

python bottle framework maximum recursion depth exceeded

I am trying to add a path for my web app but for some reason maximum recursion depth error occurs def runSQL(sql): db = sqlite3.connect('zadanie.db') c = db.cursor() c.execute(sql) data = c.fetchall() db.commit() …
mandarti
  • 33
  • 6
3
votes
2 answers

How to connect SQLite Studio to database via adb (emulator Android)

Do you know if there is a way to connected SQLite Studio (or similar) to the database via adb (emulator for Android), so I can see graphically my data via the laptop? Thanks in advance
Enrico
  • 41
  • 1
  • 4
3
votes
2 answers

Why do SQLiteStudio (and others) not display a datetime in human-readable format by default?

Today I had to use a SQLite database for the first time and I really wondered about the display of a DATETIME column like 1411111200. Of course, internally it has to be stored as some integer value to be able to do math with it. But who wants to see…
maf-soft
  • 2,335
  • 3
  • 26
  • 49
3
votes
2 answers

Reference database name in sqlite studio

In Sqlite studio, I usually select the database name from the dropdown before executing a query. However if I want to specify the database name in the SQL itself, something like Select * from C:\Folder\DbList\Test.Db \.
Aqua267
  • 873
  • 3
  • 12
  • 35
2
votes
2 answers

How to open a database encrypted with SQLCipher?

I created and encrypted a database with the package.(react-native-sqlcipher) I want to open this database with "DB Browser for SQLite" or "SQLite Studio". However, it doesn't open even though I enter the correct key. Is salt being added while…
ertandrn
  • 71
  • 1
  • 4
2
votes
1 answer

update every row with a different random datetime of a range

The question asked here is Update every row with a random datetime between two dates to update with the same datetime. What I need is to update every row with a different random datetime within a range.
Mert Mertce
  • 1,049
  • 7
  • 34
2
votes
1 answer

How to export the query results from a Database Manager to a CVS file in SQLite?

I am using DataGrip or SQLiteStudio (database managers) to run a series of queries in a database which guide me to find the information that I require. The queries works well and the results are shown in the console of the Dabase Manager. However, I…
Lucho
  • 221
  • 1
  • 6
2
votes
2 answers

Update query to append zeroes into blob field with SQLiteStudio

I'm trying to append zeroes to a blob field in a sqlite3 db. What I tried is this: UPDATE Logs SET msg_buffer = msg_buffer || zeroblob(1) WHERE msg_id = 'F0' As you can see, the field name is "msg_buffer", and what I want is to append byte zero.…
framontb
  • 1,817
  • 1
  • 15
  • 33
2
votes
1 answer

Adding Derived Attribute To An Entity With Sqlite3

Hello I have 2 entities that are CUSTOMER and PRODUCT at my Entity Relation Diagram(ER). CUSTOMER and PRODUCT has a M to N relationship which is RATE and this relationship has 2 attributes which are Comment and Rate. My PRODUCT entity has a derived…
BUY
  • 705
  • 1
  • 11
  • 30
2
votes
2 answers

Use a single query on all databases

I need to execute one simple query on a very large number of databases (50 to be precise) at the same time SELECT * FROM table1 WHERE column1 NOT IN(SELECT column1 FROM table2) I am using: SQLite Studio 3.1.0 and .sqlite databases SQLite doesn't…
Alexandru Martalogu
  • 273
  • 2
  • 12
2
votes
2 answers

How to create db file with SQLiteStudio

I have created the database for my Android app using SQLiteStudio 3.0.5 and now I need to save/export the one as .db file, but i found only the export to .sql-file. So, what should I do to make such procedure?
Sergey V.
  • 981
  • 2
  • 12
  • 24
2
votes
1 answer

How to comment out code in SQLiteStudio SQL editor?

Is there a way to temporary comment out some of code in SQLiteStudio? I have to add -- or /* ... */ each time and remove them manually. It will be greate if we can trigger comment using a button or shortcut like Ctrl-/. How do you tackle this…
Nick
  • 8,451
  • 13
  • 57
  • 106
2
votes
2 answers

How to display a specific range of numbers in an SQL query

So there's just a little bit more to this than the title suggests. I've got a table which contains a name column and a qty column, I want to display the results who have a TOTAL sum qty between 500 and 1500. Example: name qty ------ ---- brad …
dks209
  • 57
  • 11
1
2 3 4 5 6