[HN Gopher] pg_timeseries: Open-source time-series extension for...
       ___________________________________________________________________
        
       pg_timeseries: Open-source time-series extension for PostgreSQL
        
       Author : samaysharma
       Score  : 101 points
       Date   : 2024-05-20 16:44 UTC (6 hours ago)
        
 (HTM) web link (tembo.io)
 (TXT) w3m dump (tembo.io)
        
       | vantiro wrote:
       | PostgreSQL licensed, good move!
        
       | gxyt6gfy5t wrote:
       | How's it different than timescaledb?
        
         | logrot wrote:
         | > You may already be asking: "why not just power the stack
         | using TimescaleDB?" The Timescale License would restrict our
         | use of features such as compression, incremental materialized
         | views, and bottomless storage. With these missing, we felt that
         | what remained would not provide an adequate basis for our
         | customers' time-series needs. Therefore, we decided to build
         | our own PostgreSQL-licensed extension.
        
           | samaysharma wrote:
           | It's much newer for one, so it's behind on features. But,
           | we're working on adding new ones based on customer demand.
           | 
           | We want to build it with a PostgreSQL license using existing
           | community extensions as much as possible and build custom
           | stuff (still permissively licensed) only when necessary.
        
         | vantiro wrote:
         | Timescaledb's license is more like Redis' new license?
        
         | hosh wrote:
         | The use of postgresql licensing might mean we can see this
         | available for AWS RDS and other managed PostgreSQL providers.
        
       | riedel wrote:
       | >You may already be asking: "why not just power the stack using
       | TimescaleDB?" The Timescale License would restrict our use of
       | features such as compression, incremental materialized views, and
       | bottomless storage. With these missing, we felt that what
       | remained would not provide an adequate basis for our customers'
       | time-series needs. Therefore, we decided to build our own
       | PostgreSQL-licensed extension.
       | 
       | Have been using the free version timescaledb before to shard a
       | 500 Million observation time series database. Worked drop-in
       | without much hassle. Would have expected some benchmarks and
       | comparisons in the post. I will for sure watch this...
        
       | mathfailure wrote:
       | Thank you for posting it: I followed the links and found out
       | about trunk and https://pgt.dev/
        
       | ramoneguru wrote:
       | How does this stack up against something like what QuestDB
       | offers?
        
       | plainOldText wrote:
       | Your site is very well designed and easy to read btw, and the app
       | UI looks great from the demo photos. I might try it!
        
       ___________________________________________________________________
       (page generated 2024-05-20 23:00 UTC)