CL.

less info
meta site favicon meta user | stack exchange network profile network profile
201 reputation
15
bio website
location Germany
age 36
visits member for 8 months
seen 11 hours ago
stats profile views 4

 


24 Actions

suggestions reviews revisions comments badges posts accepts all
May
20
 awarded  Constituent
May
20
 awarded  Caucus
May
16
 answered How to output query to file using SQLite3
Apr
1
 comment Read-only on an SQLite database which is being modified by another program
SQLite write locking documentation.
Mar
25
 answered SQLite writing a query where you select only rows nearest to the hour
Feb
11
 comment Delete with subquery with no unique columns
What exactly is that "some condition"?
Feb
5
 answered Configuration options for relational algebra evaluator “ra.jar”
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.
Oct
2
 comment Can I monitor the progress of importing a large .sql file in sqlite3 using zenity --progress?
Now works for me with --auto-close.
Oct
2
 revised Can I monitor the progress of importing a large .sql file in sqlite3 using zenity --progress?
added 1 characters in body
Oct
2
 comment Can I monitor the progress of importing a large .sql file in sqlite3 using zenity --progress?
Output the percentages to the console (>&2 instead of >&3) to check whether they are correct.
Oct
2
 comment Can I monitor the progress of importing a large .sql file in sqlite3 using zenity --progress?
It's likely that the first lines in your file are executed faster.
Sep
29
 answered Working with multiple databases?
Sep
28
 awarded  Editor
Sep
28
 revised Can I monitor the progress of importing a large .sql file in sqlite3 using zenity --progress?
added 362 characters in body
Sep
28
 answered Can I monitor the progress of importing a large .sql file in sqlite3 using zenity --progress?
Sep
27
 comment SQLite Performance Tuning
duplicate of SQLite Select Query Performance Tuning on SO
Sep
21
 awarded  Critic
Sep
21
 answered Why $in is much faster then $all
1 2