Reputation
714
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
1 5 8
Newest
 Tenacious
Impact
~33k people reached

  • 0 posts edited
  • 6 helpful flags
  • 29 votes cast
Apr
11
comment SQLite insertion with junction table
And what exactly do you have a problem with? Executing SQL commands? The syntax of SELECT or INSERT statements? lastInsertRowid()? Transactions?
Apr
10
comment SQLite insertion with junction table
What programming language are you using?
Apr
8
comment How to select data in the same table on different rows that are empty?
Are you actually inserting NULL values, or empty strings?
Apr
1
answered Improve Query Performance
Mar
31
answered Should I use VACUUM on a SQLite db with a log-structured filesystem?
Mar
30
comment How to divide a big SQL Query into small query
Just do an INSERT for each file.
Mar
8
answered Is it correct to dynamically add rows to a table in sqlite, or should I use csv? (I'm working with objective c.)
Feb
23
awarded  Tenacious
Feb
13
answered How to define the table structure for measured data in sqlite
Feb
8
comment How do I prevent SQLite database locks?
The documentation describes the disadvantages. It is especially dangerous if you don't know how to avoid deadlocks.
Jan
30
answered How to optimize search restricted by boolean column?
Jan
28
answered Will my sqlite database occupy less space if I insert nulls instead of zeros
Jan
20
comment Unable to sort this table for the specified condition in SQLite
Did you read the documentation? Which part do you not understand?
Jan
16
revised Child records under the parent record in SQLite
added 53 characters in body
Jan
16
revised Child records under the parent record in SQLite
added 43 characters in body
Jan
16
answered Child records under the parent record in SQLite
Dec
19
answered DBEAVER: SQL error or missing database (near “,”: syntax error)
Dec
19
comment DBEAVER: SQL error or missing database (near “,”: syntax error)
@a_horse_with_no_name Only for compatibility with MySQL.
Dec
7
comment Insert values from one database table to other database table through shell scripting
Duplicate of stackoverflow.com/q/27284081/11654
Nov
4
comment Understanding SQLite filesize, size “always” 1.471.488 bytes
In theory, VACUUM should have worked. Show the output of sqlite3_analyzer.