Tag: PostgreSQL

Feed: Planet PostgreSQL. Recently there were some complaints about the behaviour of the jsonb_set function. Specifically, the complain was that if the value argument of the function is null the result is null. This happens because the function is declared STRICT, like many PostgreSQL functions. STRICT is in fact another way of spelling RETURNS NULL ON NULL INPUT.There are numerous advantages to having functions with this behaviour. It makes the code simpler and thus more efficient if it doesn’t have to worry about NULL arguments, and can just assume that they are not NULL. This function has been in PostgreSQL ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Fahad Zaidi. Having spent the better part of the last decade helping organisations in the U.S. and the U.K. use data to drive profit, efficiency, and performance improvements, I thought it would be helpful to jot down best practices for organizations that are looking to get the most value out of their enterprise-level financial and operational data sets. Every organisation entering the roaring 20s knows that they must use their data as a strategic differentiator to gain a competitive advantage and this article lists five things all companies must do to ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; I have run out of superlatives to try to express how excited I am about this release, so I'll just put it out there: The Puppet 5 Platform is available for download now.As you may remember, we wrote about the upcoming release of Puppet 5 last month. As we said in that blog post, the primary goals of this release are:To standardize the version numbering of all the major Puppet components (Puppet Agent, PuppetDB, Puppet Server) to 5, as a first step towards delivering these components as a unified platform.To include Hiera 5 ... Read More

Feed: Planet PostgreSQL. Python 2 has officially completed its life as of Jan 1st, 2020 and the Python 2.x branch will not be maintained anymore. You might be seeing repeated notices of deprecation in log files and terminals like: DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date.DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date.Python 2 had a wonderful life, coming from a ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; Whether you’re edging toward a full DevOps initiative or simply looking for ways to better communicate and collaborate across functions, you and your IT organization can take advantage of a wide variety of free and proprietary DevOps tools to help you along.DevOps tools are those that promote sharing and collaboration, and they're so widely used, you may already be familiar with some of the ones described below. The key to expanding DevOps culture and practices is to think about how they might be used beyond your IT department, and shared in new ways ... Read More

Feed: Planet PostgreSQL. pg_sleep() itself is used to stop the execution (as example of a file with SQL commands) for the specified amount of seconds. The number of seconds can be specified as fraction. postgres=# timing Timing is on. postgres=# SELECT pg_sleep(2.5); pg_sleep ---------- (1 row) Time: 2508,399 ms (00:02,508) Works quite well, the execution time is almost exactly 2.5 seconds. That is useful for short delays. But what when the waiting time is supposed to be longer? Or the execution shall wait until a specific time? Using pg_sleep() only, one has to calculate the number of seconds. pg_sleep_for() uses ... Read More

Feed: Planet PostgreSQL. As I get ready for the PgDay San Francisco event that is happening next Tue 21 January—a one-day, single-track Postgres community event at the awesome Swedish American Hall in SF—I’m reflecting a bit on how important the speakers are to developer events. Let’s face it, without speakers, there would be no conference. And because I was on the PgDaySF talk selection committee, I’ve had some good conversations these last few months about CFPs, conference talks, how talk selection committees work, and how you can improve your chances at getting your proposals accepted. So I thought it would ... Read More

Feed: Planet PostgreSQL. It's every developer's nightmare: SQL queries that get large and unwieldy. This can happen fairly quickly with the addition of multiple joins, a subquery and some complicated filtering logic. I have personally seen queries grow to nearly one hundred lines long in both the financial services and health industries.Luckily Postgres provides two ways to encapsulate large queries: Views and Materialized Views. In this article, we will cover in detail how to utilize both views and materialized views within Ruby on Rails, and we can even take a look at creating and modifying them with database migrations. Our ... Read More

Feed: Planet PostgreSQL. Andreas 'ads' ScherbaumThe PostgreSQL Project is present with a booth at FOSDEM ever since 2007. Since 2008 we organize a Devroom, since 2013 we have our own PGDay on the Friday before FOSDEM. This year marks the 8th FOSDEM PGDay. This blog post presents useful information about the PGDay, the booth and Devroom at FOSDEM. When does the PGDay take place, and can I still attend? This year's FOSDEM PGDay takes place in the Hilton Brussels Grand Place. This is a single day, single track event with PostgreSQL talks. A registration is required, the event still has a few ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; Things are heating up on the Puppet Forge this month! Lots of releases in the last 30 days, and a few of them quite noteworthy. (Also, did you know you can subscribe to modules to get notified of new releases? Now you do.)puppetlabs-postgresql 4.9.0A long awaited release is finally here! It includes bug fixes and features like the ability to grant permissions on procedural languages, and the notion of modifying ownership of databases and schemas, both at time of creation and any time after. puppetlabs-ntp 6.1.0Say hello to phase 1 of the first ... Read More