2731
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.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2732
2733
Why are there so many Canadians in India?
Any time India comes up in the context of Firefox and Data I know it’s going to be an interesting day. They’re our largest Beta population: They’re our second-largest English user…
2734
Write an SQL query builder in 150 lines of Python
This is the fourth article in a series about writing my own SQL query builder. Today, we'll rewrite it from scratch, explore API design, learn when to be lazy, and look at worse and better ways of doing things – all in 150 lines of Python!
2735
Dammit, MySQL
Update May 2018: This is more rant-ish than I would write now, but it’s my only post to hit the front page of HackerNews (it got to the number 2 spot back in 2010; I saved screenshots), so has a soft-place in my heart.
2736
Lessons Learned from Two Years as a Data Scientist
I finally escaped from (grad) school in 2019, spent two months interning as an assistant trader at FTX, and have since spent the last two years working as a data scientist, with the bulk of that time at Microsoft and the last two months at Anthropic. Not gonna lie — my time as a data scientist has been pretty awesome…
2737
Inside a Ferroelectric RAM Chip
Ferroelectric memory (FRAM) is an interesting storage technique that stores bits in a special "ferroelectric" material. Ferroelectric memory...
2738
Julia and JuliaHub: Advancing Innovation and Growth
Explore Julia and JuliaHub's remarkable growth: 494% rise in Discourse views, +412% GitHub stars, and new products like Dyad.
2739
AWS Database Migration Service
Do you currently store relational data in an on-premises Oracle, SQL Server, MySQL, MariaDB, or PostgreSQL database? Would you like to move it to the AWS cloud with virtually no downtime so that you can take advantage of the scale, operational efficiency, and the multitude of data storage options that are available to…
2740
CockroachDB 19.2
CockroachDB 19.2 improves latency, reliability, and usability. We’re bringing the speed of distributed transactions closer to the theoretical minimum.
2741
2742
RethinkDB 1.15: Geospatial queries
Today, we’re happy to announce RethinkDB 1.15 ( Lawrence of Arabia ). Download it now!
2743
2744
A basic introduction to NumPy's einsum
Haphazard investigations
2745
Devious SQL: Message Queuing Using Native PostgreSQL
An interesting question came up on the postgresql IRC channel about how to use native PostgreSQL features to handle some sort of queuing behavior. While the specific usage was related to handling serialization of specific events to some external broker, the specifics are less important than the overall structure.
2746
Mysql "Swap Insanity"
Update: Also read A brief update on NUMA and MySQL. The “swap insanity” problem, in brief When running MySQL on a large system (e.g., 64GB RAM and dual quad core CPUs) with a large Inno…
2747
I made a search engine worse than Elasticsearch (2024)
Integrating my BM25 pandas search library, SearchArray, into BEIR, in order to embarass myself in public.
2748
Introducing Riak 2.0: Data Types, Strong Consistency, Full-Text Search
The Technical Preview of Riak 2.0 is now available for download.
2749
Demystifying Text Data with the Unstructured Python Library
In the world of data, textual data stands out as being particularly complex. It doesn’t fall into neat rows and columns like numerical data does. As a side project, I’m in the process of developing my own personal AI assistant. The objective is to use the data within my notes and documents to answer my questions. The…
2750
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.
2751
Data Science Interview Study Guide
We help you acquire the perfect domain for your site. Affordable payment options. Quick and responsive customer support available.
2752
“Stateless” sync using version vectors
Isolating cloud sync and persistent storage in an app architecture.
2753
2754
How Citus Executes Distributed Transactions on Postgres
Distributed transactions are one of the meanest, baddest problems in relational databases. This post explains why distributed transactions are hard and how the Citus database supports distributed transactions by employing features like distributed deadlock detection, 2PC, and streaming replication in Postgres.
2755
2756
2757
Useful Postgres Extension: Pg_stat_statements
Inspired by a talk in the PostgreSQL devroom at FOSDEM, a post on the usefulness of the pg_stat_statements extension to Postgres and why every Postgres developer should have it in their toolbox. With sections on getting started, and how to extract insights with pg_stat_statements.
2758
Analyzing 1.1B NYC Taxi and Uber Trips
The New York City Taxi & Limousine Commission has released a staggeringly detailed historical dataset covering over 1.1 billion individual taxi trips in the city from January 2009 through June 2015. …
2759
I’ll Give MongoDB Another Try In Ten Years
A few weeks ago I wrote a small app that fetches JSON documents from app.net’s API and draws a word cloud . At first I wasn’t keeping the content around after generating the images. Later I thought of other things I’d like to do with the documents, so I decided to start storing them.
2760
Model Once, Represent Everywhere: UDA (Unified Data Architecture) at Netflix
Introducing UDA, the knowledge-graph-based architecture that translates conceptual domain models into consistent schemas and data…