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
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).
On Thu, Jun 28, 2012 at 7:12 AM, a...@zator.com 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 file is
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
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,
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: syntax error
sqlite
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 jarch...@yahoo.com wrote:
I am getting back SQLITE_DONE (101) from sqlite3_step() and the statement
is clearly being executed.
SQL: INSERT INTO
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 hector...@gmail.comwrote:
Hello everyone,
I'm new to SQLite as well as to this list. I'm writing because I was
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
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
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
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
Jeff Archer jarch...@yahoo.com 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)
message:
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
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
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
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 check
Marc L. Allen mlal...@outsitenetworks.com 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
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:
On 28 Jun 2012, at 11:53am, Peter Volkis petervol...@yahoo.com 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 it
Jeff Archer jarch...@yahoo.com 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()
Database file was
On Thu, Jun 28, 2012 at 9:54 AM, Hector Guilarte hector...@gmail.com 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 folder as the
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
mlal...@outsitenetworks.com
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
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
First, the important bit:
SQLite4 is an alternative, not a replacement, for SQLite3. SQLite3 is not
going away.
Now the URL:
http://www.sqlite.org/src4/doc/trunk/www/design.wiki
Just thought some people might enjoy reading and thinking about it.
Simon.
Mensaje original
De: Simon Slavin slav...@bigfraud.org
Para: a...@zator.com,General Discussion of SQLite Database
sqlite-users@sqlite.org
Fecha: Thu, 28 Jun 2012 15:43:26 +0200
Asunto: Re: [sqlite] SQLite Encryption Extension Performance?
On 28 Jun 2012, at 12:12pm,
On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin slav...@bigfraud.org wrote:
Now the URL:
http://www.sqlite.org/src4/doc/trunk/www/design.wiki
Just thought some people might enjoy reading and thinking about it.
FWIW, my 0.02 Euros regarding this line:
SQLite4 makes use of standard data types
On Thu, Jun 28, 2012 at 11:20 AM, Stephan Beal sgb...@googlemail.comwrote:
On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin slav...@bigfraud.org
wrote:
Now the URL:
http://www.sqlite.org/src4/doc/trunk/www/design.wiki
Just thought some people might enjoy reading and thinking about it.
On Thu, Jun 28, 2012 at 12:20 PM, Stephan Beal sgb...@googlemail.comwrote:
On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin slav...@bigfraud.org
wrote:
Now the URL:
http://www.sqlite.org/src4/doc/trunk/www/design.wiki
Just thought some people might enjoy reading and thinking about it.
On Thu, Jun 28, 2012 at 6:30 PM, Cory Nelson phro...@gmail.com 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 started
On Thu, Jun 28, 2012 at 6:46 PM, Stephan Beal sgb...@googlemail.com 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 other
On Thu, Jun 28, 2012 at 6:52 PM, Stephan Beal sgb...@googlemail.com wrote:
fully specialized). _Which_ fixed-size int type it collides with is
platform-dependent and leads to convoluted workarounds like this:
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
On Thu, Jun 28, 2012 at 6:57 PM, Robert Myers rob.my...@ziften.com 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 SQL. i
-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. However
On 28/06/2012 12:30 PM, Cory Nelson wrote:
On Thu, Jun 28, 2012 at 11:20 AM, Stephan Beal sgb...@googlemail.comwrote:
On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin slav...@bigfraud.org
wrote:
Now the URL:
http://www.sqlite.org/src4/doc/trunk/www/design.wiki
Just thought some people might
-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
On Thu, Jun 28, 2012 at 12:57 PM, Robert Myers rob.my...@ziften.com 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 from
That's kind of cool, but how about $twentyseven!
On Thu, Jun 28, 2012 at 12:57 PM, Robert Myers rob.my...@ziften.com
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
On Thu, Jun 28, 2012 at 7:09 PM, E. Timothy Uy t...@loqu8.com 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
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
On Thu, Jun 28, 2012 at 7:23 PM, Stephan Beal sgb...@googlemail.com 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
On Thu, Jun 28, 2012 at 1:23 PM, Stephan Beal sgb...@googlemail.com 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. It
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
On 28 Jun 2012, at 6:04pm, Roger Binns rog...@rogerbinns.com 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
On Thu, Jun 28, 2012 at 7:35 PM, Richard Hipp d...@sqlite.org 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 got
On Thu, Jun 28, 2012 at 7:36 PM, Stephan Beal sgb...@googlemail.com 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, i'd
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 part
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 sgb...@googlemail.com wrote:
On Thu, Jun 28, 2012 at 7:35 PM, Richard Hipp d...@sqlite.org wrote:
My makefile has the following:
Thanks for the tips. My
On Thu, Jun 28, 2012 at 8:25 PM, Richard Hipp d...@sqlite.org 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:
On Thu, Jun 28, 2012 at 8:35 PM, Stephan Beal sgb...@googlemail.com 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.
--
- stephan
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
On Thu, Jun 28, 2012 at 9:22 PM, Stephan Beal sgb...@googlemail.com 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
On Thu, Jun 28, 2012 at 3:22 PM, Stephan Beal sgb...@googlemail.com 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
On Thu, Jun 28, 2012 at 9:48 PM, Richard Hipp d...@sqlite.org 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
On Thu, Jun 28, 2012 at 7:23 PM, Stephan Beal sgb...@googlemail.com 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 ;)
(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
?
On Thu, Jun 28, 2012 at 2:48 PM, Richard Hipp d...@sqlite.org 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
Will be covering indices on views available as replacement of materialized
views?
2012/6/28 Simon Slavin slav...@bigfraud.org
First, the important bit:
SQLite4 is an alternative, not a replacement, for SQLite3. SQLite3 is not
going away.
Now the URL:
On Thu, Jun 28, 2012 at 4:09 PM, Alexey Pechnikov pechni...@mobigroup.ruwrote:
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 slav...@bigfraud.org
First, the important bit:
SQLite4 is an
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
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
practice.
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
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
On 28 Jun 2012, at 9:05pm, Nico Williams n...@cryptonector.com 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 to be
On Thu, Jun 28, 2012 at 4:32 PM, Simon Slavin slav...@bigfraud.org 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.
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,
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.
If I wanna to know how much z12.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(z12.5)=2
);
___
sqlite-users mailing list
sqlite-users@sqlite.org
70 matches
Mail list logo