PostgreSQL
Managing SQL Drift: Ensuring Stability in Database Transitions
SQL drift is a significant challenge that occurs when SQL statements from an existing system produce unexpected results after migration to a new environment or system. These issues manifest in several critical ways: SQL statements may generate new execution errors, experience significant performance degradation, or yield differences in data integrity.
Read more![Digital Tech Trek Digest [#Issue 2024.12]](https://ronaldbradford.com/images/blog/2024-digital-tech-trek-digest.png)
Digital Tech Trek Digest [#Issue 2024.12]
Falsehoods programmers believe about time zones If I told you there was a timezone 30 minutes past the hour, would you believe me? In a small section of Western Australia, there is.
Read moreDigital Tech Trek Digest [#Issue 2024.09]
As an entrepreneur, pricing is an important consideration in any evaluation, development, and customer testing. In How To Price A SaaS Product , we see different pricing strategies, cost-based pricing, competitor-based pricing, penetration pricing, value-based pricing, freemium pricing.
Read moreDigital Tech Trek Digest [#Issue 2024.08]
The One Billion Row Challenge Shows That Java Can Process a One Billion Rows File in Two Seconds Well, it’s way under 2 seconds for the 1brc . The published results are in, and if you’re good, you can read 1 billion data points of weather data and analyze it.
Read moreDigital Tech Trek Digest [#Issue 2024.02]
Indie Newsletter Tool Generates $15,000 a Month There are so many different email newsletter sites you could wonder if there is market saturation. MailChimp , Mailgun , ConvertKit , Sendgrid (now part of Twilio it seems), Moosend and Mailersend come to mind.
Read moreAWS RDS Aurora wish list
I’ve had this list on a post-it note on my monitor for all of 2022. I figured it was time to write it down, and reuse the space. In summary, AWS suffers from the same problem that almost every other product does.
Read moreSQL, ANSI Standards, PostgreSQL and MySQL
I have recently been working with the Donors Choose Open Data Set which happens to be in PostgreSQL. Easy enough to install and load the data in PostgreSQL, however as I live and breath MySQL, lets load the data into MySQL.
Read more