Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account
List archives

SQLite developers Recent threads

Threads Replies First post Last post
What contract across machine upgrade?
By: Jonathan S. Shapiro
Scenario: an older machine is upgraded, with the result that the underlying disk sector size changes. Existing data, including some SQLite data, is backed up on the old machine and restored on the new machine. Are any SQLite atomicity guarantees…
2 May 24 2012
13:46
May 24 2012
14:45
Disk behavior during power loss revisited
By: Jonathan S. Shapiro
I'm Jonathan Shapiro, new to this list, but perhaps known to some of you for work on microkernels and systemwide persistence (EROS, Coyotos). I read with caution the discussion about Atomic Sector Writes. I've asked a colleague at WD to report…
1 May 24 2012
13:37
May 24 2012
14:34
Response from WD concerning sector-level atomicity
By: Jonathan S. Shapiro
According to WD: The answer there is the drives that are “green” or “eco” don’t write their cache on loss of power. Most consumer drives are like that to reduce power use. Write is not atomic on green drives. Who knows what they are doing…
0 May 24 2012
14:20
May 24 2012
14:20
Windows 8 support
By: E. Timothy Uy
Hi, I was wondering if there has been any update on Windows 8 WinRT support. Thank you! Respectfully, Tim
5 May 21 2012
09:04
May 21 2012
09:17
SQLite 3.7.12: Test failure
By: Arfrever Frehtes Taifersar Arahesis
1 test fails in SQLite 3.7.12. Test suite was run in /var/tmp/portage/dev-db/sqlite-3.7.12/work/sqlite-src-3071200 directory. A path in output is truncated. ... shell1-3.2.1... Ok shell1-3.2.2... Ok shell1-3.2.3... Ok shell1-3.2.4... Ok…
2 May 20 2012
13:08
May 20 2012
14:47
3.7.12: segmentation fault in sqlite3ExprCodeTarget() when called from gnome-shell-3.4.1
By: Alexandre Rostovtsev
(As reported at https://bugs.gentoo.org/show_bug.cgi?id=416563; the gentoo sqlite package maintainer suggested that I report the problem directly to this mailing list.) After updating to sqlite-3.7.12, I have been getting crashes in…
1 May 20 2012
13:47
May 20 2012
13:49
Bad performance with foreign key contraint
By: Domingo Alvarez Duarte
Attached is a simple program that demostrates a performance issue with sqlite3 with foreign key enabled. It creates a simple table with a foreign key to itself: create table if not exists test( id integer primary key, parent_id integer references…
6 May 13 2012
16:46
May 14 2012
03:12
Unresolved Viruals...
By: Don Sharp Jr.
Hi ya fokes! I have been struggling with sqlite3 for days now... My Environment... trying to use sqlite3 version 3.7.11 and lcc-win32 version 4.0 under Windows 7 SP1... First I got the unresolved virtuals for any sqlite3 reference, due to the…
0 May 13 2012
11:15
May 13 2012
11:15
Listing functions
By: Roger Binns
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'd like to make the case for the 3.7.13 to include a way of getting the function list. Long time ticket: http://www.sqlite.org/src/tktview?name=5896edbe46 There is no way to get the list of…
0 May 13 2012
09:14
May 13 2012
09:14
3.7.12 release ETA
By: Roger Binns
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 What is the ETA on 3.7.12? I'm not looking for something exact but some sort of guidance on whether it is hours, days, weeks or months away. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11…
1 May 11 2012
15:27
May 11 2012
15:33
Bug in union with group by
By: Domingo Alvarez Duarte
Hello ! I found a bug in sqlite that can be seem with this small sql code: begin; create table orders(order_date date, order_type_id integer); insert into orders values("2011-04-01", 1); insert into orders values("2011-04-01", 1); insert into…
0 May 9 2012
16:26
May 9 2012
16:26
Explain what 'transaction' means in javascript for sqlite, please?
By: Andrew Lewis
Hi! Can someone help me over a hump here please? I am trying to fire up SQLite in javascript for mobiles and whilst there are plenty of sites which contain the functions for creating a footballer list on the screen, some of which seem to work, none…
7 May 9 2012
09:03
May 9 2012
10:08
I would like to help with the Linq Provider
By: Brannon King
The feature request for EF4 support here http://system.data.sqlite.org/index.html/tktview?name=c8083867b9 notes that the present implementation of SQLiteProviderServices does not implement all the necessary overrides. Namely, it's missing…
3 May 3 2012
15:57
May 7 2012
16:38
Re: Unicode transliteration
By: Roger Binns
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 04/05/12 05:06, Richard Hipp wrote: >> Note, however, than my limited Latin/Greek/Cyrillic/Hebrew >> transliterater uses only about 1K of table space, The table space is read only and…
2 May 4 2012
09:21
May 5 2012
19:42
Re: Unicode transliteration
By: Roger Binns
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 04/05/12 04:06, Petite Abeille wrote: > Out of curiosity, in what context would something like Unidecode! fit > in SQLite? If you read this group then you really should be following the…
0 May 4 2012
09:39
May 4 2012
09:39
Not a fan of mail-lists
By: john s wolter
I'm not a fan of mail-lists as I need to browse old list discussions and have access anywhere. Web mail reviews require I keep all of the sqlite-dev on my Web EMail service. Imagine all the people who participate and you can see that is a fair…
0 Apr 26 2012
15:13
Apr 26 2012
15:13
Type mismatch variable in a function output_hex_blob() in src/shell.c
By: Pavel Volkov
Hello. Valentin Davydov discovered the error output blob object in a shell sqlite3. He offered a solution. Thank you, Valentin. Please consider the problem and its solution. Initial discussions focused on the following link:…
3 Dec 22 2011
08:58
Apr 24 2012
07:03
Since 3.7.10 I'm getting an error on Android with ndk r6b dosent work r7{a, b, c}
By: Domingo Alvarez Duarte
I have an application that works on wince, win32, linux, android, I have not getting a strange problem that happens only on android (although it's like linux). The problem arises when I only use sqlite3_finalize to terminate sqlite3_stmt, today I…
7 Apr 22 2012
12:16
Apr 23 2012
05:56
SQLite version 3.7.12 release testing
By: Richard Hipp
SQLite version 3.7.12 is entering final release testing. If you have any issues with the current code, please raise them as soon as possible. The testing status can be seen on the http://www.sqlite.org/checklists/3071200page. As soon as all…
2 Apr 19 2012
10:38
Apr 19 2012
11:57
minor build bug / undefined UNUSED_PARAMETER / make test / ext/fts3/fts3_test.c / SQLITE_ENABLE_FTS3
By: Benjamin Lee
Dear all, Yesterday, I attempted fossil clone http://www.sqlite.org/src private-project.fossil fossil open private-project.fossil # configure defaults / build and host = i686-pc-linux-gnu ./configure && make clean all test but,…
2 Apr 3 2012
11:45
Apr 4 2012
00:20