FOSDEM organizes each year one of the largest keysigning event for PGP keys. When we come back from a key signing party, what to do? Here a FAQ with some useful notes about how I sign the keys. Sign other keys Bad practice: don’t upload keys you’ve just signed to the PGP server At the […]
Read moreA Laravel command to run a SQL console à la Phabricator
Phabricator offers a bin/storage shell command. It allows to run the mysql client with the options from the application configuration. That’s useful in a modern distributed environment, when it’s not always straightforward to know what server contains what databases and what credentials to use. In a Docker container, for example, that could be a linked […]
Read moreMediaWiki now accepts out of the box RDFa and Microdata semantic markup
Since MediaWiki 1.16, the software has supported — as an option — RDFa and Microdata HTML semantic attributes. This commit, integrated to the next release on MediaWiki, 1.27, will embrace more the semantic Web making these attributes always available. If you wish to use it today, this is already available in our Git repository. This also simplify […]
Read moreDocker: nasqueron/nginx-php-fpm
Split a large SQL dump by database
You created a MySQL backup of a large server installation with dozens of databases and wish to get the schema and data for one of them. You now have to deal with a file of hundreds of MB in a text editor. How convenient. Split a dump into several files You can quickly split this […]
Read moreBitbucket won’t serve CNAME anymore, how to keep URLs working?
In the past, BitBucket allowed CNAME to use custom subdomains like hg.yourdomain.tld. But recently, Atlassian decided to remove this feature, You can drop the DNS record and update your documentation, but that will be a violation of Cool URIs don’t change and you can’t update paper documentation, bookmark from other users, etc. If you want to keep […]
Read moreDecember 2014 links
Some links of stuff I appreciated this month. Links to French content are in a separate post. You can also take the time machine to November 2014. AI What if instead to understand how the brain works, we copy the neural connections as is? This is what the OpenWorm project tries to do with C. […]
Read moreTCL and the SSL security issues: sslv3 alert handshake failure
Update 2016-01-15: With tcl-tls 1.6.7, it works out of the box without any need to configure cyphers. If you have reconfigured your OpenSSL to take care of the current security issues, you’ve disabled SSLv3 since POODLE discovery. Then, you could find unexpected behavior of TCL code. The package http isn’t the best to intercept and […]
Read moreHow to determine the SQLite filename from an open connection?
If the PHP SQLite3 class doesn’t provide a property or a method to return this information, SQLite engine has a PRAGMA statement to get or set internal data or modify the library behavior. PRAGMA database_list; It will returns a row with seq, name, file fields respectively containing a sequence id, the internal name of the […]
Read moreNasqueron landing page
Nasqueron is a collection of projects, so the homepage should allow to find a resource on one of these projects. The current prototype features a responsive background and a search widget. During development, it will be softly hidden by a landing page. The painting used as background is Aurora Borealis from Frederic Edwin Church, an […]
Read more