Groups

cqengine-discuss

1–30 of 177

Welcome to the discussion group for the CQEngine library. Here you can ask questions about using the library, or discuss issues or post suggestions.

0 selected

7/20/19

SQLite Refugee - Newbie questions

One more question: To get started, I have to read all the data from the existing SQLite tables and

unread,

SQLite Refugee - Newbie questions

One more question: To get started, I have to read all the data from the existing SQLite tables and

7/20/19

1/4/24

Which index using

Hi Team, We have rule list cached data. Some query takes a long time. And We have index on cached

unread,

Which index using

Hi Team, We have rule list cached data. Some query takes a long time. And We have index on cached

1/4/24

Karthik Rangasamy

11/8/23

Hi, I have a large dataset around 130 millions object(each) object having around 8 attributes. This

unread,

Hi, I have a large dataset around 130 millions object(each) object having around 8 attributes. This

11/8/23

6/8/23

What is use of sqlite-jdbc in cqengine

Hi Team, we found new vulnerability introduced in sqlite-jdbc library, so we need to get rid of it.

unread,

What is use of sqlite-jdbc in cqengine

Hi Team, we found new vulnerability introduced in sqlite-jdbc library, so we need to get rid of it.

6/8/23

Amir Eslampanah2

3/9/23

How to ensure that DiskPersistence is closed safely

Also, to add to this; I've noticed that persistence.compact(); On a disk-persistence seems to

unread,

How to ensure that DiskPersistence is closed safely

Also, to add to this; I've noticed that persistence.compact(); On a disk-persistence seems to

3/9/23

3/6/23

Regex Pattern Matching

Hi, I need one help regarding regex. Suppose I have 3 person saved in index collection as Person p1 =

unread,

Regex Pattern Matching

Hi, I need one help regarding regex. Suppose I have 3 person saved in index collection as Person p1 =

3/6/23

2/17/23

TransactionalIndexedCollection threads blocking

Hi. I've been having a problem with a service using TransactionalIndexedCollection. About once

unread,

TransactionalIndexedCollection threads blocking

Hi. I've been having a problem with a service using TransactionalIndexedCollection. About once

2/17/23

Yu, Niall Gallagher2

12/14/22

Query for pair-wise attributes

Yes that is possible. For an example see: https://stackoverflow.com/questions/37766895/can-cqengine-

unread,

Query for pair-wise attributes

Yes that is possible. For an example see: https://stackoverflow.com/questions/37766895/can-cqengine-

12/14/22

Constantine Zachariadis, Niall Gallagher4

11/17/22

How to update existing object atomically?

Hi Niall, thx. My input message has what can be construed as a primary key indicated by a Long field

unread,

How to update existing object atomically?

Hi Niall, thx. My input message has what can be construed as a primary key indicated by a Long field

11/17/22

Fabien J, Niall Gallagher2

11/2/22

Hi, I work on this project sporadically. Some of my work on CQEngine is not publicly visible.

unread,

Hi, I work on this project sporadically. Some of my work on CQEngine is not publicly visible.

11/2/22

Kasia K, Niall Gallagher5

7/31/22

String comparison by SQL query

Great, it works! Thanks a lot Niall! niedziela, 31 lipca 2022 o 13:50:58 UTC+2 Niall napisał(a): Can

unread,

String comparison by SQL query

Great, it works! Thanks a lot Niall! niedziela, 31 lipca 2022 o 13:50:58 UTC+2 Niall napisał(a): Can

7/31/22

Clay Embry, Niall Gallagher7

9/2/21

Can't update objects in the index

Never mind. I found the deeply nested object in the Ticket fields that was, in fact, being mutated.

unread,

Can't update objects in the index

Never mind. I found the deeply nested object in the Ticket fields that was, in fact, being mutated.

9/2/21

8/5/21

Indexing and Querying Complex Object having MAP and List

Hi, I am having a complex object where want to retrieve object from collection met criteria bases on

unread,

Indexing and Querying Complex Object having MAP and List

Hi, I am having a complex object where want to retrieve object from collection met criteria bases on

8/5/21

gorgeousSuccessfulWealthy

7/21/21

[Novice Q] How to unpack anonymous Inner Class?

Good day lovely readers, I have not worked extensively with inner anonymous classes but I am trying

unread,

[Novice Q] How to unpack anonymous Inner Class?

Good day lovely readers, I have not worked extensively with inner anonymous classes but I am trying

7/21/21

Мария Клименко

4/11/20

How can I create IndexedCollection from ResultSet without iteration? Or retrieve() next Query on result of previous?

I want to perform several queries, each next on the result of the previous one. But it takes a lot of

unread,

How can I create IndexedCollection from ResultSet without iteration? Or retrieve() next Query on result of previous?

I want to perform several queries, each next on the result of the previous one. But it takes a lot of

4/11/20

Glen Lockhart, Niall Gallagher4

9/19/19

longest prefix match query

Niall, I have a working solution based on the pointers you sent me. But there are 2 issues with it

unread,

longest prefix match query

Niall, I have a working solution based on the pointers you sent me. But there are 2 issues with it

9/19/19

Ramesh M, Niall2

9/18/19

