Notes

Organizing photos and videos using linux commands

linux

I have a nextcloud instance to backup personal data, and on my phone, I use the auto upload feature of the nextcloud app to save automatically all the pictures and videos I…

Methods to detect Critical Raw Materials in patents

patstat

data-science

For an ongoing research about Critical Raw Materials (CRM) and green technologies, we were trying to identify inventions that use CRM. Our first idea was to search for…

How to compute forward citations in PATSTAT

patstat

data-science

There are two types of patent forward citations in patstat: patent applications and patent publications (that’s why there are 2 steps below).

How to create pages from a bibtex file with Quarto

quarto

I have a bibtex file with all my publications downloaded for the journal websites, so it includes all the data available (title, authors, abstract, etc).

My personal website with Quarto

quarto

I finally decided to use Quarto for my personal website. It is an open-source scientific and technical publishing system built on Pandoc. It allows researchers to create…

Using git to update an application

git

linux

Imagine you are using an open source web application downloaded from internet, you did some modifications to it, and you are not controlling the changes with a VCS (I know…

Dump MySQL / MariaDB databases with one file per table

linux

mysql

I often use mysqldump to export databases with MySQL or MariaDB. But mysqldump has no option to dump a full database and write each table dump in a separate file, so I wrote…

How to connect to a VNC server in a remote local network (SSH tunneling)

linux

Imagine you need to remotely help somebody and you need to connect to his computer. You can use the very nice teamviewer (free for personal use and it works under mac osx…

How to monitor file access in linux (ubuntu 14.04)

linux

On my computer, the hard drive is the limiting factor for the overall speed/reaction of the OS. If a process is accessing a lot the hard drive, Gnome Shell starts to be…

How to resize partition of a virtualbox guest ubuntu server

linux

virtualbox

Like a lot of people, I use to click “next” without thinking… I installed an ubuntu server on a VirtualBox VM, and the assistant proposes 8 Gb for the size of the drive…