Database connections need to be managed properly. If we keep opening connections to a database without closing or releasing them (in the case of a connection pool), the database will soon stop responding.
There often comes the time when you have an existing database and you need to build a nice diagram to analyse it quickly. Here is how to do it using open-source software. We are going to be working on a Mac running macOS 10.14 Mojave, as well as an SQLite database.
I had an issue with install R on Ubuntu 16.04. Message was about some inability to install a dependency of the main R package.
Under the motto “With Data comes Responsibility”, the RDA 13th plenary at the beautiful city of Philadelphia.
Before writing your code, you should make sure that your python environment is easily portable to other machines. None of that “Works on my machine” nonsense!
If you administer servers, you know the importance of keeping your packages up to date for security concerns.
Here is a great recipe for cuttlefish, for those that like spicy food. With strong Portuguese roots, I added some oriental touches to give it an Asian twist, but without overdoing it.
A proxy cache server acts as an intermediary between your machine and the internet. Say, for example, you have two machines in your network, and a third machine that you want to dedicate to caching web content. Here is how to set it up on a Mac.
Here is how to enable htaccess overrides in a MAMP server for local development. This is useful to test PHP configurations where you want to use a
.htaccessfile to redirect all requests to a specific file, say, an
index.phpthat acts as a router, enabling you to use pretty URIs such as
/users/new, etc. for your PHP application.
A question from one of my students at the Languages and Web Technologies class at FEUP.
How to search for good references
Logging out a user in PHP, the right way.
Do you have messages like this?
Here is my short list of reasons why LaTeX is so much better than Microsoft Word for scientific writing.
How to install Semantic MediaWiki on Ubuntu 18.04 LTS
Tired of warning about locales in Ubuntu? Me too, and there is a fix.
The new beta of Mac OS X Mojave is mostly stable and so far it has been a good experience… Apart from the recent issues that i have faced with homebrew legacy libraries and this recent problem with Virtualbox, which loads a Kernel Extension that has not yet been approved by Apple.
Docker containers can be a great way to try out some scripts before they are ready for production. One of the basic tasks is to run a command in a specific container. Here is how to do it.
MySQL, ElasticSearch and OpenLink Virtuoso are all dependencies of our research data management platform, Dendro. Here is how we back up the databases.
How to check the size of a directory in linux, in human-readable form.
If, like me, you tried installing
imagemagickor other software using Homebrew, you might have ran into this error:
I just changed my 13’’ MacBook Pro Mid-2014’s battery. Its not easy, but not as hard as I initially thought. The trick is to remove the adhesive with some dental floss or fishing line. Fishing line is actually better because it is made up of a single nylon filament and will be more robust than the dental floss, which tends to break more easily.
SSH keys allow you to login into your SSH server without having to remember passwords and with much stronger security. It’s like having a super long password that you never have to remember… Just keep your private keys in a safe place.
This short guide shows you how to install and run a Jekyll blog in your Mac. Mojave broke some things for me in Homebrew, so this addresses some possible issues that you may also face.
subscribe via RSS