
Developer Quick Tips
Check out this roundup of some of my latest developer quick tips, hacks and more.As a technical evangelist for SingleStore and long-time developer, I’m always excited to share my take on the latest product innovations, tips and tricks for SingleStoreDB. Here’s a roundup of some of the latest ones I’ve put together — you can also always find them on dev.to.Accessing JSON Data at Warp Speed with Universal StorageThe Winter 2022 release of SingleStoreDB (version 8.0) introduced the latest installment of Universal Storage, with new performance improvements for both transactions and analytics — further cementing it as the ideal database for unifying OLAP and OLTP workloads. This latest update focuses on working with JSON and string data, particularly, seekable JSON.Using JSON with SingleStoreDBOne of the most popular data formats today, SingleStoreDB effortlessly stores, retrieves and queries JSON data. With seekable JSON, data can be stored in a compressed format. When you need to retrieve specific rows, only the retrieved data needs to be compressed. This new approach makes JSON a suitable data format not only for OLTP applications, but OLAP ones as well.