356 reputation
37
bio website
location Germany
age 37
visits member for 1 year, 7 months
seen Apr 21 at 12:13

 


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.
Nov
11
comment Occasional disk I/O errors in SQLite
OpenVZ does not virtualize the disk hardware like a 'real' VM, so fsync should be implemented correctly. I suspect that OpenVZ does something wrong with shared memory (used by WAL). busy_timeout is needed if WAL is actually disabled.
Nov
11
comment Occasional disk I/O errors in SQLite
Try disabling WAL mode. (You should then also set busy_timeout.)
Nov
11
comment Occasional disk I/O errors in SQLite
What file system? Any VM?
Oct
24
comment how to restore sqlite dump file to sqlite database using java?
This is not called "backup"/"restore". You want to synchronize two databases.
Oct
24
comment how to restore sqlite dump file to sqlite database using java?
Just delete the database file first.
Oct
24
comment how to restore sqlite dump file to sqlite database using java?
sqlite3's dump file is intended to recreate everything in an empty database.
Oct
23
comment how to restore sqlite dump file to sqlite database using java?
Java has no .dump command. If you've used .dump, it was in the sqlite3 command-line tool, which has nothing to do with Java.
Sep
25
comment SQLite: updating string values
@DrCopyPaste SQLite always uses variable-length strings and does not enforce length limits.
Jun
18
comment disk I/O error in SQLite
Error code 26 is ETXTBSY, which should be impossible for this type of file. This is either a virus scanner running amok (which one are you using?), or a bug in VirtualBox's shared folder implementation.
Jun
10
comment disk I/O error in SQLite
What are the messages when you add .log stderr at the beginning of the file?
Apr
1
comment Read-only on an SQLite database which is being modified by another program
SQLite write locking documentation.
Feb
11
comment Delete with subquery with no unique columns
What exactly is that "some condition"?
Jan
17
comment Delete word, its meanings, its meaning's example sentences from DB
@HLGEM: SQLite doesn't have write concurrency and locks the entire database, so locking doesn't making a difference.
Oct
4
comment How can I create a MySQL database based on a SQLite schema?
See the answers of the Convert MySQL to SQlite SO question.