546 reputation
148
bio website
location Germany
age 37
visits member for 2 years
seen 10 hours ago

 


Sep
18
comment Group by + Order by Behavior Explanation?
possible duplicate of Why am I getting different results from a query vs. a view
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.
Jun
20
comment SQLite and Write Ahead Logging: why so large files
That's what VACUUM is for.
Jun
10
comment Create a result for a line chart with dates
This is possible, but how do you know which dates to include in the output table?
Apr
29
comment First time using an Index - SQLite / Android
Why are you using LIKE instead of GLOB? Do you need case insensitivity?
Apr
4
comment Why does SQlite return incorrect sum?
SQLite does not have NUMERIC or DECIMAL data types.
Mar
7
comment select all rows with a minimum value
@ypercube CTEs, views, and subqueries are flattened or implemented as coroutines, if possible. But a GROUP BY on a non-indexed column must be able to collect the data for all groups in parallel, so it requires some form of temporary table (in all databases).
Mar
7
comment select all rows with a minimum value
When executed, the result of the u query is stored in a temporary table, regardless of whether it's written as a CTE, a view, or inline as a subquery.
Mar
7
comment select all rows with a minimum value
This will return all four records, because the num2 values are unique.
Jan
14
comment Performance difference search on INT or TEXT in SQLite 3
That depends on the size and the access patterns of your database.
Jan
12
comment SQLite Design: Better to have many tables with few columns or few tables with many columns?
What's so bad about 14M rows? That table might still fit into RAM.