[sqlite] group by z HAVING count(z>12.5)=2

If I wanna to know how much z>12.5 result in the database,could I use this following cmd? SELECT * from TableA WHERE z in ( SELECT z FROM TableA GROUP BY z HAVING count(z>12.5)=2 ); ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

Hector, here's the link from official SQLite website about Flags for File opening operations:  http://www.sqlite.org/c3ref/c_open_autoproxy.html Unfortunately I don't know anything (yet!) about SQLite under Java. If you need any other kind of help, let me know.

Re: [sqlite] how to build sqlite4 (four)?

I apologize for top posting and not snipping but a tablet makes that difficult... The problem with a db-specific function is that it makes a lot of otherwise portable, driver-agnostic sql code not applicable to sqlite4. For example PDO and similar abstraction layers. On Jun 28, 2012 11:32 PM,

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 4:32 PM, Simon Slavin wrote: > I think SQLite4 will need to support AUTOINCREMENT for INTEGERs because so > many SQL users will assume that it's supported. Sure. At least for UNIQUE and PRIMARY KEY fields it's possible with reasonable semantics.

Re: [sqlite] how to build sqlite4 (four)?

On 28 Jun 2012, at 9:05pm, Nico Williams wrote: > I think AUTOINCREMENT should imply that the column values a) must be > INTEGER, b) tracking the max value seen so far. (b) is tricky because > it's tempting to not require an index on that column unless it's > constrained

Re: [sqlite] JDBC Drivers--which one?

> I have found both the Xerial and Zentus SQLite JDBC Drivers on the net. > This leads me to wonder are there other JDBC drivers for SQLite and if > so what are they? Also, what are the pros and cons of the available > drivers? Which one is the recommended one for use with SQLite? > > Thanks,

Re: [sqlite] how to build sqlite4 (four)?

That's the way Oracle does it too. http://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_6014.htm Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems

Re: [sqlite] how to build sqlite4 (four)?

>> Too many SQLite3 apps assume a rowid. But I agree that not having a rowid >> unless one is defined is the >> correct thing to do. Darn right they do. I'm relatively new to SQLite, but from what I've seen all across the web, good use of the convenient rowed field is considered a best

Re: [sqlite] how to build sqlite4 (four)?

On Jun 28, 2012, at 4:05 PM, Nico Williams wrote: > It's also possibly a good idea to just not have autoincrement. Let > the application implement it, no? After all, it can, including via > triggers. Or with PostgreSQL-style sequences

