Timescale Tips: Migrate Your PostgreSQL Production Database Without Downtime
Database migration is one of the most painful steps for anyone managing a database. If you want to try a different approach to minimize downtime while migrating your PostgreSQL database, follow our step-by-step guide on the “ingest and backfill” method.
What Does a PostgreSQL Commitfest Manager Do and Should You Become One?
Having been a PostgreSQL Commitfest Manager earlier this year, Timescaler and PostgreSQL contributor, Jacob Champion, shares his recommendations for those who would like to take on the same role and explains what it entails.
What PostgreSQL Contributor Heikki Linnakangas Has to Say About the State of PostgreSQL 2022
PostgreSQL celebrates its 25th birthday this year. For a deeper look into its community, we asked PostgreSQL developer and committer Heikki Linnakangas to comment on the survey results of the newly released State of PostgreSQL 2022 report. Here’s what he had to say.
State of PostgreSQL 2022—13 Tools That Aren't psql
Performance and tooling are frequently debated in the State of PostgreSQL survey, and this year was no exception. With psql remaining the number one tool for querying and admin among PostgreSQL users, we decided to compile a list of tools— that aren’t psql—to broaden your options.
Using IoT Sensors, TimescaleDB, and Grafana to Control the Temperature of the Nuclear Fusion Experiment at the Max Planck Institute
Read how TimescaleDB and Grafana are helping ensure that the Wendelstein 7-X fusion reactor is cool enough for further experimentation by the Max Planck Institute for Plasma Physics team.
State of PostgreSQL: How to Contribute to PostgreSQL and the Community
Community contribution remains a recurrent theme in the State of PostgreSQL survey. As we prepare to release the full report later this month, we dig into some of the results and leave you tips on how to contribute to PostgreSQL and its community.
What Is SQL Used For? To Build Environments Where Devs Can Experiment
Nikolay Samokhvalov not only solves problems with SQL but also assists others in doing so. In this interview, he shares the coolest thing he did with SQL, how he is building environments where devs can experiment with SQL, and advice on keeping your knowledge up to date.
SQL Isn’t That Hard (When You Don’t Approach It From an Object-Oriented Point of View)
John Pruitt first learned SQL at university, but his first interaction with computers dates back to 1986 when he was only four. His one tip for learning SQL? Do not approach it from an object-oriented programming point of view.