Bo Ingram’s Post

ScyllaDB in Action (http://mng.bz/46Jw) got a new chapter today! Chapter 5 covers turning your query-first design into tables and discusses partitioning schemes to avoid performance issues in your database. You'll learn about bucketing and why SimpleStrategy is indeed simple, but also a replication strategy to avoid in production. Manning Early Access Program (MEAP) ScyllaDB #LearnwithManning #scylladb

One of the unsung heroes that contribute significantly to the performance and responsiveness of database-driven applications is database connection pooling. In this blog post, we’ll embark on a journey to understand how database connection pooling works, explore various connection pooling techniques, and highlight some popular tools and libraries in this space. Get in touch with us at contact@drdb.ai to Supercharge your Database through our Database Administration as a Service. #database #databasemanagement #databaseperformance #databaseadministration #databaseadministrator #databaseadmin

As someone who teaches developers how to design databases (and got 5 out of 5 stars for this talk at OSCON), it galls me that microservice models are moving away from database normalization because breaking up the code monolith only to have a database monolith as a bottleneck doesn't make sense. So developers implement various patterns to achieve "eventual consistency," or identify those places where they absolutely must have immediate consistency, and somehow it all works. In over two decades of working with databases, I have to concede that "the sky is falling" approach to data integrity ignores the reality on the ground. Sure, I want a perfectly normalized, monolithic database, but even the most die-hard database advocates admit that you have to "denormalize as needed," where "as needed" usually means addressing performance concerns. With microservices, "as needed" crops up far more than one would expect. But I've worked with multi-billion dollar clients whose databases are barely functional, yet they still get things done. They turn their attention to the worst data problems because, frankly, you can't fix everything, everywhere, all at once. Microservices have taught me a lot about object-oriented programming.[1] I wasn't expecting them to teach me about database design, too. #microservices #architecture #database 1. https://lnkd.in/djpu4jeF https://lnkd.in/dwuKMx3y

One hour to our presentation about keeping your #sql #database fresh, reliable, and up to date with all #modern #practices. See the new age in engineering and learn how to improve your #cicd and #observability. https://buff.ly/3YicK7W #developer #platform #opentelemetry #postgres #sql

80% of the time, all the task you have to do is create, read, update and delete some kind of data and persisted it on database. I've stumbled upon this project that powered infamous backend-as-a-service project that let you do all simple task I'd mentioned with ease.

🚀 Excited to share my first Medium.com post: "Learn How Database Developers Store Yes/No Attributes Cost-Efficiently with Bitmasks! 💡" Are you a database developer looking to optimize storage and boost performance? In my first post, I show how the often-underestimated concept of bitmasks can save money when dealing with massive datasets of millions or billions of records. 🔍 In this post, you'll discover:    The cost-saving benefits of intelligently leveraging bitmasks for storing boolean attributes.    Practical examples for efficiently managing yes/no data at scale.    Real-world examples and case studies showcasing the power of bitmasking in database development. #DatabaseDevelopment #Bitmasks #DataOptimization #DatabaseDesign #TechInsights #freelancerForHire

SirixDB: an embedded database system for managing temporal and evolutionary data. It stores immutable versions using an append-only strategy, preserving complete history. Commits create space-efficient snapshots through structural sharing. https://lnkd.in/gj8J8q3N

Great piece by Matt Asay on InfoWorld about the importance of developers epxerience in the context of databases. "Spend less time figuring out how to work with your database and more time writing your application" https://lnkd.in/eNNX8vS3

Percona’s pg_tde project brings a long-needed ability to encrypt data to #PostgreSQL transparently, and encrypting the data requires two types of keys. We are actively asking you to help us test this code to assist in building a better project! https://lnkd.in/gw5dN24q #OpenSource

Read Database Performance At Scale, a free book by ScyllaDB folks. It offers great insights into ... performance. At some point, you yearn for performance boosts, this is where this book is helpful. I'm glad I covered distributed systems before this one, as sharding and data made more sense. Knowing libSQL and SQLite internals also helped a lot like knowing the particulars of log-based replication. Drivers and data structures and algorithms behind DB internals were a great read for me. It's also interesting to see the techniques mentioned here being implemented in libSQL like getting the data closer and user-defined functions. I knew operating system internals but not specifically Linux, had to google a few concepts. Nice point about containerization is not for free as os-specific optimizations might get wasted. It also covers monitoring and benchmarking. Glad it has a practical touch to it, helps people dealing with dbs much as it has ready-to-implement items. A delight for system design folks as well as any curious individual. Thanks, Piotr Sarna, Felipe Cardeneti Mendes, Pavel Emelyanov, and Cynthia Dunlop for producing such a treat for database people. I can imagine the work that went into this one. Even me, with a great share of the book's info in my pocket, I learned a whole lot. Download: https://lnkd.in/eUZsgGKi #opensource