Questions tagged [pipelinedb]

Questions related to PipelineDB - A PostgreSQL extension for high-performance time-series aggregation

51 questions
0
votes
1 answer

How to create continuous views for leaderboards?

I have a set of events coming in with the structure player_id, score, timestamp. I want to create cycle based leaderboards on this so that I can see the players daily, weekly, monthly and yearly leaderboards. What kind of aggregations should I use.…
user1124403
0
votes
1 answer

pipelinedb aggregates in where clause

Im am using pipelinedb for testing some analysis of data streams from sensors. I want to be able, as an example, to find events in a stream that are defined by an aggregate. E.g. find events where the difference between max(temperature) and…
Pemburu
  • 1
  • 2
-1
votes
1 answer

What happens to postgreSQL when I install pipelineDB extension?

I would like to compare pipelineDB and PostgreSQL. Reading the documentation, I found out that pipelineDB is the extension of PostgreSQL. Then I'm getting curious : What am I have to do with PostgreSQL to compare pipelineDB? Does system regards…
Sumin Son
  • 19
  • 1
-1
votes
1 answer

pipelinedb Continuous Views xxx_mrel NUMERIC to bytea?

enter image description hereI ran into a problem with pipelinedb. There is a NUMERIC type field in the Continuous Views I built, but the mrel table generated in pipelinedb is bytea. Why is this? Have you met? There is a good solution. Thank you Here…
-1
votes
1 answer

How to Upgrade version pipelinedb

Upgrade version pipelinedb What the last version of the extension kafka for pipelinedb ? How to download the last version. I use version 0.9.3
valdir
  • 1
  • 2
-1
votes
1 answer

how to send message to kafka producer using pipelindb?

I am learning kafka and pipelinedb and I got across the following statements, how to send message to kafka producer using pipelindb? Do you have a example?
1 2 3
4