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

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?
Mar
30
comment How to divide a big SQL Query into small query
Just do an INSERT for each file.
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
20
comment Unable to sort this table for the specified condition in SQLite
Did you read the documentation? Which part do you not understand?
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.
Oct
11
comment How to use relationships to extract data via select
datetime is not an SQLite keyword.
Sep
16
comment Unable to open MONyogs
Both sqlite3 on Ubuntu and SQLite Manager should have a recent enough version.
Sep
16
comment Unable to open MONyogs
Not sqlite3? What version are you using?
Sep
16
comment Unable to open MONyogs
Are you really starting a program named sqlite?
Sep
16
comment Group by + Order by Behavior Explanation?
SQLite allows such random fields only for bug compatibility with MySQL. (It would be different if there were a min() or max().)
Aug
12
comment How to get the rowid in a TRIGGER for another table in SQLite
Because a view is not a table.
Aug
12
comment How to get the rowid in a TRIGGER for another table in SQLite
You cannot have INSTEAD OF triggers on tables; you must update the record afterwards. As for getting the last inserted rowid, read the documentation.
Aug
3
comment Strategy to find the unique bivariate polynomials
You need an index on graph_id.
Jul
28
comment Query executes fast, but keeps the table locked for some time
See the last two sentences of the first paragraph.
Jul
28
comment Improving `GROUP BY` query performance in sqlite3
With a scrolling cursor, the link would not have an offset value but the column value at which to continue.
Jul
26
comment Improving `GROUP BY` query performance in sqlite3
The current offset is state.