Open Source Communities: vendors and users working together. Event organised by London open source databases meetup, on 18th September.
Good practices and advice to use #Cassandra consistency levels in practice, with an eye on performance and scalability
MySQL transactions can be read only. Here’s how to use them, and why they are useful.
Cassandra login fails with: “Cannot achieve consistency level LOCAL_ONE”? Let’s see why it happens, and how to solve the problem
In MySQL and MariaDB, all tables should have a primary key – especially InnoDB tables – this is almost common wisdom. But why? Let’s discuss the reasons.
Reducing the number of queries is important. The article describes how to use the SQL language more expressively (in MySQL) to achieve the purpose.
Returning random rows in a random order from a relational database is a very hard problem. In this article we will see an antipattern, we will discuss why this problem is so hard, and we’ll examine some imperfect solutions.
One of the trickiest problems in SQL is to query rows in tranches. This is typically needed in a website search, or in a dynamic catalogue where products appear as you scroll down. You want the DBMS to only return …
In July, London Open Source Databases group will see a meetup with Peter Zaitsev and one with Monty Widenius.
There are many non-obvious ways to return values from MySQL stored procedures, and each of them solves particular problems.