Just in case you missed the live broadcast, the video of my presentation below covers various topics around integration of PostgreSQL with other data sources and database technologies.
This presentation covers the following topics:
What is a Foreign Data Wrapper?
How to query MySQL, a Flat file, a Python script, a REST interface and a different Postgres Node
Perform all of the above simultaneously
Take snapshots of this data for fast access
Tweak remote systems for better performance
Package as an API for distribution
Stream to Kafka
Write data to... MongoDB!?
What does all of this have in common?
It's an exciting topic, and I hope more developers and admins begin to see Postgres as the global integration system it really is (more…)
Having a unified view when combining data from different sources is essential for every business. Whether you want to connect to a cloud application, import/export data to/from a text file, or sync data between your datasource and a 3rd party platform - having a database platform that provides a seamless and effective data integration process is critical.
This week on Tuesday, 13 February, 2ndQuadrant hosted the second webinar in their PostgreSQL webinar series. Principal Consultant, Shaun Thomas, conducted the webinar, covering various topics around integration of PostgreSQL with other data sources and database technologies.
The recording of the Webinar is now available. Those who couldn’t make it to the live session can now view Data Integration with PostgreSQL here.
PostgreSQL 9.6 has just been released and most of the postgres users will start asking themselves how to upgrade to the new major version. This post has the intention of showing different procedures for upgrading your PostgreSQL server.
Upgrading to a new major version is a task which has a high ratio of preparation over total execution time. Specifically when skipping a release in the middle, for example, when you jump from version 9.3 to version 9.5.
On the other hand, point release upgrades don't need as much preparation. Generally, the only requirement is for the postgres service to be restarted. There are no changes to the underlying data structure, so there's no need to dump and restore. In the worst case scenario you may need to recreate some of your indexes (more…)
Did you know - 2ndQuadrant has the largest single, collection of PostgreSQL experts of any company globally?!
With a team of some of the best known developers, they all still actively contribute to the progressive development of PostgreSQL. Would you like to have access to some of the most knowledgeable and experienced people available? The 5432...MeetUs! post-conference training is your chance!
In addition to the Kanban System Design training course with Dragos Dumitriu we mentioned last week, there will be a variety of other training courses in the days following the 5432...MeetUs! conference. When you attend a course with 2ndQuadrant, you learn from experts who understand PostgreSQL, the platforms, programs, and languages at the deepest level.
Learn in depth about the (more…)
Keynote speakers are always something everyone looks forward to at conferences. We're particularly looking forward to seeing Dragos Dumitriu team up with our very own Gabriele Bartolini at the 5432...MeetUs! conference in Milan, Italy June 28 and 29.
Dragos Dumitriu is an industry leader in the Agile community and renowned Kanban expert - helping to improve organisational efficiency in teams since 2004. 2ndQuadrant Italia has had a great friendship with Dragos since 2013 and will host him as a keynote speaker at the second edition of the 5432...MeetUs! conference. Dragos and Gabriele will discuss lean and Kanban in human enterprise environments, using 2ndQuadrant Italia as a live case study.
In addition to his talk, Dragos will host a certified Kanban training in the days after (more…)
The new feature version of pglogical is now available. The new release brings support for sequence replication, manually configured parallel subscriptions, replica triggers, numerous usability improvements and bug fixes. Let's look into the changes in more detail.
The release of PostgreSQL 9.5 is imminent so the time has come to analyse what’s new in this latest version.
A very interesting feature of version 9.5 is the ability to import a schema from a remote database, using Foreign Data Wrapper and the IMPORT FOREIGN SCHEMA command.