Re: [sqlite] Mailing list shutting down...

* Richard Hipp: > On 6/13/18, Brian Curley wrote: >> Doesn't the Fossil site already have a Capcha interface built into it that >> could be adopted to enforce additional authentication around subscriptions? > > There are no captchas built into GNU MailMan. You enter your email > address to

Re: [sqlite] 3.17.0 bug report: FTS5 insertion puts a wrong value in last_insert_rowid

* Gwendal Roué: > I have found a regression in SQLite 3.17.0. In the following SQL statements: > > CREATE VIRTUAL TABLE t1 USING FTS5(content); > INSERT INTO t1(content) VALUES ('some text'); > SELECT last_insert_rowid(); // 10 (wrong) > SELECT rowid FROM t1; // 1 > > The

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

On 11/25/2016 02:07 AM, Howard Chu wrote: 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

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

On 11/24/2016 10:41 PM, Howard Chu wrote: Florian Weimer wrote: On 11/24/2016 02:54 PM, Richard Hipp wrote: On 11/24/16, Florian Weimer <fwei...@redhat.com> wrote: I'd like to replace the use of Berkeley DB in RPM with SQLite. The scenario is special in the follow way. There is no da

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

On 11/24/2016 02:54 PM, Richard Hipp wrote: On 11/24/16, Florian Weimer <fwei...@redhat.com> wrote: I'd like to replace the use of Berkeley DB in RPM with SQLite. The scenario is special in the follow way. There is no database server, all access goes directly to the database. Unpriv

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

On 11/24/2016 01:10 PM, Simon Slavin wrote: On 24 Nov 2016, at 11:02am, Florian Weimer <fwei...@redhat.com> wrote: The scenario is special in the follow way. There is no database server, all access goes directly to the database. Unprivileged users without write access to the RPM da

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

I'd like to replace the use of Berkeley DB in RPM with SQLite. The scenario is special in the follow way. There is no database server, all access goes directly to the database. Unprivileged users without write access to the RPM database are expected to run read-only queries against the

Re: [sqlite] Using a "custom" version of SQLite under Python in Ubuntu.

* Richard Hipp: > (1) You should be able to drop in SQLite 3.15.0 (or any other release > after 3.8.2) in place of SQLite 3.8.2 and everything will continue > working just fine. The only changes will be that the applications > will run a little faster. We carefully test backwards compatibility.

Re: [sqlite] smartest way to exchange a sqlite3 database with another empty

* Richard Hipp: > You cannot rename a database file while another process has that > database open. Windows simply will not allow that. If you do it on > Unix, then the process that has the file open will not know that the > file has been renamed and will continue to write to the original file.

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

* Domingo Alvarez Duarte: > After 12 hours inserting of: > > 934,135,285 records on bolsas_familia > > 22,711,259 records in favorecidos > > 5,570 records in municipios > > ... Insertion will be faster if you create the index after populating the tables. > time sqlite3 bolsa_familia3.db

Re: [sqlite] Another unexpected source of SQLITE_BUSY_SNAPSHOT

* Dan Kennedy: >> My concern is about sqlite3_step(UPDATE) without a following >> sqlite3_reset(UPDATE). Perhaps I should change my wrapper to >> unconditionally call sqlite3_reset() after DML-related sqlite3_step(), >> whether the stepping operation succeeded or not. > > For a DML statement, I

Re: [sqlite] Potential bug: Database on gvfs mount cannot be committed to

