Re: [sqlite] Status of LSM1 extension

On Thursday, 5 March, 2020 20:39, Charles Leifer wrote: >Keith, if you could share a bit more details on how you do that, I'd be >interested. I presume you mean how to create a "built-in" extension, which is available for all connections, just the built-in functions and modules. There is a

Re: [sqlite] Status of LSM1 extension

Keith, if you could share a bit more details on how you do that, I'd be interested. On Thu, Mar 5, 2020 at 8:43 AM Keith Medcalf wrote: > > On Thursday, 5 March, 2020 05:51, Dominique Devienne > wrote: > > >PS: I'd still very much appreciate an LSM1 amalgamation > > cd ext/lsm1 > tclsh

Re: [sqlite] Status of LSM1 extension

On Thursday, 5 March, 2020 05:51, Dominique Devienne wrote: >PS: I'd still very much appreciate an LSM1 amalgamation cd ext/lsm1 tclsh tool/mklsm1c.tcl which will write an lsm1.c amalgamation in the current directory (ext/lsm1) You can append this to the amalgamation and use an EXTRA_INIT

Re: [sqlite] Status of LSM1 extension

On Thu, Mar 5, 2020 at 12:35 PM Dan Kennedy wrote: > On 5/3/63 16:11, Dominique Devienne wrote: > > I'm interested in LSM1 [1] as an alternative to SQLite [...] > > [...], I don't think it's too bad of an implementation. The > automated tests are reasonably good - although of course not as good

Re: [sqlite] Status of LSM1 extension

On 5/3/63 16:11, Dominique Devienne wrote: Hi, I'm interested in LSM1 [1] as an alternative to SQLite, since in a particular use-case, I'm using SQLite mostly as a key-value store, and write performance is particularly important, in addition to MVCC. Sounds like it could be an excellent fit

[sqlite] Status of LSM1 extension

Hi, I'm interested in LSM1 [1] as an alternative to SQLite, since in a particular use-case, I'm using SQLite mostly as a key-value store, and write performance is particularly important, in addition to MVCC. Sounds like it could be an excellent fit here, and the fact it comes from the SQLite team

Re: [sqlite] Status analyze with Sqlite

n Mangold > Sent: Friday, 23 November, 2012 02:02 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Status analyze with Sqlite > > > > > ID | TimeStamp | Status > > > > 0 | 2012

Re: [sqlite] Status analyze with Sqlite

On 23 Nov 2012, at 9:01am, Steffen Mangold wrote: > But it should be: > ID| Begin | End | Status > --- > 0 | 2012-07-24 22:23:00 | 2012-07-24

Re: [sqlite] Status analyze with Sqlite

Steffen Mangold wrote: > TimeStamp | Status > - > 2012-07-24 22:23:00 | status1 > 2012-07-24 22:23:05 | status1 > 2012-07-24 22:23:10 | status2 > 2012-07-24 22:23:16 | status2 > 2012-07-24 22:23:21 | status1 > 2012-07-24

Re: [sqlite] Status analyze with Sqlite

Hi Clemens, first thank you for your comments. > > It works for what you've asked. Perhaps you should not have kept your actual > requirements a secret. > Sorry for being unclear! :( Hope my English is understandable (I'm from Germany). > > So you want to group only consecutive events with

Re: [sqlite] Status analyze with Sqlite

Steffen Mangold wrote: > this won't work It works for what you've asked. Perhaps you should not have kept your actual requirements a secret. > if the table look like this: > > ID | TimeStamp | Status > > 0| 2012-07-24

Re: [sqlite] Status analyze with Sqlite

> ID| TimeStamp | Status > > 0 | 2012-07-24 22:23:00 | status1 > 1 | 2012-07-24 22:23:05 | status1 > 2 | 2012-07-24 22:23:10 | status2 > 3 | 2012-07-24 22:23:16 | status2 > 4 | 2012-07-24 22:23:21