is cqengine very strict about additional open and close parentheses ?

Yes, unfortunately CQEngine is pretty strict about parentheses. The reason is that the SQL parser

unread,

is cqengine very strict about additional open and close parentheses ?

Yes, unfortunately CQEngine is pretty strict about parentheses. The reason is that the SQL parser

9/18/19

4/12/19

cqengine result set iteration is slow , taking 0.7sec to iterate 15k records on an average

Hi All, cqengine result set iteration is slow, taking 0.7sec to iterate 20k records on an average, is

unread,

cqengine result set iteration is slow , taking 0.7sec to iterate 15k records on an average

Hi All, cqengine result set iteration is slow, taking 0.7sec to iterate 20k records on an average, is

4/12/19

3/29/19

AttributeSourceGenerator to generate attributes for nested POJO's

Has anyone written or extend the AttributeSourceGenerator to generate attribute for nested POJO's

unread,

AttributeSourceGenerator to generate attributes for nested POJO's

Has anyone written or extend the AttributeSourceGenerator to generate attribute for nested POJO's

3/29/19

Athanasios Viennas, Niall Gallagher3

3/28/19

Ability to specify Join Queries predicates with custom type mappings instead

Hello, thank you very much for the follow up. I was almost certain that this would not be possible. I

unread,

Ability to specify Join Queries predicates with custom type mappings instead

Hello, thank you very much for the follow up. I was almost certain that this would not be possible. I

3/28/19

1/20/19

Results Deduplication for "in" queries

Hi, I just read the details about deduplication strategies (https://github.com/npgall/cqengine/blob/

unread,

Results Deduplication for "in" queries

Hi, I just read the details about deduplication strategies (https://github.com/npgall/cqengine/blob/

1/20/19

om...@illusivenetworks.com, Niall Gallagher4

1/7/19

Contains on ResultSet is too slow

For your second question, if you want to check if an object matches a query, it's usually more

unread,

Contains on ResultSet is too slow

For your second question, if you want to check if an object matches a query, it's usually more

1/7/19

Ramesh M, Niall Gallagher2

1/3/19

Nestled objects search using sql query is possible ?

Yes, that is possible. See this (and please upvote it!).. https://stackoverflow.com/questions/

unread,

Nestled objects search using sql query is possible ?

Yes, that is possible. See this (and please upvote it!).. https://stackoverflow.com/questions/

1/3/19

L1...@hotmail.de, Niall Gallagher2

12/11/18

Performance: CQEngine Vs. In-Memory-DB

In memory databases would be a direct competitor of CQEngine in a lot of cases. You can find some

unread,

Performance: CQEngine Vs. In-Memory-DB

In memory databases would be a direct competitor of CQEngine in a lot of cases. You can find some

12/11/18

Ramesh M, Niall Gallagher2

12/7/18

how to do case sensitive search using cq-engine SQL queries?

For case insensitive search, you don't need to modify data in your collection to be in a certain

unread,

how to do case sensitive search using cq-engine SQL queries?

For case insensitive search, you don't need to modify data in your collection to be in a certain

12/7/18

Marcin Kruglik, Niall3

12/5/18

Query for collection equality in MultiValueAttribute

Sorry for the delay. This is a good question. The best way to solve this is probably to define

unread,

Query for collection equality in MultiValueAttribute

Sorry for the delay. This is a good question. The best way to solve this is probably to define

12/5/18

Jonathan Baxter, Niall3

12/5/18

Quickest way to remove elements matching a query?

There is no special trick per-se to remove objects matching a query. For collections stored on-heap,

unread,

Quickest way to remove elements matching a query?

There is no special trick per-se to remove objects matching a query. For collections stored on-heap,

12/5/18

Venkat Pedapati, Niall2

12/5/18

Dropping indexes on CQEngine collections

No dropping is not supported i'm afraid. This is something which might be added in future via

unread,

IndexedCollection

Dropping indexes on CQEngine collections

No dropping is not supported i'm afraid. This is something which might be added in future via

12/5/18

Pavel Niedoba, Niall2

12/5/18

How to get first or last item from cqengine IndexedCollection with NavigableIndex

Sorry for the delay. I see you found a solution. Another alternative is in https://github.com/npgall/

unread,

IndexedCollection

How to get first or last item from cqengine IndexedCollection with NavigableIndex

Sorry for the delay. I see you found a solution. Another alternative is in https://github.com/npgall/

12/5/18

annda...@gmail.com, Niall Gallagher3

12/5/18

SQL EXISTS and exists-based JOIN

Thanks for confirming Niall! On Wednesday, December 5, 2018 at 2:56:19 PM UTC-7, Niall wrote: Neither

unread,

SQL EXISTS and exists-based JOIN

Thanks for confirming Niall! On Wednesday, December 5, 2018 at 2:56:19 PM UTC-7, Niall wrote: Neither

12/5/18

Lars Krog-Jensen, … Niall4

12/5/18

Sorry for the delay getting back to this -yes Java 9 is now supported in v3.0

unread,

Sorry for the delay getting back to this -yes Java 9 is now supported in v3.0

12/5/18

Search

Clear search

Close search

Google apps

Main menu