SingleStore Forums are available anytime you have a question about SingleStore, want to know more about SingleStore, or are willing and able to help others. And now the SingleStore Forums, coming up on their one-year anniversary, have their first Community Star: Ziv Meidav, a big data architect who is serving as senior principal engineer at cybersecurity innovators Palo Alto Networks.
The community of SingleStore users, developers, and employees gathers at the SingleStore Forums to ask questions, offer support, and discuss strategies for leveraging SingleStore. Got a nasty error message? Post it on a Forum. Want to suggest a feature? Same thing.
What the SingleStore Forums Do
The SingleStore Forums are organized into topics. Topics include:
The great thing about the Forums is the mix of people aboard. SingleStore engineers, experienced SingleStore users from organizations large and small, new users, and students all come on, asking and answering questions, from the simplest to the most arcane. Everyone pitches in to help.
The Forums are particularly valuable to users of SingleStore who don’t have an Enterprise license, but instead run SingleStore for free. This works on-premises as well as in the cloud, up to certain limitations as to nodes and resources used. For such users, the Forums are the only source of support. And users of SingleStore’s free level are regular contributors to the Forums.
One of the things that makes it fun to create and use SingleStore is that it is, fairly literally, a computer science project. Building and using “the next great database,” which is our goal, touches on all sorts of problems. They range from the momentary and entirely practical – “my cluster just crashed” – to the architectural, mathematical, and sometimes almost philosophical. It all gets hashed out on the Forums.
Ziv to the Rescue
Like many SingleStore users and fans, Ziv asks penetrating questions on the SingleStore Forums. Ziv’s Forums activity shows comments on columnstore performance for JSON data, a question on SingleStore Studio, and a group of comments on a performance issue – which turns out to be a fairly deep topic.
It all started with a SELECT statement that had varying execution speeds, ranging from 40ms to 500ms, when run on the SingleStore DB 7.0 beta. Ziv posted extensive details, and SingleStore’s Haoran Xu chimed in with an initial response.
This was the beginning of a long exchange that eventually totaled 17 pages over 5 days. It ended with Haoran recognizing a bug in the beta, described in detail in his final message in the exchange. SingleStore found and fixed the cause of the bug immediately, and the new and improved code will appear in SingleStore DB 7.0 soon.
Another strong contribution is a question about optimizing a specific query, also from Ziv. The exchange generated by this question yields considerable insight into how SingleStore handles many different kinds of queries and how to optimize them.
As you see here, the Forums, with questions like Zivs’, help SingleStore people as well as customers. Through the Forums, we learn about bugs, documentation issues, feature requests, and more. Software work can be very individual; through the Forums, SingleStore people and customers from around the world can work together to make SingleStore better.
The SingleStore Forums are a great resource, community, and unofficial school for SingleStore users and employees to teach and learn from each other, while solving problems and minimizing downtime. They’re available to anyone who has a free account from the SingleStore Customer Portal or signs up with a valid email. And if you participate in the forums, perhaps you’ll get chosen next month as our next Community Star.