History

 
A little background. The first version of Shopkeeper was released in 2009. Then it was a module for CMS MODX , or rather for its first branch, which is now called Evolution. At that time MODX had only one such module, but its quality did not suit me, so I decided to write my own. Plus, I needed some kind of project to increase my experience in programming in PHP. Because there was almost no competition, my component became the most popular for that version of MODX.
 
???-pl3 - The latest version of Shopkeeper from the ...[/h]

In this message, we will look at ways to connect collections in NoSQL databases mongodb, arangodb, orientdb and rethinkdb (in addition to being a NoSQL database, they also have a free version with a fairly loyal license). In relational databases, similar functionality is implemented using SQL JOIN. Despite the fact that CRUD operations in NoSQL databases are very similar and differ only in details, for example, in one database, create ({}) is used to create an object, on the other - insert ({}), and in third - save ({}), - the implementation of a sample of two or more collections in each database ...

When working with databases there is a problem that is called "SELECT N + 1" - this is when the application instead of one query to the database that selects all the necessary data from several linked tables, collections, makes an additional subquery for each result row of the first query, to get related data. For example, first we get a list of students of the university, in which its specialty is identified by an identifier, and then for each of the students we make an additional subquery in the table or a collection of specialties in order to get the name of the specialty by the specialty ID...

<{full}>
After reading the title, many probably have a question - why another bike if there are already run-in Mongoose, Mongorito, TypeORM, etc.? For the answer it is necessary to understand what is the difference between ORM and ODM. We look at Wikipedia:
 
ORM (English Object-Relational Mapping, Russian object-relational mapping, or transformation) is a programming technology that links databases to the concepts of object-oriented programming languages, creating a "virtual object database".
That is, ORM is just a pro-data representation of data. I recall that in relational databases there is no way ...

To search for relevant information on websites and mobile applications, it is often necessary to search by words or phrases that the user freely enters from the keyboard (rather than selecting from the list for example). Naturally, the user can make mistakes and typos. In this case, full-text search, full-text indexes that are implemented in most databases do not give the expected result and are practically useless. Such functionality is increasingly implemented based on elasticsearch.
 
 
Solutions using elasticsearch have one significant drawback - a very high probability of mismatching the main ...

There is a proposal. In connection with locks, let's all massively just ask. I understand it's funny. But something needs to be done. At https://rkn.gov.ru/ at the bottom there is a complaint. Let's write. Just write.
 
I wrote about docs.mongodb.com.
 
Join now. What if something changes?There is a proposal. In connection with locks, let's all massively just ask. I understand it's funny. But something needs to be done. At https://rkn.gov.ru/ at the bottom there is a complaint. Let's write. Just write. I wrote about docs.mongodb.com. Join now. What if something changes?...

I want to share with you how private mode Safari led to the development of a simple storage key-value on Node.js with backup, access to data from certain domains and password protection from writing and cleaning the repository.
 
 

 
 
It all started with the fact that I was given the task to implement a test order in a web application that is built-in via iframe in one popular resource.
 
 
The problem was solved and worked as follows:
 
 
 
an unauthorized user clicks on the store (link "_blank");
 
In a new window, the test items are displayed, and in the iframe we redirect the user to the profile of ...