[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();

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

s 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

[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

[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

[sqlite] Sqlite incompatibility with Postgres

On 2016-05-15 11:17 PM, dandl wrote: >>> 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

[sqlite] Sqlite incompatibility with Postgres

On 2016-05-15 10:50 PM, J Decker wrote: > On Sun, May 15, 2016 at 10:02 PM, Darren Duncan > wrote: >> On 2016-05-15 9:56 PM, J Decker wrote: >>> >>> On Sun, May 15, 2016 at 9:29 PM, Darren Duncan >>> wrote: On 2016-05-15 12:35 AM, Simon Slavin wrote: > > All true. But it

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

This may be completely irrelevant, but what about storing your sqlite db on a zfs file system (or another with similar capabilities) and creating a new zfs snapshot whenever you need to? I don't know how this'll fly in practice if you have a lot of snapshots or if you need to create many very