721
Lesser-known Postgres features
Features you already have but may not know about!
New
The latest blog posts to take off on Hacker News. 1,888 posts.
722
723
Zillow, Prophet, time series, and prices
So I made a mildly controversial tweet. Lots of people enjoyed it, but the LinkedIn-adjacent section of data science Twitter is not happy about it. I want to provide as much context for it as I can…
724
Spending $5k to learn how database indexes work
At Superwall we’re building an SDK to help App Developers increase their revenue by showing the right offer to the right person at the right time. Follow me on twitter for little tips and articles like this one.
725
726
Tao: Facebook’s distributed data store for the social graph
The papers over the next few weeks will be from (or related to) research from VLDB 2021 - on the horizon is one of my favorite systems conferences SOSP . As always, feel free to reach out on Twitter with feedback or suggestions about papers to read! These paper reviews can be delivered weekly to your inbox , or you…
727
Comparing SQLite, DuckDB and Arrow with UN trade data
This is not a competition, is just to show how to use the hardware with relative efficiency, being the idea is to show something collaborative rather than competitive.
728
Which jobs most often pair together among married couples
Find out which jobs most often pair together among married couples.
729
EBCDIC is incompatible with GDPR
Welcome to acronym city! The Court of Appeal of Brussels has made an interesting ruling. A customer complained that their bank was spelling the customer's name incorrectly. The bank didn't have support for diacritical marks. Things like á, è, ô, ü, ç etc. Those accents are common in many languages. So it was a little…
730
Deleting an S3 Bucket Costs Money
Deleting an S3 bucket is harder than you think, and may even cost you money.
731
Roapi: An API Server for Static Datasets
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
732
FoundationDB: A distributed unbundled transactional key value store
FoundationDB: A Distributed Unbundled Transactional Key Value Store Zhou, et al., 2021
733
Word-Aligned Bloom Filters
Programmers often need to 'filter out' data. Suppose that you are given a database of users where only a small percentage are 'paying customers' (say 5% or less). You can write an SQL query to check whether a given user is indeed a paying customer, but it might require a round trip to your database … Continue reading…
734
R, OpenMP, MKL, Disaster
The answer should be something close to ALPHA , i.e. 0.01 . What R was printing out was weird numbers like 1e-10 .
735
Dublin Core's dirty little secret (2010)
[This is part two in a series — you should read part 1 first for context and then you might go on to part 3.] The Dublin Core — metadata made dumb Just when librarians were in despair o…
736
I don't think Elasticsearch is a good logging system
I’ve been a heavy user of ElasticSearch for coming up 7 years now. During that time I’ve used it for a few main usecases: A Search Engine, An APM Solution (after NewRelic started being stupidly expensive), a backend for Jaeger, and as a log storage system. In all of those usecases I’ve really pushed ElasticSearch to…
737
Why I Use Nim instead of Python for Data Processing
Lazy programmers often prefer to substitute computing effort for programming effort.
738
Is BI dead? – On dismantling data's ship of Theseus
On dismantling data's ship of Theseus.
739
PostgreSQL 15: default permissions for everyone is now restricted to db owner
PostgreSQL always allowed, by default, any user to connect to any database, and create new tables (and views, and so on) in “public" schema. The one that is created by default.
740
741
How We Went All In on sqlc/pgx for Postgres and Go
Touring the ORM and Postgres landscape in Go, and why sqlc is today’s top pick.
742
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…
743
The 74,000 numbers of Barclays Bank
The UK faces an epidemic of telephone scams. Fraudsters are constantly calling people up pretending to be their bank. But how can you be sure the number displayed on your screen in genuine? You can't. The telecom system is hopelessly insecure and shouldn't be trusted for anything more complicated than dialling the…
744
SQL vs. NoSQL Is the Wrong Distinction
A misconception that I held for a really long time was that systems that use SQL (Structured Query Language) are by definition relational databases, and systems that don’t (e.g., MongoDB, Cassandra) are non-relational. It’s easy to understand whether a database uses SQL or not, but what does it mean when we say a…
745
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!
746
Wikidata or Scraping Wikipedia
Yesterday I was pointed to a blog post describing how to answer an interesting project: how many generations from Alfred the Great to Elizabeth II ? Alfred the Great was a king in England at the end of the 9th century, and Elizabeth II is the current Queen of England (and a bit more).
747
Data-Mining Wikipedia for Fun and Profit
The engineering blog of Bill P. Godfrey.
748
How is efficacy vs. severe disease strong if 60% of hospitalized are vaccinated?
A surge involving the rapidly-transmitting Delta variant in heavily vaccinated countries has led to much hand-wringing that the vaccines are not effective against Delta, or vaccine effectivenss wanes after 4-6 months. This has fueled anti-vaccine sentiment suggesting the vaccines are not working, and causing much…
749
750
Evidence of fraud in an influential field experiment about dishonesty
This post is co-authored with a team of researchers who have chosen to remain anonymous. They uncovered most of the evidence reported in this post. These researchers are not connected in any way to…