The most performed RANDOM querying on Rails!

Ivan Marynych — Fri, 14 Jul 2023 22:31:32 +0000

🌟 Prepare to have your mind blown by the Unbelievable Performance Gem! 🌟

Are you tired of slow random record retrieval in your Rails applications? Say goodbye to sluggish queries and hello to lightning-fast performance! Our gem is here to revolutionize the way you fetch random records, delivering results that will leave you speechless.

🔥 Experience the future of speed and efficiency as our gem seamlessly integrates into your codebase. With near-instantaneous responses, you can elevate your user experience to new heights.

💪 Join the ranks of developers who are already witnessing jaw-dropping results. Don't miss out on this game-changing gem that's setting new performance standards in the Rails community.

Ready to ignite your Rails application? Visit our repo to learn more about the Unbelievable Performance Gem and be part of the performance revolution today! 🚀💎

the-rubies-way / random-rails

The most performed gem to get random record you ever seen! Available for Ruby on Rails with PostgreSQL right now!

RandomRails

🚀 The most performant way to get random records from ActiveRecord. Supports PostgreSQL, MySQL, and SQLite with intelligent strategy selection to replace slow ORDER BY RANDOM() queries.

Why RandomRails?

Traditional ORDER BY RANDOM() queries become extremely slow on large tables because they require sorting the entire dataset. RandomRails solves this by using:

TABLESAMPLE BERNOULLI for PostgreSQL (ultra-fast on large tables)
Efficient offset-based sampling for all databases
Intelligent strategy selection based on table size and database type
Configurable sampling methods for different use cases

Performance Comparison

Real-world benchmark results comparing RandomRails with traditional methods (10 iterations each):

Sample Size	`ORDER BY RANDOM()`	`User.random()`	`User.sample()`	Performance Gain
1,000 users	3.8359s	0.2157s	347.1409s	17.79x faster
10,000 users	6.1273s	2.7313s	369.7583s	2.24x faster
100,000 users	31.578s	3.6968s	369.4334s	8.54x faster
1,000,000 users	171.497s	5.3441s	373.6102s	32.09x faster

Key Takeaways:

RandomRails consistently outperforms ORDER BY RANDOM() by 2-32x
Performance advantage increases dramatically…

View on GitHub

Verifying Monobank Acquiring API Webhook Sign with Ruby Script

Ivan Marynych — Sat, 10 Jun 2023 14:25:00 +0000

Introduction

Webhooks play a crucial role in modern API integrations, allowing real-time communication between applications. However, ensuring the integrity and authenticity of incoming webhook data is essential to prevent security breaches. In this article, we will explore a Ruby script that demonstrates how to verify the Monobank Acquiring API webhook sign, ensuring the received data is from a trusted source. The script, available at the GitHub repository loqimean/monobank_webhook_sign_verification, provides a straightforward implementation to validate the webhook sign using Ruby.

Understanding the Monobank Acquiring API Webhook Sign: The Monobank Acquiring API sends webhook notifications containing transaction information. To verify the authenticity of these notifications, Monobank includes a webhook sign in the request headers. This sign is generated using a shared secret key and serves as proof of origin for the webhook data. The Ruby script we will discuss utilizes this sign to validate incoming webhook requests.

Implementation Details: The Ruby script available in the repository mentioned above showcases a concise and efficient method to verify the Monobank Acquiring API webhook sign. Let’s walk through the important components of the script:

Dependencies: The script requires the ‘openssl’ and ‘base64’ libraries, which are commonly available in Ruby installations. If you encounter any issues related to these dependencies, make sure they are installed or update your Ruby environment accordingly.
Verification Process: The script parses the incoming webhook request headers to extract the provided webhook sign and the body of the request. It then applies the same hashing algorithm used by Monobank (SHA1) to generate a local sign from the request body, using the shared secret key obtained from Monobank. Finally, it compares the locally generated sign with the one received in the webhook request headers. If they match, the script confirms the authenticity of the webhook data.
Error Handling: To provide comprehensive feedback, the script incorporates error handling mechanisms. If any errors occur during the verification process, appropriate error messages are displayed, aiding in troubleshooting and debugging.

Conclusion

Webhook sign verification is a crucial step in securing API integrations, ensuring that data originates from trusted sources. The Ruby script provided in loqimean/monobank_webhook_sign_verification repository offers a simple yet effective way to verify the Monobank Acquiring API webhook sign. By implementing this script in your application, you can enhance the security of your Monobank webhook integrations, safeguarding the integrity of your data and preventing potential security breaches.

Remember to regularly update your secret key and keep it securely stored. Additionally, monitoring and logging webhook verification results can be beneficial for detecting any unusual activity or potential attacks.

Please note that while the provided script demonstrates a viable approach to verify Monobank Acquiring API webhook signs, it’s important to review and customize it based on your specific requirements and security practices.

Remember to regularly review the official Monobank documentation for any updates or changes to their API implementation.

Happy coding and secure webhook integrations! 🎉

DEV Community: Ivan Marynych