New – USASpending.gov on an Amazon RDS Snapshot | AWS Blog

[S]tarting today, the entire public USAspending.gov database is available for anyone to copy via Amazon Relational Database Service (RDS). USAspending.gov data includes data on all spending by the federal government, including contracts, grants, loans, employee salaries, and more. The data is available via a PostgreSQL snapshot, which provides bulk access to the entire USAspending.gov database, and is updated nightly. At this time, the database includes all USAspending.gov for the second quarter of fiscal year 2017, and data going back to the year 2000 will be added over the summer. You can learn more about the database and how to access it on its AWS Public Dataset landing page.

Source: New – USASpending.gov on an Amazon RDS Snapshot | AWS Blog

My Twitter Digest for 05/08/2017

Kubernetes Services By Example – OpenShift Blog

In a nutshell, Kubernetes services are an abstraction for pods, providing a stable, virtual IP (VIP) address. As pods may come and go, for example in the process of a rolling upgrade, services allow clients to reliably connect to the containers running in the pods, using the VIP. The virtual in VIP means it’s not an actual IP address connected to a network interface but its purpose is purely to forward traffic to one or more pods. Keeping the mapping between the VIP and the pods up-to-date is the job of kub

Source: Kubernetes Services By Example – OpenShift Blog

How to speed up your MySQL queries 300 times | Opensource.com

MySQL has a built-in slow query log. To use it, open the my.cnf file and set the slow_query_log variable to “On.” Set long_query_time to the number of seconds that a query should take to be considered slow, say 0.2. Set slow_query_log_file to the path where you want to save the file. Then run your code and any query above the specified threshold will be added to that file.

Source: How to speed up your MySQL queries 300 times | Opensource.com

My Twitter Digest for 05/03/2017

My Twitter Digest for 04/27/2017

My Twitter Digest for 04/26/2017