When a relational database is not the right tool: document, key-value and graph stores, how they are operated, how to model data for them and when they belong next to a relational engine.
By Franck Pachot . NoSQL provides an API that is much simpler than SQL. And one advantage of it is that users cannot exceed a defined amount of resources in one call. You can read this in Alex DeBrie article https://www.alexdebrie.com/posts/dynamodb-no-bad-queries/#relational-queries-are-unbounded which I take as a base for some of my “Myth of NoSQL vs RDBMS” posts because he explains…
By Franck Pachot . J’essaie quelque chose de nouveau. Je publie beaucoup en anglais (blog, articles, présentations) mais cette fois quelque chose de 100% francophone. En sortant du confinement, on reprend les transports (train, voiture,…) et c’est l’occasion de se détendre en musique mais aussi de s’informer avec des podcasts. J’ai l’impression que c’est un format qui a de l’avenir:…
By Franck Pachot . I’ll reference Alex DeBrie article “SQL, NoSQL, and Scale: How DynamoDB scales where relational databases don’t“, especially the paragraph about “Why relational databases don’t scale”. But I want to make clear that my post here is not against this article, but against a very common myth that even precedes NoSQL databases. Actually, I’m taking this article…
By Franck Pachot . There are good reasons for NoSQL and semi-structured databases. And there are also many mistakes and myths. If people move from RDBMS to NoSQL because of wrong reasons, they will have a bad experience and this finally deserves NoSQL reputation. Those myths were settled by some database newbies who didn’t learn SQL and relational databases. And,…
Today I participate to SOUG Day which takes place in Lausanne at the “Centre Pluriculturel et social d’Ouchy”. After a coffee and a welcome speech by Yann Neushaus, Ludovico Caldara and Flora Barriele, the event starts with 2 global sessions: A l’heure du serverless, le futur va-t-il aller aux bases de données distribuées? Franck Pachot makes a comparison between Oracle…
Azure DocumentDB is a documentary database service and as like its name suggests, it is aMicrosoft Azure Cloud service. Since the last summer, developers have access to this new service, and now it is available for all. The Redmond Company offers for the first time a “NoSQL” database. This is not the only service that has come; it is associated…
