Sqlfmt: an opinionated online SQL formatter

sqlfmt is an online SQL formatter. It is pronounced sequel fumpt. Its purpose is to beautifully format SQL statements. I built sqlfmt with my Cockroach Labs colleague Raphael “knz” Poss. Here I will describe how to use it and its features. In addition, I will argue for its need in light of the existing SQL formatters and describe its somewhat interesting implementation. As we are dealing with code formatting here, there is much opinion, and here I will discuss mine. If you do not heartily ascribe to automated, opinionated (i.e., few or no options) choices in your code formatters, sqlfmt is not for you. sqlfmt is for those who think it is better to have no choice in the SQL formatting than it is to format it by hand.


A search for sql formatter uncovers lots of online and offline formatters. I tested six of the formatters from the first page

Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/rSKxXs2lyi8/

Original article

Kubernetes 1.12

Author: The 1.12 Release Team

We’re pleased to announce the delivery of Kubernetes 1.12, our third release of 2018!

Today’s release continues to focus on internal improvements and graduating features to stable in Kubernetes. This newest version graduates key features such as security and Azure. Notable additions in this release include two highly-anticipated features graduating to general availability: Kubelet TLS Bootstrap and Support for Azure Virtual Machine Scale Sets (VMSS).

These new features mean increased security, availability, resiliency, and ease of use to get production applications to market faster. The release also signifies the increasing maturation and sophistication of Kubernetes on the developer side.

Let’s dive into the key features of this release:

Introducing General Availability of Kubelet TLS Bootstrap

We’re excited to announce General Availability (GA) of Kubelet TLS Bootstrap. In Kubernetes 1.4, we introduced an API for requesting certificates from a cluster-level Certificate Authority (CA). The original intent of this API is to enable

Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/xzwbNIoKs8M/

Original article

Upgrading GitHub from Rails 3.2 to 5.2

On August 15th GitHub celebrated a major milestone: our main application is now running on the latest version of Rails: 5.2.1!

In total the project took a year and a half to upgrade from Rails 3.2 to Rails 5.2. Along the way we took time to clean up technical debt and improve the overall codebase while doing the upgrade. Below we’ll talk about how we upgraded Rails, lessons we learned and whether we’d do it again.

How did we do it?

Upgrading Rails on an application as large and as trafficked as GitHub is no small task. It takes careful planning, good organization, and patience. The upgrade started out as kind of a hobby; engineers would work on it when they had free time. There was no dedicated team. As we made progress and gained traction it became not only something we hoped we could do, but a priority.

Since GitHub is so

Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/uA_y3QRwHDA/

Original article

Slack preparing to go public in early 2019: WSJ

Slack Technologies Inc, a provider of chat services for businesses, is preparing for an initial public offering in the first half of 2019, the Wall Street Journal reported on Friday, citing people familiar with the company’s plans.

Original URL: http://feeds.reuters.com/~r/reuters/technologyNews/~3/E_mjod-CU3o/slack-preparing-to-go-public-in-early-2019-wsj-idUSKCN1M81Q1

Original article

Now Available – Amazon EC2 High Memory Instances with 6, 9, and 12 TB of Memory, Perfect for SAP HANA

The Altair 8800 computer that I built in 1977 had just 4 kilobytes of memory. Today I was able to use an EC2 instance with 12 terabytes (12 tebibytes to be exact) of memory, almost 4 billion times as much!
The new Amazon EC2 High Memory Instances let you take advantage of other AWS services including Amazon Elastic Block Store (EBS), Amazon Simple Storage Service (S3), AWS Identity and Access Management (IAM), Amazon CloudWatch, and AWS Config. They are designed to allow AWS customers to run large-scale SAP HANA installations, and can be used to build production systems that provide enterprise-grade data protection and business continuity.
Here are the specs:
Instance Name
Logical Processors
Dedicated EBS Bandwidth
Network Bandwidth
6 TiB
14 Gbps
25 Gbps
9 TiB
14 Gbps
25 Gbps

Original URL: http://feedproxy.google.com/~r/AmazonWebServicesBlog/~3/Sv0PPWGs-ZE/

Original article

Linux Now Dominates Azure

An anonymous reader shares a report: Three years ago, Mark Russinovich, CTO of Azure, Microsoft’s cloud program, said, “One in four [Azure] instances are Linux.” Then, in 2017, it was 40 percent Azure virtual machines (VM) were Linux. Today, Scott Guthrie, Microsoft’s executive vice president of the cloud and enterprise group, said in an interview, “Slightly over half of Azure VMs are Linux. That’s right. Microsoft’s prize cloud, Linux, not Windows Server, is now the most popular operating system. Windows Server isn’t going to be making a come back. Every month, Linux goes up,” Guthrie said. And it’s not just Azure users who are turning to Linux. “Native Azure services are often running on Linux,” Guthrie added. “Microsoft is building more of these services. For example, Azure’s Software Defined Network (SDN) is based on Linux.” It’s not just on Azure that Microsoft is embracing Linux. “Look at our simultaneous release

Original URL: http://rss.slashdot.org/~r/Slashdot/slashdot/~3/c5idEunOhr0/linux-now-dominates-azure

Original article

Mmm, Pi-hole

I have a love-hate relationship with ad blockers. On the one hand, I despise the obnoxious ads that are forced down our throats at what seems like every turn. On the other hand, I appreciate the need for publishers to earn a living so that I can consume their hard-earned work for free. Somewhere in the middle is a responsible approach, for example the sponsorship banner you see at the top of this blog. Companies I choose to partner with get to appear there and they get themselves 140 characters and a link. That is all. No images. No video. No script. No HTML tags. No tracking. Sponsors are happy as they get exposure, visitors are happy because there’s none of the aforementioned crap and I’m happy because it pays a lot better than ads ever did anyway. It almost seems like everyone is happy. Almost…
As I wrote about a

Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/GpOz08haMck/

Original article

Archive MySQL Data in Chunks Using Stored Procedure

In a DBA’s day to day activities, we are doing Archive operation on our transnational database servers to improve your queries and control the Disk space. The archive is a most expensive operation since its involved a huge number of and Write will be performed. So its mandatory to run the archive queries in chunks. The archive is depended on business use. Many of us need a copy of the data on an archive database to refer later. To perform the archive we can just simply run the delete query with the limit. But we need to run the query again and again until the matched rows count is 0. We can create a procedure to do this in a while loop. I have created one such procedure to archive many tables. 

Why Archive is an expensive operation? 

Generally how we are arching the data is from table_name where column_name 0

Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/HbXCrRBVSgo/

Original article

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑

%d bloggers like this: