751
Why LLMs Can't Write Q/Kdb+: Writing Code Right-to-Left
In my previous post I showed how LLMs struggle with coding in q/kdb+; having immediate feedback loops using the q-MCP server does help a…
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 1,888 posts.
752
Rails on SQLite: new ways to cause outages
This post was originally given as a talk for Friendly.rb and Kaigi on Rails. The slides are also available. Between Litestack and the Rails 8 trifecta of Solid Cable, Solid Cache, and Solid Queue, it’s easier than ever to spin up a Rails app that doesn’t need a database service, or a redis service, or a file storage…
753
A Gentle Visual Intro to Data Analysis in Python Using Pandas
Discussions: Hacker News (195 points, 51 comments), Reddit r/Python (140 points, 18 comments) If you’re planning to learn data analysis, machine learning, or data science tools in python, you’re most likely going to be using the wonderful pandas library. Pandas is an open source library for data manipulation and…
754
Notes on the SQLite DuckDB Paper
SQLite: Past, Present, and Future is a newly published paper authored by Kevin P. Gaffney, Martin Prammer and Jignesh M. Patel from the University of Wisconsin-Madison and D. Richard Hipp, …
755
756
Oracle’s Cloud Licensing Change
Over the last couple of years I've been doing talks about running Oracle databases in the cloud. In both my talks and articles I refer to the Licensing Oracle Software in the Cloud Computing Environment document. This morning I was reading a post on a mailing list and someone mentioned the document had been updated on…
757
Pandas Should Go Extinct
Pandas has taken us a long way, but it's time for a new bear
758
Ballista: Distributed Compute with Rust, Apache Arrow, and Kubernetes
Software engineer specializing in query engines and distributed systems
759
Why I Enjoy PostgreSQL – Infrastructure Engineer's Perspective
Why I enjoy PostgreSQL - Infrastructure Engineer's Perspective
760
How to Make Maps Using Leaflet.js, PostGIS and Chicago Open Data
How to get started with mapping GIS data
761
762
R Passes SAS in Scholarly Use
Relative market share of R, SAS, SPSS, Stata, Spark, H2O, and other data science tools
763
Representing Graphs in PostgreSQL
Some tricks and techniques for working with graph or tree like data in Postgresql
764
Pokémon Team Optimization
This article will show you how forming your Pokémon team can be turned into a mathematical optimization problem.
765
What I talk about when I talk about query optimizer (part 1): IR design
Achieving Data Freedom Through Open Source and Rust
766
Lessons learned from building a sync-engine and reactivity system with SQLite
Welcome to my personal blog! I use it to share what I'm currently learning or thinking about, usually on topics related to technology, business, and health.
767
Data Compression Explained (2012)
Copyright (C) 2010-2012, Dell, Inc . You are permitted to copy and distribute material from this book provided (1) any material you distribute includes this license, (2) the material is not modified, and (3) you do not charge a fee or require any other considerations for copies or for any works that incorporate…
768
Replacing a 3 GB SQLite db with a 10 MB FST (finite state transducer) binary
Note for numberphiles: all numbers have been rounded to their first significant digit, because I’m a fan of Rob Eastaway’s “zequals” method of getting to the point when it comes to estimation. It’s much more valuable to walk away with the heuristic “some dude got a 300x memory reduction by swapping out a database he…
769
Harvard discrimination lawsuit: data show penalization of Asian-Americans
Harvard and Students For Fair Admissions (SFFA), which is suing Harvard over discrimination against Asian-American applicants, have relea...
770
Deep dive into Turso, the “SQLite rewrite in Rust”
I love Rust and I love SQLite, so you can guess. Iwas pretty excited when I lerned that "SQLite was rewritten in Rust" What is SQLite, actually? 2 things: a
771
Turning the database inside-out (2015)
Databases are global, shared, mutable state. That’s the way it has been since the 1960s, and no amount of NoSQL has changed that. However, most self-respecting developers have got rid of mutable global variables in their code long ago. So why do we tolerate databases as they are?
772
773
The magic of small databases
Notes on personal libraries, collections and small indexes on the web
774
SQLite is easy to compile
SQLite is really easy to compile
775
Planet Labs' open satellite feed
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
776
Interpretable Machine Learning
Machine learning is part of our products, processes, and research. But computers usually don’t explain their predictions , which can cause many problems, ranging from trust issues to undetected bugs. This book is about making machine learning models and their decisions interpretable.
777
Phrase matching in Marginalia Search
Marginalia Search now properly supports phrase matching. This not only permits a more robust implementation of quoted search queries, but also helps promote results where the search terms occur in the document exactly in the same order as they do in the query. This is a write-up about implementing this change. This is…
778
779
Faster LZ is not the answer to 150-250 GB video game downloads
When the JPEG folks were working on image compression, they didn't create a better or faster LZ. Instead they developed new approaches. I se...
780
