• Programming,  Technology

    Riverton Agency – Software Development Company

    In case you didn’t know, I have recently taken my software development company to the next level and purchased the LLC required for the business. All software development will now be run through my company Riverton Agency, LLC. Visit our website at RivertonAgency.com. Feel free to shoot me an email if you would like to talk business, partnerships, or have some work you’d like us to do. We’re steadily growing and always entertaining new ideas and equity projects. We are located in the Frederick, MD area and serving local businesses however we take on clients from any areas of the world and encourage remote client connections. Brandon Please follow and…

  • Technology

    Linux CRON Scheduling and Setup for MySQL Backups

    Backups are useful, and a must have feature of anyone’s site or product if you are going to be successful. Backup as often as you can, as much as you can. In this short post I’m going to quickly outline Linux CRON Scheduling with MySQL to backup your databases. Once logged into your server run: crontab -e This is like your CRON configuration file and will show you all scheduled tasks that you currently have running in your system. Here is an example of what part of my config file looks like: # m h dom mon dow command # db Backups - Every day at 4AM. - Write to…

  • Technology

    Write VERY large record-sets to CSV, JSON with ColdFusion

    So I was tasked to build something that writes a very large data set to CSV Files, and JSON files. I was running into memory issues with ColdFusion because I was trying to store the CSV string in memory before writing it to a file on the server. For a 1 Million+ row recordset in SQL Server this usually would time out after a 2 hour request timeout, and just not finish. By using the underlying Java objects we can write 1 Million+ records to a CSV file, or JSON file in just about 8-10 seconds. Credit for finding these Java objects goes to my co-worker Sean Louisin. The fix…