[sqlite] using cerod/sqlite with JDBC

Hi , yes, this is perfectly understood. but my quesion is around the CEROD extension. the sqlite driver does not support DBs which are created with CEROD based compression. thanks Tal > On May 16, 2016, at 10:53 PM, Klaas Van B. wrote: > > Did you read, understood and used all instructions you

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

Thank you for your answer, here is the code i used to backup my SQLite database : var source = new SQLiteConnection("Data Source = MyDB.db ; Version = 3;"); var destination = new SQLiteConnection("Data Source = NewDBBackup.db; Version = 3;"); source.Open(); destination.Open(); source.BackupDatab

[sqlite] select 1='1'

Hi, In SQLite 3.x there is no equality between number and text representing number like in PostgreSQL and Oracle - example: sqlite> SELECT 1 WHERE 1='1'; (nothing) sqlite> postgresql> SELECT 1 WHERE 1='1'; t postgresql> oracle> SELECT 1 FROM dual WHERE 1='1'; 1 oracle> The problem I do have is

[sqlite] 64bit DLL vs 32bit

I don't think so. The WoW layer allows 32 bit code to talk to the 64 bit OS, but there is no support included to connect 32 bit and 64 bit user application pieces (executable and dll). On 5/15/16 5:22 PM, Bart Smissaert wrote: > So, is there any way that a 32 bit VB6 ActiveX dll or a32 bit VB6 A

[sqlite] Accessing an encyrpted Sqlite Database

Sqlite Support, If there is a particular database that was created using DotNet's System.Data.Sqlite, and that database was encrypted with a "Password" argument via the SqliteConnection string. Would it be possible to access that encrypted database by means of the native C++ language using Visua

[sqlite] using cerod/sqlite with JDBC

Did you read, understood and used all instructions you can find here? http://www.tutorialspoint.com/sqlite/sqlite_java.htm Tal Tabakman wrote Sun, 15 May 2016 09:41:39 -0700: > ... open an sqlite DB , compressed with CEROD, using java?s sqlite JDBC > connection ? Kind regards | Vriendelijke gr

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

Hi sir, In fact, i have an issue with SQLite database Restore using c# i'm coding a button which can restore an existing SQLite database with ' *.db*' extension i wonder if you can guide me please, i'll ber very grateful Sincerely yours Hashim 2016-05-16 19:08 GMT+00:00 Roger Binns : > On 16/05/1

[sqlite] sqlite3_prepare*() statement argument detailed

E.D. wrote: > The sqlite3 documentation specifies, that sqlite3_prepare*() compile > "the first statement" from the sqlite3_stmt ** argument. This argument > ought to be explained thoroughly. It is explained thoroughly on . Regards, Clemens

[sqlite] using cerod/sqlite with JDBC

On 5/15/16, Tal Tabakman wrote: > Hi > is there a way to open an sqlite DB , compressed with CEROD, using java?s > sqlite JDBC connection ? Yes. (1) Recompile your JDBC driver so that it uses the CEROD-enabled sqlite3.c file instead of the public domain sqlite3.c file. (2) When you connect to t

[sqlite] Sqlite incompatibility with Postgres

> > All true. But it brings up a question. Suppose the following: > > > > first second > > - -- > > MarkSpark > > Emily Spark > > MarySoper > > Brian Soper > > > > SELECT first,second FROM members ORDER BY second LIMIT 3 > > > I think a proper solut

[sqlite] sqlite3_prepare*() statement argument detailed

Hi. The sqlite3 documentation specifies, that sqlite3_prepare*() compile "the first statement" from the sqlite3_stmt ** argument. This argument ought to be explained thoroughly. What exactly can be put through this argument? Compound statements, transactions? What syntax?

[sqlite] sqlite3_prepare*() statement argument detailed

On 2016/05/16 2:58 PM, E.D. wrote: > Hi. > > The sqlite3 documentation specifies, that sqlite3_prepare*() compile "the > first statement" from the sqlite3_stmt ** argument. This argument ought to be > explained thoroughly. > What exactly can be put through this argument? Compound statements, >

