Timescale is addressing one of the largest challenges (and opportunities) in databases for years to come: helping developers, businesses, and society make sense of the data that humans and their machines are generating in copious amounts. 

TimescaleDB is the only open-source time-series database that natively supports full-SQL, combining the power, reliability, and ease-of-use of a relational database with the scalability typically seen in NoSQL systems. It is built on PostgreSQL and optimized for fast ingest and complex queries. TimescaleDB is deployed for powering mission-critical applications, including industrial data analysis, complex monitoring systems, operational data warehousing, financial risk management, and geospatial asset tracking across industries as varied as manufacturing, space, utilities, oil & gas, logistics, mining, ad tech, finance, telecom, and more. 

Timescale is backed by NEA, Benchmark, Icon Ventures, Redpoint Ventures, Two Sigma Ventures, and Tiger Global.

Documentation: https://docs.timescale.com
GitHub: https://github.com/timescale/timescaledb
Twitter: https://twitter.com/timescaledb

New Enterprise Associates

Two Sigma Ventures

Benchmark

Icon Ventures

Michael Walrath

Redpoint

Tiger Global Management

Timescale

We're Timescale, of course, we're going to tell you to watch this video and click the link below. 🚀👇
 https://tsdb.co/postgres

🤔 How does the BETWEEN operator simplify data filtering in PostgreSQL?

🐯🐘Timescale – Weekly PG Tips

Struggling with complex data filtering?

The BETWEEN operator in PostgreSQL offers a streamlined solution!

(But, there is a trap you need to watch out for 👀).

🔍💻 By using BETWEEN, you can specify a range of values directly in your WHERE clause, reducing the need for multiple conditions. 

⏳🎯 Check out this example:
sql
SELECT * FROM employees
WHERE salary BETWEEN 50000 AND 80000;

This query retrieves all employees with salaries >= $50,000 AND <= $80,000. 

But beware 😵💫, because the overlapping upper and lower bounds BETWEEN isn’t for every use-case.

In time-series data, you wouldn’t use it for a graph, because the upper and lower bound would be double plotted in adjacent time ranges.

🚀💡 Ready to simplify your SQL queries? 
Explore the power of the BETWEEN operator today! 💪🔑

(but watch out for the 🐉)

#Postgres #PostgreSQL #PostgresTips #SQL

📅 Join Jônatas Paganini's live session with the Timescale community in less than 1️⃣ 0️⃣ minutes! 🚀 

We'll be walking through the #finance framework and exploring why default choices matter. 📊 

Don't miss out on valuable insights for finance professionals and enthusiasts!

🌐 All events will be on Thursdays at 11:00 AM GMT-3. Check out the other upcoming sessions:
* Feb 29, 2024 - Hierarchical continuous aggregates for candlestick processing
* March 7, 2024 - Tracking last price and the trigger side effects
* March 14, 2024 - Tracking pair correlation
* March 21, 2024 - Downsampling techniques
* March 28, 2024 - Compression and side effects

🔗 Interested? Join our Slack community or DM us for more details: https://lnkd.in/deVTvUUB

Finance + Timescale + Jônatas Paganini -> bring it on 📈!

🧑💻 Introducing Weekly PostgreSQL Tips!

Every week, Doug Ortiz 🐘🐯 will share PostgreSQL insights and tips you won't want to miss.👇

🤔 Are your PostgreSQL queries running slower than expected? 
🚀 Boost their performance with a simple solution! 

By optimizing query performance with indexes, you can significantly enhance search speed. 

💡 Learn how to implement CREATE INDEX on frequently queried columns to unlock the full potential of your database. 

#PostgresTips #DatabasePerformance #PostgreSQL

Discover how to create a fast time-series graph with PostgreSQL materialized views.

Gain valuable insights on effectively visualizing and analyzing time-series data for real-time analytics. 👇

https://lnkd.in/g7_mxddZ 

#TimeSeries #PostgreSQL #DataAnalytics

Cool to see this OpenAI GPT that enables you to analyze 7M+ US court decisions to more easily find relevant court cases to your question. 

It's one of an increasing number of Legal AI applications being built with pgvector and Timescale Vector.

Long #PostgreSQL 🐘📈!

#legalai #vectordatabase #pgvector #gptstore #openai

🤨 Struggling with slow aggregated data in PostgreSQL? 

💡 Read about the challenges with data aggregation and how to overcome them using continuous aggregates. 

💪 Learn how to improve query response times with this incremental and automatically updated version of PostgreSQL materialized views. 

Check it out here 👉 https://tsdb.co/speed

#PostgreSQL #DataAggregation #ContinuousAggregate

Are you curious about time-series analysis and its practical applications? 

Explore the fundamentals, methodologies, examples and use cases of time-series analysis. 

Learn more ⬇️ 
https://lnkd.in/gBAsu_uq 

 #DataAnalysis #TimeSeries #DataInsights #PostgreSQL

🤔 Curious about the battle between Postgres TOAST and Timescale Compression? 

We conducted a comprehensive comparison to uncover the limitations of TOAST and showcased the power of Timescale's columnar compression. 

✨ Explore the findings and uncover how you can optimize your PostgreSQL database storage. 👇

https://tsdb.co/toast 

#DataManagement #TimescaleDB #PostgresSQL

InfluxData provides a time series platform that is purpose-built for real-time metrics, events, and other time-based data.

influxdata.com

Grafana offers open-source visualization and analytics software. It allows users to query, visualize, alert on, and understand metrics no matter where they are stored.

grafana.com

PostgreSQL is a powerful, open-source object-relational database system known for reliability, feature robustness, and performance.

postgresql.org

Stack Overflow is a question and answer site for professional and enthusiast programmers. It is a community-driven platform for sharing programming knowledge and expertise.

stackoverflow.com

Elasticsearch is a distributed, RESTful search and analytics engine capable of analyzing data that is updated in real time.

Elasticsearch

Prometheus is an open-source systems monitoring and alerting toolkit. It is designed for reliability, scalability, and fault-tolerance.

Prometheus

Timescale is a modern cloud platform built on PostgreSQL for time series, events, and analytics. It provides a time-series SQL database, TimescaleDB, which offers fast analytics, scalability, and automated data management on a proven storage engine.

news impact assignment basic	general	Mar 4, 2024 9:35 PM	de8d0e7d
public peers	general
news daily refresh	general	Sep 1, 2024 10:20 AM	5d0a9a54
news processing daily refresh	general
news impact assignment daily	general
news processing basic	general	Mar 4, 2024 9:35 PM	6b917e4b
company summary	general
signals	general
crunchbase trigger	general
crunchbase profile	general
li profile	general	Mar 4, 2024 9:35 PM	853031c5
translate crunchbase fundingrounds	general
peers	general
news basic	general	Mar 4, 2024 9:35 PM	283e6e52
bundesanzeiger	filings
merger acquisitions	company_analysis
financials download nd	financials
private financials	financials

COM:TIMESCALE

Timescale