フィードアグリゲーター

9.6.14

postgresql.org - 2019-06-20(木) 09:00:00
9.6.14 is the latest release in the 9.6 series.
カテゴリー: postgresql

9.5.18

postgresql.org - 2019-06-20(木) 09:00:00
9.5.18 is the latest release in the 9.5 series.
カテゴリー: postgresql

9.4.24

postgresql.org - 2019-06-20(木) 09:00:00
9.4.24 is the latest release in the 9.4 series.
カテゴリー: postgresql

stitcher.io: Typed properties in PHP

phpdeveloper.org - 2019-06-20(木) 06:30:01

Typed class properties have been added in PHP 7.4 and provide a major improvement to PHP's type system. These changes are fully opt-in and backwards compatible. In this post we'll look at the feature in-depth, but first let's start by summarising the most important points: They are available as o...

カテゴリー: php

Tomáš Votruba Blog: How to upgrade Meetup.com API to OAuth2 with Guzzle

phpdeveloper.org - 2019-06-20(木) 06:30:01

I got an email from Meetup.com 5 days ago, that basically every API request will be paid since August 15, 2019. $ 30/month, that's like my phone bill.

95 % of data on Friends Of Php depend on Meetup.com API - updated daily. The website is free, so it might kill the content or I'd have to mov...

カテゴリー: php

symfony Project Blog: SymfonyLive London 2019: workshop topics and complete conference schedule are available!

phpdeveloper.org - 2019-06-20(木) 06:30:01

The SymfonyLive London 2019 conference is coming in less than 3 months! The conference will be split into 2 days: Thursday September 12th is dedicated for the pre-conference workshop day and September 13th for the conference day. We offer several workshops on September 12th and we're very please...

カテゴリー: php

Pine: Generating Vue Files With Artisan Command

phpdeveloper.org - 2019-06-20(木) 06:30:01

In larger projects, often we find ourselves making new files – controllers, events, jobs and so on – as the project goes. For these classes, we have all the commands we need, however, if the project is front-end heavy we need to make the files manually. Let’s see how to make a generat...

カテゴリー: php

Interview with Woody Gilk

planet PHP - 2019-06-20(木) 05:31:00
カテゴリー: php

LaravelConf Taiwan 2019 announcement

php.net - 2019-06-19(水) 23:46:22
カテゴリー: php

PHP Architect: Serverless PHP With Bref, Part 2

planet PHP - 2019-06-19(水) 19:02:00

Part two of my article on using Serverless PHP using Bref has been published! In part one, I introduced Bref as we wrote a simple "Hello World" application.

Part follows this up exploring a more complete serverless application, my Project365 website. This S3 hosted static website is build using a serverless PHP function that connects to the Flickr API to retrieve my my one-photo-per-day images and present them on a single page per year. In the article I show how to use Bref to connect to a 3rd party API and use the AWS PHP SDK to update S3 and invalidate CloudFront caches.

The article is in the June 2019 issue of php[architect]. If you don't have a subscription, now may be a good time to take one out!

カテゴリー: php

php|architect: Serverless PHP, Array Functions, and Data Structures with Chris Tankersley

phpdeveloper.org - 2019-06-19(水) 05:00:02

In Episode 21 Eric, John, and Oscar are back post-php[tek] to discuss the June 2019 issue. Topics John and Oscar mention what they liked from speakers and sponsors at php[tek]. Eric’s experience with serverless application performance and thinking about when and where to use it. A function...

カテゴリー: php

PHP: Hypertext Preprocessor: PHP 7.4.0 alpha 1 Released

phpdeveloper.org - 2019-06-19(水) 05:00:02

PHP team is glad to announce the release of the first PHP 7.4.0 version, PHP 7.4.0 Alpha 1. This starts the PHP 7.4 release cycle, the rough outline of which is specified in the PHP Wiki. For source downloads of PHP 7.4.0 Alpha 1 please visit the download page. Please carefully test this version and...

カテゴリー: php

Delicious Brains: Switching to Windows for Local WordPress Development: Part 2

phpdeveloper.org - 2019-06-19(水) 01:30:02

Last year when I wrote about switching to Windows for local WordPress development, I hadn’t anticipated how much I would change in the weeks/months to follow. There were several things I wasn’t happy with in my development environment and general workflow – Local by Flywheel was slow,...

カテゴリー: php

Laravel News: Video: Dries Vints on Maintaining Laravel

