Examining PostgreSQL 9.4 – A first look
PostgreSQL is currently entering its final commit fest. While its still going, which means there could still be more great features to come, we can start to take a look at what you can expect from it now. This release seems to bring a lot of minor increments versus some bigger highlights of previous ones. At the same…
Making ActiveRecord 2x faster
TL;DR: AdequateRecord is a set of patches that adds cache stuff to make ActiveRecord 2x faster
Improve developer habits by showing time cost of DB queries
This is the first in a series of posts where I share a quick, easy to implement tip that I’ve found useful in my development career
The Log: An Epic Software Engineering Article
There's some sort of inflection point where a "long read" becomes an "epic article." I'm not quite sure where that inflection point is, bu...
The Idiot's Guide to High Frequency Trading
First, let me say what you read here is going to be wrong in several ways. HFT covers such a wide path of trading that different parties participate or are impacted in different ways. I wanted to put this out there as a starting point . Hopefully the comments will help further educate us all
A Statistical Analysis of All Hacker News Submissions
After downloading all 1,265,114 Hacker News submissions from the official Hacker News API, I gathered a few interesting statistics which show the true impact of Hacker News.
What's left of NoSQL?
What’s left of NoSQL if they start adding ACID and SQL support?
How to be a Bayesian in Python
See also Frequentism and Bayesianism: A Python-driven Primer , a peer-reviewed article partially based on this content.
Stuff that every programmer should know: Data Visualization
Realtime rendering and videogame programming mostly, but I love computer science and visuals in all their forms. This is a notepad of my ideas.
Recommending music on Spotify with deep learning
An overview of what I've been doing as part of my internship at Spotify in NYC this summer: using convolutional neural networks for audio-based music recommendation.
ZFS Gotchas
Things Nobody Told You About ZFS Yes, it's back. You may also notice it is now hosted on my Blogger page - just don't have time to deal w...
Downloading All of Hacker News Posts and Comments
Shital Shah's personal website and blog. Research Engineer at Microsoft Research with interests in deep learning and reinforcement learning. Created AirSim, TensorWatch, archai, most recently worked on training Phi series of LLM models.
Apache Spark: The Next Big Data Thing?
Apache Spark is generating quite some buzz right now. Databricks, the company founded to support Spark raised $14M from Andreessen Horowitz, Cloudera has decided to fully support Spark, and others chime in that it's the next big thing. So I thought it's high time I took a look to get an understanding what the whole…
The best Postgres feature you're not using – CTEs aka WITH clauses
SQL by default isn’t typically friendly to dive into, and especially so if you’re reading someone else’s already created queries. For some reason most people throw out principles we follow in other languages such as commenting and composability just for SQL. I was recently reminded of a key feature in Postgres that…
Linux's fsync() woes are getting some attention
In two weeks, I'm headed to LSF/MM and the Linux Collaboration Summit , by invitation of some Linux kernel hackers, to discuss how the Linu...
Results of the SQL Performance Quiz
SQL indexing: 60% don’t know how to get it right
What's wrong with statistics in Julia?
Introduction Link to heading Several months ago, I promised to write an updated version of my old post, “The State of Statistics in Julia”, that would describe how Julia’s support for statistical computing has evolved since December 2012. I’ve kept putting off writing that post for several reasons, but the most…
The Multiple SQLite Problem
If your app makes use of two separate instances of the SQLite library, you can end up with a corrupted SQLite data file.