Re: [sqlite] Status analyze with Sqlite

On 11/22/2012 4:47 PM, Steffen Mangold wrote: HI sqlite community, I have a problem I get stucked, maybe someone can help me. :( My issue: For instance if we have 10 rows with following data ID | TimeStamp | Status 0

[sqlite] Status analyze with Sqlite

HI sqlite community, I have a problem I get stucked, maybe someone can help me. :( My issue: For instance if we have 10 rows with following data ID | TimeStamp | Status 0 | 2012-07-24 22:23:00 | status1 1 |

Re: [sqlite] Status

I think that you can track progress at http://www.sqlite.org/src/timeline?n=20=winrt Best regards, Krystian Bigaj On 2 March 2012 16:37, Steven Nesbit wrote: > Sorry about that, WinRT Sqlite > > Steve > > > ___ > sqlite-users

Re: [sqlite] Status

Sorry about that, WinRT Sqlite Steve ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Status

Sorry... What effort? > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Steven Nesbit > Sent: Friday, March 02, 2012 10:35 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Status > > What is t

[sqlite] Status

What is the status of this effort? We actually need to have the platform determined at runtime since we need to run on WinRT, Android and iOS. Steve ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] status of unqlspec / sqlite

Hi, Recent comment on the topic from unql mailing list: https://groups.google.com/forum/#!msg/unql/dVc_cM1ZGw8/3QHE1_MIqRQJ On 04.11.2011 10:50, sqlite-us...@h-rd.org wrote: Hi, some time ago Richard was involved in http://www.unqlspec.org/ . Is that still going on? I am quite interested in

[sqlite] status of unqlspec / sqlite

Hi, some time ago Richard was involved in http://www.unqlspec.org/ . Is that still going on? I am quite interested in a backend for sqlite. thanks, ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Status of SQLite's full-text search (and Python 2.5 support?)

P Kishor, > I have no idea how I conveyed that impression. I think FTS3 is really > wonderful, and have implemented it in my own personal website. I firmly > believe in the "Why file when you can full-text search" doctrine. Excellent! Thanks for the follow-up. You answered my questions. And

Re: [sqlite] Status of SQLite's full-text search (and Python 2.5 support?)

On 4/20/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > >> Is SQLite's full text ready for production use yet? > > > as ready as it will be. FTS 1/2 are deprecated. > > > You don't sound too thrilled :) Are there any limitations that one > should be aware of? I have no idea how I conveyed

Re: [sqlite] Status of SQLite's full-text search (and Python 2.5 support?)

>> Is SQLite's full text ready for production use yet? > as ready as it will be. FTS 1/2 are deprecated. You don't sound too thrilled :) Are there any limitations that one should be aware of? Thank you, Malcolm ___ sqlite-users mailing list

Re: [sqlite] Status of SQLite's full-text search (and Python 2.5 support?)

On 4/20/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I'm trying to figure out the status of SQLite's support for full-text > search. > > It appears that full-text support was provisionally added to SQLite in > late 2006 via an extension module. It sounds like this early version was >

[sqlite] Status of SQLite's full-text search (and Python 2.5 support?)

I'm trying to figure out the status of SQLite's support for full-text search. It appears that full-text support was provisionally added to SQLite in late 2006 via an extension module. It sounds like this early version was experimental only. After more googling it appears that there are two

Re: [sqlite] Status of FOREIGN KEY implementation

On Wed, Aug 11, 2004 at 05:09:49PM -0700, Cliff Hudson wrote: > engine in a mobile device. Foreign key constraints are one of the features > I would like to see in any database engine we eventually use. According to > the web site, this feature is not yet implemented, and the mailing list This

Re: [sqlite] Status Update: Unix file locking is badly broken

The latest version in CVS defers close() calls until locks have all cleared. If you are running SQLite on unix and have a chance, please throw everything you can at this new version. If I get no reports of problems over the next few days I'll call this one 2.8.10 and release it. -- D. Richard