phpdeveloper.org - 2019-06-19(水) 01:30:02
Have you ever wondered how the maintainers of Laravel manage the project? Dries Vints has created a video of him managing issues. The first part covers tips when you are posting new issues and the second part shows the actual issue handling. The p...
カテゴリー: php

431 Request Header Fields Too Large

planet PHP - 2019-06-19(水) 00:00:00

When a client sends a HTTP request with HTTP headers that are too big, a server can use 431 Request Headers Fields Too Large in response.

This response can be used if either the total size of all headers exceeded some limit, or if there are individual headers that are too big.

If a client sees a 431, it could hypothetically remove some headers and try again. The most obvious candidate for this could be removing cookies.

Example HTTP/1.1 431 Request Headers Too Large Content-Type text/html <h1>Too many cookies! Try to reduce your cookie footprint.</h1> References
カテゴリー: php

Technical Thoughts, Tutorials, and Musings: I was wrong about PSR-11

phpdeveloper.org - 2019-06-18(火) 23:30:01
I was wrong about PSR-11 Submitted by Larry

on 15 June 2019 - 2:43pm

Back in January 2017, the PHP Framework Interoperability Group (FIG) reviewed and passed PSR-11, the "Container...
カテゴリー: php

murze.be: A Look At PHP’s isset()

phpdeveloper.org - 2019-06-18(火) 23:30:01

Liam Hammet wrote a good blogpost on the isset language construct.

Let’s take a look through how isset behaves and what’s so special about it. Even if you’re a veteran PHP developer, hopefully, you’ll pick up something new here.

カテゴリー: php

Interview with Allan MacGregor

planet PHP - 2019-06-18(火) 22:07:00

@allanmacgregor Show Notes Audio This episode is sponsored by
Day Camp 4 Developers:Data

The post Interview with Allan MacGregor appeared first on Voices of the ElePHPant.

カテゴリー: php

Hubert 'depesz' Lubaczewski: Changes on explain.depesz.com

planet postgresql - 2019-06-18(火) 20:54:00
Recently got two bug reports: plans with “COSTS OFF" do not parse, and error out (bugreport by Marc Dean Jr) WorkTable Scan is not properly parsed (bugreport by Ivan Vergiliev) Additionally, I was kinda upset because plans that include trigger calls did not display properly. All of this has been fixed today: First, I fixed … Continue reading "Changes on explain.depesz.com"
カテゴリー: postgresql

Granthana Biswas: Install PostgreSQL 9.6 with Transparent Data Encryption

planet postgresql - 2019-06-18(火) 17:00:14
Cluster encryption can be used if the DBA can not or does not rely on the file system in terms of confidentiality. If this feature is enabled, PostgreSQL encrypts data  (both relations and write-ahead log) when writing to disk, and decrypts it when reading. The encryption is transparent, so the applications see no difference between the encrypted and unencrypted clusters.

PostgreSQL 9.6 with TDE on Ubuntu

In this blog, we go through the basic steps used to install PostgreSQL 9.6 with Transparent Data Encryption (TDE) on Ubuntu. You can download the patch for this here.

Create data directory for PostgreSQL: Just for example, I am creating it at the default location:

 

sudo mkdir -p /usr/local/pgsql/data
sudo chown postgres:postgres /usr/local/pgsql/data

Install the libraries for readline, bison, flex, openssl, zlib and crypto:

 

sudo apt-get install libreadline8 libreadline-dev zlibc zlib1g-dev bison flex libssl-dev openssl

Run configure from the source code directory:

You can choose where all files will be installed by passing --prefix. Default is /usr/local/pgsql which I am using here for example. Make sure you enable openssl by passing --with-openssl:

 

sudo ./configure --prefix=/usr/local/pgsql --with-openssl
sudo make

 

The above two commands should run without errors. Now we are ready to install:

 

sudo make install

 

We can now proceed to initialize the cluster. For that, let’s switch to the postgres user:

 

sudo su - postgres

As a good practice, lets add the PostgreSQL binaries to PATH:

 

export PATH=$PATH:/usr/local/pgsql/bin

To create encrypted cluster, use the -K option to pass the initdb utility. For example:

 

initdb -D /usr/local/pgsql/data -K/usr/local/pgsql/keypass

 

Here /usr/local/pgsql/keypass is an executable file that returns either encryption key or encryption password with the appropriate prefix. In this case, we are passing the encryption_password in 8-16 characters in a simple executable file which outputs: 

 

encryption_password=<8-16_passphrase>

$ chmod 755 /usr/local/pgsql/keypass
$ c

[...]
カテゴリー: postgresql

ページ