571 reputation
148
bio website
location Germany
age 38
visits member for 2 years, 2 months
seen 5 hours ago

 


Nov
4
comment Understanding SQLite filesize, size “always” 1.471.488 bytes
In theory, VACUUM should have worked. Show the output of sqlite3_analyzer.
Nov
1
comment NoSql vs Sqlite in terms of crossplatform application
How would points 12456 not apply to some NoSQL DB? And are you aware that SQLite uses dynamic typing?
Oct
12
answered Retrieve index column
Oct
11
comment How to use relationships to extract data via select
datetime is not an SQLite keyword.
Sep
24
awarded  Autobiographer
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().)
Sep
6
awarded  Yearling
Sep
4
awarded  Fanatic
Sep
3
answered SQLITE table joining with group
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
revised Strategy to find the unique bivariate polynomials
added 551 characters in body; added 4 characters in body
Aug
3
comment Strategy to find the unique bivariate polynomials
You need an index on graph_id.
Aug
2
answered Strategy to find the unique bivariate polynomials
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.