Re: [sqlite] using sqlite extensions within Ruby

On 8 December 2016 at 23:23, Don V Nielsen wrote: > Like you, I like ruby and working with sqlite via sqlite3 gem. So you have > recompiled sqlite3 with the sessions extension. Correct? And this modified > sqlite3 is the nearest sqlite3 available in your execution path.

Re: [sqlite] sqlite3_changes() using 64 bit counters?

Just curious -- some of your tables approach 2 billion (2 milliard) rows? Or, more precisely, you operate on more than 2 billion rows in a single transaction? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] sqlite3_changes() using 64 bit counters?

Hi, is there a plan for sqlite3_changes() and sqlite3_total_changes() returning 64 bit values? SQLite supports far more rows than a signed 32 bit counter can store and I would feel more comfortable if I don't need to check for an overflow. Thank you, Detlef.

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.104.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Monday, December 12th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] using sqlite extensions within Ruby

Documentation update to https://sqlite.org/sessionintro.html: "The session extension provide a mechanism". Should that read, "The session extension provides a mechanism"? dvn On Thu, Dec 8, 2016 at 9:23 AM, Don V Nielsen wrote: > Like you, I like ruby and working with

Re: [sqlite] using sqlite extensions within Ruby

Like you, I like ruby and working with sqlite via sqlite3 gem. So you have recompiled sqlite3 with the sessions extension. Correct? And this modified sqlite3 is the nearest sqlite3 available in your execution path. Correct? The sqlite_ruby library is an interface to sqlite3...the base model.

Re: [sqlite] Default file permissions

On 8 Dec 2016, at 12:08pm, Petr Shestov wrote: > How do I change default file permissions of SQLite db files on Windows? > Currently all freshly created DBs allow full access for Everyone. But I need > to restrict this to current user. > One option that I tried is to

Re: [sqlite] Default file permissions

On Thu, Dec 8, 2016 at 1:08 PM, Petr Shestov wrote: > How do I change default file permissions of SQLite db files on Windows? > Currently all freshly created DBs allow full access for Everyone. But I > need to restrict this to current user. > One option that I tried is to

[sqlite] Default file permissions

Hi all! How do I change default file permissions of SQLite db files on Windows? Currently all freshly created DBs allow full access for Everyone. But I need to restrict this to current user. One option that I tried is to manually create empty file and set required permissions. But if using WAL

[sqlite] using sqlite extensions within Ruby

I don't usually see questions about using SQLite3 from Ruby here, so I hope this is not out of place. Ruby is my normal programming language of choice nowadays, and I've been very happy with the sqlite3 ruby gem to use SQLite3 within my programs. I'd now like to make use of the SQLite3 session