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.
|
1 |
<span class="pln">PRAGMA database_list</span><span class="pun">;</span> |
It will returns a row with seq, name, file fields respectively containing a sequence id, the internal name of the database […]
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 moreThimbl client – Tools
A quick note: I’ve prepared a small Thimbl client in PHP. The Finger client I wrote to read .plan file. Test it.
Read moreUse ssh-agent on Windows
ssh-agent is a part of OpenSSH to setup an agent. An agent is a piece of software to store the private keys in memory and ease agent forwarding. This is a requirement to painless SSH operations. Mark A. Hershberger explains here a popular way to configure ssh-agent on UNIX system. When you launch the agent […]
Read moreFreeBSD port update: devel/git-review
The devel/git-review port has been updated to the latest version. Changelog for git-review 1.23 Fix str(None) bug in port detection for hook setup Fix pep8 deps for pyflakes version conflict. Expand multiple commit submission warning. Changelog for git-review 1.22 Provide usage help even if not in Git directory Document defaultremote option & site/user configs Allow […]
Read more