Re: [sqlite] SQLite4 (don't scream)

On Thu, Jun 28, 2012 at 4:09 PM, Alexey Pechnikov wrote: > Will be covering indices on views available as replacement of materialized > views? > No. I don't know how to do that. > > 2012/6/28 Simon Slavin > > > First, the important bit: > > > >

Re: [sqlite] SQLite4 (don't scream)

Will be covering indices on views available as replacement of materialized views? 2012/6/28 Simon Slavin > First, the important bit: > > "SQLite4 is an alternative, not a replacement, for SQLite3. SQLite3 is not > going away." > > Now the URL: > >

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 2:48 PM, Richard Hipp wrote: > Note that SQLite4 does not have a rowid (at last not always) so the whole > concept of autoincrement will need to be revisited.  I don't think the old > SQLite3 way of doing autoincrement makes sense any more.  Not good sense

[sqlite] question about sqlite4_open() flags

(i hope i'm not flooding the list too much with v4. If this should move to the dev list or gmail, just point me in the right direction.) i found that there is no open_v2() in v4, and the signature has changed a small amount. My code used to look like: rc = flags ?

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 7:23 PM, Stephan Beal wrote: > i'm racing to be the first to adapt his db access abstraction layer to > sqlite4 and i've hit my first stumbling block... > i hope this qualifies as "first" ;)

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 9:48 PM, Richard Hipp wrote: > Note that SQLite4 does not have a rowid (at last not always) so the whole > concept of autoincrement will need to be revisited. I don't think the old > SQLite3 way of doing autoincrement makes sense any more. Not good >

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 3:22 PM, Stephan Beal wrote: > A follow-up: > > i've got it linking now, but i am seeing different behaviour between > autoincrement fields and sqliteX_last_insert_rowid(). v4 doesn't allow the > following SQL: > Autoincrement isn't working yet. I

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 9:22 PM, Stephan Beal wrote: > i haven't yet narrowed down the problem, but wanted to point it out. If > it's a known problem, let me know and i'll stop digging. > A couple more details: schema: CREATE TABLE t( vInt INTEGER NOT NULL PRIMARY KEY

Re: [sqlite] how to build sqlite4 (four)?

A follow-up: i've got it linking now, but i am seeing different behaviour between autoincrement fields and sqliteX_last_insert_rowid(). v4 doesn't allow the following SQL: and when i hard-code a row ID into my test SQL it's last_insert_rowid() is returning <=0 (i don't yet know which - an

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 8:35 PM, Stephan Beal wrote: > http://localhost:8080/artifact/3a695fc9bb272a4f5ca0d1a8cf540d61b52ff534 > > (i strongly suspect that link will work for you ;) > > contains Table::tnum. > That's a lie - tnum is in Index in that version. -- -

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 8:25 PM, Richard Hipp wrote: > My makefile uses gcc. Why don't you change yours to gcc too, to see if > that helps. > Strangely enough, no. i can't quite explain this because i'm on trunk and:

Re: [sqlite] how to build sqlite4 (four)?

My makefile uses gcc. Why don't you change yours to gcc too, to see if that helps. On Thu, Jun 28, 2012 at 2:14 PM, Stephan Beal wrote: > On Thu, Jun 28, 2012 at 7:35 PM, Richard Hipp wrote: > > > My makefile has the following: > > > > Thanks for the

Re: [sqlite] Example database with lots of "types"?

> I'm working on getting the Mac version of the SQLite ODCB connector fully > functional. I'm having some problems getting examples of lots of different data > types - for instance, my northwind copy has a decimal stored as a varchar. > > Does anyone have a small test DB they would be willing to

Re: [sqlite] Regarding the subclassing model of sqlite4

On Thu, Jun 28, 2012 at 7:36 PM, Stephan Beal wrote: > In the off chance that i might influence such a design decision in > sqlite4, here's the article: > > http://wanderinghorse.net/computing/papers/DoingOOInC.pdf > > And to put my money where my mouth is, so to speak,

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 7:35 PM, Richard Hipp wrote: > My makefile has the following: > Thanks for the tips. My initial problem was that sqlite4.h was 0 bytes due to a failed build before i had installed tclsh and clang. That of course caused grief. Removing it and rebuilding

Re: [sqlite] SQLite4 (don't scream)

On 28 Jun 2012, at 6:04pm, Roger Binns wrote: > http://news.ycombinator.com/item?id=4168645 LOL. Those Hacker News guys are hardcore. Make some of my mailing lists look almost civil. Simon. ___ sqlite-users mailing list

[sqlite] Regarding the subclassing model of sqlite4

Hello again, (@non-developers: this post will not interest you in the slightest. @devs: it may or may not interest you in the slightest.) Regarding the subclassing model of sqlite4, where one subclasses by creating an over-sized struct and padding it with their fields... About a year ago i

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 1:23 PM, Stephan Beal wrote: > Hiho! > > i'm racing to be the first to adapt his db access abstraction layer to > sqlite4 and i've hit my first stumbling block... > Everything is still pretty makefile-touchy. Remember, this is like pre-alpha code.

Re: [sqlite] how to build sqlite4 (four)?

On Thu, Jun 28, 2012 at 7:23 PM, Stephan Beal wrote: > stephan@tiny:~/cvs/fossil/sqlite4$ make > clang -g -o mkkeywordhash -DSQLITE_DEBUG=1 -DHAVE_GMTIME_R - > Sorry, should have added: stephan@tiny:~/cvs/fossil/sqlite4$ clang --version clang version 2.9

[sqlite] how to build sqlite4 (four)?

Hiho! i'm racing to be the first to adapt his db access abstraction layer to sqlite4 and i've hit my first stumbling block... stephan@tiny:~/cvs/fossil/sqlite4$ make clang -g -o mkkeywordhash -DSQLITE_DEBUG=1 -DHAVE_GMTIME_R -DHAVE_LOCALTIME_R -DHAVE_MALLOC_USABLE_SIZE -DHAVE_USLEEP

Re: [sqlite] SQLite4 (don't scream)

On Thu, Jun 28, 2012 at 7:09 PM, E. Timothy Uy wrote: > That's kind of cool, but how about $twentyseven! > $c1...$c27 (c==column)? -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users

Re: [sqlite] SQLite4 (don't scream)

That's kind of cool, but how about $twentyseven! > On Thu, Jun 28, 2012 at 12:57 PM, Robert Myers > wrote: > > > Aghhh (just kidding) > > > > One request for a change - make bind and column start with the same > index. > > I always have to look up which one is zero

Re: [sqlite] SQLite4 (don't scream)

On Thu, Jun 28, 2012 at 12:57 PM, Robert Myers wrote: > Aghhh (just kidding) > > One request for a change - make bind and column start with the same index. > I always have to look up which one is zero based and which one is one based. > Right now, porting an app

Re: [sqlite] SQLite4 (don't scream)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/06/12 08:57, Simon Slavin wrote: > Just thought some people might enjoy reading and thinking about it. There has also been discussion on Hacker News and Reddit: http://news.ycombinator.com/item?id=4168645

Re: [sqlite] SQLite4 (don't scream)

On 28/06/2012 12:30 PM, Cory Nelson wrote: On Thu, Jun 28, 2012 at 11:20 AM, Stephan Beal wrote: On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin wrote: Now the URL: Just thought some people

Re: [sqlite] SQLite4 (don't scream)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/06/12 09:20, Stephan Beal wrote: > size_t does not have a specified size and causes all sorts of grief in > porting i/o-based APIs between 32/64 bits, I have been one of the people complaining loudest about not using types like size_t.

Re: [sqlite] SQLite4 (don't scream)

On Thu, Jun 28, 2012 at 6:57 PM, Robert Myers wrote: > One request for a change - make bind and column start with the same index. > I always have to look up which one is zero based and which one is one based. > That particular convention comes not from sqlite3, but from

Re: [sqlite] SQLite4 (don't scream)

Aghhh (just kidding) One request for a change - make bind and column start with the same index. I always have to look up which one is zero based and which one is one based. Rob On 6/28/2012 10:57 AM, Simon Slavin wrote: First, the important bit: "SQLite4 is an alternative, not a

Re: [sqlite] SQLite4 (don't scream)

On Thu, Jun 28, 2012 at 6:52 PM, Stephan Beal wrote: > fully specialized). _Which_ fixed-size int type it collides with is > platform-dependent and leads to convoluted workarounds like this: > > >

Re: [sqlite] SQLite4 (don't scream)

On Thu, Jun 28, 2012 at 6:46 PM, Stephan Beal wrote: > 64-bits. size_t has at least the following drawbacks compared to using a > fixed-size integer type: > - In C++ size_t is often problematic in template specializations because in invariably collides with one of the

Re: [sqlite] SQLite4 (don't scream)

On Thu, Jun 28, 2012 at 6:30 PM, Cory Nelson wrote: > Probably not an issue -- I'm not sure how a public API would need inttypes > anyway. Also, perhaps you are seeing size_t be misused. A blanket "please > don't use" is nonsense. > Hi, Cory! That's what i thought to until i

Re: [sqlite] SQLite4 (don't scream)

On Thu, Jun 28, 2012 at 12:20 PM, Stephan Beal wrote: > On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin > wrote: > > > Now the URL: > > > > > > > > Just thought some people might enjoy reading and

Re: [sqlite] SQLite4 (don't scream)

On Thu, Jun 28, 2012 at 11:20 AM, Stephan Beal wrote: > On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin > wrote: > > > Now the URL: > > > > > > > > Just thought some people might enjoy reading and

Re: [sqlite] SQLite4 (don't scream)

On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin wrote: > Now the URL: > > > > Just thought some people might enjoy reading and thinking about it. > FWIW, my 0.02 Euros regarding this line: "SQLite4 makes use of standard

Re: [sqlite] SQLite Encryption Extension Performance?

> > Mensaje original > De: Simon Slavin > Para: a...@zator.com,General Discussion of SQLite Database > > Fecha: Thu, 28 Jun 2012 15:43:26 +0200 > Asunto: Re: [sqlite] SQLite Encryption Extension Performance? > > > > >On 28 Jun 2012,

[sqlite] SQLite4 (don't scream)

First, the important bit: "SQLite4 is an alternative, not a replacement, for SQLite3. SQLite3 is not going away." Now the URL: Just thought some people might enjoy reading and thinking about it. Simon.

[sqlite] Not sure how to interrupt this

>Igor Tandetnik itandetnik at mvps.org Thu Jun 28 09:57:06 EDT 2012 >Did you prepare the INSERT statement in between running CREATE TABLE and CREATE INDEX, >by any chance? Or perhaps CREATE TABLE for a different table? No, the CREATE INDEXs were done right after the CREATE TABLE. I have a wrapper

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

It will not be possible with SQLite but it would be possible using H2. http://www.h2database.com/html/advanced.html#file_system maybe you could convert the sqlite to H2 somewhere in your process? Best regards, Sylvain ___ sqlite-users mailing list

Re: [sqlite] Not sure how to interrupt this

I think SQLITE_SCHEMA can happen even if you run things like CREATE TABLE or ALTER TABLE on the same connection. Also ATTACH DATABASE and DETACH DATABASE should invalidate all statements prepared before that. Pavel On Thu, Jun 28, 2012 at 9:58 AM, Marc L. Allen

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

On Thu, Jun 28, 2012 at 9:54 AM, Hector Guilarte wrote: > I don't think it would. > > Connection conn = DriverManager.getConnection("jdbc:sqlite:sample.db", > config.toProperties()); > > is telling to open a connection to the file "sample.db" which is located in > the same

Re: [sqlite] Not sure how to interrupt this

Jeff Archer wrote: >> Igor Tandetnik itandetnik at mvps.org Thu Jun 28 09:38:27 EDT 2012 >> My guess is that a) you have prepared your statement with > sqlite3_prepare_v2 (as opposed to sqlite3_prepare)... > > > Statement was prepared with sqlite3_prepare16_v2() > >

Re: [sqlite] Complete list of companies that bought SQLite licenses?

On 28 Jun 2012, at 11:53am, Peter Volkis wrote: > Occasionally I bump into some proprietary software that's using SQLite behind > the curtain and I wonder if they have bought a license. I know SQLite is > public domain and it is not required to buy a license while using

Re: [sqlite] Not sure how to interrupt this

Oh.. you're positing a second party. Ok.. now I'm interested to see if there was one. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Thursday, June 28, 2012 9:55 AM To: sqlite-users@sqlite.org Subject:

Re: [sqlite] Not sure how to interrupt this

Marc L. Allen wrote: > How could the schema have changed? Someone ran CREATE TABLE or VACUUM or similar on the database (possibly via a different connection). -- Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

I don't think it would. Connection conn = DriverManager.getConnection("jdbc:sqlite:sample.db", config.toProperties()); is telling to open a connection to the file "sample.db" which is located in the same folder as the application is executing, but is going for a *file*. However, I'm going to

[sqlite] Not sure how to interrupt this

>Igor Tandetnik itandetnik at mvps.org Thu Jun 28 09:38:27 EDT 2012 >My guess is that a) you have prepared your statement with sqlite3_prepare_v2 (as opposed to sqlite3_prepare)... Statement was prepared with sqlite3_prepare16_v2() Database file was created only moments earlier. Jeff Archer

Re: [sqlite] SQLite Encryption Extension Performance?

On 28 Jun 2012, at 12:12pm, a...@zator.com wrote: > Assuming using SEE, do is there the ability to decide what I/O operations are > to be performed encrypted or with the plain (as is) content? I hope Richard's answer tells you what you want to know. He runs the team that makes SEE. Just in

Re: [sqlite] Not sure how to interrupt this

How could the schema have changed? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Thursday, June 28, 2012 9:38 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Not sure how to interrupt this Jeff

Re: [sqlite] Not sure how to interrupt this

Jeff Archer wrote: > I have SQLITE_CONFIG_LOG callback installed: > sqlite3_config(SQLITE_CONFIG_LOG, cb_sqlite_config_log, /*pUserData*/NULL); > > I get the following message through the SQLITE_CONFIG_LOG callback during > the sqlite3_step(): > errcode: SQLITE_SCHEMA (17) >

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

Does this article help? http://stackoverflow.com/questions/4574303/java-sqlite-how-to-open-database-as-read-only Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems

Re: [sqlite] Not sure how to interrupt this

I think he wants to know why he is receiving what appears to be an error notification via the callback. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Adam DeVita Sent: Thursday, June 28, 2012 9:05 AM To: General Discussion

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

Because I want it to run on Google App Engine. GAE doesn't allow to write to the FileSystem, so I can't open the JDBC Connection to the SQLite file and therefore I can't read the data to convert to CSV. I upload the file to Google App Engine with a HTML form and that's how I get it in an

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

If you've got the database in a stream, why can't you save it to a disk file and then use this file with sqlite? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

Hello? I'm starting to feel hopeless, No luck in StackOverflow and no luck here :-(... Well, i guess it just can't be done. On Wed, Jun 27, 2012 at 10:13 AM, Hector Guilarte wrote: > Hello everyone, > > I'm new to SQLite as well as to this list. I'm writing because I was >

Re: [sqlite] Not sure how to interrupt this

SQLITE DONE is what you get when you successfully run an insert. What is the problem? Adam On Wed, Jun 27, 2012 at 7:02 PM, Jeff Archer wrote: > I am getting back SQLITE_DONE (101) from sqlite3_step() and the statement > is clearly being executed. > > SQL: "INSERT INTO

Re: [sqlite] How do I rename a column called IN?

Quote it: sqlite> create table x(in); Error: near "in": syntax error sqlite> create table x("in"); sqlite> insert into x values(1); sqlite> select * from x; 1 sqlite> select in from x; Error: near "in": syntax error sqlite> select "in" from x; 1 sqlite> update x set in=3; Error: near "in":

[sqlite] Complete list of companies that bought SQLite licenses?

Occasionally I bump into some proprietary software that's using SQLite behind the curtain and I wonder if they have bought a license. I know SQLite is public domain and it is not required to buy a license while using it for commercial purposes. I wonder about it just out of straight curiousity,

[sqlite] How do I rename a column called IN?

Hi all, I am no programmer, and I only know a small number of very basic SQLite commands, and I have a serious problem: I need to change values in a column that some fool named IN like the operator (I think IN is an operator). Normally, I use the command line UPDATE name_of_table SET xyz=10

Re: [sqlite] SQLite Encryption Extension Performance?

On Thu, Jun 28, 2012 at 7:12 AM, wrote: > Hi: > > Assuming using SEE, do is there the ability to decide what I/O operations > are to be performed encrypted or with the plain (as is) content? > Encryption is turned on and off at the database level. So either an entire database

Re: [sqlite] SQLite Encryption Extension Performance?

Hi: Assuming using SEE, do is there the ability to decide what I/O operations are to be performed encrypted or with the plain (as is) content? I'm planning an application with only selected data encripted (in each row of certain tables, there is a flag showing the encrypted/plain state).

[sqlite] JDBC Drivers--which one?

I have found both the Xerial and Zentus SQLite JDBC Drivers on the net. This leads me to wonder are there other JDBC drivers for SQLite and if so what are they? Also, what are the pros and cons of the available drivers? Which one is the recommended one for use with SQLite? Thanks, LA