FrenchTech SAAS
33.5K views | +1 today
FrenchTech SAAS
Les news de l'univers SAAS et FrenchTech
Curated by Mickael Ruau
Your new post is loading...
Your new post is loading...

Popular Tags

Scooped by Mickael Ruau
June 1, 2021 3:19 AM
Scoop.it!

Is a Session Analyzer a Good Tool to Simulate Real Traffic?

Is a Session Analyzer a Good Tool to Simulate Real Traffic? | FrenchTech SAAS | Scoop.it
My idea is simple; use the slow query log to get a usable template script of workload to simulate real database traffic.
No comment yet.
Scooped by Mickael Ruau
June 1, 2021 3:18 AM
Scoop.it!

Infinitely Scalable Storage with High Compression Feature

Infinitely Scalable Storage with High Compression Feature | FrenchTech SAAS | Scoop.it
Today, the Percona Innovation Team, which is part of the Engineering organization, is proud to announce a new feature - High Compression.
No comment yet.
Scooped by Mickael Ruau
June 1, 2021 3:17 AM
Scoop.it!

MySQL 101: Basic MySQL Server Triage

MySQL 101: Basic MySQL Server Triage | FrenchTech SAAS | Scoop.it
So your MySQL server has crashed.  What do you do now?
No comment yet.
Scooped by Mickael Ruau
May 27, 2021 3:57 AM
Scoop.it!

Le DataXDay revient le 24 juin prochain !

Le DataXDay revient le 24 juin prochain ! | FrenchTech SAAS | Scoop.it
Le DataXDay rassemble depuis plusieurs années déjà une communauté de plus en plus grande de “data lovers”  souhaitant échanger et partager sur leur univers.
No comment yet.
Scooped by Mickael Ruau
May 25, 2021 2:19 AM
Scoop.it!

Easily Validate Configuration Settings in MySQL 8

Easily Validate Configuration Settings in MySQL 8 | FrenchTech SAAS | Scoop.it
As of MySQL 8.0.16, there is now a 'validate-config' option to quickly test and validate server configuration options without having to start the server.
No comment yet.
Scooped by Mickael Ruau
May 20, 2021 3:18 AM
Scoop.it!

InnoDB File Growth Weirdness

InnoDB File Growth Weirdness | FrenchTech SAAS | Scoop.it
Space allocation in InnoDB tablespace is not as intuitive as one could think. A significant amount of reserved space must be considered.
No comment yet.
Scooped by Mickael Ruau
May 12, 2021 3:34 AM
Scoop.it!

Point-in-Time Recovery for MongoDB on Kubernetes

Point-in-Time Recovery for MongoDB on Kubernetes | FrenchTech SAAS | Scoop.it
In the latest 1.8.0 version, we add a feature that implements Point-in-time recovery, allowing users to store Oplog on an external S3 bucket and perform recovery to a specific date and time.
No comment yet.
Scooped by Mickael Ruau
April 28, 2021 10:59 AM
Scoop.it!

RGPD : précisions sur la protection du NIR des salariés | SVP SIRH

RGPD : précisions sur la protection du NIR des salariés | SVP SIRH | FrenchTech SAAS | Scoop.it
Données personnelles - répertoire national d'identification des personnes physiques : précisions sur la mise en œuvre de traitements comportant l'utilisation ou la consultation du numéro d'inscription au répertoire national d'identification des personnes physiques.
No comment yet.
Scooped by Mickael Ruau
April 28, 2021 3:36 AM
Scoop.it!

eMag: Modern Data Engineering

eMag: Modern Data Engineering | FrenchTech SAAS | Scoop.it
Data engineers and software architects will benefit from the guidance of the experts in this eMag as they discuss various aspects of breaking down traditional silos that defined where data lived, how data systems were built and managed, and how data flows in and out of the system.
Mickael Ruau's insight:
  • The Future of Data Engineering - Chris Riccomini examines the current and future states of the art in data pipelines, data streaming, and data warehousing. He presents a six-stage evolution that data ecosystems follow from simple monolith to a complex data-microwarehouse architecture as the data engineers who manage them solve problems and clarify their roles as infrastructure engineers rather than data stewards.
  • Beyond the Database, and beyond the Stream Processor: What's the Next Step for Data Management? -  Databases have been around forever with the same shape: you make a request to your data and then you receive an answer. Now, stream processors came along with a different approach: data isn’t locked up, it is in motion. Understand how stream processors and databases relate and why there is an emerging new category of databases that focus on data that stays in place as well as data that moves.
  • Data Gateways in the Cloud Native Era - Data Gateways act like API Gateways but focus on access to the data aspect. A Data Gateway offers abstractions, security, scaling, federation, and contract-driven development features. There are many types of Data Gateways, from the traditional data virtualization technologies, to light GraphQL translators, cloud-hosted services, connection pools, and fully open source alternatives.
  • Combining DataOps and DevOps: Scale at Speed - DataOps is an extension of DevOps standards and processes into the data analytics world. It's about streamlining the processes involved in processing, analyzing and deriving value from big data.
