Monday, February 18

Tag: data integration

[Video] Data Integration with PostgreSQL

PostgreSQL, Shaun's PlanetPostgreSQL
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…)

Webinar: Data Integration With PostgreSQL [Follow Up]

Liaqat's PlanetPostgreSQL, Webinars
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. Below, (more…)

Untangling the PostgreSQL upgrade

pglogical, PostgreSQL
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. Point releases 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…)
Conference isn’t enough?!  Join us for post-conference training!

Conference isn’t enough?! Join us for post-conference training!

2ndQuadrant, International News
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…)
Keen on Kanban? The 5432…MeetUs! Conference can teach you everything you need to know!

Keen on Kanban? The 5432…MeetUs! Conference can teach you everything you need to know!

2ndQuadrant, International News
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…)