Technologies

I mainly use Free and Open Source Software by philosophy and pragmatism. I describe here the edifice towards which I have for the moment converged.

Main points :

• Centralising all the data in a single database makes it possible to make the company’s data coherent and accessible (the hunt for excel files)
• Database model should not be application oriented.
• The database is interfaced with web applications, which allows immediate use on the company’s desktops and/or remotely.

GNU / Linux ecosystem

Fell into it in 1996, I take over the administration of application servers if possible¹.

An architecture with two clone servers is proposed for the production environment, with master/slave replication in real time of the database. Backups are logged over several days, and all system settings are versioned. Deployments are based on Makefiles, and the test environment automatically updates itself with each update of the repository test branch.

PostGreSQL database

Normal form modelisation, installation, configuration, use and maintenance. Used since version 7.0, for models up to 300 tables, 600 req. /s.

PostGreSQL allows me to offer high-performance, reliable and scalable transactional systems. It is the most advanced relational database of the free-software world.

Python laguage, Django web development framework

Python is a language that allows you to develop quickly and cleanly. The Django web framework is in the same vein. Mainly intended to work with PostGreSQL, I was able to use it for high traffic websites and complex web applications. Modular by escence, the product has finally not evolved a lot in recent years and its initial credo, “the web framework for perfectionists with deadlines”, is still not usurped.

Angular framework

Angular is a Javascript framework written by Google that allows me to have:

• In combination with Django REST Framework, JavaScript code that exchanges with the server in json.
• A template language that communicates with this JavaScript data, allowing a complete separation between display and data.

Miscellaneous

Are listed here in bulk other tools that allow me to offer quality work and make my life easier!

• Apache couplé à NGINX to serve web,
• GNU Emacs the world per se,
• git to not saw off the branch,
• Magit which reconciles ergonomics and efficiency,
• GNU bash always close,
• GNU make, GNU sed and gawk because they’re getting forgotten.
• rsync that saves the world every night,
• LaTeX for wondefull PDF,
• Firefox, Wikipedia, two beautiful free and general public projects among others.