SleekDB - PHP NoSQL Flat File Database
▻https://sleekdb.github.io
SleekDB is a simple flat file NoSQL like database implemented in PHP without any third-party dependencies that store data in plain JSON files.
Une solution possible pour remplacer les sauvegardes Sqlite de SPIP qui nécessitent l’extension sqlite de PHP.
Le repo Github : ▻https://github.com/rakibtg/SleekDB
#sleekdb #noSQL #sauvegarde #SPIP #json
Searching #dynamodb : An indexer sidecar for #elasticsearch
▻https://hackernoon.com/searching-dynamodb-an-indexer-sidecar-for-elasticsearch-6e70f2abf676?sou
TLDR;DynamoDB is great, but partitioning and searching are hardWe built alternator and migration-service to make life easierWe open sourced a sidecar to index DynamoDB tables in Elasticsearch that you should totes use. Here’s the code.When we embarked on Bitbucket Pipelines more than three years ago we had little experience using #nosql databases. But as a small team looking to produce quality at speed, we decided on DynamoDB as a managed service with great availability and scalability characteristics. Three years on, we’ve learnt a lot about how to use and how to not use DynamoDB, and we’ve built some things along the way that might be useful to other teams or that could be absorbed by the ever growing platform.To NoSQL or not to NoSQL that is the questionFirst off the bat, relational (...)
How we built a real-time in-game currency service with 7.5M transactions per minute
▻https://hackernoon.com/how-we-built-a-real-time-in-game-currency-service-with-7-5m-transactions
For us techies at Loco, there is nothing more exciting than to work on the cutting edge solutions, use new products, and solve problems that don’t have a solution on StackOverflow. Recently, we came across one such problem and discovered one such technology to solve it.We designed our new, high performance, transactional currency service around #tarantool, a high-performance #database. It served as our SSOT (single source of truth) database to ship a new feature.Why did we even think of Tarantool?We had to build an in-game currency transaction system which requires a minimum of 150K concurrent users to get coins real-time. The users should be able to use the coins as soon as they get it. For us, ‘real-time’ means ~300ms. For all our users, all 150K concurrent users.One way of solving this is (...)
Relational, NoSQL, Ledger Databases work, not Permissioned Blockchains.
▻https://hackernoon.com/relational-nosql-ledger-databases-work-not-permissioned-blockchains-9cca
The premise of my article is to dive into the architecture of databases and learn why it has worked well for enterprises. While comparing the resiliency of databases with the value proposition of permissioned chains. Finally a look ahead of how ledger #database if architected correctly could be poised to ride the next wave of innovation. Jon Choi argued that we should retire the word blockchain and use the term “open networks”. The conclusion from Jon’s article is that open crypto networks, “are networks that share resources and responsibilities with their participants”. By establishing the term this would allow the community to evolve and grow independently from other communities. I would argue that the enterprise community should retire the word blockchain and adopt the term “ledger (...)
#permissioned-blockchains #relational-databases #nosql-database #ledger-database
Why Adopting #nosql is Difficult for Beginners
▻https://hackernoon.com/why-adopting-nosql-is-difficult-for-beginners-511659fb79d9?source=rss---
With the increasing technological breakthroughs, traditional ways of storing data are being challenged. With the adoption of NoSQL by industry giants and the ever-increasing NoSQL database options, it is becoming a trend in considering NoSQL as alternatives to Relational Databases for mainstream software development.However, when it comes to Relational Databases, it has been there for several decades. It is not difficult in finding developers who have the knowledge and experience in writing SQL queries, designing entity relationships, normalizing schemas and ensuring ACID properties. This is not the case with NoSQL where knowledge, expertise, and experience are scarce.This could lead to wrong design decisions in using NoSQL where it doesn’t fit in. Another common mistake in adopting (...)
#beginners-guide #programming #adopting-nosql #best-practices
Apache Cassandra — The minimum internals you need to know
▻https://hackernoon.com/apache-cassandra-the-minimum-internals-you-need-to-know-89724603abb2?sou
Apache Cassandra — The minimum internals you need to knowFor effective data modeling and comparison with other DB’sWe will discuss two parts here; first, the #database design internals that may help you compare between database’s, and second the main intuition behind auto-sharding/auto-scaling in Cassandra, and how to model your data to be aligned to that model for the best performance.Part 1: Database Architecture — Master-Slave and Masterless and its impact on HA and ScalabilityThere are two broad types of HA Architectures Master -slave and Masterless or master-master architecture.Here is an interesting Stack Overflow QA that sums up quite easily one main trade-off with these two type of architectures.Q. -I’ve heard about two kind of database architectures.master-master and master-slaveIsn’t (...)
GraphCMS - GraphQL based Headless Content Management System
▻https://graphcms.com
“1. Define your content model
Define the structures, relations and permissions of your application data by using our intuitive content model editor.
2. Manage your content
Start the data onboarding with our easy-to-use content editor or import existing data from JSON/CSV. Your apps can of course push data to your backend as well.
3. Connect your apps
Connect your web and mobile apps to the generated and hosted GraphQL endpoint via Relay, Apollo or other GraphQL client libraries.”
Installation de MongoDB sur Windows
▻http://www.dsfc.net/infrastructure/base-de-donnees-infrastructure/installation-mongodb-windows
Il m’aura fallu un trentaine de minutes pour installer et prendre en main MongoDB.
Ouais, ben c’est plus la mode on dirait #nosql
▻http://seenthis.net/tag/nosql
2010 : 8 mentions
2011 : 4
2012 : 4
2013 : 2
2014 : 1
2015 : 3
Je cherche une explication, parmi les millions qui existent, de quand utiliser #mongodb, et quand utiliser #postgresql.
J’en suis arrivé à la conclusion que mongodb est adapté pour des données simples, et très nombreuses, et postgresql pour un modèle de données complexe (beaucoup de relations entre beaucoup d’objets).
Qu’en dites-vous ?
pas vraiment compétent, mais de ce que j’ai compris pg est remonté au niveau de perfs des mongo et compagnie, ce qui fait que cet argument-ci n’est plus essentiel
par exemple ici ▻http://www.aptuz.com/blog/is-postgres-nosql-database-better-than-mongodb
le dernier lien parle de la version nosql de postgres, et pas de postgresql qui est une base relationnelle (enfin de ce que je comprends de la comparaison de départ de @severo)
@rastapopoulos je comprends de l’article que postgresql 9.4 intègre maintenant le type json, ce qui permet de stocker des documents de type json de la même manière que dans mongodb, et il est possible de mettre des contraintes, des clés, etc. sur les champs du json.
Mais il s’agit bien de postgresql, pas d’une version « nosql ».
Ouais en gros comme le champ « json » de Sphinx quoi. Et du coup ça veut dire que tu peux mélanger à la fois une base relationnelle classique, avec champs typés et définis en avance ET des tables avec un unique champ « json » dedans, complètement libre. Et même un mélange avec un objet contenant des champs bien typés ET un champ json totalement libre, dans la même table. L’avantage étant aussi de pouvoir faire tout ça avec le même logiciel, sans installer et maintenir deux moteurs différents.
Collecte de tickets de caisse : vue sur l’architecture | OCTO talks !
▻http://blog.octo.com/collecte-de-tickets-de-caisse-vue-sur-larchitecture
une #architecture répondant à un use case qui repose sur des technologies open-source distribuées, tolérantes à la panne et scalables. Cet exemple montre le potentiel de la plateforme #Kafka-Spark-Cassandra pour la réalisation d’architectures temps ré… Tags : #Spark #Cassandra Kafka #flux #MOM #clevermarks architecture #NoSQL
La popularité des #Bases_de_données, selon DB-Engines
▻http://www.dsfc.net/infrastructure/base-de-donnees-infrastructure/popularite-des-bases-de-donnees
Avec une politique tarifaire aussi imbécile, #Oracle ne fait qu’accompagner un mouvement irréversible des utilisateurs vers les bases de données Open Source et aussi vers #Microsoft_SQL_Server !Autres lectures sur le thèmeMarché et utilisation des bases de données en 2012Support en matière de bases de donnéesMySQL, 1ère #Base_de_données utilisée au monde devant…
#Formateur_MariaDB #Formateur_MySQL #Formateur_Oracle #Formateur_PostgreSQL #Formateur_SQL #Formateur_SQL_Server #MariaDB #MySQL #NoSQL #Oracle_Database #PostgreSQL #SQL #SQL_Server
ArangoDB - the multi-purpose NoSQL DB
▻https://www.arangodb.org
An open-source database with a flexible data model for documents, graphs, and key-values. Build high performance applications using a convenient sql-like query language or JavaScript extensions.
Rubedo project - Accueil
▻http://www.rubedo-project.org
Tags : #CMS #opensource #nosql #mongodb #zendframework
Je ne trouve pas forcément cela pertinent d’avoir une admin comme un bureau d’ordinateur (en plus un bureau selon les anciennes normes ! les OS d’aujourd’hui n’ont presque plus cette interface).
Mais sinon ya des bonnes idées. :)
Au moins deux CMS du CMS Day avaient une telle interface dont je ne vois pas particulièrement l’intérêt non plus. L’un d’eux allait même jusqu’à nommer ses plugins « applications », agaçant gimmick marketing.
Autre tendance : Bootstrap partout (cf. le backend de Joomla3 par ex.). Tant mieux en même temps c’est des éléments d’UI plutôt bien lisibles.
C’est la Freebox qui se met à l’interface « OS » à présent...
L’interface bureau a l’ancienne a le mérite de sa propre cohérence, par opposition à l’absence de logique d’ensemble des diverses interfaces des divers CMS. Des interfaces d’administration comme DSM, qui proposent une interface bureau classique, font la fortune de leurs éditeurs.
Donc, tout dépend de savoir s’il s’agit de rendre l’utilisateur productif ou de le piéger dans une interface innovante.
Are NoSQL and Big Data Just Hype? Interview with SQL Creator, Monty Widenius
▻http://www.dzone.com/articles/are-nosql-and-big-data-just
The expert in the database area, Monty Widenius, talks in his interview about the current and future state of SQL, NoSQL and Big Data. And his answers were somewhat surprising.
Source: dzone.com - fresh links for developers
Most companies don’t have massive amounts of data, like Facebook and Google, and they will not be able to afford to have experts to tune and constantly develop the database.
et
(...)it’s easier to get started with a NoSQL database. You don’t have to learn SQL and define your database schema before you start using it. A few are using it because they belive it can scale better than SQL.
ça me rappelle les devs avec Lotus Notes de mes jeunes années, au siècle dernier... :)
#RethinkDB - an open-source distributed #database
►http://www.rethinkdb.com
An open-source distributed database (...) intuitive query language, automatically parallelized queries, and simple administration.
dans la veine du #NoSQL avec la possibilité de tranquillement faire du #map-reduce
Pragmatic Programming Techniques : MongoDb Architecture
►http://horicky.blogspot.fr/2012/04/mongodb-architecture.html
a discussion about the technical architecture of MongoDb
What is Amazon DynamoDB?
►http://docs.amazonwebservices.com/amazondynamodb/latest/developerguide/Introduction.html
#Amazon #DynamoDB is a fully managed #NoSQL #database service that provides fast and predictable performance with seamless scalability. If you are a developer, you can use Amazon DynamoDB to create a database table that can store and retrieve any amount of data, and serve any level of request traffic. Amazon DynamoDB automatically spreads the data and traffic for the table over a sufficient number of servers to handle the request capacity specified by the customer and the amount of data stored, while maintaining consistent and fast performance.
Hoping to unify the growing but disparate market of NoSQL databases, the creators behind CouchDB and SQLite have introduced a new query language for the format, called UnQL (Unstructured Data Query Language).
►http://www.infoworld.com/d/data-center/couchbase-sqlite-launch-unified-nosql-query-language-168470
#seenthis_bug : j’ai été obligé de remplacer dans l’URL le tilde par un %7E, sinon ce n’était pas pris en compte
Why does Quora use MySQL rather than NoSQLs?
►http://www.quora.com/Why-does-Quora-use-MySQL-as-the-data-store-rather-than-NoSQLs-such-as-Cassand.?
“The primary online data store for an application is the worst place to take a risk with new technology. If you lose your database or there’s corruption, it’s a disaster that could be impossible to recover from.”
#nosql #MySQL #bdd #base_de_données #architecture #web #dev #gp:links #clevermarks #Quora #Cassandra #MongoDB #CouchDB
