Services

Posted on January 1, 2021

Starting with 2016 S.C. MAGNA SOFTWARE S.R.L offers a variety of software services and solutions to clients world-wide.

For reference, see the details below. If you have any questions feel free to send an e-mail.

Contact details

Company name

S.C. MAGNA SOFTWARE S.R.L

Email:

stefan@garage-coding.com

stefan.petrea@gmail.com

Phone:

+40732070179

Stackoverflow:

link

Github:

link

Company registration number:

J40/4134/18.03.2016

Company tax number:

35831444

EU VAT ID:

RO42588403

Expertise

Databases

Both traditional RDBMS such as PostgreSQL, MySQL/MariaDB, SQLite and NoSQL solutions like Elasticsearch and Redis.

  • Analyzing, measuring and improving performance of existing SQL codebases

  • Backup planning and implementation

  • DR planning and implementation

  • Writing custom tools to analyze performance for a specific database

  • Monitoring

  • Support for production issues

Custom Software development

Designing, prototyping new software (in niche areas, sometimes involving non-mainstream technologies languages and frameworks), writing add-ons or plugins for existing software, customizing opensource software to fit requirements and solve business needs which in turn adds value to the client’s existing or new products.

Support for opensource software

Support for opensource software in the following situations:

  • outstanding/open bugs which you need fixed

  • opensource software that is insufficiently documented

  • fixing build pipelines of opensource software

  • reviewing existing opensource tools for a specific purpose and crafting a survey document of the tools available and their capabilities

  • other types of software maintenance related to opensource

Online data collection and scraping

Providing services related to automatic online data collection, writing scalable web scrapers and web spiders (using Scrapy, Splash or custom solutions)

Infrastructure

Services related to automating deployment and infrastructure creation in different cloud providers (AWS, Azure) and automation using Ansible and Terraform.

Creation, maintenance and support of CI/CD pipelines in Jenkins

Creation of software packages and setting up package repositories for Debian / Redhat / CentOS (deb and rpm packages). Designing and writing new Docker images as well as maintaining existing ones.

Setting up and configuring monitoring and dashboards for Nagios, Icinga2 or Prometheus/Grafana. Development of custom monitoring plugins, adapted to the client’s specific business needs.

Code Reviews

Manual code reviews as well as automatic code reviews using language-specific tools for the following languages: Perl, Python, Bash, C

Data visualization

Designing and preparing accurate data visualizations (charts, graphs, or other types of custom visualizations).

Scripting/ETL

Writing data processing pipelines in Python, Perl, Bash

Documentation

Technical writing services for the following types of documents:

  • software specifications

  • user documentation

  • software architecture diagrams

Opensource contributions

Many companies are making use of opensource software. S.C. MAGNA SOFTWARE S.R.L supports clients custom deployments and actively contributes to existing opensource software projects and modules, mainly database tools, mathematical software but also other areas:

typetechnologies usedlinksdate

optimization

Python3

link

2021-01-15

improved docs, tests

Python3

link ; link

2020-11-29

feature, improvement

Python3

link

2018-10-17

patch, feature

Elisp

link

2018-04-19

patch, bugfix

Ruby

link

2017-07-30

patch, feature

C

link

2017-07-16

patch + improvement

Java

link

2016-09-16

bugreport + reproducible test

Java

link

2014-11-10

patch,bugfix

C++

link

2014-05-06

patch,bugfix

Perl

link

2014-03-12

patch,bugfix

Perl

link

2013-08-13

patch,bugfix

Perl

link ; link

2013-08-12

patch,bugfix

Perl

link

2011-12-06

patch,improvement

Perl

link

2011-10-05

Opensource projects

projectdescription

mysqltotsv

Converts a MySQL dump to multiple TSV files, one for each table found

sitemap-range-fetch

Uses sitemaps to fetch news article links from a certain time range

fieldtop

Finds near-overflow columns in MySQL databases

parcel-cut

Module for land subdivision in geographic databases

imagemagick-identify-parser

Utility to extract image metadata and bring it to a format suitable for machine consumption