2851
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2852
Anaconda 5.0 Released
Anaconda Scale Customer Event Join us live October 15th Save Your Seat Anaconda Blog
2853
NoSQL is What?
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…
2854
Subtleties of SQLite Indexes
Understanding query planner quirks yielded a ~35% speedup.
2855
2856
FoundationDB community highlights, two weeks in
In two weeks since open sourcing FoundationDB , we’ve had an outpouring of interest.
2857
Algorithms on billion-scale graph using 10GB RAM: I love DataFusion
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…
2858
Linux Fsync Issue for Buffered IO and Its Preliminary Fix for PostgreSQL
With the latest upgrades to PostgreSQL the fsync failure had been fixed. Avinash Vallarapu takes a look at why this issue might cause problems.
2859
2860
2861
The Ultimate Guide to PostgreSQL Data Change Tracking
Explore five methods of data change tracking in PostgreSQL available in 2024.
2862
Machine Learning: A Summary on Feature Engineering Using R Language
Access to this page requires authorization. You can try signing in or changing directories .
2863
2864
Statistics that live in your SQL
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.
2865
XKCD Plots in Matplotlib: Going the Whole Way
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.
2866
2867
2868
Extending SQLite with Rust
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 …
2869
OkCupid on Trial - 4 Month Experiment
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.
2870
2871
One Giant Leap for SQL: MySQL 8.0 Released
MySQL is the last major SQL database that has evolved beyond SQL-92 by introducing window functions (OVER) and common table expressions (WITH [RECURSIVE])
2872
Cursed Excel: "1/2"+1=45660
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.
2873
Some analysis of the 1M most popular sites on the web
Over the last couple of weeks I’ve run some analysis on the one million most popular sites on the web.
2874
2875
InfluxDB 1.0 GA Released: A Retrospective and What’s Next
Today were excited to announce the release of the open source time series database, InfluxDB 1.0 and our commercial offering, InfluxEnterprise.
2876
How exchanges turn order books into distributed logs
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.
2877
PlanetScale increases plans to include billions of reads
PlanetScale offers the world’s fastest and most scalable cloud hosting for Vitess, Neki, and Postgres.
2878
Julia, I love you (2012)
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…
2879
2880
Random Forest vs. Neural Network
Choosing between Random Forest and Neural Network depends on the data type. Random Forest suits tabular data, while Neural Network excels with images, audio, and text data.