[sqlite] sqlite3_prepare*() statement argument detailed

On Mon, May 16, 2016 at 2:58 PM, E.D. wrote: > Hi. > > The sqlite3 documentation specifies, that sqlite3_prepare*() compile "the > first statement" from the sqlite3_stmt ** argument. This argument ought to > be explained thoroughly. > What exactly can be put through this argument? Compound statem

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

On 5/16/16, Eric Rubin-Smith wrote: > > Richard: when your contract is up in 2050 maybe you can write us a book. > Sort of a "War As I Knew It" but for programming. :-) > To be clear: There is no contract. Airbus purchased a small amount of support assistance from us during the initial develop

[sqlite] Sqlite incompatibility with Postgres

On 16 May 2016, at 5:29am, Darren Duncan wrote: > On 2016-05-15 12:35 AM, Simon Slavin wrote: > >> firstsecond >> --- >> Mark Spark >> EmilySpark >> Mary Soper >> BrianSoper >> >> SELECT first,second FROM members ORDER BY second LIMIT 3 > > I think a pr

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

On Sat, May 14, 2016 at 4:17 PM, Simon Slavin wrote: > Those interested in SQLite might like to listen to > > > Having spent many years working directly in Richard's code and that of many hundreds of other programmers, I consider Richard to be by far the best program

[sqlite] Sqlite incompatibility with Postgres

On Mon, 16 May 2016 16:17:35 +1000 "dandl" wrote: > > > All true. But it brings up a question. Suppose the following: > > > > > > first second > > > - -- > > > Mark Spark > > > Emily Spark > > > Mary Soper > > > Brian Soper > > > > > > SELECT first,second FROM

[sqlite] Any way to do inexpensive SQLite database/table versioning? (I.e. cheap snapshotting & jumping between)

On Sun, 15 May 2016 10:42:37 -0500 mikeegg1 wrote: > I was once told of an idea (decades ago) of versioning data within a > table where one column has a real/float value that is the version > number. You can have a point-in-time database if: * each transaction has an id * DELETE is redefine

[sqlite] SQLite Is Not Support Uint64?

I insert a value 18446744072708321492 as a integer into the table. In C code,sqlite3_column_type tells me is a type of 2, which is float point value. And I usesqlite3_column_double to get it. It returns18446744072708321280, which is already lost theaccuracy. Is SQLite not support Uint64 value,

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

: 181 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160516/9ee7a5e7/attachment.pgp>

[sqlite] Sqlite incompatibility with Postgres

On 2016/05/16 8:17 AM, dandl wrote: >> all rows are returned or zero rows are returned. Thus the result is >> deterministic. >> >> Whether returning above or below the limit is done, is a separate thing to >> decide, though I suggest returning above is better. > I would say that this is an inval

[sqlite] sqlite3_prepare*() statement argument detailed

SQL statements end with a ";" That is what is meant by "statement." On Mon, May 16, 2016 at 8:58 AM, E.D. wrote: > Hi. > > The sqlite3 documentation specifies, that sqlite3_prepare*() compile "the > first statement" from the sqlite3_stmt ** argument. This argument ought to > be explained thor

[sqlite] Sqlite incompatibility with Postgres

That is irrelevant. You said three rows, so three rows should be returned. The language should not attempt to implement wishy washy conditions guessing what you might have meant. If you wanted a maximum of three rows containing the SAME firstname, then that is what you would have asked for.

[sqlite] SQLite Is Not Support Uint64?

It doesn't support unsigned integers natively, but most of the time it will effectively upconvert to a larger signed integer. In the case where it's greater than the maximum int8 it obviously cannot upconvert, so uses a floating point to approximate. https://www.sqlite.org/datatype3.html If you

[sqlite] Any way to do inexpensive SQLite database/table versioning? (I.e. cheap snapshotting & jumping between)

2016-05-15 23:46 GMT+07:00 Dominique Devienne : > On Sunday, May 15, 2016, Mikael wrote: > > > > Would there be any facility whereby after each transaction I do on a > > database or table, I could somehow make a snapshot so that at any future > > point in time, I could easily do a SELECT to a giv