I've been tearing my hair out over this for a little while, but I feel like
there must be something simple I'm missing. Based on the behavior I'm seeing,
the EXCLUSIVE locking mode isn't working the way I'd expect it to work based on
the docs at http://www.sqlite.org/pragma.html#pragma_locking_m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/28/2011 07:39 PM, Simon Slavin wrote:
> Actually I don't see how BLOBs can be used in an index anyway, since
> technically blobs have no ordering.
memcmp provides an ordering just as it can for strings without a collation.
(That is what SQLite
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/28/2011 03:05 PM, Dale Arntson wrote:
> I installed python 2.7.1 for AIX 6.1 (64 bit), but it appears to be
> missing the _sqlite3.so library, even though this is a standard library
> that comes with the current python release on all other plat
On 29 Jul 2011, at 3:34am, Roger Binns wrote:
> On 07/28/2011 06:57 PM, Simon Slavin wrote:
>> Would it improve the SQLite time if it was changed to strings instead of
>> BLOBs ?
>
> Note that internally SQLite treats strings and blobs virtually identically.
> Usually the same data structure an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/28/2011 06:57 PM, Simon Slavin wrote:
> Would it improve the SQLite time if it was changed to strings instead of
> BLOBs ?
Note that internally SQLite treats strings and blobs virtually identically.
Usually the same data structure and function
On 29 Jul 2011, at 2:51am, Afriza N. Arief wrote:
> Actually as per their blog-post (
> http://google-opensource.blogspot.com/2011/07/leveldb-fast-persistent-key-value-store.html
> ) .
> They probably want to simulate "an ordered mapping from string keys to
> string values" and to test "batch upd
On Fri, Jul 29, 2011 at 8:53 AM, Richard Hipp wrote:
> On Thu, Jul 28, 2011 at 12:27 AM, wrote:
>
> > they used
> >
> > CREATE TABLE test (key blob, value blob, PRIMARY KEY(key))
> > CREATE INDEX keyindex ON test (key)
> >
>
> Notice the inefficiencies inherent in this schema.
>
> (1) A primary
There are the LevelDB sources and tests
svn checkout http://leveldb.googlecode.com/svn/trunk/ leveldb-read-only
Build SQLite test as
make db_bench_sqlite3
And LevelDB test as
make db_bench
My patch for leveldb-read-only/doc/bench/db_bench_sqlite3.cc to disable
redudant index and enable WAL is her
On Thu, Jul 28, 2011 at 1:08 PM, Jay A. Kreibich wrote:
> On Thu, Jul 28, 2011 at 12:57:45PM -0700, km4hr scratched on the wall:
>>
>> Is there a way to edit SQL commands typed in on the command line?
>
> Only if the "sqlite3" tool is compiled with a copy of the readline
> library. In that case
On Thu, Jul 28, 2011 at 12:27 AM, wrote:
> they used
>
> CREATE TABLE test (key blob, value blob, PRIMARY KEY(key))
> CREATE INDEX keyindex ON test (key)
>
Notice the inefficiencies inherent in this schema.
(1) A primary key on a BLOB? Really?
(2) They create an redundant index on the primary
Hm, I test I find index on PK field:
CREATE TABLE test (key blob, value blob, PRIMARY KEY(key))
CREATE INDEX keyindex ON test (key)
Epic fail, I think :D
Default test on Intel(R) Atom(TM) CPU N450 @ 1.66GHz
fillseq : 442.937 micros/op;0.2 MB/s
fillseqsync :1678.168 micros/op
LevelDB use append log but SQLite is tested without WAL :)
I check and some tests 2.5x faster with WAL.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailma
I installed python 2.7.1 for AIX 6.1 (64 bit), but it appears to be
missing the _sqlite3.so library, even though this is a standard library
that comes with the current python release on all other platforms. Does
anyone know of the existence of a sqlite3 shared library for AIX 6.1 (64
bit) or ea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/28/2011 09:21 AM, Clifford Hung wrote:
> For statements, sqlite3_next_stmt() can be called to return a pointer to the
> first prepared statement associated with a database connection
In my opinion that API is a huge mistake outside the context
If you configure and compile sqlite3 command line yourself and your
system have readline installed then yes.
Pavel
On Thu, Jul 28, 2011 at 4:08 PM, wrote:
> Is it possible to edit commands entered on the sqlite3 command line?
>
>
>
>
>
> ___
> sqlite
On Thu, Jul 28, 2011 at 12:57:45PM -0700, km4hr scratched on the wall:
>
> Is there a way to edit SQL commands typed in on the command line?
Only if the "sqlite3" tool is compiled with a copy of the readline
library. In that case, just hit up-arrow.
-j
--
Jay A. Kreibich < J A Y @ K
Is it possible to edit commands entered on the sqlite3 command line?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Is there a way to edit SQL commands typed in on the command line?
--
View this message in context:
http://old.nabble.com/Editing-sqlite3-commands-tp32158636p32158636.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users maili
hey all. i got my engine to compile so now im doing basic SQL syntax of load
the user, since its in a very early production stage the players table only has
4 values to load. Table: Players UserID varchar(30) /* their constant
userid */ Race smallint /* their race
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/28/2011 12:40 AM, Baruch Burstein wrote:
> On the same topic, I know the documentation says SQLITE_OMIT_* are not
> supported by the amalgamation, but I have used many of them to successfully
> reduce my object file. Is there any documentation on
Hello,
My situation is that I am setting up our testing project for unit tests using
NUnit.
The requirements are developers must be able to run the tests from within
visual studio and through the nunit exe, and also our continuous integration
server must be able to run the unit tests after a ch
The tclsqlite3.dll i do not know. But this days i've used the ActiveTcl
http://www.activestate.com/activetcl the instalation of him installs the
tcl85.dll I think it maybe can help you.
2011/7/27 Jerzy Witkowski
> Hello,
>
> I tried to upgrade my environment to latest Sqlite distribution
> 3.7.7.
On Thu, Jul 28, 2011 at 9:21 AM, Clifford Hung wrote:
> I would like to make a feature request for a function to return a handle to
> the first open blob handle. For statements, sqlite3_next_stmt() can be
> called to return a pointer to the first prepared statement associated with a
> database co
I would like to make a feature request for a function to return a handle to the
first open blob handle. For statements, sqlite3_next_stmt() can be called to
return a pointer to the first prepared statement associated with a database
connection but there doesn't appear to be such a function for r
On Thu, Jul 28, 2011 at 11:41 AM, Григорий Григоренко wrote:
> So, should we file this as a defect or bug somehow?
>
>
As I understand currently the issues acknowledged and fixed during the
e-mail conversation in this list ( read
http://www.sqlite.org/src/wiki?name=Bug+Reports ). So I'd rather ask
Hello,
I tried to upgrade my environment to latest Sqlite distribution
3.7.7.1. Usually I downloaded two files from Download page
http://www.sqlite.org/download.html section "Precompiled Binaries For
Windows": sqlite3.exe and tclsqlite3.dll. This time I was unable to
find tclsqlite3.dll file. P
So, should we file this as a defect or bug somehow?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thank you. I went back through my command history and saw I had accidentally
searched sqlite3.h instead of sqlite3.c Sorry to bother everyone.
On the same topic, I know the documentation says SQLITE_OMIT_* are not
supported by the amalgamation, but I have used many of them to successfully
reduce m
they used
CREATE TABLE test (key blob, value blob, PRIMARY KEY(key))
CREATE INDEX keyindex ON test (key)
on random replaces it doubles the write operations.
J Decker schrieb:
> On Wed, Jul 27, 2011 at 6:22 PM, Stephan Wehner
> wrote:
>> There are some benchmark's at
>> http://leveldb.google
29 matches
Mail list logo