フィードアグリゲーター

PHP 7.2.22 Released

php.net - 2019-08-30(金) 05:27:22
カテゴリー: php

Musings, ninja ones: Bearings

phpdeveloper.org - 2019-08-30(金) 04:00:02

Fig 1. Some BearingsThere is a lot of talk about the direction of PHP as a language, there have been discussions on internals and open letters from community bloggers ...I think, actually, there is rather a lot of confusion in the air, and so I'm seeking to cleanse that air with this post.FactionsA ...

カテゴリー: php

Derick Rethans: PHP Internals News: Episode 25: Security Management

phpdeveloper.org - 2019-08-30(金) 00:00:03
PHP Internals News: Episode 25: Security Management London, UK Thursday, August 29th 2019, 09:25 BST This episode of "PHP Internals News" is the second and last part of a longer conversation that I had with Stanislav Malyshev (GitHub, Linke...
カテゴリー: php

stitcher.io: re: re: A letter to the PHP team

phpdeveloper.org - 2019-08-29(木) 23:00:02

Thanks you Joe for taking the time to reply to my letter, I really appreciate it! I'll be happy to reply here. Your reply started by addressing the P++ shenanigans:

A lot of the discussion is based on an assertion made during the P++ discussion that there are two camps of developers

As a matt...

カテゴリー: php

PHP 7.3.9 Release Announcement

php.net - 2019-08-29(木) 20:55:58
カテゴリー: php

Granthana Biswas: pgBackRest to Backup PostgreSQL

planet postgresql - 2019-08-29(木) 16:30:01

pgBackRest is an open source backup tool for PostgreSQL which offers easy configuration and reliable backups. So if you want to protect your database and create backups easily, pgBackRest is a good solution to make that happen. In this blog, we are going to go through the basic steps of using pgBackRest for full and differential backup of PostgreSQL.

Some of the key features of pgBackRest are:

  1. Parallel backup & restore
  2. Local and remote operations
  3. Full, incremental & differential backups
  4. Backup rotation & archive expiration
  5. Backup integrity
  6. Page checksums
  7. Resume backups
  8. Streaming compression and checksums

 

To read about them more in detail, please visit pgbackrest.org.

Here, we are going to build pgBackRest from the source and install it on the host where a test DB cluster is running.

Installation:

Installing from Debian / Ubuntu packages:

sudo apt-get install pgbackrest

 

For manual installation, download the source on a build host. Please avoid building the source on a production server, as the tools required should not be installed on a production machine:

 

Download pgBackRest Version 2.14: sudo wget -q -O - \ https://github.com/pgbackrest/pgbackrest/archive/release/2.14.tar.gz | \ sudo tar zx -C /root Install the dependencies and check for 64-bit integers:

 

sudo apt-get install build-essential libssl-dev \ libxml2-dev libperl-dev zlib1g-dev perl -V | grep USE_64_BIT_INT

 

Build pgbackrest package: (cd /root/pgbackrest-release-2.14/src && ./configure) make -s -C /root/pgbackrest-release-2.14/src Copy from build host to DB host: sudo scp BUILD_HOST:/root/pgbackrest-release-2.14/src/pgbackrest /usr/bin/ sudo chmod 755 /usr/bin/pgbackrest Install Perl packages: sudo apt-get install libdbd-pg-perl pgBackRest config files & directories on DB test host: sudo mkdir -p -m 770 /var/log/pgbackrest sudo chown postgres:postgres /var/log/pgbackrest sudo mkdir -p /etc/pgb[...]
カテゴリー: postgresql

Jignesh Shah: Setting up PostgreSQL 12 Beta 3 for Testing in Amazon RDS

planet postgresql - 2019-08-29(木) 16:28:00
One of the amazing things about the PostgreSQL community is launching releases like clockwork. On 8/8/2019 the PostgreSQL community not only launched the minor versions for PostgreSQL 11 and old major versions but also a new Beta 3 version for upcoming PostgreSQL 12.

On AWS, you can check versions of PostgreSQL available in your region as follows:



$ aws rds describe-db-engine-versions --engine postgres --query 'DBEngineVersions[*].EngineVersion'
[
"9.3.12",
...
"11.2",
"11.4"
]


You will not see any beta versions out there. Pre-release versions for PostgreSQL in AWS  are available in the Preview Environment within US East 2 (Ohio).  If you are using the cli you have to add the region us-east-2 and also the url endpoint  rds-preview.us-east-2.amazonaws.com to your CLI commands.




$ aws rds describe-db-engine-versions --engine postgres \
--query 'DBEngineVersions[*].EngineVersion' \
--region us-east-2 --endpoint https://rds-preview.us-east-2.amazonaws.com
[
"12.20190617",
"12.20190806"
]


The versions displayed are bit cryptic but they denote the  major version followed by date  when the build was synced for the preview release. The version description will be more friendly to read than the version itself.




$ aws rds describe-db-engine-versions --engine postgres \
--query 'DBEngineVersions[*].DBEngineVersionDescription' \
--region us-east-2 --endpoint https://rds-preview.us-east-2.amazonaws.com
[
"PostgreSQL 12.20190617 (BETA2)",
"PostgreSQL 12.20190806 (BETA3)"
]


Lets deploy an instance of PostgreSQL 12 Beta 3 aka version 12.20190806.



$ aws rds create-db-instance \
--engine postgres --engine-version 12.20190806 --db-instance-identifier mypg12b3 \
--allocated-storage 100 --db-instance-class db.t2.small \
--db-name benchdb --master-username pgadmin --master-user-password SuperSecret \
--region us-east-2 --endpoint https://rds-preview.us-east-2.amazonaws[...]
カテゴリー: postgresql

PHP 7.2.22 Released

planet PHP - 2019-08-29(木) 09:00:00
The PHP development team announces the immediate availability of PHP 7.2.22. This is a security release which also contains several bug fixes.All PHP 7.2 users are encouraged to upgrade to this version.For source downloads of PHP 7.2.22 please visit our downloads page, Windows source and binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
カテゴリー: php

PHP 7.3.9 Release Announcement

planet PHP - 2019-08-29(木) 09:00:00
The PHP development team announces the immediate availability of PHP 7.3.9. This is a security release which also contains several bug fixes.All PHP 7.3 users are encouraged to upgrade to this version.For source downloads of PHP 7.3.9 please visit our downloads page, Windows source and binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
カテゴリー: php

Magnus Hagander: PGConf.EU 2019 - Schedule posted

planet postgresql - 2019-08-29(木) 04:01:35

We have now posted our schedule. There are a few session still remaining particularly on the sponsor tracks, but almost all other sessions have been scheduled. Of course, individual sessions are still subject to change in case of unforeseen circumstances.

Registration is still open, but selling fast so we recommend you secure your seats! One of our training sessions is sold out at this point, but the others have a few seats left.

カテゴリー: postgresql

Pine: Creating the @route Blade Directive

phpdeveloper.org - 2019-08-29(木) 01:00:02

Laravel offers a bunch of useful and handy directives that we can use in our templates. But easily, we can face a situation that we repeat some code in our blade files. In this case, it’s possible that we can refactor some code to its own directive.

Wrapping Helpers in Directives Laravel of...

カテゴリー: php

stitcher.io: A letter to the PHP team

phpdeveloper.org - 2019-08-29(木) 00:00:03

To whomever contributes to PHP, from a userland developer. Let me start by thanking those who actively work on the PHP project. Those who contribute to the core, extensions, maintain the docs or vote on RFCs: thank you for a language that I can use every day both in my professional and personal lif...

カテゴリー: php

Blog of Leonid Mamchenkov: PHP vs P++

phpdeveloper.org - 2019-08-28(水) 06:00:02

If you haven’t heard the news yet and are wondering what the heck P++ is, here’s a quick update for you. There’s been some noise around the idea of creating a separate dialect of PHP, code-named P++. The idea is an attempt to find a compromise between two different schools of though...

カテゴリー: php

Voices of the ElePHPant: Interview with Olivia Bisset

phpdeveloper.org - 2019-08-28(水) 05:00:02
@lemonadecode

Show Notes Olivia Bisset's Blog How Young People Can Build Big Ideas Using WordPress

Audio

This episode is sponsored by Using the WordPress REST API

The post Interview with Olivia Bisset appeared first on Voices of the ElePH...

カテゴリー: php

Paul Ramsey: Waiting for PostGIS 3: GEOS 3.8

planet postgresql - 2019-08-28(水) 04:54:57

While PostGIS includes lots of algorithms and functionality we have built ourselves, it also adds geospatial smarts to PostgreSQL by linking in specialized libraries to handle particular problems:

カテゴリー: postgresql

Webslesson: What Every PHP Developer Needs to Know About Cyber Security

phpdeveloper.org - 2019-08-28(水) 04:00:02

PHP which stands for Hypertext Preprocessor is a general-purpose programming language. According to W3techs Web Technology Surveys, at least 79% of websites of the web use PHP as the server-side programming language. In fact, it is way past Java, Ruby, and ASP.NET in market position as well. Althoug...

カテゴリー: php

Interview with Joe McGill

planet PHP - 2019-08-28(水) 03:02:00
カテゴリー: php

murze.be: ★ Supercharging common controllers

phpdeveloper.org - 2019-08-27(火) 23:30:02

From time to time our team needs to create fairly complicated CRUD interfaces from scratch. While this isn't rocket science, there surprisingly aren't that many good resource out there on how to do this. That's why our team dove in and published a couple of packages that can help create modern CRUD ...

カテゴリー: php

ページ