Re: [sqlite] LevelDB benchmark

On Wed, Jul 27, 2011 at 7:00 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 28 Jul 2011, at 2:53am, Stephan Wehner wrote: > >> On Wed, Jul 27, 2011 at 6:44 PM, Simon Slavin <slav...@bigfraud.org> wrote: >>> >>> On 28 Jul 2011, at 2:22am,

Re: [sqlite] LevelDB benchmark

On Wed, Jul 27, 2011 at 6:44 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 28 Jul 2011, at 2:22am, Stephan Wehner wrote: > >> There are some benchmark's at >> http://leveldb.googlecode.com/svn/trunk/doc/benchmark.html >> >> I don't have anything

[sqlite] LevelDB benchmark

There are some benchmark's at http://leveldb.googlecode.com/svn/trunk/doc/benchmark.html I don't have anything to point to, but I thought sqlite3 does better than stated there. In particular, 26,900 sequential writes per second and 420 random writes per second from section "1. Baseline

Re: [sqlite] Hidding records from the application

phan > Thanks in advance. > long san > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -> http://stephan.sugarmotor.org (b

[sqlite] Pretty schema ?

Hello everybody, is there a way to get a pretty-print version of sqlite> .schema Would be nice. Stephan -- Stephan Wehner -> http://stephan.sugarmotor.org (blog and homepage) -> http://loggingit.com -> http://www.thrackle.org -> http://www.buckmaster.ca -> http://www.traff

Re: [sqlite] how to get a reliable Integer from a Real?

result for 2.3 expected behaviour (strange floating point arithmetic > reasons?) and is > > sqlite> SELECT CAST(2.3*1000 AS INTEGER)/10; > 230 > sqlite> > > a reliable way to get rid of my problem (even if the Real has 2 digits behind > the .)? >

Re: [sqlite] Speed up DELETE of a lot of records

On Fri, Oct 8, 2010 at 9:49 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 8 Oct 2010, at 5:48pm, Stephan Wehner wrote: > >> On Fri, Oct 8, 2010 at 7:14 AM, Michele Pradella >> <michele.prade...@selea.com> wrote: >>>  "science fiction?&q

Re: [sqlite] Speed up DELETE of a lot of records

t; Via Aldo Moro 69 > Italy - 46019 Cicognara (MN) > Tel +39 0375 889091 > Fax +39 0375 889080 > *michele.prade...@selea.com* <mailto:michele.prade...@selea.com> > *http://www.selea.com* > ___ > sqlite-users mailing list >

Re: [sqlite] Getting unique years from a timestamp column

gt; Any assistance on this would be appreciated.  Thanks! > > Bobby > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -&g

Re: [sqlite] Question concerning foreign keys across databases

>> all possible? >> >> >> Thanks, >> >> // Oliver >> >> PS: I'm using SQLite version 3.6.22 >> PPS: Tried to send it with PGP/MIME signature, but it didn't get through >> according to the list archive, so sending without signatu

Re: [sqlite] Encryption of sqlite DB

ng list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -> http://stephan.sugarmotor.org (blog and homepage) -> http://loggingit.com -> http://www.thrackle.org -> http://www.buckmaster.ca -> htt

Re: [sqlite] Computing day of week the using strftime() function - Feature or bug ?

the section Examples at http://www.sqlite.org/lang_datefunc.html Stephan > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -> ht

Re: [sqlite] Parsing create statements

es Family(ID) >         foreign table: Family >         foreign column: ID > > I'm writing in Objective-C, so anything accessible to it would be helpful. > > Thanks, > Tom > BareFeet > > ___ > sqlite-users mailing list &

Re: [sqlite] command line does not accept arrow keys

sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -> http://stephan.sugarmotor.org (blog and homepage) -> http://loggingit.com -> http://www.thrackle.org -> http://www.buckmaster.ca -> h

Re: [sqlite] is ticket 4037 not a bug?

ment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEARECAAYFAksCOYAACgkQmOOfHg372QSt6ACgjAAwTucstMRp950Ce4dFjxs5 > /hgAoNtrs/2oAPab4vjaZbi1ZNkCE56E > =9tn8 > -END PGP SIGNATURE- > ___ > sqlite-users mailing list > sql

Re: [sqlite] in-memory database concept

string."  --from Anathem by Neal Stephenson >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > ___ &

Re: [sqlite] in-memory database concept

tem. On SunOS it should be straightforward; that wiki page says "SunOS, and later Solaris, include probably the earliest implementations of tmpfs". Stephan > Thanks for the answer, > Serdar Genc > > On Wed, Nov 4, 2009 at 10:45 AM, Stephan Wehner > <stephanweh...@gmail.com>w

Re: [sqlite] in-memory database concept

> sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -> http://stephan.sugarmotor.org (blog and homepage) -> http://loggingit.com -> http://www.thrackle.org -> h

Re: [sqlite] sparse matrix in scientific computing with sqlite

___ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> >> >> >> -- >> Puneet Kishor http://www.punkis

Re: [sqlite] feature request - field exclusion list in select list

;complementary > projection" > operator separate to the "projection" operator. > > Note that especially if this proposal is treated favorably by SQLite, I'll go > on > and propose it to other DBMS groups too, starting with Postgres. > > Thank you in

Re: [sqlite] Strange File Import Error

n. See you, Stephan > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -> http://stephan.sugarmotor.org (blog and homepage) -> http

Re: [sqlite] Running test after misc7-6.1.2

On Fri, Sep 18, 2009 at 7:51 AM, Stephan Wehner <stephanweh...@gmail.com> wrote: > On Fri, Sep 18, 2009 at 2:35 AM, D. Richard Hipp <d...@hwaci.com> wrote: >> >> On Sep 17, 2009, at 10:56 PM, Stephan Wehner wrote: >> >>> I downloaded the sqlite3 s

Re: [sqlite] Running test after misc7-6.1.2

On Fri, Sep 18, 2009 at 2:35 AM, D. Richard Hipp <d...@hwaci.com> wrote: > > On Sep 17, 2009, at 10:56 PM, Stephan Wehner wrote: > >> I downloaded the sqlite3 source ( sqlite-3.6.18.tar.gz ) and managed >> to complete "make". >> >> Now with  "

[sqlite] Running test after misc7-6.1.2

for? How can I run the tests that come next in "fulltest"? Stephan -- Stephan Wehner -> http://stephan.sugarmotor.org (blog and homepage) -> http://www.thrackle.org -> http://www.buckmaster.ca -> http://www.trafficlif

Re: [sqlite] Multi-master replication through UPDATE and INSERT logging?

uys, a collective group that's trying > to understand and assimilate technology. We feel that resistance to > new ideas and technology is unwise and ultimately futile. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.o