#query

#PHP Annotated – June 2022 | The PhpStorm Blog
▻https://blog.jetbrains.com/phpstorm/2022/06/php-annotated-june-2022

https://blog.jetbrains.com/wp-content/uploads/2022/06/php-annotated-blog-social-share-image-1280x720-1.png

Welcome to the June installment of PHP Annotated, where we’ll catch up on the most interesting things that have happened in the PHP world over the last month, including curated news, articles, tools, and videos.

Morceaux choisis...

▻https://github.com/php-fig/per-coding-style

PER Coding Style 1.0.0 is the same as PSR-12. This recommendation will now evolve much faster to keep up with all the new features that we’re getting in the PHP language.
Congratulations to the whole working group!

If you don’t know what a #PER is, it’s similar to a# PSR but it’s not set in stone, it’s meant to evolve rapidly over time, so the coding style is the perfect example where a PER is the best way to go.

▻https://github.com/minicli/minicli

A minimalist, dependency-free framework for building #CLI centric PHP applications.

▻https://github.com/crwlrsoft/url

A Swiss Army knife for URLs. It allows you to create, access, and manipulate #query_strings for HTTP requests very conveniently.

« Introduction to GraphQL » by GraphQL authors
▻https://graphql.org/learn
#graphql #query-language #schema-language #introduction

« An Overview of GraphQL » by Neo4j, William Lyon
Developer Relations Engineer
▻https://dzone.com/refcardz/an-overview-of-graphql
#graphql #schema-language #query-language #data-hub #overview #neo4j

marine/proxy.php at master · brunob/marine · GitHub
▻https://github.com/brunob/marine/blob/master/proxy.php

Script: Simple PHP Proxy: Get external HTML, JSON and more!

une alternative à l’intégration de contenus externes par iframe.
A interfacer avec le plugin Querypath ►https://contrib.spip.net/Query-Path pour manipuler à la volée le contenu récupéré

#proxy #php #json #iframe #querypath #contenu_distant

Wikidata Query Service

▻https://twitter.com/WikidataFacts/status/814075781957746689

https://pbs.twimg.com/media/C0wtN-9XgAAcngN.jpg:large

▻http://tinyurl.com/j2j3wp3

Minimisation de votre empreinte #Dns avec QNAME
▻http://www.dsfc.net/infrastructure/reseau/minimisation-de-votre-empreinte-dns-avec-qname

https://upload.wikimedia.org/wikipedia/commons/thumb/5/53/Pas_Sage_en_Seine_-_Day_3_%28cropped%29.jpg/330px-Pas_Sage_en_Seine_-_Day_3_%28cropped%29.jpg

Le cache DNS #Unbound vous permet désormais de diminuer votre empreinte DNS avec l’intégration de la RFC 7816, instituant le #Query_Name_Minimisation.

#Réseau #QNAME_Minimisation #Stéphane_Bortzmeyer

La recherche #Twitter au format #Rss
▻http://www.dsfc.net/internet/veille/twitter-search-in-rss

A la manière de Google qui a tué son service d’alertes, Twitter semblait vouloir limiter l’accès à ses services via RSS. TwittRSS ou #QueryFeed permettent de follower un compte Twitter via votre agrégateur RSS.

#Veille #Atom #Formateur_Veille #Twitter_2_RSS #Twitter_to_RSS #Twitter_Search #Recherche_Twitter #TwittRSS.me

#query() #spreadsheet returns extra header, can I remove it? - Forums des produits Google
▻https://productforums.google.com/forum/#!topic/docs/0CPyUKPSl5E

One tip: To go from direct column ids (A, B, C ) to relative column ids (Col1, Col2, Col3) use a conversion method like below. E.g. you have:

=QUERY( B2:D ; Select B, D, C “)
which you can convert to

=ArrayFormula( QUERY( ( B2:D ) ; Select Col1, Col3, Col2” ) )

Note that the latter notation makes the Select clause more portable, when the range you refer to (B2:D) moves (e.g. to become C2:E) the relative column ids in the Select clause stay valid.

#spreadsheet - #Google_Sheets: #QUERY using cell contents as SQL variables - Stack Overflow
▻http://stackoverflow.com/questions/26448028/google-sheets-query-using-cell-contents-as-sql-variables
▻http://cdn.sstatic.net/stackoverflow/img/apple-touch-icon@2.png?v=73d79a89bded&a

nstead of fixed strings such as ’ENQ’, you can have your formula refer to the index in column A of your output. For example, you could change your formula to this, in cell C4:

`
=QUERY($A$24:$D, “Select D Where B=’” & $A4 & “’ and A=’2/27/14 - Thu’”)
^^^^^^^

`

PHP Simple HTML DOM Parser
▻http://simplehtmldom.sourceforge.net/index.htm

Un parseur HTML écrit en PHP qui permer de manipuler du HTML facilement et en particulier retrouver des éléments avec des sélecteurs à la jQuery. Supporte le HTML invalide.
API avec nombreuses fonctions et options.

#php #parseur #api #simple_html_dom #html #manipulation #DOMDocument

Increase MySQL performance with query cache query_cache
▻http://go2linux.garron.me/query-cache-mysql-size-limit-tunning-hit-rate

utilisation du query_cache de MySQL : informations de base sur les paramètres et réglages.

#mysql #performance #paramétrage #optimisation #query_cache

Particletree » Logging MySql Queries on MAMP
►http://particletree.com/notebook/logging-mysql-queries-on-mamp

#MySQL #MAMP #slow #query #log