* R. Smith: > Enterprise DBs have servers on the same machine as the Files they > access, they do not actually use the network file-system to access the > DB data-files over the network from multiple clients, or even servers > (unless the DBs are partitioned so and ONLY accessed by the single >

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

On 01/25/2016 04:47 PM, Richard Hipp wrote: > On 1/25/16, Matthias-Christian Ott wrote: >> >> Does this mean that if I use SQLite SQLITE_EXTRA_DURABLE=0, PRAGMA >> journal_mode=DELETE and PRAGMA synchronous=FULL, SQLite could loose a >> transaction that it said to be committed depending on the

[sqlite] Another unexpected source of SQLITE_BUSY_SNAPSHOT

* Dan Kennedy: > On 10/18/2015 10:27 PM, Florian Weimer wrote: >> My first surprise was SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE (see >> ?SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE?). I have found another >> source of such snapshot failures with WAL-mode databases. >>

[sqlite] Another unexpected source of SQLITE_BUSY_SNAPSHOT

My first surprise was SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE (see ?SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE?). I have found another source of such snapshot failures with WAL-mode databases. I like to pre-compile my DML statements before starting transactions, mainly for the implied syntax

[sqlite] SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE

* Rowan Worth: > On 29 September 2015 at 03:47, Florian Weimer wrote: > >> Relatively rarely, while starting a transaction on a concurrently >> modified SQLite database in WAL mode, I get a SQLITE_BUSY_SNAPSHOT >> error for just-prepared "BEGIN IMMEDIATE" state

[sqlite] SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE

Relatively rarely, while starting a transaction on a concurrently modified SQLite database in WAL mode, I get a SQLITE_BUSY_SNAPSHOT error for just-prepared "BEGIN IMMEDIATE" statement. When I look at the list of statements with sqlite3_stmt_next, I cannot find any busy statement. Is it possible

[sqlite] Potential bug: Database on gvfs mount cannot be committed to

* Roger Binns: > On 09/06/2015 11:13 AM, Florian Weimer wrote: >> Surely that's not true, and NFS and SMB are fine as long as there >> is no concurrent access? > > And no program crashes, no network glitches, no optimisation in the > protocols to deal with laten

[sqlite] Potential bug: Database on gvfs mount cannot be committed to

* Roger Binns: > On 09/06/2015 06:16 AM, Markus Weiland wrote: >> I've discovered a potential bug in handling of SQLite database >> files on gvfs mounted network shares. > > SQLite doesn't support being stored on the network for several > reasons, including that network file protocols don't

[sqlite] Crippling query plan change between 3.7.13 and 3.8.10.2

The Debian security tracker uses an SQLite database to keep track of vulnerabilites and generate reports. We recently upgraded SQLite from 3.7.13 to 3.8.7.1 as part of an operating system upgrade and experienced a crippling query planner change. I verified

[sqlite] Is a transaction in progress?

On 05/11/2015 09:11 AM, Florian Weimer wrote: > Is there a way to discover if a transaction is in progress for a given > database handle, without committing or aborting the transaction? Found it?it's sqlite3_get_autocommit. The name is not really obvious, though. -- Florian Weimer / R

[sqlite] Is a transaction in progress?

Is there a way to discover if a transaction is in progress for a given database handle, without committing or aborting the transaction? -- Florian Weimer / Red Hat Product Security

[sqlite] Thoughts on storing arrays of complex numbers

* Steven M. McNeese: > I would serialize to JSON and store as a string. You need to be careful about the choice of JSON library, many of them lose information when converting doubles to JSON.

[sqlite] Why is empty string not equal to empty blob?

* Paul: > Maybe this question was already asked and explained. > Or maybe it is documented somewhere (could not fiund it). > Sorry, if this is the case, but why does > > SELECT '' = x''; > > yields 0? In SQLite, string literals have manifest type string. This is different from SQL, where string

Re: [sqlite] Database corruption issue

* Grzegorz Sikorski: > We do fsck on the startup. Occasionally, there are some errors, so we > decided to do 'fsck -p' to fix them before mounting the > filesystem. Here is how we then mount the actual filesystem: > /dev/mmcblk0p2 on /media/DATA type ext4 >

Re: [sqlite] Goodram C50 SSD slow in SQlite benchmark

* piotr maliński: > The usb3 case has asmedia chip and phoronix sqlite insert benchmark runs > around 6 times faster than when running via sata. Some benchmarks like > untaring, some iozone benchmarks do not differ so I'm suspecting controller > or OS issue. Does sqlite insert uses some specific

Re: [sqlite] Is is possible to optimize this query on a very large datatbase table?

* Frank Chang: > This table could potentially hold 10 to 40 million rows. We are > using the following query to obtain the minumum rowid for each > unique LastName: > > sqlite> explain query plan select t1.FieldName,t1.rowid from BlobLastNameTest > t1 > GROUP BY t1.FIELDNAME HAVING t1.rowid =

Re: [sqlite] [sqlite-dev] Is there an option to not lock during transaction?

* Pavel Ivanov: > To answer your original question: if you disable shared cache, start > reading transaction on one connection and start writing transaction on > the other connection then you'll be able to read on the first > connection database in the state it was before writing transaction. >

Re: [sqlite] JOIN bug in 3.7.2, not in 3.6.22

* Richard Hipp: > I don't think it makes sense in SQL (not just SQLite but SQL in > general) for an aggregate query to return columns that are not in > the GROUP BY clause. Isn't this just what PostgreSQL implements as DISTINCT ON? Then it *is* useful.

[sqlite] IS [NOT] DISTINCT FROM

In standard SQL, you cannot write expr1 IS expr2 (Only "expr1 IS NULL" is permitted.) You have to write: expr1 IS NOT DISTINCT FROM expr2 Are there any plans to add the second syntax to SQLite? This version also supports comparing multiple values at once, as in: (expr1, expr2) IS NOT

Re: [sqlite] VACUUM can actually increase the DB file?

* Oliver Schneider: > just a few minutes ago I ran a VACUUM on a DB file and the size before > was 2089610240 and afterwards 2135066624. Is this normal? This is just typical behavior with B-trees because the fill factor almost always changes when they are rebuilt. It seems that SQLite doesn't

Re: [sqlite] Database corruption on Linux ext3

* D. Richard Hipp: > An appliance manufacturer has discovered a database corruption issue > on Linux using ext3. The issue is documented here: > > http://www.sqlite.org/draft/lockingv3.html#ext3-barrier-problem It's a generic Linux problem, not an ext3-specific issue. Until recently,

Re: [sqlite] WAL in SQLite

* Richard Hipp: > Good to know. Would moving to shm_open() help? I think it's difficult to clean up the shared memory segments when a database which had opened the database crashes. And access control would be very hard to get right, too. ___

Re: [sqlite] Proposed: drop support for LinuxThreads

* D. Richard Hipp: > If we drop support for (the non-standard, non-compliant) LinuxThreads > threading library and instead support only standard Posix threads > implemented using NPTL, beginning with SQLite release 3.7.0, what > disruptions might this cause? There are several variants of

Re: [sqlite] Proposed new sqlite3_open_v3() interface

* D. Richard Hipp: > Question 2: Are there other foibles that we could correct using > sqlite3_open_v3? You could default the page size to the file system block size (if it can be determined). ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

* sub sk: > Somehow no one seems to have mentioned it on this mailing list so far!? > Here is the scoop... > > On March 23, Oracle announced the latest release of Oracle® Berkeley > DB - 11g Release 2 - which introduces a new SQL API, based on lo and > behold, SQLite v3 API. What this means is

Re: [sqlite] ANN: SQLite 3.6.16.C#

* Noah Hart: > I am pleased to announce that the C# port is done to the point where others > can look at it. Congratulations! (Is there something similar for Java, not using JNI nor NestedVM? 8-) ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Advice on which to use (SQLite or SQL Server) for the following app.

* Robel Girma: > Example, 5000 users connect to our server every 10 seconds and each > time they connect, I need to update a table with their IP and > Last_connect_time. That's 500 commits per second, right? If you need durability, you can get these numbers only with special hardware. SQL

Re: [sqlite] Join performance in SQLite

* D. Richard Hipp: > One of the criticisms of SQLite is that it is slow to do joins. That > is true if SQLite is unable to figure out how to use an index to speed > the join. I was under the impression that SQLite actually did a > fairly reasonable job of making use of indices, if they

Re: [sqlite] sqlite3_create_collation_v2 and SQLITE_UTF16_ALIGNED

* D. Richard Hipp: > On May 3, 2009, at 11:15 AM, Florian Weimer wrote: > >> The documentation suggests that I can pass SQLITE_UTF16_ALIGNED. >> However, the logic in main.c:createCollation() assumes that >> SQLITE_UTF16_ALIGNED is ORed with another encoding flag value >

[sqlite] sqlite3_create_collation_v2 and SQLITE_UTF16_ALIGNED

The documentation suggests that I can pass SQLITE_UTF16_ALIGNED. However, the logic in main.c:createCollation() assumes that SQLITE_UTF16_ALIGNED is ORed with another encoding flag value (presumably SQLITE_UTF16). If I specify SQLITE_UTF16_ALIGNED alone, I end up with a crash due to a double free

Re: [sqlite] Strict affinity again

* D. Richard Hipp: > SQLite is strongly typed, Curiously, it's even more strongly typed than SQL: sqlite> SELECT 1 = '1'; 0 fw=> SELECT 1 = '1'; ?column? -- t (1 row) (In SQL, quoted values are not of string type, but their type is inferred from context.)

[sqlite] FAQ on threading outdated

It seems to me that the FAQ entry on threading is outdated and should point to instead. Due to locking issues in concurrent, garbage-collected languages, last-resort finalization of statement and database objects has to happen in a separate finalization thread.

Re: [sqlite] General index information

* Igor Tandetnik: > L B wrote: >> The explanation you made is only valid for sqlite or >> for SQL in general? > > For SQL in general. True, but there are some database engines that support skip-index scans, so if there are only few different values of X, say x_1, ...

Re: [sqlite] Destruction callback for sqlite3_aggregate_context

* Florian Weimer: >> On Nov 19, 2008, at 9:59 PM, Florian Weimer wrote: >> >>> In order to avoid a resource leak, I think I need some sort of >>> callback when the memory allocated by sqlite3_aggregate_context is >>> freed by SQLite. >>&g

Re: [sqlite] Destruction callback for sqlite3_aggregate_context

* Dan: > On Nov 19, 2008, at 9:59 PM, Florian Weimer wrote: > >> In order to avoid a resource leak, I think I need some sort of >> callback when the memory allocated by sqlite3_aggregate_context is >> freed by SQLite. >> >> As far as I can see, it is not

[sqlite] Destruction callback for sqlite3_aggregate_context

In order to avoid a resource leak, I think I need some sort of callback when the memory allocated by sqlite3_aggregate_context is freed by SQLite. As far as I can see, it is not guaranteed that the xFinal function specified in sqlite3_create_function will be called in all cases, so this is not

[sqlite] Signaling errors from collation functions

I'm working on something which is supposed to be a foolproof interface to SQLite. During that, I discovered that SQLite lacks a way to return errors from a user-defined collation function. Is there something I've missed? Right now, I call sqlite3_interrupt() to signal at least something (after

Re: [sqlite] cidr data type

* Jay A. Kreibich: > Yeah, I screwed that up. I was too caught up on the other error. > > In the original function (-1 << network_size) returns the wrong bit > mask. For example, 10.0.0.0/8 should return a netmask of 255.0.0.0, > or 0xFF00. The original function will return

Re: [sqlite] cidr data type

* Jay A. Kreibich: >> Is this Java or C? For C, this breaks if network_size == 32. > > It breaks for everything except network_size == 16. I was alluding to the fact that a popular architecture implements modulo-32 shifts for 32-bit integers (and modulo-64 shifts for 64-bit integers), for

Re: [sqlite] cidr data type

* Dennis Cote: > This last function can be implemented using bit manipulation operators > in SQL or in a custom function in C. > > containedIn(ip_addr, network_addr, network_size) > > can be replaced by > > nework_addr == (ip_addr & (-1 << network_size)) > > which will be true if the IP

Re: [sqlite] What is the standard way to store dates and do operations with dates please?

* Dennis Cote: > From the wikipedia article you cited: > > Note: although many references say that the Julian in "Julian day" > refers to Scaliger's father, Julius Scaliger, in the introduction to > Book V of his Opus de Emendatione Temporum ("Work on the Emendation of > Time") he states,

Re: [sqlite] Most widely deployed?

* Aristotle Pagaltzis: > * Shawn Wilsher <[EMAIL PROTECTED]> [2008-02-21 20:00]: >> > Every copy of Firefox 3 contains a copy of SQLite. >> And Firefox 2 ;) > > Really? What is it used for? It's used to store data used by the client-side URL classifier ("phishing filter").

Re: [sqlite] Checking that a row exists?

* Gilles Ganault: > Is this the standard way to check that a row exists in PHP/SQLite, or > is there a better syntax? > $query = "SELECT count(*) FROM contacts WHERE contacts_phones_tel GLOB '%s*'; This query stops after the first match: SELECT 1 FROM contacts WHERE contacts_phones_tel GLOB

Re: [sqlite] VFS memory leak : During lock / unlock operations

* Dennis Cote: > The OP said they were measuring an excess of lock calls. That would > imply that SQLite is locking files it has already locked. Is that > possible with the POSIX APIs? SQLite uses fcntl-based locks, which keep a separate lock for each byte in a file (or, more precisely, any

Re: [sqlite] Proposed change to sqlite3_trace()

> Legacy applications should continue to work. You might get a > compiler warning about a type mismatch on the 2nd parameter to > sqlite3_trace(). But calling a 2-parameter function with 3 > parameters is suppose to be harmless in C. It's not allowed by the standard, so it will almost

Re: [sqlite] Proposed sqlite3_initialize() interface

> This is still just an idea. If you think that adding a new > required sqlite3_initialize() interface would cause serious > hardship for your use of SQLite, please speak up now. It requires changing and recompiling all applications linking to it. This is a bit annoying for distributions.

Re: [sqlite] Race condition -- fixed?

> This is true of SQLite because isolation in SQLite > is "SERIALIZABLE". This is the highest level of isolate > provided by SQL. Most client/server database engines > by default implement "READ COMMITTED". The value of > "balance" might change between the SELECT and the > UPDATE in MySQL, for

Re: [sqlite] sqlite testing with Boundschecker

> So apparently boundschecker is upset because SQLite is merely making > a copy pointer to previously freed memory. There really is no harm > in this. Nothing bad can happen unless the program actually tries > to dereference the pointer - which it never does. I don't think GCC makes this

Re: [sqlite] What's this?

* Ion Silvestru: > This is a message I received: Your mailserver rejected a message, probably with good reason: > <[EMAIL PROTECTED]>: > 217.26.144.4 failed after I sent the message. > Remote host said: 550 This message contains a virus (HTML.Phishing.Pay-131) ezmlm, the mailing list

Re: [sqlite] SQLite - how to protect the data

* mxs: > If anybody knows hot to ensure that the data is not readable without the > front end I would appreciate it. You need to turn your application into some kind of web-based service which is actively monitored for misuse. Anybody who's got a copy of the application can reverse-engineer

Re: [sqlite] Abuse of the SQLite website

* Terry Jones: > Given 50K attempts in 5 hours, this is either a bug somewhere or it's > automated, likely the latter. I've seen broken proxies which acted as accidental traffic amplifiers. It's not necessarily a deliberate attack.

Re: [sqlite] Fix for sqlite3.h in version 3.3.10

> Having SQLITE_TRANSIENT point to a real function is perhaps a > good idea. The problem is such a change would break backwards > compatibility of the API. Somebody who compiled against an > older SQLite and who drops in a newer DLL with this change will > find that their code no longer works.

Re: [sqlite] Sqlite design question

* Ken: > Would the reader be blocked by the writer? Yes. > Would the writer be blocked by the reader? Yes. However, depending on the size of the transactions this may not be an issue. > I guess I'm unclear what I can/cant do using sqlite and how to gain > as much performance as possible.

Re: [sqlite] sqlite web site performance

* w. wg: > The following is from ibm developerworks site: > > Its creator conservatively estimates that it can handle a Web site > with a load of up to 100,00 hits a day, and there have been cases > where SQLite has handled a load 10 times that. > > origin link: >

Re: [sqlite] sqlite web site performance

* w. wg: > The documents on sqlite official site says that sqlite can works fine > if a site's traciffic is under 10 click per day. But I found a > lot of sites ( including IBM developer network) say the number is only > 1 per day. Your are probably confusing the number of hits and

Re: [sqlite] 2PC / two-phase commit?

> SQLite uses a 2-phase commit internally when it is > making changes to two or more ATTACHed database files. Are there any plans to expose this at the API level? This could be useful for implementing reliable data exchange with other database systems.

Re: [sqlite] SQLite and McAfee Anti-Virus

> After sending my email I realized the blame is partly with > me because SQLite is putting is own name on TEMP files. > I changed this so that the prefix is now "etilqs_" instead > of "sqlite_". That should help head off future troubles. I think this is worse. Veritas does something similar

Re: [sqlite] database corrouption during power failure

* jayanth KP: >Please can anybody respond to this question. I am able to hits is >issue pretty often now... You should check that your operating system and hardware actually flush buffers when told to do so. Here's a test you can run:

Re: [sqlite] Avoiding Fragmentation of SQLite database file ???

* A. Pagaltzis: >> On Windows, perhaps. On most UNIX systems, this is very hard >> to do and often not supported at all by the file system. > > Then again, Unix filesystems tend to be designed such > that as long as there is sufficient free space on the > device, fragmentation will remain

Re: [sqlite] Avoiding Fragmentation of SQLite database file ???

* Jay Sprenkle: > On 6/14/06, RohitPatel <[EMAIL PROTECTED]> wrote: >> >> Any solution to that (which does not force end-user of app to manage sqlite >> file fragments or to defragment disk) ? > > A scheduled task or cron job is trivial to implement and does not > add any extra work for the

Re: [sqlite] Multithreading. Again.

> Remember, that the operating system bug that is causing all the > multithreading grief is that file locks created by one thread > cannot be reliably removed or modified by a different thread. > So if a statement acquires a lock on the database file in one > thread and you try to finalize the

Re: [sqlite] Multithreading. Again.

> As long as no prepared statements are outstanding, you should > be safe moving sqlite database connections across threads, as > of version 3.3.1. The rules are not really quite that strict, > but the exact rules are more complex and this strict rule > gives you an extra margin of safety. Is it

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

* Clay Dowling: > [EMAIL PROTECTED] at least does have an auto-responder. The message > contains the text of any message sent to it, appended to the bottom of > the email. That would serve to automatically validate the check > email. In my experience, the real problem with ezmlm's subscription

Re: [sqlite] Issue with sqlite3_result_error inside aggregatefunction

* Nathan Kurz: > On Wed, Nov 16, 2005 at 01:16:40PM +0100, Florian Weimer wrote: >> * D. Richard Hipp: >> >> > If an error occurs in a step function, record that fact in >> > the aggregate context. Then when the finalizer is called, >> > ch

Re: [sqlite] Issue with sqlite3_result_error inside aggregatefunction

* D. Richard Hipp: > If an error occurs in a step function, record that fact in > the aggregate context. Then when the finalizer is called, > check the error flag in the context and call sqlite3_result_error > at that point if it is appropriate to do so. Does this really work? According to my

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

> Please let me restate the proposed change: I desire to change > SQLite so that it no longer distinguishes between integer and > real. Put this way, this seems to be a good idea, provided that there isn't a performance penalty. Most of the numbers I store in SQLite databases are small

Re: [sqlite] Re: OCaml binding for SQLite 3

* Toby Allsopp: > On 30 Oct 2005 at 03:14 NZST, Florian Weimer wrote: > >> Is it true that there isn't yet a binding to SQLite versoin 3 from >> Objective Caml? >> >> (I only found one for version 2.) > > There seem to be a couple of different oca

[sqlite] OCaml binding for SQLite 3

Is it true that there isn't yet a binding to SQLite versoin 3 from Objective Caml? (I only found one for version 2.)

Re: [sqlite] Optimal page size

* Chris Schirlinger: > 4096 in Win32 machines and 1024 on nix ones (I think, I am no expert > on Unix style OS's) This depends on the file system. On Linux on x86, it's typically 4096 bytes. According to my performance measurements, switching from page size of 1024 bytes to 4096 bytes gives a

Re: [sqlite] Convert SQLite to Java

* Randy Ray: > Java libraries linked with C (via JNI) generally have to run with the exact > same version of Java they were built with. Uh-oh, Sun advertises something else. I can understand that you must exactly match JVM versions for certified configurations, but this isn't true even if you

Re: [sqlite] Share an sqlite3 struct between multiple threads

* Christian Smith: > IMHO, SQLite should, however, only open a single file per database (based > on inode) which should allow threads to override each others locks as the > locks will be on a single file. I think you need multiple file descriptors, otherwise you'd have to use pread for accessing

Re: [sqlite] Re: philosophy behind public domain?

* D. Richard Hipp: > This would be a problem for any citizen of Germany or Austria > that wanted to contribute code to the SQLite project. I cannot > see that this would ever be a problem for an SQLite users. Yes, of course. > Can citizens of Germany and Austria assign their copyright interest