Re: [sqlite] Introducing Bedrock: SQLite for the Enterprise

Hm, that's an interesting case that I don't quite follow. But you could definitely use Bedrock on 2 nodes, and Bedrock would handle realtime replication from one to the other. This would provide an instant offsite backup. Granted, if there were only 2 nodes, you couldn't take one offline, as

Re: [sqlite] Optimizations to recover early from D state of the process

Rutuja Shah wrote: > the process goes into D state and takes around 5 to 15 minutes to recover. There appears to be something wrong with your storage system. Are you using a local disk, without RAID, not in a VM? Regards, Clemens ___ sqlite-users

[sqlite] Optimizations to recover early from D state of the process

Hi, Requirement 1: Data dumped to the DB every 15 minutes. One table per day, data is stored for the last 7 days. 2 such tables needed. Total number of tables - 7 days * 2 tables = 14 Average number of rows inserted per transaction (per 15 minutes per table) - 1,20,000 Requirement 2: Data dumped

Re: [sqlite] 2 consecutive rises in value

What about this one? create table TABLE1(Seq integer primary key autoincrement, Id integer, Date date, Value integer); insert into TABLE1(Id,Date,Value) values(2,'2004-06-23', 42), (...), ...; select distinct T1.Id-- only one per Id from

Re: [sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

A follow-up on this (and a late thanks!): I've used your answer to write some build instructions for Ubuntu and Raspbian at http://blog.wezeku.com/2016/10/09/using-system-data-sqlite-under-linux-and-mono/ I've also modified the F# SQLProvider type provider so that it no longer always loads

Re: [sqlite] 2 consecutive rises in value

Thanks, will give that a try as well, but I am happy with the solution form R Smith. Only one relatively simple SQL and quite fast. Took about 1.5 secs to process 5 rows. RBS On Thu, Oct 20, 2016 at 4:55 PM, Jean-Luc Hainaut < jean-luc.hain...@unamur.be> wrote: > > What about this one? > >

[sqlite] Typical suffixes of sqlite database files

Hello, I'm asking this for further discussion of a deficiencies of emacs sql-mode w/ sqlite databases (https://debbugs.gnu.org/cgi/bugreport.cgi?bug=23566). What suffixes to sqlite database files do you use or see in the wild? There are for sure .db (e.g. firefox) .sqlite[23]?

[sqlite] spellfix1 is unable to match words beginning with 'Kn' and 'Gn'

Is this the right list to report issues with the spellfix1 extension? Here's a complete repro case: [deepthought ~] ls -l newdb ls: newdb: No such file or directory [deepthought ~] sqlite3 newdb SQLite version 3.14.2 2016-09-12 18:50:49 Enter ".help" for usage hints. sqlite> SELECT

[sqlite] Risk of damaging a non-sqlite file with `sqlite3 `?

Hello, I'm asking this for further discussion of a deficiencies of emacs sql-mode w/ sqlite databases (https://debbugs.gnu.org/cgi/bugreport.cgi?bug=23566). If the cmd line tool sqlite3 is used, is it possible to damage a file, given as sqlite database file argument to sqlite3? Just sqlite3

[sqlite] Drop Existing Table Results in 'no such table'

I am trying to rename a table by editing the sqlite_master directly. I do know there are a ‘ALTER TABLE … RENAME TO …’ syntax to do that. I just want to try it in this way. But I find that the ‘no such table’ error occurs while I try to drop the renamed table. Only I close the connection or

Re: [sqlite] Typical suffixes of sqlite database files

At 01:17 21/10/2016, you wrote: What suffixes to sqlite database files do you use or see in the wild? I routinely/always use .sq3 but that's only a personal convention. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Optimizations to recover early from D state of the process

On 19 Oct 2016, at 2:22pm, Rutuja Shah wrote: > I observed that the process goes into D state and takes > around 5 to 15 minutes to recover. There is nothing in SQLite that could put a process in TASK_UNINTERRUPTIBLE mode. SQLite doesn't know much about your storage