Re: [sqlite] Does sqlite has db file-size restriction on Solaris 10?

2013-11-25 Thread Pepijn Van Eeckhoudt
On 2013-11-23 02:03, Liang Kunming wrote: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: tasks) at org.sqlite.DB.newSQLException(DB.java:383) at org.sqlite.DB.newSQLException(DB.java:387) at org.sqlite.DB.throwex(DB.java:374)

Re: [sqlite] Does sqlite has db file-size restriction on Solaris 10?

2013-11-25 Thread Liang Kunming
Hi, Pepijn, Thanks. Please help me to do some testing and check whether the 2GB restrict issue be solved if use new driver. Regards, Liang Kunming. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pepijn Van Eeckhoudt

Re: [sqlite] System.Data.SQLite version 1.0.89.0 released

2013-11-25 Thread Jan Slodicka
Hi Joe, I have couple of small perf tips. 1) SQLite3.GetValue(SqliteStatement stmt, int index, SQLiteType typ) Starts with this code: if (IsNull(stmt, index)) return DBNull.Value; In my opinion the call into native code (IsNull) is unnecessary in case typ.Affinity is known - which happens a

Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

2013-11-25 Thread Luuk
On 24-11-2013 19:36, Petite Abeille wrote: On Nov 24, 2013, at 7:10 PM, Valentin Davydov wrote: Wait a second... and you'll get different value of datetime('now'). In this sense datetime() is as deterministic as random(): it may give the same result next invocation or may not, dependng on var

Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

2013-11-25 Thread Simon Slavin
On 25 Nov 2013, at 11:58am, Luuk wrote: > On 24-11-2013 19:36, Petite Abeille wrote: >> >> On Nov 24, 2013, at 7:10 PM, Valentin Davydov wrote: >> >>> Wait a second... and you'll get different value of datetime('now'). In this >>> sense datetime() is as deterministic as random(): it may give

[sqlite] sqlite3_last_insert_rowid() and AUTOINCREMENT

2013-11-25 Thread L. Wood
I have my own whateverId column of type INTEGER PRIMARY KEY AUTOINCREMENT. Does AUTOINCREMENT change anything? * Is whateverId still just an alias for the built-in rowid (as it would be without the AUTOINCREMENT)? * Does sqlite3_last_insert_rowid() return the whateverId of the last INSERTed ro

[sqlite] Doc typo

2013-11-25 Thread Sunanda
Is this the right place to report typos in the documentation? Please forward if not. malloc.html Dynamic Memory Allocation In SQLite > The failure point continues to advice one allocation at a time until the entire test procedure runs to completion without hitting a memory allocation error.

Re: [sqlite] sqlite3_last_insert_rowid() and AUTOINCREMENT

2013-11-25 Thread Stephan Beal
On Mon, Nov 25, 2013 at 2:18 PM, L. Wood wrote: > I have my own whateverId column of type INTEGER PRIMARY KEY AUTOINCREMENT. > > Does AUTOINCREMENT change anything? > > * Is whateverId still just an alias for the built-in rowid (as it would be > without the AUTOINCREMENT)? > > * Does sqlite3_last

Re: [sqlite] Doc typo

2013-11-25 Thread Richard Hipp
On Sun, Nov 24, 2013 at 10:00 PM, Sunanda wrote: > Is this the right place to report typos in the documentation? Please > forward if not. > > malloc.html > Dynamic Memory Allocation In SQLite > > > The failure point continues to advice one allocation at a time until the > entire test procedure ru

Re: [sqlite] sqlite3_last_insert_rowid() and AUTOINCREMENT

2013-11-25 Thread Igor Tandetnik
On 11/25/2013 8:18 AM, L. Wood wrote: I have my own whateverId column of type INTEGER PRIMARY KEY AUTOINCREMENT. Does AUTOINCREMENT change anything? Yes. http://www.sqlite.org/autoinc.html * Is whateverId still just an alias for the built-in rowid (as it would be without the AUTOINCREMENT)?

Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

2013-11-25 Thread Nico Williams
If a function is deterministic for then it can be executed once and its result can be memoized for the rest of the statement (or transaction even). If a function is idempotent for a statement then it can be executed once per-statement, and its result(s) can be memoized and reused for the life of t

Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

2013-11-25 Thread Luuk
On 25-11-2013 13:41, Simon Slavin wrote: I'm wondering whether there's an argument that it should be evaluated just once for a transaction. I'm still thinking about this question, i can think of some benefits if its evaluated just once per transaction. but i hope anyone has some examples why

[sqlite] ETA on version 4

2013-11-25 Thread Stephen Chrzanowski
I realize that it is still a Work In Progress, and I realize I can download the code and compile for my code. But I'm kind of curious as to what the remaining life span of version 3 is looking to be. When do you think (In resolution of months and/or years) it will be out? UNKNOWN is acceptable to

Re: [sqlite] ETA on version 4

2013-11-25 Thread Sascha Sertel
According to this http://sqlite.org/src4/doc/trunk/www/design.wiki SQLite 3 and 4 will be maintained in parallel, since version 4 brings some fundamental changes that users might not want and/or agree with and therefore prefer to stick with version 3. I think that falls into the UNKNOWN category,

Re: [sqlite] ETA on version 4

2013-11-25 Thread Simon Slavin
On 25 Nov 2013, at 8:20pm, Stephen Chrzanowski wrote: > I realize that it is still a Work In Progress, and I realize I can download > the code and compile for my code. But I'm kind of curious as to what the > remaining life span of version 3 is looking to be. > > When do you think (In resoluti

Re: [sqlite] ETA on version 4

2013-11-25 Thread Richard Hipp
On Mon, Nov 25, 2013 at 3:20 PM, Stephen Chrzanowski wrote: > I realize that it is still a Work In Progress, and I realize I can download > the code and compile for my code. But I'm kind of curious as to what the > remaining life span of version 3 is looking to be. > SQLite3 is permanent and wil

Re: [sqlite] ETA on version 4

2013-11-25 Thread Stephen Chrzanowski
Thanks all. I'll keep on chugging with 3 then. :] Richard, "Forever" is a long time. Did you ever say that for version 2? ;) On Mon, Nov 25, 2013 at 3:27 PM, Richard Hipp wrote: > On Mon, Nov 25, 2013 at 3:20 PM, Stephen Chrzanowski >wrote: > > > I realize that it is still a Work In Progres

Re: [sqlite] ETA on version 4

2013-11-25 Thread Richard Hipp
On Mon, Nov 25, 2013 at 3:44 PM, Stephen Chrzanowski wrote: > > Richard, "Forever" is a long time. Did you ever say that for version 2? ;) > Not that I recall. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org ht

Re: [sqlite] System.Data.SQLite version 1.0.89.0 released

2013-11-25 Thread Joe Mistachkin
Jan Slodicka wrote: > > I have couple of small perf tips. > > 1) SQLite3.GetValue(SqliteStatement stmt, int index, SQLiteType typ) > > Starts with this code: > if (IsNull(stmt, index)) return DBNull.Value; > I've adjusted the method to take advantage of the known affinity, here: h

Re: [sqlite] Does sqlite has db file-size restriction on Solaris 10?

2013-11-25 Thread Liang Kunming
Hi, Pepijn, After confirm and compare the content, the jdbc driver which we are using to access sqlite is from Xerial fork (https://bitbucket.org/xerial/sqlite-jdbc): sqlite-jdbc-3.7.2.jar. Do you have any other suggest