API

dbSQWare is the essential software for operating database engines to gain efficiency and autonomy!

Because thanks to its export and import APIs, dbSQWare promotes interactions with other management software.
For complete and comprehensive use of all this software.

2023 GRAND OPENING

This evening, a big digital evening at the Gare Maritime de la Major, in Marseille.
Medinsoft has chosen this remarkable location to organize its 2023 Grand Opening.

The dbSQWare team will be present at this exceptional event which delights us every year.

Very good evening to all participants!

COTER NUMÉRIQUE: Working group of 09/15/23

The COTER NUMERIQUE working group at thecamp (Aix-en-Provence) is today!
– at 9:00 a.m., it will be reception/coffee,
– at 9:30 a.m., a message from the President of CoTer Numérique, Antoine Trillard,
– then, between 9:45 a.m. and 12:15 p.m., 5 communities will intervene, each in turn, to provide 30 minutes of feedback (20 minutes of presentation, 10 minutes of questions/answers),
– and finally, from 12:15 p.m., all participants will gather around a lunch cocktail.

📣 📣 📣
At 11:30 a.m., Frédéric Lagarde from the city of Marseille will do his feedback. With a presentation which will focus on “the 360° vision and the maintenance of its DBMS fleet with dbSQWare”.
📣 📣 📣

Emmy, Séverine and Michel Payan will also be present.

Thank you to the city of Marseille for its participation and feedback during this unique event at the camp.
And a big congratulations to the organizers and speakers!

SUMMER

The dbSQWare team wishes you all a very happy summer 2023.

May it bring you all the energy and desire necessary for the successful realization of your personal and professional projects!

CANDLEMAS

Today is Candlemas!
The opportunity for pancake lovers to share a good moment of conviviality with colleagues, friends or family!

Enjoy yourself!!

THANK YOU

As the end of the year approaches, we would like to thank you, dear users, for your trust and loyalty!

dbSQWare has just celebrated its 15th anniversary and has therefore been installed by some of our historical customers.

THANK YOU for your interest, your involvement and your solicitation!

GEOGRAPHICAL DISTRIBUTION

Initially implemented exclusively in the Paris region, our software dbSQWare has since made its way.
It’s thanks to our users: their trust, loyalty and high standards.
The software is constantly evolving to meet customer needs.
This year, 6 patches have completed and enriched the 2022 version of dbSQWare.
The 7th will be released in a few days while waiting for the 2023 version…

Incontournable CIP Avignon

This evening, afterwork “Incontournable Avignon” organized by the CIP – Club Informatique Provence Méditerranée.

Our CEO, Michel Payan will give feedback on the use of design in software design. He will be accompanied by Aurélien Beguet from the Atrioom agency, with whom we collaborated during the redesign of the dbSQWare web interface.

Exchanges, conviviality and networking will be there.
Good Essential to all participants!

HOSPITAL CENTER

dbSQWare was chosen by one of the PACA region Hospital Centers to manage and maintain its databases.
With this new collaboration, a new sector of activity is opening its doors to us: health.

We are very pleased with this new mark of trust.

DBMS: Backups

– “By the way, what’s the point of making database backups? »

As its name suggests, a database is a structured collection of data. It consists of files in which the data is stored.
It is created and managed by a database management system (DBMS) which, among other things, allows data to be recorded, searched for, sorted and modified.

Data is at the heart of business activity. It is extremely valuable and its loss can be devastating when there is no copy.
This is why it is essential to make backups of the databases.

There are several types of backup:
– the “full backup”: all the files of a database are copied
– the “incremental backup”: only the blocks of files that have been modified since the last backup are copied
– the “log backup” (redo log, transaction log, wal or xlog): transaction log files are copied. These files are used to memorize all the modifications carried out on a database.

Backups can be made:
– cold: when the database is stopped
– or hot: when the database is active.

Once the backups have been made, it is then possible to recover the data if necessary.

And since trust does not exclude control, it is a good idea to check compliance with the backup policy on a daily basis across the entire database.