No comment yet.
Scooped by Mickael Ruau
April 27, 2021 3:29 AM
Scoop.it!

Datalog - Wikipedia

Datalog - Wikipedia

Datalog is a declarative logic programming language that syntactically is a subset of Prolog. It is often used as a query language for deductive databases. In recent years, Datalog has found new application in data integration, information extraction, networking, program analysis, security, cloud computing and machine learning.

No comment yet.
Scooped by Mickael Ruau
April 12, 2021 7:25 AM
Scoop.it!

yEd - Graph Editor

yEd - Graph Editor | FrenchTech SAAS | Scoop.it
yEd is a free desktop application to quickly create, import, edit, and automatically arrange diagrams. It runs on Windows, macOS, and Unix/Linux.
No comment yet.
Scooped by Mickael Ruau
April 8, 2021 8:03 AM
Scoop.it!

RelaxNG [Introduction à XML : principes, syntaxe, schémas et manipulations]

Regular Language for XML Next Generation

RelaxNG (REgular LAnguage for XML Next Generation) est un langage de schéma XML.

  • RelaxNG est une alternative aux DTD et à W3C XML Schema, qui combine les avantages de ces deux autres langages.

  • RelaxNG est un standard OASIS et une norme ISO/CEI.

  • Deux syntaxes : une syntaxe XML (alternative à W3C Schema) et une syntaxe compacte (alternative aux DTD).

  • RelaxNG ne définit que la structure (comme les DTD) et utilise W3C XML Schema pour le typage des données.

http://relaxng.org/

Mickael Ruau's insight:

Exemple de schémas publics définis en Relax NG

  • OpenDocument (format bureautique)

  • DocBook (format documentaire)

  • Atom (syndication)

No comment yet.
Scooped by Mickael Ruau
April 5, 2021 8:01 AM
Scoop.it!

Syntaxe XML et espaces [Introduction à XML : principes, syntaxe, schémas et manipulations]

Espaces conservés

Par défaut, un programme doit considérer que tous les espaces sont signifiants et doivent être conservés lors des traitements.

Remarque : Équivalence entre séparateurs

XML considère comme équivalents les caractères de séparation :

  • Espace ' '

  • Tabulation \t

  • Retour chariot \r

  • Fin de ligne \n

No comment yet.
Scooped by Mickael Ruau
June 1, 2021 3:19 AM
Scoop.it!

Importing an Encrypted InnoDB Tablespace into MySQL

Importing an Encrypted InnoDB Tablespace into MySQL | FrenchTech SAAS | Scoop.it
Transportable tablespaces were introduced in MySQL 5.6 for copying a tablespace to a server. Here's how to use this feature with encrypted tablespaces.
No comment yet.
Scooped by Mickael Ruau
June 1, 2021 3:18 AM
Scoop.it!

Which Version of MySQL Should I Use for MyRocks?

Which Version of MySQL Should I Use for MyRocks? | FrenchTech SAAS | Scoop.it
MyRocks is gaining interest as an alternative storage engine to the traditional InnoDB, but which version of MySQL is the best to use it with?
No comment yet.
Scooped by Mickael Ruau
June 1, 2021 3:17 AM
Scoop.it!

How InnoDB Handles TEXT/BLOB Columns

How InnoDB Handles TEXT/BLOB Columns | FrenchTech SAAS | Scoop.it
Discover how InnoDB stores TEXT/BLOB columns using simple common tools and better understand the performance implications of these types.
No comment yet.
Scooped by Mickael Ruau
May 26, 2021 9:25 AM
Scoop.it!

MongoDB Tuning Anti-Patterns: How Tuning Memory Can Make Things Much Worse

MongoDB Tuning Anti-Patterns: How Tuning Memory Can Make Things Much Worse | FrenchTech SAAS | Scoop.it
How MongoDB uses memory and how to avoid potentially disastrous mistakes when using MongoDB.
No comment yet.
Scooped by Mickael Ruau
May 20, 2021 3:46 AM
Scoop.it!

