654 reputation
148
bio website
location Germany
age 38
visits member for 2 years, 4 months
seen yesterday

 


1d
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.
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