Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
In 2010ish, we tried to roll out a feature ( Treasury ) using MongoDB. It was an interesting experience. I learned quite a bit in the process. I wrote about what I was thinking at the time here . But for the most part it was an abject failure and Ryan Young wound up porting the entire thing to the MySQL shards which…
Anaconda Scale Customer Event Join us live October 15th Save Your Seat Anaconda Blog
I found myself reading NoSQL is a Premature Optimization a few minutes ago and threw up in my mouth a little. That article is so far off base that I’m not even sure where to start, so I guess…
Understanding query planner quirks yielded a ~35% speedup.
In two weeks since open sourcing FoundationDB , we’ve had an outpouring of interest.
In a previous post, I was sceptical about using Apache DataFusion for graph analytics. However, after some thought and experimentation, I changed my mind. I have reconsidered my approach and now have a working implementation of basic graph algorithms, such as WCC, PageRank and MSSP. For example, I can identify weakly…
With the latest upgrades to PostgreSQL the fsync failure had been fixed. Avinash Vallarapu takes a look at why this issue might cause problems.
It's not just for big data
Explore five methods of data change tracking in PostgreSQL available in 2024.
Access to this page requires authorization. You can try signing in or changing directories .
A tour of the-stats-duck v0.6.0: a one-shot data profiler, regression and bootstrap CIs in plain SQL, ten new distributions, and SAS/XPT imports that got 52x faster — with live Bedevere demos you can poke at.
One of the most consistently popular posts on this blog has been my XKCDify post, where I followed in the footsteps of others to write a little hack for xkcd-style plotting in matplotlib. In it, I mentioned the Sketch Path Filter pull request that would eventually supersede my ugly little hack.
SQLite has a powerful extension mechanism: loadable extensions. Being an in-process database, SQLite has other extensions mechanisms like application-defined functions (UDF for short). But UDFs have …
10 fictional profiles were created on OKCupid with the same profiles but different photos to test how online dating is different for men than women.
MySQL is the last major SQL database that has evolved beyond SQL-92 by introducing window functions (OVER) and common table expressions (WITH [RECURSIVE])
Explore Excel's bizarre date/time quirks—like “1/2”+1=45660—and how Quadratic fixes legacy issues with a modern approach to datetimes and spreadsheet logic.
Over the last couple of weeks I’ve run some analysis on the one million most popular sites on the web.
Today were excited to announce the release of the open source time series database, InfluxDB 1.0 and our commercial offering, InfluxEnterprise.
Every modern exchange is a distributed database in disguise. This article reveals how trading engines transform chaotic streams of buy and sell orders into a perfectly ordered, replayable log, ensuring fairness, determinism, and market data reliability.
PlanetScale offers the world’s fastest and most scalable cloud hosting for Vitess, Neki, and Postgres.
Julia is a new language for scientific computing that is winning praise from a slew of very smart people, including Harlan Harris, Chris Fonnesbeck, Douglas Bates, Vince Buffalo and Shane Conway. As a language, it has lofty design goals, which, if attained, will make it noticeably superior to Matlab, R and Python for…
