[sqlite] New word to replace "serverless"

2020-01-28 Thread Howard Chu
server in a separate thread. In fact, that is how most >> embedded RDBMSes other than SQLite work, if I am not much mistaken. Wait, really? AFAICS embedded means in-process, no IPC required to operate. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun h

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

2020-01-04 Thread Howard Chu
r on a 64-threaded CPU vs 64 single-threaded processes. In practice, the single process with 64 threads ought to be slightly faster, due to less context switch overhead between threads, but if nothing else in the system is contending for CPU then context switching shouldn't even be an issue. -

Re: [sqlite] FTS5 Transaction Leads to OOB Read

2019-03-19 Thread Chu
YES. AFL with ASAN. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] FTS5 Transaction Leads to NULL Pointer

2019-03-18 Thread Chu
The code: ``` CREATE VIRTUAL TABLE t1 USING fts5(content); INSERT INTO t1 VALUES(''); BEGIN ; DELETE FROM t1 WHERE rowid = 1; SELECT * FROM t1 WHERE content MATCH ''; INSERT INTO t1 VALUES(''); SELECT * FROM t1 WHERE

[sqlite] FTS5 Transaction Leads to OOB Read

2019-03-18 Thread Chu
The code: ``` CREATE VIRTUAL TABLE t1 USING fts5(content); BEGIN; INSERT INTO t1 (content) VALUES(''); SELECT * FROM t1('*'); END; ``` As you can see, it creates a virtual table

Re: [sqlite] Multi threaded readers on memory sqlite cannot scale

2018-05-15 Thread Howard Chu
Jens Alfke wrote: On May 14, 2018, at 11:25 PM, Howard Chu <h...@symas.com> wrote: Do you have a link to the currently updated version of this? Google gives me projects that haven't been updated since 2015. That's the most recent version. So far I haven't seen any compelli

Re: [sqlite] Multi threaded readers on memory sqlite cannot scale

2018-05-15 Thread Howard Chu
This is the latest: http://www.sqlitening.planetsquires.com/index.php?topic=9427.0 I contributed to the last SQLitening update. No one has reported any issues that need fixing or updating since that update. It seems to be working quite well/stable. > On 5/13/18, 6:48 AM

Re: [sqlite] Multi threaded readers on memory sqlite cannot scale

2018-05-15 Thread Howard Chu
Peter Da Silva wrote: On 5/13/18, 6:48 AM, "sqlite-users on behalf of Howard Chu" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of h...@symas.com> wrote: SQLightning Do you have a link to the currently updated version of this? Google gives me projects that have

Re: [sqlite] Multi threaded readers on memory sqlite cannot scale

2018-05-13 Thread Howard Chu
(with looser synchronous and journal_mode settings), and rely on the OS file cache. Or just use SQLightning, which has no scalability limits for readers. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect

Re: [sqlite] Enabling MMAP in Android

2017-12-12 Thread Howard Chu
J Decker wrote: On Tue, Dec 12, 2017 at 4:35 PM, Howard Chu <h...@symas.com> wrote: Martin Raiber wrote: On 12.12.2017 19:47 Simon Slavin wrote: On 12 Dec 2017, at 6:27pm, Jens Alfke <j...@mooseyard.com> wrote: On Dec 12, 2017, at 5:46 AM, Simon Slavin <slav...@bigf

Re: [sqlite] Enabling MMAP in Android

2017-12-12 Thread Howard Chu
ooted devices can bypass... -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/ ___ sqlite-users mailing list sqlite-users@mail

Re: [sqlite] Enabling MMAP in Android

2017-12-12 Thread Howard Chu
use on MacOS, no issues have been reported. On iOS there's this nagging problem that the virtual address space is still limited to 4GB, even on 64bit systems. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief

Re: [sqlite] Read-only access which does not block writers

2016-11-28 Thread Howard Chu
, but readers block writers. That's the best you're going to get without custom lock protocols like LMDB uses natively. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project

Re: [sqlite] Read-only access which does not block writers

2016-11-24 Thread Howard Chu
Florian Weimer wrote: On 11/24/2016 10:41 PM, Howard Chu wrote: As a compromise you could use SQLightning, which replaces SQLite's Btree layer with LMDB. Since LMDB *does* allow readers that don't block writers. How does it do that? Does LMDB perform lock-free optimistic reads

Re: [sqlite] Read-only access which does not block writers

2016-11-24 Thread Howard Chu
eaders that don't block writers. But it would be more efficient to just use LMDB directly, and not incur the overhead of the SQL translation layer. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, Op

Re: [sqlite] Parallel access to read only in memory database

2016-10-13 Thread Howard Chu
modified to get this working. Certainly if there is an extra flag or URI I need to use to get concurrent in memory read access that would be great, but I'm willing to try and modify the source code and sharing with the community if I can figure out how to get this going. -- -- Howard Chu CTO, Sy

Re: [sqlite] Parallel access to read only in memory database

2016-10-11 Thread Howard Chu
Jens Alfke wrote: On Oct 9, 2016, at 10:41 AM, Howard Chu <h...@symas.com> wrote: As for code freshness, I've seen no compelling new features from 3.8.x onward that would improve performance so there's been no reason to update further. Perhaps, but there’s important new functio

Re: [sqlite] Parallel access to read only in memory database

2016-10-09 Thread Howard Chu
Jens Alfke wrote: On Oct 9, 2016, at 8:15 AM, Howard Chu <h...@symas.com> wrote: Use SQLightning, it's designed specifically for write once read many workloads. "SQLite3 ported to use LMDB instead of its original Btree code” — sounds great, and the performance figures quoted in

Re: [sqlite] Parallel access to read only in memory database

2016-10-09 Thread Howard Chu
read many workloads. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/ ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Why so much I/O ? Can sqlite be improved ?

2016-10-01 Thread Howard Chu
sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Archit

Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

2016-05-26 Thread Howard Chu
RAM. One common mistake of new Unix admins is to delete large log files from /var/spool when they're low on disk space; if they do this without telling syslog to close the files first, the space remains in use and can't be freed until syslog is killed and restarted. -- -- Howard Chu

[sqlite] Make mmap_size dynamic?

2016-05-03 Thread Howard Chu
n RAM. There is a larger performance loss when your DB is larger than RAM - every time you touch a page to write to it, if it's not already memory-resident, the OS faults it in from disk. It's a wasted page fault if you were simply going to overwrite the entire page (which e.g. LMDB does). If you up

[sqlite] Changing the default page_size in 3.12.0

2016-03-05 Thread Howard Chu
rd Hipp >> drh at sqlite.org >> ___ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > ___ > sqlite-users mailing list > sqlit

[sqlite] Fwd: Re: SQLite and Thunderbird

2016-02-26 Thread Howard Chu
nel of communication regarding these bugs. >>> >>> While I believe thunderbird uses a format of call that is depreciated in >>> the newer SQLite packages, it is not ideal to statically compile >>> thunderbird against sqlite to make it work (which I believe is the

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-03 Thread Howard Chu
o setting PRAGMA > synchronous ON/OFF makes a big difference in write performance on Windows > systems. > > Howard Chu schrieb am 30.01.2016 um 23:23: >> dpb wrote: >>> Dear Community, >>> >>> Assuming that SQLite would arrange the database table contents

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-02-01 Thread Howard Chu
ly, there's no excuse for your database to not also come up successfully, fully intact. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-01 Thread Howard Chu
James K. Lowden wrote: > On Sat, 30 Jan 2016 22:23:24 + > Howard Chu wrote: > >> Note that the cache eviction runs quite frequently - once every 5 >> seconds or so, and evicts pages regardless of whether there's any >> memory pressure in the system. It's quite poss

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-01-30 Thread Howard Chu
nds or so, and evicts pages regardless of whether there's any memory pressure in the system. It's quite possibly the stupidest cache manager ever written. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Archi

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-01-28 Thread Howard Chu
in Linux, at least. It is also independent of whether or not the filesystem uses journaling. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-01-26 Thread Howard Chu
Richard Hipp wrote: > On 1/25/16, Howard Chu wrote: >> >> This is actually quite an unusual requirement; on older Unix systems you >> couldn't even *open* a directory, let alone obtain write access to it or >> fsync it. > > Yeah. When the SQLITE_DISABLE_DIRSY

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-01-25 Thread Howard Chu
* fsync is needed? The issue here is that file creation/deletion/rename ops require an fsync *on the containing directory*. This is actually quite an unusual requirement; on older Unix systems you couldn't even *open* a directory, let alone obtain write access to it or fsync it. -- -- Howard

[sqlite] POSIX and MMU (was Re: out of the void: xDlSym)

2016-01-17 Thread Howard Chu
I'm just curious as to > whether or not an MMU is a requirement or just really nice to have. ST-Minix ran on MC68000 - no MMU. POSIX API only defines a programming model, it doesn't mandate how it gets implemented under the covers. An MMU *can* make some things easier, but we had fork/ex

[sqlite] SQLITE vs. OSX mmap == inevitable catalog corruption?

2015-11-18 Thread Howard Chu
eep in mind that this requires a unified buffer cache and systems like OpenBSD still don't have that, so this approach will cause corruptions on systems like that. > >http://sqlite.org/src/info/67c5d3c646c8198c > > It would be interesting to know if this clears the problem in your

[sqlite] MMAP performance with databases over 2GB

2015-08-08 Thread Howard Chu
o such limit... https://github.com/LMDB/sqlightning there's nothing "heavy" about making maximum use of mmap. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-18 Thread Howard Chu
en considered to be a mistake on the part of the LDAP designers. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/

[sqlite] Enabling mmap on OpenBSD: Anything really in the way, and how do?

2015-05-22 Thread Howard Chu
Mikael wrote: > You who know SQLite all the way through, would either 1) or 2) or something > else still make a problem on OpenBSD? > > > If not, how do I use SQLite with all-file memory mapping on OpenBSD: I just Use SQLightning. https://github.com/LMDB/sqlightning -- -- Ho

[sqlite] How do non-SQLite DBMS communicate?

2015-04-23 Thread Howard Chu
oad > Hauppauge, NY 11788 > 631-272-5947 / William.Drago at L-3COM.com<mailto:William.Drago at L-3COM.com> -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/

[sqlite] sqlite3 (or sqlite4) performance on NFS

2015-04-12 Thread Howard Chu
onvenience. Seriously - there are many other distributed filesystems out there, all designed because users keep running into the same deficiencies of NFS, over and over again. Please, can we stop reinventing this wheel now? -- -- Howard Chu CTO, Symas Corp. http://www

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-13 Thread Howard Chu
Scott Robison wrote: On Sat, Sep 13, 2014 at 2:24 PM, Howard Chu <h...@symas.com> wrote: Scott Robison wrote: A couple of academic thoughts. 1. If one wanted to embed the journal within the database, would it be adequate to reserve a specific page as the "root" pag

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-13 Thread Howard Chu
quot; truncate operation. A custom VFS might be able to provide a proof of concept... hmm. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/ _

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-13 Thread Howard Chu
the ftp transfer to succeed without just getting garbage on the other end. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/ _

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-13 Thread Howard Chu
ell. It's no paragon of efficiency, but it doesn't need to be particularly performant in the first place, and it requires zero setup. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.op

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-13 Thread Howard Chu
Simon Slavin wrote: That's not what I meant. That's the file as a database. What I want is the entire volume as a database. That's exactly what I pointed you to before. The thesis is pretty enlightening too. http://www.fsl.cs.sunysb.edu/docs/kbdbfs-msthesis/ -- -- Howard Chu CTO

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-12 Thread Howard Chu
device-level ordering support too. - which prompted my suggestion here http://www.spinics.net/lists/linux-fsdevel/msg70047.html -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-12 Thread Howard Chu
ist on a modern filesystem like EXT4. Actually LMDB comes out on top with zero vulnerabilities. I spoke to the UWisc folks to find out what was the one Atomicity vulnerability they reported in LMDB and we confirmed that it was not in fact a valid vulnerability. -- -- Howard Chu CTO, Symas

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-12 Thread Howard Chu
pot.ie/2007/05/kernel-berkeley-db-file-system-kbdbfs.html https://github.com/dmeister/kbdb/tree/master/kbdbfs-1.0 I've got a project underway to retrace their steps, using LMDB instead of BerkeleyDB. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highla

Re: [sqlite] SQlite on flash filesystem

2014-08-16 Thread Howard Chu
h we're not sure about. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/ ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] sqlite & multi process usage

2014-07-18 Thread Howard Chu
seems that FreeBSD and other related BSDs still don't implement these though, so you have to use semaphores on them instead. (Either SysV style or POSIX named semaphores.) -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/

Re: [sqlite] SQLite scalability

2013-11-22 Thread Howard Chu
imits like these. The only definive SQLite limits are documentet in the relevant manual page. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.o

Re: [sqlite] Row Level Locking as in InnoDB

2013-11-10 Thread Howard Chu
most happiest person here :) You seem to enjoy asking a lot of others, without regard to cost. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.

Re: [sqlite] Row Level Locking as in InnoDB

2013-11-08 Thread Howard Chu
so BDB SQL can only be slower than SQLite. Whatever other differences there may be, there is no performance benefit to using BDB as a backend for SQLite. In most cases there is a performance loss. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun

Re: [sqlite] Row Level Locking as in InnoDB

2013-11-04 Thread Howard Chu
://sphia.org/benchmarks.html Quite off-topic for this list, but those results are garbage. https://github.com/pmwkaa/sophia_benchmark/issues/2#issuecomment-27740082 -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief

Re: [sqlite] Row Level Locking as in InnoDB

2013-11-03 Thread Howard Chu
, for example LSM tree or create new, like in sophia (sphia.org) key value DB? I just looked, sophia is nothing special. See these microbench results. http://pastebin.com/cFK1JsCN LMDB's codebase is still smaller and faster. Nothing else touches LMDB's read speed. -- -- Howard Chu CTO, Symas Corp

Re: [sqlite] Row Level Locking as in InnoDB

2013-11-03 Thread Howard Chu
saying BDB is better and faster than SQLite ? Oracle claims that. From what I can see, Oracle is wrong. On Sun, Nov 3, 2013 at 8:28 PM, Howard Chu <h...@symas.com> wrote: Aris Setyawan wrote: SQLightning replaces the SQLite backend with Symas' LMDB, which also uses MVCC and th

Re: [sqlite] Row Level Locking as in InnoDB

2013-11-03 Thread Howard Chu
when I created LMDB. That's like asking why a hammer isn't a screwdriver. On 11/3/13, Howard Chu <h...@symas.com> wrote: Aris Setyawan wrote: SQLite do not use row level locking, but db level locking, so it was the right behavior the second thread was blocked. For innodb like in SQLite,

Re: [sqlite] Row Level Locking as in InnoDB

2013-11-03 Thread Howard Chu
eed to do a lot of selects and inserts in my application and hence a row level locking is suitable vs table or database level locking. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http:

Re: [sqlite] logical to use sqlite to replace Berkeley DB ?

2013-09-13 Thread Howard Chu
Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Minimizing Internal Function Calls in SQLite

2013-07-30 Thread Howard Chu
schema really so complex? Are your queries? Do you need to do JOINs across multiple tables? -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/p

Re: [sqlite] Large Database Windows vs Linux

2013-06-28 Thread Howard Chu
way to handle the Hardware Destroyer (Power Management) in Windows. Disable it completely. The best thing to do with Windows is format the drive and install Unix or FreeBSD or Linux. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

2013-04-04 Thread Howard Chu
Dan Kennedy wrote: On 04/04/2013 08:44 PM, Howard Chu wrote: Richard Hipp wrote: The memory-mapped I/O is only enabled for windows, linux, mac OS-X, and solaris. We have found that it does not work on OpenBSD, for reasons we have not yet been able to uncove; but as a precaution, memory mapped

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

2013-04-04 Thread Howard Chu
or not it even works for you, is very important to us. Thanks for giving the new code a try. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

2013-04-04 Thread Howard Chu
es obvious and easy to fix. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/ ___ sqlite-users mailing list sq

Re: [sqlite] experimental (better?) usage based sqlite cache

2013-02-25 Thread Howard Chu
Simon Slavin wrote: On 25 Feb 2013, at 11:33am, Howard Chu <h...@symas.com> wrote: Gabriel Corneanu wrote: Following a few other discussions, I had the feeling that sqlite should benefit from a cache which discards cached pages in a least frequently used order. Just offhand, classic

Re: [sqlite] experimental (better?) usage based sqlite cache

2013-02-25 Thread Howard Chu
, because no reorganizing of LRU lists is needed during page references. And of course, having gone thru all of these exercises of fancy application-level cache algorithms already, it's still obvious that the best approach is to leave it to the kernel. -- -- Howard Chu CTO, Symas Corp

Re: [sqlite] Concurrent read performance

2013-01-14 Thread Howard Chu
of programmer time invested in proper coding saves eons of user time. Putting programmer effort into making correct code fast is always The Right Thing to Do. Software that delivers the correct answer, late, is still wrong. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director

Re: [sqlite] Concurrent read performance

2013-01-13 Thread Howard Chu
saves eons of user time. Putting programmer effort into making correct code fast is always The Right Thing to Do. Software that delivers the correct answer, late, is still wrong. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlands

Re: [sqlite] Please help. Read only process being blocked by writer process.

2012-11-29 Thread Howard Chu
ld hang while having a prepared statement open and cause the wal file to grow forever, then causing errors in other processes. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.

Re: [sqlite] Please help. Read only process being blocked by writer process.

2012-11-28 Thread Howard Chu
ad transactions open indefinitely. Call sqlite3_reset() when you are done with a statement so that its implied read transaction will close. Thank you for your quick answer. On Wed, Nov 28, 2012 at 9:52 AM, Richard Hipp <d...@sqlite.org> wrote: PRAGMA journal_mode=WAL

Re: [sqlite] light weight write barriers

2012-11-16 Thread Howard Chu
Ric Wheeler wrote: On 11/16/2012 10:06 AM, Howard Chu wrote: David Lang wrote: barriers keep getting mentioned because they are a easy concept to understand. "do this set of stuff before doing any of this other set of stuff, but I don't care when any of this gets done" and the

Re: [sqlite] light weight write barriers

2012-11-16 Thread Howard Chu
fix for them. Once you have drives that are actually trustworthy, actually reliable (which doesn't mean they never fail, it only means they tell the truth about successes or failures), most of these other issues disappear. Most of the need for barriers disappear. -- -- Howard Chu CTO

Re: [sqlite] Shared in-memory SQLite database in shared memory

2012-11-03 Thread Howard Chu
databases. Nothing else is anywhere close to as efficient as MDB for reads. Read more here http://highlandsun.com/hyc/mdb/ The port of SQLite using MDB as its backend is available on gitorious https://gitorious.org/mdb/ -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director

Re: [sqlite] light weight write barriers

2012-11-01 Thread Howard Chu
nc. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

[sqlite] light weight write barriers

2012-10-30 Thread Howard Chu
is progressing as well. -- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/ ___ sqlite-users mailing list sqlite-users