MySQL 101: 10 Great MySQL DBA Interview Questions (and Answers)

MySQL 101: 10 Great MySQL DBA Interview Questions (and Answers) | FrenchTech SAAS | Scoop.it
How do you find great DBAs? Here are 10 great MySQL DBA interview questions to ask when looking...
No comment yet.
Scooped by Mickael Ruau
May 12, 2021 3:36 AM
Scoop.it!

Want MongoDB Performance? You Will Need to Add and Remove Indexes!

Want MongoDB Performance? You Will Need to Add and Remove Indexes! | FrenchTech SAAS | Scoop.it
Talking about MongoDB performance, having too many indexes, and finding both duplicate and unused indexes.
No comment yet.
Scooped by Mickael Ruau
April 30, 2021 10:49 AM
Scoop.it!

Spooling Queries With Results in PSQL - DZone Database

Spooling Queries With Results in PSQL - DZone Database | FrenchTech SAAS | Scoop.it

Click here to edit the content

Mickael Ruau's insight:

Comment envoyer les résultats d'un requête vers un fichier avec la commande spool.

No comment yet.
Scooped by Mickael Ruau
April 28, 2021 3:46 AM
Scoop.it!

Back From a Long Sleep, MyDumper Lives!

Back From a Long Sleep, MyDumper Lives! | FrenchTech SAAS | Scoop.it
MyDumper is an open source, community-managed tool for handling logical backups and restores with all flavors of MySQL.
No comment yet.
Scooped by Mickael Ruau
April 27, 2021 3:33 AM
Scoop.it!

Google Logica Aims to Make SQL Queries More Reusable and Readable

Logica is a Datalog-like declarative logic programming language for database querying. It supports the creation of reusable abstractions to build complex queries and compiles to SQL, thus making it suitable for wide application.
Mickael Ruau's insight:

Coming from Google, Logica is well integrated with its BigQuery database. Here is a short example of Logica syntax showing how you can use BigQuery to select popular baby names:

# Connecting predicate to a table. BabyNames(..r) :- `bigquery-public-data.usa_names.usa_1910_current`(..r); # Extracting an arbitrary sample from the table. @Limit(BabyNamesSample, 11); BabyNamesSample(..r) :- BabyNames(..r); NameCountByYear(name: , year:) += number :- BabyNames(name:, year:, number:); # Finding most popular name for each year. @OrderBy(TopNameByYear, "year"); TopNameByYear(year) ArgMax= name -> NameCountByYear(name:, year:);

Logica's syntax is strongly informed by Datalog's, hence Prolog's, which can make it appear rather abstruse. According to Tretyakov and Skvortsov, though, it can be a good option if you use complex SQL queries that end up being scarcely readable and would like to express them in a more manageable way. It must be noticed, though, that SQL is not just a query definition language, since it also includes data manipulation features to create new data properties, such as adding columns to a table, creating new tables, and so on.

No comment yet.
Scooped by Mickael Ruau
April 15, 2021 1:33 AM
Scoop.it!

Replay the Execution of MySQL With RR (Record and Replay)

Replay the Execution of MySQL With RR (Record and Replay) | FrenchTech SAAS | Scoop.it
Record and Replay lets us record the execution of a MySQL program, allowing it to be replayed over and over to produce the same result.
No comment yet.
Scooped by Mickael Ruau
April 8, 2021 9:11 AM
Scoop.it!

Outils XML pour Notepad++

Outils XML pour Notepad++ | FrenchTech SAAS | Scoop.it
Outils XML pour Notepad++
Mickael Ruau's insight:

Éditeur de texte indispensable pour tout développeur sous Windows, Notepad++ possède un plugin XML Tools basé sur la libXML. Ce plugin ne prétend pas remplacer XMLSpy mais est bien suffisant pour de nombreuses tâches courantes. Le fait qu'il soit intégré à Notepad++ évite de lancer un autre logiciel alors que celui-ci est toujours actif.

No comment yet.
Scooped by Mickael Ruau
April 6, 2021 8:02 AM
Scoop.it!

W3C XML Schema [Introduction à XML : principes, syntaxe, schémas et manipulations]

Les XML Schema ont été proposés par le W3C pour permettre de dépasser les limites des DTD.

http://www.w3.org/XML/Schema

On notera en particulier :

  • une syntaxe XML

  • l'extension de l'expression des règles d'organisation structurelle (héritage, réutilisation, etc.)

  • l'ajout d'un langage de typage des éléments (particulièrement utile pour les format XML orientés données)

No comment yet.